dropdownlist is not displaying data while retrieving from database

Question

5.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hi,
I m trying below code to display data from database in dropdownlist as well as textbox

but Textboses are working fine but Dropdownlist is not showing data of database.

Pls Help..

C#

SqlCommand cmd = default(SqlCommand);
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
         con.Open();
        cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
         SqlDataReader reader = cmd.ExecuteReader();
        int i=0;
        while (reader.Read())
        {
            txtRegdt.Text = Convert.ToString(reader["Reg_dt"]);
            txtComplnno.Text = Convert.ToString(reader["Complaint_no"]);
            txtFname.Text = Convert.ToString(reader["Cust_FName"]);
            txtLname.Text = Convert.ToString(reader["Cust_LName"]);
            txtPh.Text = Convert.ToString(reader["ph_no"]);
            txtMob.Text = Convert.ToString(reader["mob_no"]);
            txtemail.Text = Convert.ToString(reader["email"]);
            txtadd.Text = Convert.ToString(reader["address"]);
            txtcity.Text = Convert.ToString(reader["city"]);
            txtdist.Text = Convert.ToString(reader["dist"]);
            ddlstat.Items.Add(new ListItem(Convert.ToString(reader["state"]),i.ToString()));
            i++;
}
con.close();

Posted 3-Jan-13 3:10am

Member 9693583

Updated 3-Jan-13 3:17am

Raje_

v2

Add a Solution

3 solutions

Solution 3

Try this: For dropdown list only

private void dropdownlistbind()
    {
       
        SqlCommand cmd = new SqlCommand("Your Command using appropriate clause","Your Connection");
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        DropDownList1.DataSource = ds;
        // FieldName of Table in DataBase
        DropDownList1.DataValueField = "FieldName";
        DropDownList1.DataBind();   
      }

Posted 3-Jan-13 3:26am

Prasad_Kulkarni

Comments

Member 9693583 3-Jan-13 9:56am

hi prasad, tried below code & call it on button click.... exception error

"Invalid operation exception was unhandled by user code" pls help..

private void ddlstatebind()
{
SqlCommand cmd = new SqlCommand("Select state from Call_Reg ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ddlstat.DataSource = ds;
ddlstat.DataValueField = "state";
ddlstat.DataBind();
}

Solution 1

First - Bind the dropdown on page_load event.

SqlCommand cmd = default(SqlCommand);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
con.Open();
cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
SqlDataReader reader = cmd.ExecuteReader();
int i=0;
while (reader.Read())
{
txtRegdt.Text = Convert.ToString(reader["Reg_dt"]);
txtComplnno.Text = Convert.ToString(reader["Complaint_no"]);
txtFname.Text = Convert.ToString(reader["Cust_FName"]);
txtLname.Text = Convert.ToString(reader["Cust_LName"]);
txtPh.Text = Convert.ToString(reader["ph_no"]);
txtMob.Text = Convert.ToString(reader["mob_no"]);
txtemail.Text = Convert.ToString(reader["email"]);
txtadd.Text = Convert.ToString(reader["address"]);
txtcity.Text = Convert.ToString(reader["city"]);
txtdist.Text = Convert.ToString(reader["dist"]);

SQL

ddlstat.SelectedIndex =
    ddlstat.Items.IndexOf(ddlstat.Items.FindByValue(Convert.ToString(reader["state"])))

i++;
}
con.close();

Posted 3-Jan-13 3:17am

$*Developer - Vaibhav*$

Updated 3-Jan-13 3:19am

v2

Comments

Member 9693583 3-Jan-13 9:30am

hi vaibhav,Thanks 4 reply... I tried that code but its not working i want the code on button click event

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Zafar Sultan · Accepted Answer · 2013-01-03T03:25:00

First, on your page load event fill the list of states:

C#

protected void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
fillStates();
}
}
//function to fill state list
protected void fillStates()
{
SqlCommand cmd = default(SqlCommand);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
con.Open();
cmd = new SqlCommand("Select distinct stateID,stateName from YourStateTable", con);
SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
ListItem li = new ListItem();
li.Text = Convert.ToString(reader["stateName"]);
li.Value = Convert.ToString(reader["stateID"]);
ddlstat.Items.Add(li);
}
con.close();
}

Now on you button click event write

C#

protected void btnDetails_Click(object sender, System.EventArgs e)
{
SqlCommand cmd = default(SqlCommand);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Callregister_connectionstring"].ConnectionString);
con.Open();
cmd = new SqlCommand("Select * from Call_Reg where Complaint_no='" + ddlupCompl.SelectedItem.ToString() + "'", con);
SqlDataReader reader = cmd.ExecuteReader();
txtRegdt.Text = Convert.ToString(reader["Reg_dt"]);
txtComplnno.Text = Convert.ToString(reader["Complaint_no"]);
txtFname.Text = Convert.ToString(reader["Cust_FName"]);
txtLname.Text = Convert.ToString(reader["Cust_LName"]);
txtPh.Text = Convert.ToString(reader["ph_no"]);
txtMob.Text = Convert.ToString(reader["mob_no"]);
txtemail.Text = Convert.ToString(reader["email"]);
txtadd.Text = Convert.ToString(reader["address"]);
txtcity.Text = Convert.ToString(reader["city"]);
txtdist.Text = Convert.ToString(reader["dist"]);
ddlstat.SelectedValue = Convert.ToString(reader["state"]);
/*the above line willl set the value to the stored value if you are storing id 
of the state in the database. If you are storing state as text in the database replace the line with following line:
ddlstat.SelectedIndex =
ddlstat.Items.IndexOf(ddlstat.Items.FindByValue(Convert.ToString(reader["state"])))
*/
con.close();
}