G
Guest
I'm trying to bind my listbox to a SQL query like this:
using (SqlConnection conn = new SqlConnection(CONN_STR)) {
using (SqlDataAdapter da = new SqlDataAdapter("roboticSiteNames", conn)) {
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
lbSiteCode.DataSource = dt;
lbSiteCode.DisplayMember = dt.Columns[0].ColumnName;
lbSiteCode.ValueMember = dt.Columns[1].ColumnName;
}
}
Column 0 is a varchar(10), and column 1 is a tinyint. I see the names
properly in the listbox, but when I get into my event handler to see which
item was selected, and I do this: lbSiteCode.SelectedValue.ToString()
I get back a DataRowView instead of the expected tinyint value. What am I
doing wrong?
using (SqlConnection conn = new SqlConnection(CONN_STR)) {
using (SqlDataAdapter da = new SqlDataAdapter("roboticSiteNames", conn)) {
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
lbSiteCode.DataSource = dt;
lbSiteCode.DisplayMember = dt.Columns[0].ColumnName;
lbSiteCode.ValueMember = dt.Columns[1].ColumnName;
}
}
Column 0 is a varchar(10), and column 1 is a tinyint. I see the names
properly in the listbox, but when I get into my event handler to see which
item was selected, and I do this: lbSiteCode.SelectedValue.ToString()
I get back a DataRowView instead of the expected tinyint value. What am I
doing wrong?