每张单对应多个值,想将每张单子号从表中读出来,然后将 checkedListBox1(包含每张单取值范围) 其中数据比较,若相同
则将其选中
string sql= " select pr from sd_tbl ";
SqlDataReader sqlread = boperate.getread(sql);
if (sqlread.HasRows)
{
while (sqlread.Read())
{ string pr= sqlread["pr"].ToString().Trim(); for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
if(checkedListBox1.Items[i].ToString()==pr ) { checkedListBox1.SetItemChecked(i,true ); }
}
}
}
则将其选中
string sql= " select pr from sd_tbl ";
SqlDataReader sqlread = boperate.getread(sql);
if (sqlread.HasRows)
{
while (sqlread.Read())
{ string pr= sqlread["pr"].ToString().Trim(); for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
if(checkedListBox1.Items[i].ToString()==pr ) { checkedListBox1.SetItemChecked(i,true ); }
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货