標籤:建立 name mes tables for update .sh upd new
一.綁定下拉框資料
string sql = "select * from Grade";
SqlDataAdapter sda = new SqlDataAdapter(sql,helper.Con);
sda.Fill(ds,"Grade");
//建立一個下拉框選項
DataRow row = this.ds.Tables["Grade"].NewRow();
row[0] = -1;
row[1] = "請選擇";
this.ds.Tables["Grade"].Rows.InsertAt(row,0);
//綁定下拉框
this.cbograde.DataSource=ds.Tables["Grade"];
this.cbograde.DisplayMember="GradeName";
this.cbograde.ValueMember="GradeId";
二.綁定DataGradeView資料
//根據年級查詢GradeId
string sql = "select * from Student where GradeId=‘" + this.cbograde.SelectedValue + "‘";
try
{
studentsda = new SqlDataAdapter(sql, helper.Con);
if (ds.Tables["Student"] != null) {
ds.Tables["Student"].Clear();
}
studentsda.Fill(ds, "Student");
//綁定資料來源和DataGradeView
this.dgvStudent.DataSource = ds.Tables["Student"];
}
catch (Exception x)
{
MessageBox.Show(x.Message);
}
三.實現資料更新
DialogResult result=MessageBox.Show("確定更改資訊嗎?","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Information);
if (result == DialogResult.Yes) {
SqlCommandBuilder scb = new SqlCommandBuilder(studentsda);
studentsda.Update(ds, "Student");
}
使用Windows實現資料繫結----------的解析