一. 连接 Access
public static void Query()
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\VTT.mdb";
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * from Error WHERE ErrorCode=262212";
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.Write(dr[i] + " ");
}
Console.WriteLine();
}
}
}
二. 连接 Sql
public static void QuerySql()
{
string connectionString = "server=localhost;uid=SubSonicTest;pwd=SubSonicTest;database=SubSonicTest";
using (SqlConnection conn = new SqlConnection(connectionString))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * from Branch WHERE DeptCode=0104";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.Write(dr[i] + " ");
}
Console.WriteLine();
}
}
}
补充:
1) SqlDataAdapter 与 SqlDataReader 区别?
2) ExecuteReader、ExecuteNonQuery、ExecuteScalar 的使用