CODEWITHSUNDEEP
c#asp.netsql-serverado.netdrop-down-menu
Kev
Kev

Reputation: 41

Fill DropDownList from database

I am new to C# and trying to populate a DropDownList based on a database value. I tried connecting to database as shown below - tested with the statement and it says connected. Can I assume this is correct? Am I on the right track? Also, how do I then select value from the table and fill DropDownList with a field?

protected void Page_Load(object sender, EventArgs e)
{
    SqlConnection connection = new SqlConnection (
    "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:customers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

     try
     {
         connection.Open();
         TextBox1.Text = "connected";
     }
     catch (Exception)
     {
         TextBox1.Text = " not connected";
     }
 }

Upvotes: 1

Views: 20476

Answers (3)

Just_Ice
Just_Ice

Reputation: 563

            using (SqlConnection con = new SqlConnection("Data Source = NIPOON; Initial Catalog = CustomerOrders; Integrated Security = true"))
            {
                SqlCommand cmd = new SqlCommand("SELECT Name FROM Customer", con);
                con.Open();

                dropDownList.DataSource = cmd.ExecuteReader();
                dropDownList.DataTextField = "Name";
                dropDownList.DataValueField = "Name";
                dropDownList.DataBind();
            }

Upvotes: 0

Swati
Swati

Reputation: 227

It's So Much Simple :----

SqlConnection con = new SqlConnection(); 
DataSet ds = new DataSet(); 
con.ConnectionString = @"Data Source=TOP7\SQLEXPRESS;Initial Catalog=t1;Persist Security Info=True;User ID=Test;Password=t123";
string query = "Select * from tbl_User"; 
SqlCommand cmd = new SqlCommand(query, con); 
cmd.CommandText = query;
con.Open(); 
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(ds);
comboBox1.Items.Clear();
comboBox1.DisplayMember = "UserName";
comboBox1.ValueMember = "UserId";
comboBox1.DataSource = ds.Tables[0];

------------------------------------------------------------------------

Upvotes: 0

sobby01
sobby01

Reputation: 2164

protected void Page_Load(object sender, EventArgs e)
{
    SqlConnection connection = new SqlConnection (
    "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:customers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");

     try
     {
          SqlDataReader dReader;
          SqlCommand cmd = new SqlCommand();
          cmd.Connection = connection;
          cmd.CommandType = CommandType.Text;
          cmd.CommandText ="Select distinct [Name] from [Names]" +
          " order by [Name] asc";
         connection.Open();

         dReader = cmd.ExecuteReader();
         if (dReader.HasRows == true)
         {
              while (dReader.Read())
              //Names collection is a combo box.
              namesCollection.Add(dReader["Name"].ToString());

         }
         else
         {
              MessageBox.Show("Data not found");
         }
           dReader.Close()
         TextBox1.Text = "connected";
     }
     catch (Exception)
     {
         TextBox1.Text = " not connected";
     }
 }

Hope that helps................

Upvotes: 2

Related Questions