// 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; }