private void toolStripButton8_Click(object sender, EventArgs e)
{
BindingNavigator bn = this.学生信息DataSet.stuinfo;
bn.RowFilter = "userno='" + this.txtSuserno.Text + "'";
dt[0]["sex"] = this.comSsex.SelectedValue;
this.stuinfoTableAdapter.Update(this.学生信息DataSet.stuinfo);
MessageBox.Show("修改成功");
}
代码不完全 具体是用comSsex.SelectedValue 里面放了性别男、女。
我想把男女存储到表里面。例子
DataTable ds = new DataTable();
ds.Columns.Add("roleid", typeof(Int16));
ds.Columns.Add("rolename", typeof(string));
DataRow dx;
dx = ds.NewRow();
dx["roleid"] = 1;
dx["rolename"] = "组长";
ds.Rows.Add(dx);
dx = ds.NewRow();
dx["roleid"] = 0;
dx["rolename"] = "组员";
ds.Rows.Add(dx);
this.cmdRole.DataSource = ds;
this.cmdRole.DisplayMember = "rolename";
this.cmdRole.ValueMember = "roleid";DataView dv = new DataView(this.studentDbDataSet.groups);
dv.RowFilter = "stuid='" + this.textBox1.Text + "'";
dv[0]["stuid"] = this.textBox1.Text;
dv[0]["stugroup"] = this.cmdGroup.SelectedValue;
dv[0]["roles"] = this.cmdRole.SelectedValue;
this.groupsTableAdapter.Update(this.studentDbDataSet);
MessageBox.Show("数据添加成功");这个例子用的是dataview拖名字 我那个没有用dataview
不知道要怎么改。。哪位高手教教
{
BindingNavigator bn = this.学生信息DataSet.stuinfo;
bn.RowFilter = "userno='" + this.txtSuserno.Text + "'";
dt[0]["sex"] = this.comSsex.SelectedValue;
this.stuinfoTableAdapter.Update(this.学生信息DataSet.stuinfo);
MessageBox.Show("修改成功");
}
代码不完全 具体是用comSsex.SelectedValue 里面放了性别男、女。
我想把男女存储到表里面。例子
DataTable ds = new DataTable();
ds.Columns.Add("roleid", typeof(Int16));
ds.Columns.Add("rolename", typeof(string));
DataRow dx;
dx = ds.NewRow();
dx["roleid"] = 1;
dx["rolename"] = "组长";
ds.Rows.Add(dx);
dx = ds.NewRow();
dx["roleid"] = 0;
dx["rolename"] = "组员";
ds.Rows.Add(dx);
this.cmdRole.DataSource = ds;
this.cmdRole.DisplayMember = "rolename";
this.cmdRole.ValueMember = "roleid";DataView dv = new DataView(this.studentDbDataSet.groups);
dv.RowFilter = "stuid='" + this.textBox1.Text + "'";
dv[0]["stuid"] = this.textBox1.Text;
dv[0]["stugroup"] = this.cmdGroup.SelectedValue;
dv[0]["roles"] = this.cmdRole.SelectedValue;
this.groupsTableAdapter.Update(this.studentDbDataSet);
MessageBox.Show("数据添加成功");这个例子用的是dataview拖名字 我那个没有用dataview
不知道要怎么改。。哪位高手教教
2 adapter.Update(ds);
3 ds.AcceptChanges();