Use SqlDataAdapter to update database, but SqlCommandBuilder required

            SqlDataAdapter da = new SqlDataAdapter();
           SqlCommand cmd = new SqlCommand("select * from t_upload", conn);
           da.SelectCommand = cmd;
         
           SqlCommandBuilder cb = new SqlCommandBuilder(da);

           DataSet ds = new DataSet();
           da.Fill(ds, "upload");
           DataRow newrow = ds.Tables[0].NewRow();
           newrow["filesize"] = filesize;
           newrow["filename"] = filename;
           newrow["filecontent"] = content;
           ds.Tables[0].Rows.Add(newrow);
           fs.Close();
           da.Update(ds, "upload");
           conn.Close();

原文地址:https://www.cnblogs.com/Winston/p/1026484.html