concatenation of two dropdownlists

[madhukk]

im using three dropdownlists to store year month date in database..

 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;
 
 

this is working as i can save year month day in a single column(startdate) in table.
and retrieving that column using session and posting that value to other page..
while retriving i want year month date in seperate ddls any sample code plz....

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

[Frinavale]

In the first piece of code you are saving a String (that contains the date) into a database...but it looks like the database is expecting a Date object??

In the second piece of code you are retrieving something from Session....

How are the 2 pieces of code related??? Session is not the same thing as your database.....

You could try using the DateTime object instead of Strings. That way you can easily access the Day/Month/Year (etc) values as you need them.

-Frinny