Use SqlDataAdapter to update database, but SqlCommandBuilder required

weixin_34301132

于 2008-01-04 21:44:00 发布

阅读量80

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Winston/archive/2008/01/04/1026484.html

版权

            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/archive/2008/01/04/1026484.html