我的代码如下:
我想在ComboBox中显示:全部,男,女,三个元素;(数据库中只有男女两个值)
而且加载上的值会重复很多个,请问怎么才能不显示重复的值?
我是一个新手,请各位高手援助小弟,谢谢……
private void frmTeacherMsgTable_Load(object sender, EventArgs e)
{
this.cboSelectItems.DataSource =
selectBySex.GetAllTeachers().Tables["teacherTable"];
cboSelectItems.DisplayMember = "Sex";
this.dgvTeacher.Columns["TeacherId"].HeaderText = "ID";
this.dgvTeacher.Columns["TeacherId"].Visible = false;
this.dgvTeacher.Columns["LoginId"].HeaderText = "用户名";
this.dgvTeacher.Columns["LoginPwd"].HeaderText = "密码";
this.dgvTeacher.Columns["UserStateId"].HeaderText = "用户状态";
this.dgvTeacher.Columns["TeacherName"].HeaderText = "教员姓名";
this.dgvTeacher.Columns["Sex"].HeaderText = "性别";
this.dgvTeacher.Columns["Birthday"].HeaderText = "生日";
} private void cboSelectItems_SelectedIndexChanged(object sender, EventArgs e)
{
this.dgvTeacher.DataSource =
selectBySex.GetTeacherBySex(this.cboSelectItems.Text.Trim().ToString());
}
我想在ComboBox中显示:全部,男,女,三个元素;(数据库中只有男女两个值)
而且加载上的值会重复很多个,请问怎么才能不显示重复的值?
我是一个新手,请各位高手援助小弟,谢谢……
private void frmTeacherMsgTable_Load(object sender, EventArgs e)
{
this.cboSelectItems.DataSource =
selectBySex.GetAllTeachers().Tables["teacherTable"];
cboSelectItems.DisplayMember = "Sex";
this.dgvTeacher.Columns["TeacherId"].HeaderText = "ID";
this.dgvTeacher.Columns["TeacherId"].Visible = false;
this.dgvTeacher.Columns["LoginId"].HeaderText = "用户名";
this.dgvTeacher.Columns["LoginPwd"].HeaderText = "密码";
this.dgvTeacher.Columns["UserStateId"].HeaderText = "用户状态";
this.dgvTeacher.Columns["TeacherName"].HeaderText = "教员姓名";
this.dgvTeacher.Columns["Sex"].HeaderText = "性别";
this.dgvTeacher.Columns["Birthday"].HeaderText = "生日";
} private void cboSelectItems_SelectedIndexChanged(object sender, EventArgs e)
{
this.dgvTeacher.DataSource =
selectBySex.GetTeacherBySex(this.cboSelectItems.Text.Trim().ToString());
}
解决方案 »
- 父窗体combobox的数据怎样在子窗体的combobox出现
- 小弟写了一个关于网页自动登录的程序,遇到了问题,请各位大哥给我指点迷津
- 如何通过对话框刷新主窗口界面
- 求助!用C#操作WORD生成多个表格时,如何使得上下相邻表格之间没有空行?
- CSS设置字体好奇怪的问题 有经验的人来帮忙看下!
- 关于 TreeView 的使用问题?
- 怎么在.net安装部署项目中指定system32目录
- 关于海天人系统的页面跳转问题(看似简单.)研究过海天人系统的进!
- [[分享]]树treeview的好文章和源代码
- 请问urlMappings可以设置一个不用后缀名的url吗?
- 带滚动条的winform的剪切区是什么位置呀??
- c#桌面应用程序到底该怎么发布?
cboSelectItems.DisplayMember = "Sex";
三个值可直接添加
DataTable dt = ds.Tables[0];
DataView dv= new DataView(dt);
string[] strComuns ={ "Sex" };
dt = dv.ToTable(true, strComuns);