public static DataTable MyMethod(string Query) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(Query, StaticSqlConnection); da.Fill(dt); List <SelectListItem> list = new List <SelectListItem>(); StaticSqlConnection.Close(); return(dt); }
public DataStores() { _connection = StaticSqlConnection.GetConnection(); }