Program.cs
class Program
{
static void Main(string[] args)
{
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnStr"].ToString();
SqlConnection conn = null;
using (conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from MyTable2";
cmd.Parameters.Clear();
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
{
static void Main(string[] args)
{
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnStr"].ToString();
SqlConnection conn = null;
using (conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from MyTable2";
cmd.Parameters.Clear();
DataSet dataset = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);