Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
 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;
     }
 }