public DataTable dbActionSet(SqlCommand command, databaseAction action) { //Connecting to a database string connectdbbe = ConfigurationManager.ConnectionStrings["dbconnect"].ConnectionString; //Declare connecting to a database with the name dbcon SqlConnection dbcon; //Using the connection dbcon = new SqlConnection(connectdbbe); command.Connection = dbcon; dbcon.Open(); DataTable result = new DataTable(); if (action == databaseAction.Execute) { command.ExecuteNonQuery(); } else if (action == databaseAction.Read) { SqlDataAdapter ad = new SqlDataAdapter(command); ad.Fill(result); } dbcon.Close(); return(result); }
public DataTable dbActionSet(SqlCommand query, databaseAction dba) { return(db.dbActionSet(query, dba)); }