C#如何串連到sql server2008資料庫的樣本分享

這篇文章主要介紹了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();    }  }}

總結