sqlcommandbuilder进行数据更新

来源:互联网 发布:苏州教师网络培训平台 编辑:程序博客网 时间:2024/06/10 02:36

protected void ok_Click(object sender, EventArgs e)
    {
        string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["jobmanageConnectionString"].ConnectionString;
        SqlConnection Conn = new SqlConnection(strConn);
        Conn.Open();

        DataSet ds = new DataSet();
        string strSql = "select * from jiuye where xuehao = '" + name + "'";
        SqlDataAdapter da = new SqlDataAdapter(strSql,Conn);
        da.Fill(ds, "jiuye");
        SqlCommandBuilder cb = new SqlCommandBuilder (da);
        DataTable dt = ds.Tables["jiuye"];
        DataRow dr = dt.Rows[0];
        dr["jiuyebiaozhiid"] = jybz.Text;
        da.Update(ds, "jiuye");
       
        Conn.Close();

原创粉丝点击