I am trying to put in a combobox while using the DISTINCT is use.
It works without the DISTICNT
<
using (SqlConnection conn = new SqlConnection(zGV.csAviation))
{
try
{
string query = "select '<Select>' as name, 0 as id union Select name, id from Airlines ORDER BY Name ";
SqlDataAdapter da = new SqlDataAdapter(query, conn);
conn.Open();
DataSet ds = new DataSet();
da.Fill(ds, "airline");
cbxAirline.DisplayMember = "Name";
cbxAirline.ValueMember = "ID";
cbxAirline.DataSource = ds.Tables["airline"].DefaultView;
}
catch (Exception ex)
{
// write exception info to log or anything else
MessageBox.Show("Error occured in Airline!");
}
}
You need to sign in to view this answers
Leave feedback about this