SQL 数据库的连接
using System;
using System.Data;
using System.Data.SqlClient;
namespace DataReader1App
{
/// <summary>
/// Class1 的摘要说明。
/// </summary>
class Class1
{
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void
{
//
// 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();
}
}
}