sqlCommandBuilder 更新时只需保持dataAdapter中的Selectcmd与读取时相同即可

最新推荐文章于 2017-06-20 14:57:28 发布

Yanzzz

最新推荐文章于 2017-06-20 14:57:28 发布

阅读量638

点赞数

文章标签： cmd object string

本文链接：https://blog.csdn.net/Yanzzz/article/details/1928037

版权

private void GetScores(string courseID)
        {
            SqlCommand cmd = new SqlCommand("GetScore", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@CourseID", courseID));
            da.SelectCommand = cmd;
            try
            {
                da.Fill(ds,courseID);
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

private void btnUpdate_Click(object sender, EventArgs e)
        {
            SqlCommandBuilder scb = new SqlCommandBuilder(da);
            try
            {
                foreach (DataRowView dr in ds.Tables["course"].DefaultView)
                {
                    da.SelectCommand.Parameters["@CourseID"].Value=dr["CourseID"].ToString();
                    da.Update(ds.Tables[dr["CourseID"].ToString()]);
                }
                da.SelectCommand.Parameters["@CourseID"].Value = "course";
                da.Update(ds, "course");
            }
            catch(SqlException ex)
            {
                MessageBox.Show(ex.ToString());
            }
            Refresh();
        }