public static void ExecuteNonquery(string v, List <SqlParameter> list) { DBLayer dbLayer = new DBLayer(); dbLayer.ExecuteNonQuery(v, list); dbLayer.Dispose(); }
public static void ExecuteNonquery(string sql) { DBLayer dbLayer = new DBLayer(); dbLayer.ExecuteNonQuery(sql); dbLayer.Dispose(); }
public static DataSet GetDataSetStatic(string storedProcedureName, List <SqlParameter> parameters, ref int returnValue) { DBLayer dbLayer = new DBLayer(); DataSet result = dbLayer.GetDataSet(storedProcedureName, parameters, ref returnValue); dbLayer.Dispose(); return(result); }