dataset更新数据库的问题，请大家看这段代码有什么问题

Question

参数中少一个参数 @DepartmentName ，另外
cmd.Parameters.Add("@departmentId", SqlDbType.NVarChar);少了对应字段的名称

Answer 1

you need to do something likeSqlCommand cmd = new SqlCommand("Update Department Set DepartmentName = @DepartmentName Where DepartmentId = @departmentId", conn);
cmd.Parameters.Add("@DepartmentName", SqlDbType.NVarChar, 30, "DepartmentName");
cmd.Parameters.Add("@departmentId", SqlDbType.NVarChar, 30,"departmentId");see
http://www.dotnetjohn.com/articles/articleid106.aspx