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();    }  }}

总结

更多相关文章

随机推荐