public static DataSet ExecuteDatasetTEST(string strConnection, string commandText)
{
if (strConnection == null) throw new ArgumentNullException("connection");
// Create a command and prepare it for execution
DbConnection conn = new TAdoDbxInterBaseConnection();
conn.ConnectionString = strConnection;
DataSet dsReturnin = new DataSet();
DataTable dt = new DataTable();
string sql = commandText;
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
DbDataReader myreader = cmd.ExecuteReader();
dsReturnin.Tables.Add(dt);
dsReturnin.Load(myreader, LoadOption.PreserveChanges, dsReturnin.Tables[0]);
myreader.Close();
conn.Close();
conn.Dispose();
return dsReturnin;
}
public static DataSet ExecuteDataset_UPDT_COMMD(string strConnection, string commandText)
{
if (strConnection == null) throw new ArgumentNullException("connection");
// Create a command and prepare it for execution
DbConnection conn = new TAdoDbxInterBaseConnection();
conn.ConnectionString = strConnection;
DataSet dsReturnin = new DataSet();
DataTable dt = new DataTable();
string sql = commandText;
DbCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
DbDataAdapter adapter = new TAdoDbxDataAdapter();
adapter.UpdateCommand = cmd;
//BdpCommand CommIns = new BdpCommand("INSERT INTO TESTTABLE VALUES(?)", Conn);
//BdpDataAdapter adapter
//adapter.InsertCommand = CommIns;
return dsReturnin;
}