C#2005与SQL2000相互连接?谁会啊
来源:百度知道 编辑:UC知道 时间:2024/05/30 17:49:00
和2003的连接方法一样
怎么连接?你是指用程序连接数据库?
using System.Data.SqlClient;
SqlConnection cn = new SqlConnection("database=test;server=.;uid=sa;pwd=sa");
cn.Open();
.
.
cn.Close();
参考
private void ConnectToSQL2000()
{
string connstr = "Provider=SQLOLEDB.1;Password=csm;Persist Security Info=True;User ID=sa;Data Source=csm;";
System.Data.OleDb.OleDbConnection oleConn = new System.Data.OleDb.OleDbConnection(connstr);
System.Data.OleDb.OleDbCommand oleCmd=oleConn.CreateCommand();
oleCmd.CommandText = "select * from testTable";
System.Data.OleDb.OleDbDataReader oleRder=oleCmd.ExecuteReader();
while (oleRder.Read())
{
string testColumn=oleRder.GetString(oleRder.GetOrdinal("testColumn"));
//...
}
}