dropdown list binding with sql database

Question

1.00/5 (1 vote)

See more:

ASP.NET

how to bind dropdownlist in disconnected mode

Posted 11-Aug-12 1:05am

srishti_

Add a Solution

3 solutions

Solution 4

SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=cmcdb;Integrated Security=True");
        con.Open();
       SqlCommand cmd = new SqlCommand("select userid from logins ", con);
       SqlDataReader dr = cmd.ExecuteReader();
       while (dr.Read())
       {

           DropDownList1.Items.Add(dr["userid"].ToString());
       }

Posted 11-Aug-12 2:28am

Deepak Kr Choudhary

Comments

srishti_ 13-Aug-12 6:27am

i am asking in disconnected mode.

Deepak Kr Choudhary 18-Aug-12 6:23am

ok

Solution 1

try
{
sqlconnection con=new sqlconnection("Data Source=.; Initial Catalog=database name;uid=sa; pwd=password");
con.Open();
sqlcommand cmd = new OleDbCommand("select distinct(prod_Name) from purchase" , con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBox1.Items.Add(dr[0].ToString());
}
dr.Close();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error...."+ex.Message);
}

Posted 11-Aug-12 1:13am

Shambhoo kumar

Comments

srishti_ 11-Aug-12 7:26am

i am asking in disconnected mode this solution is for connected mode.

Shambhoo kumar 11-Aug-12 7:39am

ok ok......

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Accepted Answer · 2012-08-11T02:21:00

Solution 3

C#

DataTable table = new DataTable();
           cmd = new SqlCommand();
           cmd.CommandText = "GetEmployee";
           cmd.CommandType = CommandType.StoredProcedure;

           table = dbConn.ExecuteQuery(cmd);
           ddlEmp.DataSource = table;
           ddlEmp.DataValueField = "DeptId";
           ddlEmp.DataTextField = "DeptName";
           ddlEmp.DataBind();

Posted 11-Aug-12 2:21am

Santhosh Kumar Jayaraman

Comments

srishti_ 13-Aug-12 6:26am

thanks ur solution was helpful for me

Santhosh Kumar Jayaraman 13-Aug-12 6:32am

Can you mark it as accepted answer? SO that others will know

srishti_ 13-Aug-12 6:52am

i did

Santhosh Kumar Jayaraman 13-Aug-12 6:52am

thanks

dropdown list binding with sql database

3 solutions

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0

dropdown list binding with sql database

3 solutions

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us