Connect SQL Server to VS

Try this:

Using System.OleDb;

        OleDbConnection x;
        OleDbCommand y;
        OleDbDataReader z;
        private void Form1_Load(object sender, EventArgs e)
        {
            x = new OleDbConnection(@"provider=sqloledb;Data Source=LAB5\SQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI;");
            x.Open();

            y = new OleDbCommand("select * from emp", x);
            z = y.ExecuteReader();

            while (z.Read())
            {
                MessageBox.Show(z["empno"].ToString() + " " +z["ename"].ToString());
            }

            x.Close();
        }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anubhav Chaudhary12y ago
Try this:

Using System.OleDb;

        OleDbConnection x;
        OleDbCommand y;
        OleDbDataReader z;
        private void Form1_Load(object sender, EventArgs e)
        {
            x = new OleDbConnection(@"provider=sqloledb;Data Source=LAB5\SQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI;");
            x.Open();

            y = new OleDbCommand("select * from emp", x);
            z = y.ExecuteReader();

            while (z.Read())
            {
                MessageBox.Show(z["empno"].ToString() + " " +z["ename"].ToString());
            }

            x.Close();
        }
12y ago
http://razibdeb.wordpress.com/2011/01/23/sql-server-2008-basics-connection-with-vs2010/