public static int do_nonquery(DbCommand input_comm)//带参增删改,例子见方法后面 { #if SQLSERVER SqlConnection myconn = Hc_db.createConn(); SqlCommand mycomm =(SqlCommand)input_comm; #elif MYSQL MySqlConnection myconn = Hc_db.createConn(); MySqlCommand mycomm =(MySqlCommand)input_comm; #else OleDbConnection myconn = Hc_db.createConn(); OleDbCommand mycomm = (OleDbCommand)input_comm; #endif mycomm.Connection = myconn; try { int c; myconn.Open(); c=mycomm.ExecuteNonQuery(); myconn.Close(); //myconn.Dispose(); return c; } catch (Exception e1) { //HttpContext.Current.Response.Write("<script language='javascript' defer>alert('" + e1.ToString() + "');</script>"); throw (e1); //return false; } }
public static DataTable get_datatable(string s1) { #if SQLSERVER SqlConnection myconn = Hc_db.createConn(); SqlDataAdapter myda = new SqlDataAdapter(s1, myconn); #elif MYSQL MySqlConnection myconn = Hc_db.createConn(); MySqlDataAdapter myda = new MySqlDataAdapter(s1, myconn); #else OleDbConnection myconn = Hc_db.createConn(); OleDbDataAdapter myda = new OleDbDataAdapter(s1, myconn); #endif DataSet myds = new DataSet(); try { myconn.Open(); myda.Fill(myds, "No1"); myconn.Close(); //myconn.Dispose(); return myds.Tables["No1"]; } catch (Exception e1) { throw (e1); } }
public static DataTable get_datatable(DbCommand input_comm)//带参查询,例子见后面 { #if SQLSERVER SqlCommand mycomm = (SqlCommand)input_comm; mycomm.Connection = Hc_db.createConn(); SqlDataAdapter myda = new SqlDataAdapter(mycomm); #elif MYSQL MySqlCommand mycomm = (MySqlCommand)input_comm; mycomm.Connection = Hc_db.createConn(); MySqlDataAdapter myda = new MySqlDataAdapter(mycomm); #else OleDbCommand mycomm = (OleDbCommand)input_comm; mycomm.Connection = Hc_db.createConn(); OleDbDataAdapter myda = new OleDbDataAdapter(mycomm); #endif DataSet myds = new DataSet(); try { myda.Fill(myds, "No1"); return myds.Tables["No1"]; } catch (Exception e1) { throw (e1); } }