// execute SQL statement
public int ExecSQL(cDB obj, string sql, bool is_quary)
{
dbCmd = new OdbcCommand(sql, dbCon);
dbCon.Open();
if(is_quary)
{
// select
using(OdbcDataReader dbr = dbCmd.ExecuteReader())
{
int count;
object[] row;
while (dbr.Read())
{
// read each row at a time
count = dbr.FieldCount;
row = new object[count];
dbr.GetValues(row);
obj.ReadData(row);
}
}
}
else
{
// delete, create, update, insert
dbCmd.ExecuteNonQuery();
}
return 0;
}
// execute SQL statement
public int ExecSQL(cDB obj, string sql, bool is_quary)
{
dbCmd = new OdbcCommand(sql, dbCon);
dbCon.Open();
if (is_quary)
{
// select
using (OdbcDataReader dbr = dbCmd.ExecuteReader())
{
int count;
object[] row;
while (dbr.Read())
{
// read each row at a time
count = dbr.FieldCount;
row = new object[count];
dbr.GetValues(row);
obj.ReadData(row);
}
}
}
else
{
// delete, create, update, insert
dbCmd.ExecuteNonQuery();
}
return(0);
}
// execute SQL statement
public int ExecSQL(cDB obj, string sql, bool is_quary)
{
if(is_quary)
{
// select
using( DbDataAdapter dbda = new OleDbDataAdapter(sql, dbCon) )
{
obj.FillList(dbda);
}
}
else
{
// delete, create, update, insert
dbCmd = new OleDbCommand(sql, dbCon);
dbCon.Open();
dbCmd.ExecuteNonQuery();
}
return 0;
}
// execute SQL statement
public int ExecSQL(cDB obj, string sql, bool is_quary)
{
if (is_quary)
{
// select
using (DbDataAdapter dbda = new OleDbDataAdapter(sql, dbCon))
{
obj.FillList(dbda);
}
}
else
{
// delete, create, update, insert
dbCmd = new OleDbCommand(sql, dbCon);
dbCon.Open();
dbCmd.ExecuteNonQuery();
}
return(0);
}
// execute special select SQL statement
public int ExecSQL_RowCount(cDB obj, string sql, string tbl_name)
{
int rc = 0;
dbCmd = new OdbcCommand(sql, dbCon);
dbCon.Open();
using (OdbcDataReader dbr = dbCmd.ExecuteReader()) {
int count;
object[] row;
if (dbr.Read())
{
count = dbr.FieldCount;
row = new object[count];
dbr.GetValues(row);
rc = Convert.ToInt32(row[0]);
}
}
return(rc);
}
// execute special select SQL statement
public int ExecSQL_RowCount(cDB obj, string sql, string tbl_name)
{
int rc = 0;
using(DbDataAdapter dbda = new OleDbDataAdapter(sql, dbCon))
{
using(DataTable dtbl = new DataTable(tbl_name))
{
dbda.Fill(dtbl);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows[0].ItemArray.Length > 0)
{
rc = Convert.ToInt32(dtbl.Rows[0].ItemArray[0]);
}
}
}
}
return rc;
}
// execute special select SQL statement
public int ExecSQL_RowCount(cDB obj, string sql, string tbl_name)
{
int rc = 0;
using (DbDataAdapter dbda = new OleDbDataAdapter(sql, dbCon))
{
using (DataTable dtbl = new DataTable(tbl_name))
{
dbda.Fill(dtbl);
if (dtbl.Rows.Count > 0)
{
if (dtbl.Rows[0].ItemArray.Length > 0)
{
rc = Convert.ToInt32(dtbl.Rows[0].ItemArray[0]);
}
}
}
}
return(rc);
}
// execute special select SQL statement
public int ExecSQL_RowCount(cDB obj, string sql, string tbl_name)
{
int rc = 0;
dbCmd = new OdbcCommand(sql, dbCon);
dbCon.Open();
using(OdbcDataReader dbr = dbCmd.ExecuteReader()) {
int count;
object[] row;
if(dbr.Read())
{
count = dbr.FieldCount;
row = new object[count];
dbr.GetValues(row);
rc = Convert.ToInt32(row[0]);
}
}
return rc;
}
