C#连接SQL server2008数据库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = null;
            SqlCommand comm = null;
            SqlDataReader sdreader = null;

            try
            {
                string ConStr = "server=192.168.21.111;uid=sa;pwd=123456;database=test110";
                conn = new SqlConnection(ConStr);
                conn.Open();

                string sql = "select * from dbo.student";
                comm = new SqlCommand(sql);
                comm.Connection = conn;
                

                sdreader = comm.ExecuteReader();
                sdreader.Read();

                Console.WriteLine("数据库连接成功！");
                Console.WriteLine("student表的内容");

                while (sdreader.Read())
                {
                    Console.WriteLine("sdreader[\"id\"]=" + sdreader["id"]);
                    Console.WriteLine("sdreader[\"name\"]=" + sdreader["name"]);
                    Console.WriteLine("sdreader[\"sex\"]=" + sdreader["sex"]);
                }

                sdreader.Close();
                conn.Close();


            }
            catch (SqlException e)
            {
                Console.WriteLine("A SqlException was thrown");
                Console.WriteLine("Number = " + e.Number);
                Console.WriteLine("Message = " + e.Message);
                Console.WriteLine("StackTrace:\n" + e.StackTrace);
            }

            Console.ReadKey();
        }
    }
}