数据库的连接

SQL 数据库的连接 

using System;

using System.Data;

using System.Data.SqlClient;

 

namespace DataReader1App

{

     /// <summary>

     /// Class1 的摘要说明。

     /// </summary>

     class Class1

     {

         /// <summary>

         /// 应用程序的主入口点。

         /// </summary>

         [STAThread]

         static void Main(string[] args)

         {

              //

              // TODO: 在此处添加代码以启动应用程序

              //

 

              //SqlConnection conn=new SqlConnection(@"Data Source =(local);Integrated Security=SSPI;"+"Initial Catalog=NorthWind");

              //SqlConnection conn=new SqlConnection("server=(local);database=NorthWind;UID=sa;pwd=sa");

              //SqlConnection conn=new SqlConnection(@"Data Source =.;Integrated Security=SSPI;"+"Initial Catalog=NorthWind");

              SqlConnection conn=new SqlConnection(@"Data Source=.; uid=sa; pwd=sa; Initial Catalog=Northwind");

              //SqlConnection conn=new SqlConnection(@"server=.;database=NorthWind;UID=sa;pwd=sa");

              conn.Open();

              SqlCommand cmd=conn.CreateCommand();

              cmd.CommandText="select * from Employees";

              SqlDataReader reader=cmd.ExecuteReader();

              while(reader.Read())

              {

                   Console.WriteLine("/t{0}/t{1}/t{2}",reader["EmployeeID"],reader["FirstName"],reader["LastName"]);

              }

              reader.Close();

              conn.Close();

             

         }

     }

}

 

ACCESS数据库联接

using System;

using System.Data;

using System.Data.OleDb;

 

namespace DataReader2App

{

     /// <summary>

     /// Class1 的摘要说明。

     /// </summary>

     class Class1

     {

         /// <summary>

         /// 应用程序的主入口点。

         /// </summary>

         [STAThread]

         static void Main(string[] args)

         {

              //

              // TODO: 在此处添加代码以启动应用程序

              //

              //数据源还可以写直接路径

              OleDbConnection conn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source =Northwind.mdb");

              conn.Open();

              OleDbCommand cmd=conn.CreateCommand();

              cmd.CommandText="select * from 客户";

              OleDbDataReader reader=cmd.ExecuteReader();

              while(reader.Read())

              {

                   Console.WriteLine("/t{0}/t{1}/t{2}",reader["客户ID"],reader["联系人姓名"],reader["邮政编码"]);

              }

              reader.Close();

              conn.Close();

         }

     }

}