concatenation of two dropdownlists

madhukk

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

Expand|Select|Wrap|Line Numbers

  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....

Expand|Select|Wrap|Line Numbers

  
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

concatenation of two dropdownlists

re: concatenation of two dropdownlists

Similar ASP.NET bytes

/bytes/development

/bytes/it

/bytes/about