combo box with default text

Enos

Hi ,

i have a combo box which loads from the database. Now i want default text on the combo box ("--Please Select--") to appear on top of the list, it must show the text whithout the user even opened the combo box. Also when the user clear the combo box, the default text will be "--Please Select--"

this is how i bindeed it ;

private void LoadCombo()

{

try

{

oConnection = new SqlConnection(_connectionString);

oCommand = new SqlCommand("select * from tbldpt", oConnection);

oAdapter = new SqlDataAdapter(oCommand);

oConnection.Open();

oDataset = new System.Data.DataSet();

SqlDataReader oReader = oCommand.ExecuteReader();

while (oReader.Read())

{

string _Combobox = oReader["Departmentname"].ToString();

cboDepartment.Items.Add(_Combobox);

}

oReader.Close();

oConnection.Close();

}

catch(Exception ex)

{

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Try it like this:

private void LoadCombo()
{
try
{
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("select * from tbldpt", oConnection);
oAdapter = new SqlDataAdapter(oCommand);
oConnection.Open();
oDataset = new System.Data.DataSet();
SqlDataReader oReader = oCommand.ExecuteReader();
while (oReader.Read())
{
string _Combobox = oReader["Departmentname"].ToString();
cboDepartment.Items.Add(_Combobox);
}
oReader.Close();
oConnection.Close();
}
catch(Exception ex)
{
}
cboDepartment.Items.Insert(0, "--Please Select--");
cboDepartment.SelectedIndex = 0;
}
Enos11y ago
cannot find column 0. from the first line when i try to debugg

DataRow row = oDataset.Tables[0].NewRow();
row["Category"] = "--Please Select--";
oDataset.Tables[0].Rows.InsertAt(row, 0);
Manish Kumar Choudhary11y ago
try this
private void LoadCombo()
{
try
{
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("select * from tbldpt", oConnection);
oAdapter = new SqlDataAdapter(oCommand);
oConnection.Open();
oDataset = new System.Data.DataSet();
SqlDataReader oReader = oCommand.ExecuteReader();

DataRow row = oDataset.Tables [0].NewRow();
row["Category"] = "--Please Select--";
oDataset.Tables[0].Rows.InsertAt(row, 0);

while (oReader.Read())
{
string _Combobox = oReader["Departmentname"].ToString();
cboDepartment.Items.Add(_Combobox);
}

oReader.Close();
oConnection.Close();
}
catch (Exception ex)
{
}
}
Enos11y ago
It is only displaying after i have opened the combo box. i want the user to see the text when you load the form.
Manish Kumar Choudhary11y ago
hi Enos,
this will work fine
private void LoadCombo()
{
try
{
oConnection = new SqlConnection(_connectionString);
oCommand = new SqlCommand("select * from tbldpt", oConnection);
oAdapter = new SqlDataAdapter(oCommand);
oConnection.Open();
oDataset = new System.Data.DataSet();
SqlDataReader oReader = oCommand.ExecuteReader();
while (oReader.Read())
{
string _Combobox = oReader["Departmentname"].ToString();
cboDepartment.Items.Add(_Combobox);
}
cboDepartment.Items.Insert(0, "--Please Select--");
oReader.Close();
oConnection.Close();
}
catch (Exception ex)
{
}
}