Question

其他信息: Update 无法找到 TableMapping['StudentMsg'] 或 DataTable“StudentMsg”。

private void StudentFrm_Load(object sender, EventArgs e)
{

ShowStudents();
}

private SqlDataAdapter da = new SqlDataAdapter();
private DataSet ds = new DataSet("Userinfor");
private void ShowStudents()
{
string connString = @"Data Source=.\SQLEXPRESS;Data Source=DELL-PC;Initial Catalog=Userinfor;Integrated Security=True";
string sql = "select StudentId as 学号，StudentName as 姓名, sex as 性别,Brithday as 出生年月,Department as 院系,Speciality as 专业 from StudentMsg";
SqlConnection conn = new SqlConnection(connString);
conn.Open();
SqlCommand comm = new SqlCommand(sql, conn);
da.SelectCommand = comm;
SqlCommandBuilder builder = new SqlCommandBuilder(da);
da.Fill(ds, "StudentMsg");
dgvStudent.DataSource = ds.Tables["StudentMsg"];
conn.Close();
}

private void button1_Click(object sender, EventArgs e)
{
da.Update(ds, "StudentMsg");
MessageBox.Show("数据更新已经成功！", "注意", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);

}

Answer 1

首先 datatable 需要构建 datacolumn

datatable dt=new datatable();
dt.columns.add(new datacolumn("列名"))

添加数据方法（）
｛
datarow dr=dt.newRows();

dr["xxx"]=xxx;
...

dt.Rows.Add(dr);

｝