s.m_PubsDataSet = new System.Data.DataSet();
            ((System.ComponentModel.ISupportInitialize)(this.m_PubsDataSet)).BeginInit();
            //
            // m_con
            //
            this.m_con.ConnectionString = configurationAppSettings.Get("m_con.ConnectionString");
            //
            // m_cmdAuthorsSelect
            //
            this.m_cmdAuthorsSelect.CommandText = "SELECT au_id, au_lname, au_fname, phone, address, city, state, zip, contract FROM" +
                " authors";
            this.m_cmdAuthorsSelect.Connection = this.m_con;
            //
            // m_cmdAuthorsInsert
            //
            this.m_cmdAuthorsInsert.CommandText = @"INSERT INTO authors(au_id, au_lname, au_fname, phone, address, city, state, zip, contract) VALUES (@au_id, @au_lname, @au_fname, @phone, @address, @city, @state, @zip, @contract); SELECT au_id, au_lname, au_fname, phone, address, city, state, zip, contract FROM authors WHERE (au_id = @Select_au_id)";
            this.m_cmdAuthorsInsert.Connection = this.m_con;
            this.m_cmdAuthorsInsert.Parameters.Add(new System.Data.SqlClient.SqlParameter("@au_id", System.Data.SqlDbType.Char, 11, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "au_id", System.Data.DataRowVersion.Current, null));
            this.m_cmdAuthorsInsert.Parameters.Add(new System.Data.SqlClient.SqlParameter("@au_lname", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "au_lname", System.Data.DataRowVersion.Current, null));
            this.m_cmdAuthorsInsert.Parameters.Add(new System.Data.SqlClient.SqlParameter("

上一页  [1] [2] [3] [4] [5] [6] [7] 下一页

在google里搜索更多实现一个客户端的DataSet-----ClientDataSetDataProvider.asmx.cs(1)

	Web www.51ec.org

上一篇信息学院： 关于DataGrid对象的属性设置(VB)

下一篇信息学院： 实现一个客户端的DataSet-----index.htm