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数据库的示例分享的详细内容，更多内容请关注技术你好其它相关文章！