C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Code Snippets » Databinding »

Bind DropDownList from DataBase , Using c#


Posted Date: 26 Apr 2008    Resource Type: Code Snippets    Category: Databinding
Author: SureshMember Level: Silver    
Rating: 1 out of 5Points: 3



The following code shows how to bind a DropDownList control with data from a table in the DataBase.


string s = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

private void bindtoddl()
{
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("select FieldName from TableName", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "FieldName"; // FieldName of Table in DataBase
DropDownList1.DataValueField = "FieldName";
DropDownList1.DataBind();

}






Responses

Author: Ankit Bhadana    17 Oct 2008Member Level: Bronze   Points : 1
sry Suresh! this code is not working for me,,,i still cant bind data from my database to the dropdownlist in my application using this code.On runing the code ,,it still shows an empty dropdownlist.


Author: Shawpnendu bikash maloroy    14 May 2009Member Level: Silver   Points : 1
READERS YOU CAN VISIT MY BELOW POST WHERE I TRIED SIMPLIFY THE CODE FOR REUSABILITY.

http://shawpnendu.blogspot.com/2009/05/how-to-bind-or-populate-data-into.html

HOPE IT WILL HELP YOU A LOT.

REGARDS
http://shawpnendu.blogspot.com


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Sign In to add tags.
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Fill a DropDownList with files in a directory using c#
Previous Resource: How To bind data With the help odbc by coding
Return to Discussion Resource Index
Post New Resource
Category: Databinding


Post resources and earn money!
 
More Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use