problem in binding values with dropdownlist

[ndhamecha]

i have a problem in binding values with dropdownlist.i have one dropdownlist name,dropdowndiagnosticcategory..i have made one function bind_category() for binding the category values.The code for binding the values with dropdownlist is as under,here

 private void bind_category()
    {
 
        string s = "Data Source=LAB1-40;Initial Catalog=MNSDaignosticCenter;Integrated Security=True";
        SqlConnection con = new SqlConnection(s);
        con.Open();
 
        SqlCommand cmd = new SqlCommand("select DiagnosisCategoryId,DiagnosisCategoryName from TblDiagnosisCategory");
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds);
 
        if (ds != null && ds.Tables[0].Rows.Count > 0)
        {
            DropDownDiagnosticCat.DataSource = ds;
            DropDownDiagnosticCat.DataTextField = "DiagnosisCategoryName";
            DropDownDiagnosticCat.DataValueField = "DiagnosisCategoryId";
            DropDownDiagnosticCat.DataBind();
        }
        DropDownDiagnosticCat.Items.Insert(0, "-Select category");
        sda.Dispose();
        con.Close();
 
    }
 
 protected void DropDownDiagnosticCat_SelectedIndexChanged(object sender, EventArgs e)
    {
        bind_category();
    }
 
 

would you please give me suggestion to display data in this gridview.this is not giving any error.but even not given values to select from this gridview.

thanking you.
ndhamecha

[Frinavale]

I'm sorry that I don't understand your question but...
What does the GridView have to do with the DropDownList?

[Frinavale]

ndhamecha:
hello.
i found my mistake..yes.but before that.i want to tell you what i am doing right now.
i have taken one dropdown list,which contains the list of categories of diagnosis.&made one function for binding that dropdownlist with sqlserver 2005 using connection string.and that function,i am calling on dropdownlist_selected_index_changed event..getting?
but i found my mistake was that.when i wrote my select query for getting values of diagnosis category from database i forgot to pass object of connection string also.
so..the it should be like this:-
SqlCommand cmd = new SqlCommand("select DiagnosisCategoryId,DiagnosisCategoryName from TblDiagnosisCategory",con);

I'm happy that you were able to solve your problem (even though I'm still not sure what the GridView had to do with anything).

ndhamecha:
yes..1 more thing.i am not rude.but using this site first time.even i don't know,how to present ourselves in front of great developers.so i am really extremely sorry if i am hurting u all from my language.but believe me,my intention is not to hurt anyone.

thanks for your reply :)

ndhamech

You haven't been rude yet :)
The one thing you should be aware of is that this forum likes to keep solutions to problems public so that other people with the same problem can find an answer in the discussions that we have in your thread. So, we do not help solve problems privately using PMs. I know it's a bit confusing because of the automated system that PMs you to let you know when someone has replied to your question...but please reply in thread instead of in PMs.

I've posted your PM here so that people can see what you said :)

-Frinny