C#连接到sql server2008数据库的实例代码

namespace MyFirstApp{  class Program  {    static void Main(string[] args)    {      SqlConnection conn = null;      SqlCommand comm = null;      SqlDataReader sdreader = null;      try      {        string ConStr = "server=192.168.1.110;uid=sa;pwd=woaifr0828;database=shudiansuo";        conn = new SqlConnection(ConStr);        conn.Open();        string sql = "select * from dbo.Member";        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["MemberName"]);          Console.WriteLine("sdreader[/"sex/"]=" + sdreader["PhoneNum"]);        }        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();    }  }}