hi guys can i bind my combo box into sqlreader, if yes how?

       // populate a SqlDataReader object
        SqlDataReader objReader = objCommand.ExecuteReader();

        // set the source of the "starwars" datagrid
         DataGrid.DataSource = objReader;

         // bind the data to the grid
         DataGrid.DataBind();
         objReader.Close();

The above three lines can be used to bind.



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

how bour in combo box is it possible to bind it in sqldatareader?

Try the same with Combo, also set DisplayMember and ValueMember property.



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

hi pradeep,

niway i find ur website cool,
Im using the code in Microsoft Application Data block for net Code
heres the code
 dr = SqlHelper.ExecuteReader(connection, "invoice2")
                    Me.ComboBox1.DataSource = dr
                    Me.ComboBox1.DisplayMember = "DOCNO"
                     Me.ComboBox1.ValueMember = "TRNO"
heres the error code
complex databinding accepts as a datasource either ilist or ilist source

Sorry drachx it seems we cannot bind DataReader directly to the comboBox, I am really sorry for this. But you can directly add all the values from the DataReader to the comboBox like below

while(reader.Read())
{
  comboBox1.add(reader["column"].ToString());
}

Thanks!



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

ok,tnx niway :)