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);
        }
Beispiel #2
0
 public DataStores()
 {
     _connection = StaticSqlConnection.GetConnection();
 }