// :::::::::::: Use this method to Execute a query string :::::::::::: public void ExecuteCommand(string MyQuery) { con = dbCon.dbConnect(); con.Open(); SqlCommand sqlComm = new SqlCommand(MyQuery, con); sqlComm.ExecuteNonQuery(); con.Close(); }
// :::::::::::: Use this method to execute query by DataReader :::::::::::: public SqlDataReader getDataReader(string MyQuery) { SqlConnection con = new SqlConnection(); dbConnection dbCon = new dbConnection(); con = dbCon.dbConnect(); con.Open(); SqlCommand cmd = new SqlCommand(MyQuery, con); return(cmd.ExecuteReader()); }
// :::::::::::: Use this method to return a DataSet from query string :::::::::::: public DataSet getDataSet(string MyQuery, string MyString) { SqlConnection con = new SqlConnection(); dbConnection dbCon = new dbConnection(); SqlDataAdapter daGen; DataSet dsGen; dsGen = new DataSet(); con = dbCon.dbConnect(); daGen = new SqlDataAdapter(MyQuery, con); daGen.Fill(dsGen, MyString); return(dsGen); }
public static DataTable getResultStringConvert(string MyQuery) { DataTable dt = new DataTable(); SqlConnection con1 = new SqlConnection(); dbConnection dbCon1 = new dbConnection(); SqlDataAdapter daGen1; DataSet dsGen1; dsGen1 = new DataSet(); con1 = dbCon1.dbConnect(); daGen1 = new SqlDataAdapter(MyQuery, con1); daGen1.Fill(dsGen1); dt = dsGen1.Tables[0]; return(dt); }
// :::::::::::: Use this method to return a DataTable from query string :::::::::::: public DataTable getDataTable(string MyQuery, string MyTable) { DataTable dt = new DataTable(); SqlConnection con1 = new SqlConnection(); dbConnection dbCon1 = new dbConnection(); SqlDataAdapter daGen1; DataSet dsGen1; dsGen1 = new DataSet(); con1 = dbCon1.dbConnect(); daGen1 = new SqlDataAdapter(MyQuery, con1); daGen1.Fill(dsGen1, MyTable); dt = dsGen1.Tables[MyTable]; dsGen1.Tables.Remove(MyTable); return(dt); }