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

总结

以上就是C#如何连接到sql server2008数据库的示例分享的详细内容，更多请关注其它相关文章！

声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！