C#实现控件ComboBox绑定数据的多种方式
·
第一种:
string sql = "select meeting_no,meeting_name from meeting " +
"where meeting_company_no= '" + Form_Home.company_no + "' order by meeting_created_time desc";
DataSet dsMeeting = DBHelpers.select(Form_Home.connectionString, sql);
if (dsMeeting != null)
{
if (dsMeeting.Tables.Count > 0)
{
if (dsMeeting.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsMeeting.Tables[0].Rows.Count; i++)
{
ComboBox_MeetingName.Items.Add(dsMeeting.Tables[0].Rows[i]["meeting_name"].ToString().Trim());
}
}
}
}
第二种:
string sql = "select meeting_no,meeting_name from meeting " +
"where meeting_company_no= '" + Form_Home.company_no + "' order by meeting_created_time desc";
DataSet dsMeeting = DBHelpers.select(Form_Home.connectionString, sql);
if (dsMeeting != null)
{
if (dsMeeting.Tables.Count > 0)
{
if (dsMeeting.Tables[0].Rows.Count > 0)
{
ComboBox_MeetingName.DisplayMember = "meeting_name "; // 显示的字段
ComboBox_MeetingName.ValueMember = "meeting_no"; // 值的字段
ComboBox_MeetingName.DataSource = dsMeeting.Tables[0];
ComboBox_MeetingName.SelectedIndex = 0;
}
}
}
DAMO开发者矩阵,由阿里巴巴达摩院和中国互联网协会联合发起,致力于探讨最前沿的技术趋势与应用成果,搭建高质量的交流与分享平台,推动技术创新与产业应用链接,围绕“人工智能与新型计算”构建开放共享的开发者生态。
更多推荐

所有评论(0)