Populate combobox
-
Hi all. Im trying to load data into a combo box during form load.The items Im trying to load are from a database. Now here is my little code that gives me errors. protected void Page_Load(object sender, EventArgs e) { con.ConnectionString = str; String str1 = "Select * from Filter"; con.Open(); cm.Connection = con; dtr = cm.ExecuteReader(); if (dtr.Read()) { // Load FilterByKeys onto the combo box cboExtension.Text = (dtr["FilterKey"]).ToString();<<*****Problem**** lblMessage.Text = "Good. All the values are loaded"; Thanx.
kagiso
:)what a mess is this!! "cbo.extension.text" will never populate items in to combobox control, this only displays the specified text if it is already there in combobox items collection. to populate the items u should specifie { combobox.items.add(dtr["filterKey"].tostring()); }
-
DataTable status = new DataTable(); status = ExecuteNonQuery_SP("Select * from Filter");//getting the value cmbStatus.DataSource =status ; cmbStatus.DisplayMember = "Status_Name"; cmbStatus.ValueMember = "Status_Id"; give the displaymember and valuemember to the combobox'x object here cmbStatus is the combobox
My small attempt...
-
:)what a mess is this!! "cbo.extension.text" will never populate items in to combobox control, this only displays the specified text if it is already there in combobox items collection. to populate the items u should specifie { combobox.items.add(dtr["filterKey"].tostring()); }
cboExtension.items.add(dtr["filterKey"].tostring()); items gives this error "System.Web.UI.WebControl.DropdownList doesnt contain definition for items." Then to .tostring() "object doesnt contain a definition for string Can you generate a code that would work. NB. The Items in the database are jus A.B.C til Z So, it suppose to load A B C Till Z Thank you for your help.A nice code would be nice.Im an amature in this
kagiso
-
sujithkumarsl wrote:
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value cmbStatus.DataSource =status ;
:confused::|
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value cmbStatus.DataSource =status ; actually ExecuteNonQuery_SP("Select * from Filter"); is a method which takes quaery as parameter and returns the datatable. i used this code in my proj and its working
My small attempt...
-
cboExtension.items.add(dtr["filterKey"].tostring()); items gives this error "System.Web.UI.WebControl.DropdownList doesnt contain definition for items." Then to .tostring() "object doesnt contain a definition for string Can you generate a code that would work. NB. The Items in the database are jus A.B.C til Z So, it suppose to load A B C Till Z Thank you for your help.A nice code would be nice.Im an amature in this
kagiso
please try the exable which i gave to you. that will work which field from db, you want to add in combobox?
My small attempt...
-
cboExtension.items.add(dtr["filterKey"].tostring()); items gives this error "System.Web.UI.WebControl.DropdownList doesnt contain definition for items." Then to .tostring() "object doesnt contain a definition for string Can you generate a code that would work. NB. The Items in the database are jus A.B.C til Z So, it suppose to load A B C Till Z Thank you for your help.A nice code would be nice.Im an amature in this
kagiso
using sytem.oledb; using system.windows.forms; oledbconnection connect=new oledbconnection; oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel' where 'condition'", connect); oledbreader reader=command.executeReader(); reader.read(); { combobox1.items.add(reader[0].tostring()); } reader.close(); connect.close();
-
please try the exable which i gave to you. that will work which field from db, you want to add in combobox?
My small attempt...
-
using sytem.oledb; using system.windows.forms; oledbconnection connect=new oledbconnection; oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel' where 'condition'", connect); oledbreader reader=command.executeReader(); reader.read(); { combobox1.items.add(reader[0].tostring()); } reader.close(); connect.close();
using sytem.oledb; using system.windows.forms; oledbconnection connect=new oledbconnection; oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel' ***There are only two fields. ID & FilterKey and Im using FilterKey so no need for where ***** where 'condition'", connect); oledbreader reader=command.executeReader(); reader.read(); { combobox1.items.add(reader[0].tostring()); } reader.close(); connect.close();
kagiso
-
sujithkumarsl wrote:
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value cmbStatus.DataSource =status ;
:confused::|
-
using sytem.oledb; using system.windows.forms; oledbconnection connect=new oledbconnection; oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel' where 'condition'", connect); oledbreader reader=command.executeReader(); reader.read(); { combobox1.items.add(reader[0].tostring()); } reader.close(); connect.close();
-
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value cmbStatus.DataSource =status ; actually ExecuteNonQuery_SP("Select * from Filter"); is a method which takes quaery as parameter and returns the datatable. i used this code in my proj and its working
My small attempt...
sujithkumarsl wrote:
actually ExecuteNonQuery_SP("Select * from Filter"); is a method which takes quaery as parameter and returns the datatable. i used this code in my proj and its working
Two things: 1) There is no method named
ExecuteNonQuery_SPin the framework, and therefore using it in an example to a newer programmer is just going to confuse them more! This method is most likely defined in your own project, or is part of a data access framework that you use. 2) The name of the method would imply that it executesIDbConnection.ExecuteNonQuerywhich does not "return a table". If your method really does take a SQL clause as a parameter and return a table it should be namedExecuteDataTable_SPPlease take the time to consider the usefulness of the code and the target audience before posting a (useless) code snippet. -
Ok, its not taking the using system.Windows.forms; and the combobox1.items.add(reader[0].tostring()); says its doesnot have a definition for Add. Everything else was what I did before
kagiso
hi if its a web application, it wont take windows.forms, and u wont get combobox control also.... in such case, use " using system.web.ui.webcontrols; " { dropdownlist1.items.add(reader[0].tostring()); } this will defenetely work:)
-
hi if its a web application, it wont take windows.forms, and u wont get combobox control also.... in such case, use " using system.web.ui.webcontrols; " { dropdownlist1.items.add(reader[0].tostring()); } this will defenetely work:)