.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

DropDownList DataBinding

Posted By:Sasi Prabhu       Posted Date: August 17, 2011    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

Perform validation for DownDownList Controls which items are Binded from DataBase.
 


.aspx :




.aspx.cs

protected void LoadDropdownItems()
{
SqlConnection con=new SqlConnection("");
try
{
con.Open();
SqlCommand cmd=new SqlCommand("select ProductID,Items from ProductMaster", con);
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);
dd_Items.DataSource=ds;
dd_Items.DataTextField="Items");
dd_Items.DataValueField="ProductID");
ListItem lst=new ListItem();
lst.Text="--Select Items==";
lst.Value="-1";
dd_Items.Items.Insert(0,lst);
dd_Items.SelectedIndex=0;
}
catch(Exception ex)
{Response.Write(ex.Message);}
finally
{
con.Close();
}
}


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend