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

           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);