C# (CSharp) DataAccess AutoCreatAdapterCommand Examples

Example #1

File: DataAccess.cs Project: computer2011/computer2011

        public bool Excute(string TableName, DataTable Table, SqlDataAdapter SqlDa)
        {
            AutoCreatAdapterCommand AC = new AutoCreatAdapterCommand(TableName, "SQL Server");

            SqlDa.TableMappings.Add(AC.TableMapping);
            SqlDa.AcceptChangesDuringUpdate = true;
            AC.InsertString.Connection      = this.DC.myConn;
            AC.DeleteString.Connection      = this.DC.myConn;
            AC.UpdateString.Connection      = this.DC.myConn;
            SqlDa.InsertCommand             = (SqlCommand)AC.InsertString;
            SqlDa.UpdateCommand             = (SqlCommand)AC.UpdateString;
            SqlDa.DeleteCommand             = (SqlCommand)AC.DeleteString;
            try
            {
                SqlDa.Update(Table);
                return(true);
            }
            catch
            {
                return(false);
            }
        }

Example #2

File: DataAccess.cs Project: pwf2/Tell1

 public bool Excute(string TableName, DataTable Table, SqlDataAdapter SqlDa)
 {
     AutoCreatAdapterCommand AC = new AutoCreatAdapterCommand(TableName, "SQL Server");
     SqlDa.TableMappings.Add(AC.TableMapping);
     SqlDa.AcceptChangesDuringUpdate = true;
     AC.InsertString.Connection = this.DC.myConn;
     AC.DeleteString.Connection = this.DC.myConn;
     AC.UpdateString.Connection = this.DC.myConn;
     SqlDa.InsertCommand = (SqlCommand)AC.InsertString;
     SqlDa.UpdateCommand = (SqlCommand)AC.UpdateString;
     SqlDa.DeleteCommand = (SqlCommand)AC.DeleteString;
     try
     {
         SqlDa.Update(Table);
         return true;
     }
     catch
     {
         return false;
     }
 }