连接Acce2000是这样子 using System; using System.Data; using System.Data.OleDb;string str1; string str2; OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:\\数据库.mdb"); OleDbCommand cmd = new OleDbCommand("select * from 表名 ",con); con.Open(); OleDbDataReader reader = cmd.ExecuteReader();
连接SqlServer2000是大致这样子 using System; using System.Data; using System.Data.SqlClient;string str1; string str2; SqlConnection con = new SqlConnection("Server=服务器名;Database=数据库名;uid=sa;pwd=密码"); SqlCommand cmd = new SqlCommand("select * from 表名 ",con); con.Open(); SqlDataReader reader = cmd.ExecuteReader();
using System;
using System.Data;
using System.Data.OleDb;string str1;
string str2;
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:\\数据库.mdb");
OleDbCommand cmd = new OleDbCommand("select * from 表名 ",con);
con.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
str1 = reader.GetString(0);
str2 = reader.GetString(1);
}
using System;
using System.Data;
using System.Data.SqlClient;string str1;
string str2;
SqlConnection con = new SqlConnection("Server=服务器名;Database=数据库名;uid=sa;pwd=密码");
SqlCommand cmd = new SqlCommand("select * from 表名 ",con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
str1 = reader.GetString(0);
str2 = reader.GetString(1);
}
谢谢
比如在C:\根目录下有一个iwant.mdb数据库文件,有一张表TRY
TRY有3个字段,分别为 PN(字符型),imsi(字符型),akey(字符型)using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;class my
{
static void Main()
{
string imsi="", akey=""; OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:\\iwant.mdb");
OleDbCommand cmd = new OleDbCommand("select IMSI,AKEY from TRY where PN ='5630000'", conn);
conn.Open();
OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read())
{
imsi = reader.GetString(0);
akey = reader.GetString(1);
} conn.Close();
Console.WriteLine("{0},{1}", imsi, akey);
}
}
在vs2005调试通过