string connStr = "Data Source=SERVER-5;Initial Catalog=MydB;Integrated Security=SSPI;Connection Timeout=5";

        DataTable data;

        using (var connection = new SqlConnection(connStr))
        {
            try
            {
                var sda = new SqlDataAdapter("select * from pri_date", connection);
                var ds = new DataSet();
                sda.Fill(ds);
                data = ds.Tables[0];
            }
            catch (SqlException ex)
            {
                var exc = ex.InnerException;
            }
        }