Hi!
I have database with two column: "name" and "mobile". I need to filter for example on the column "mobile" a specific number. Then into my combobox should appear all names affected by the same mobile number only. But the code I wrote doesnt obey. Its point the error here: SqlDataReader sdr = comm.ExecuteReader();
private void cbxName_SelectedIndexChanged(object sender, EventArgs e)
{
conn.Open();
//comm = new SqlCommand("SELECT DISTINCT nom_complet FROM church", conn);
comm = new SqlCommand("SELECT name FROM church where mobile like('" + "txtMobileNumber.Text" + "%')");
SqlDataReader sdr = comm.ExecuteReader();//Its point here as error
DataTable dt = new DataTable();
dt.Load(sdr);
cbxReadNomFlashMessage.DisplayMember = "name";
cbxReadNomFlashMessage.DroppedDown = true;
List list = new List();
foreach (DataRow row in dt.Rows)
{
list.Add(row.Field("name"));
}
this.cbxReadNomFlashMessage.Items.AddRange(list.ToArray());
cbxReadNomFlashMessage.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbxReadNomFlashMessage.AutoCompleteSource = AutoCompleteSource.ListItems;
conn.Close();
///////////////////////doesnt allow repeat item in combobox////////////
for (int i = 0; i < cbxReadNomFlashMessage.Items.Count; i++)
{
for (int y = 0; y < cbxReadNomFlashMessage.Items.Count; y++)
{
if (y != i && cbxReadNomFlashMessage.Items[i].ToString() == cbxReadNomFlashMessage.Items[y].ToString())
{
cbxReadNomFlashMessage.Items.RemoveAt(i);
break;
}
}
}
Amit GuptaPosted Apr 19, 2017, 1:08 PM
IsraelPosted Apr 19, 2017, 5:02 PM
IsraelPosted Apr 19, 2017, 5:42 AM
Ramesh PalanivelPosted Apr 19, 2017, 5:16 AM
Manas MohapatraPosted Apr 19, 2017, 5:03 AM