Re: startdate in dropdownlist - ASP.NET Discussion Boards

m@dhu20-Oct-09 3:49

20-Oct-09 3:49

concatenated three dropdownlists values i inserted year month day into a column in sql table.
how to retrieve that values seperately to that three ddls from sql table
help plz...
for inserting i used....

 string str = DropDownList5.SelectedItem.Value.ToString();
        string str1 = DropDownList6.SelectedItem.Value.ToString();
        string str2 = DropDownList7.SelectedItem.Value.ToString();
        string final = str1 + "-" + str + "-" + str2;

cmd.Parameters.Add("@startdate", SqlDbType.SmallDateTime.ToString()).Value = final;

Re: startdate in dropdownlist

Abhijit Jana20-Oct-09 4:00

Abhijit Jana

20-Oct-09 4:00

madhukk wrote:
cmd.Parameters.Add("@startdate", SqlDbType.SmallDateTime.ToString()).Value = final;

Try This .

DateTime MyDateTime;
 MyDateTime = new DateTime();
 MyDateTime = DateTime.ParseExact(final , "yyyy-MM-dd",
                                  null);

cmd.Parameters.Add("@startdate",MyDateTime );

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: startdate in dropdownlist

m@dhu20-Oct-09 4:15

m@dhu

20-Oct-09 4:15

im able to insert it..
i want to retrieve startdate column and transfer to other page using session..
using datareader i stored that column in a string

SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                { Session["startdate"] = dr["startdate"];
                 }

in next page to tranfer the value
if i write this

DropDownList1.SelectedItem.Text= Session["startdate"].ToString();

im getting complete date(10/20/2001) in DropDownList1..
but what i want is ddl1(10) ddl2(20) ddl3(2001) as i inserted...

Re: startdate in dropdownlist

Richard MacCutchan20-Oct-09 4:19

Richard MacCutchan

20-Oct-09 4:19

madhukk wrote:
im getting complete date(10/20/2001) in DropDownList1..

Which is exactly what you coded. If you want to separate the values across different drop downs then you need to separate the components of the date. Day to one, month to another, and year to the third. How complicated can this be?

Re: startdate in dropdownlist

Abhijit Jana20-Oct-09 4:44

Abhijit Jana

20-Oct-09 4:44

You need to split them before store. Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: startdate in dropdownlist

m@dhu20-Oct-09 19:45

m@dhu

20-Oct-09 19:45

thats what im unable to any sample code please..

Re: startdate in dropdownlist

Abhijit Jana20-Oct-09 20:03

Abhijit Jana

20-Oct-09 20:03

madhukk wrote:
any sample code please..

One sample code for you.

String DateText="12/10/2009";
String [] DatePart= DateText.Split('/');
string dd=DatePart[0].ToString();
string mm=DatePart[1].ToString();
string yy=DatePart[2].ToString();

Hope you can take it forward. Let me know if any more issue.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: startdate in dropdownlist

Nisha Agrawal20-Oct-09 20:25

Nisha Agrawal

20-Oct-09 20:25

I would prefer this one as it does not believe on string manipulatio and when we have datetime datatype then why do string manipulation?

String strDate = "12/27/2009"; //or any date format
String strFormat = "mm/dd/yyyy";
System.Globalization.CultureInfo provider = System.Globalization.CultureInfo.InvariantCulture;
DateTime dt = DateTime.ParseExact(strDate, strFormat, provider);
String dd = dt.Day.ToString();
String mm = dt.Month.ToString();
String yyyy = dt.Year.ToString();

Re: startdate in dropdownlist

Abhijit Jana20-Oct-09 21:27

Abhijit Jana

20-Oct-09 21:27

Yes Nish, You are Correct. Actually there are many ways that we can implement it. I have given a very basic example. You given much better! Thumbs Up | :thumbsup:

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: startdate in dropdownlist

Richard MacCutchan21-Oct-09 0:13

Richard MacCutchan

21-Oct-09 0:13

If everybody stored their datetime values properly as DateTime values and not as strings they would not get into this mess. Who is teaching all these awful habits?

Re: startdate in dropdownlist

m@dhu20-Oct-09 21:29

m@dhu

20-Oct-09 21:29

Session["headline"] = dr["headline"];
 Session["startdate"] = dr["startdate"];
 Response.Redirect("newsedit.aspx");

next page

 TextBox5.Text = Session["headline"].ToString();
String DateText = Session["startdate"].ToString();
         String[] DatePart = DateText.Split('/');
         string dd = DatePart[0].ToString();
         string mm = DatePart[1].ToString();
         string yy = DatePart[2].ToString();
         DropDownList6.SelectedItem.Text=dd.ToString();
Object reference not set to an instance of an object.

Re: startdate in dropdownlist

Abhijit Jana20-Oct-09 21:35

Abhijit Jana

20-Oct-09 21:35

