using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace ClientSideDataSets
{
    public class ClientDataSetDataProvider : System.Web.Services.WebService
    {
        private System.Data.SqlClient.SqlDataAdapter m_AuthorsAdapter;
        private System.Data.SqlClient.SqlCommand m_cmdAuthorsSelect;
        private System.Data.SqlClient.SqlCommand m_cmdAuthorsInsert;
        private System.Data.SqlClient.SqlCommand m_cmdAuthorsUpdate;
        private System.Data.SqlClient.SqlCommand m_cmdAuthorsDelete;
        private System.Data.DataSet m_PubsDataSet;
        private System.Data.SqlClient.SqlConnection m_con;
    
        public ClientDataSetDataProvider()
        {
                      InitializeComponent();
        }

        #region Component Designer generated code
        private void InitializeComponent()
        {
            System.Collections.Specialized.NameValueCollection configurationAppSettings = System.Configuration.ConfigurationSettings.AppSettings;
            this.m_con = new System.Data.SqlClient.SqlConnection();
            this.m_cmdAuthorsSelect = new System.Data.SqlClient.SqlCommand();
            this.m_cmdAuthorsInsert = new System.Data.SqlClient.SqlCommand();
            this.m_cmdAuthorsUpdate = new System.Data.SqlClient.SqlCommand();
            this.m_cmdAuthorsDelete = new System.Data.SqlClient.SqlCommand();
            this.m_AuthorsAdapter = new System.Data.SqlClient.SqlDataAdapter();
            this.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 FR