c# 通过 DataSet 对象更新数据库

来源:百度文库 编辑:神马文学网 时间:2024/05/10 09:47:03
c# 通过 DataSet 对象更新数据库2009-07-27 15:44

           string sConnectionString;

            // 链接字符串,根据实际情况修改

            sConnectionString = "Password=;User ID=sa;"
                + "Initial Catalog=pubs;"
                + "Data Source=(local)";

            SqlConnection objConn
                = new SqlConnection(sConnectionString);
            objConn.Open();

            // 创建DataAdapter实例

            SqlDataAdapter daAuthors
                = new SqlDataAdapter("Select * From Authors", objConn);