madhukk wrote:
Session["headline"] = dr["headline"];
Session["startdate"] = dr["startdate"];
Response.Redirect("newsedit.aspx");

next page

TextBox5.Text = Session["headline"].ToString();
String DateText = Session["startdate"].ToString();
String[] DatePart = DateText.Split('/');
string dd = DatePart[0].ToString();
string mm = DatePart[1].ToString();
string yy = DatePart[2].ToString();
DropDownList6.SelectedItem.Text=dd.ToString();
Object reference not set to an instance of an object.

What is ur question ?

madhukk wrote:
DropDownList6.SelectedItem.Text=dd.ToString();
Object reference not set to an instance of an object.

I guess this one.
What is the value of dd.ToString(); ? Does this exist on the dropdownlist? Hope now you understand what I want to mean Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: startdate in dropdownlist

J4amieC20-Oct-09 4:03

J4amieC

20-Oct-09 4:03

SELECT DAY(startDate) as day, MONTH(startDate) as month, YEAR(startDate) AS Year FROM YourTable

Re: startdate in dropdownlist

Richard MacCutchan21-Oct-09 0:11

Richard MacCutchan

21-Oct-09 0:11

J4amieC wrote:
SELECT DAY(startDate) as day, MONTH(startDate) as month, YEAR(startDate) AS Year FROM YourTable

No, no, no! That's MUCH too sensible ... Laugh | :laugh:

Display the link and content in my site using RSS

yesu prakash20-Oct-09 2:12

yesu prakash

20-Oct-09 2:12

Hi,

I need to display the content in my site of a particular link using RSS.
Eg:
When a user click the link of a new which is displayed using RSS, i need to display the content also in my page, without going to another site or source site. For yahoo RSS we get all links, When we click a link it will redirect to yahoo site for the content.
How can i bring the content in to my site without going to yahoo? How it possible? Is it possible?

Thankyou
YPKI

Re: Display the link and content in my site using RSS

Abhijit Jana20-Oct-09 3:34

Abhijit Jana

20-Oct-09 3:34

I have already provided you the information in your last thread. For details you need to search google. If need to read all the content of RSS nothing else.
Please read this article,
An ASP.NET RSS Feed Reader[^]
Let me know if it clear to you !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Display the link and content in my site using RSS

yesu prakash20-Oct-09 17:50

yesu prakash

20-Oct-09 17:50

I try this article.. but the content is opening in www.megatokyo.com site. My requriment is to display the particular content in my site itself.. is it possible?

Re: Display the link and content in my site using RSS

Abhijit Jana20-Oct-09 20:22

Abhijit Jana

20-Oct-09 20:22

Yes. make a HTTPRequest for that site. Read the HTTPResponse. Parse the text and display it in your page. Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Display the link and content in my site using RSS

yesu prakash20-Oct-09 20:45

yesu prakash

20-Oct-09 20:45

can u please provide me an example

Re: Display the link and content in my site using RSS

yesu prakash21-Oct-09 17:44

yesu prakash

21-Oct-09 17:44

hi Abhijit ,
Can u provide me a example

Johndas20-Oct-09 2:05

Johndas

20-Oct-09 2:05

Hi All,
i have question, in my project most of user control is Register in page as traditional manner. If i change to load the user control dynamically, Is any performance difference will be there.

My question is, i need to improve performance of page.If i load the user control dynamically.any improvement of Performance?

Please suggest Me.

Thanks In Advance..

JohnDas

Re: Register the user control or Dynamic Loading the User Control Performance.

Abhijit Jana20-Oct-09 3:47

Abhijit Jana

20-Oct-09 3:47

Yes you can dynamically load User control for Peformance improvement. Even I will suggest you look into Partial Page Caching which will improve your site peroformance a lot.

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

How to retrive the values from Cache

sjs4u20-Oct-09 2:03

sjs4u

20-Oct-09 2:03

Hi,

I have one server application and one client application. Server application directly connected to the database. Client application uses web service.
I am using Cache in my client application. I am using Web Service fetching Records from Server application Storing into the cache. With the help of that cache I am performing some updation on the fetched data and update the cache.(Not updating database).

Now if client application stop or end by any condition(Failure of power supply). If I restart the application i will get the again the same data as well as newly added data from server application.

Now I want save previously updated data as well as newly added data into cache.

From Where Should I get the previous data if the power failure happens?.

Is there any other solution for that.

Thanks,
sjs

Re: How to retrive the values from Cache

Ashfield20-Oct-09 2:12

Ashfield

20-Oct-09 2:12

If I understand you correctly, the cache is memory only on the client, so if it is powered down its gone. If it is a true client app (NOT a web page) you could write the cache out to disk each time it changed (probably only the changed bits) and reload it at start up.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: How to retrive the values from Cache

sjs4u20-Oct-09 2:36

sjs4u

20-Oct-09 2:36

Thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.