string strConnection,strSQL;
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
strConnection ="Server=LCEC2000;Database=term;User ID=sa;Password=12345678;Trusted_Connection=False";
strSQL = "SELECT TermID,TermName FROM term;";
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL,objConnection);
objAdapter.Fill(objDataSet,"term");
数据库的名字是lgtest,用户名是sa,密码12345678
objConnection = new OleDbConnection(strConnection);这句话报错.
错误内容是System.ArgumentException: OLE DB ConnectionString
'Provider=SQLOLEDB;'
DataSet objDataSet = new DataSet();
OleDbConnection objConnection = null;
OleDbDataAdapter objAdapter = null;
strConnection ="Server=LCEC2000;Database=term;User ID=sa;Password=12345678;Trusted_Connection=False";
strSQL = "SELECT TermID,TermName FROM term;";
objConnection = new OleDbConnection(strConnection);
objAdapter = new OleDbDataAdapter(strSQL,objConnection);
objAdapter.Fill(objDataSet,"term");
数据库的名字是lgtest,用户名是sa,密码12345678
objConnection = new OleDbConnection(strConnection);这句话报错.
错误内容是System.ArgumentException: OLE DB ConnectionString
'Provider=SQLOLEDB;'
<add name="Server=LCEC2000;Database=term;User ID=sa;Password=12345678;Trusted_Connection=False" providerName="System.Data.SqlClient"/>
</connectionStrings>private static string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString"].ToString();
<add name="MyDatabaseConnectionString" connectionString="Server=LCEC2000;Database=term;User ID=sa;Password=12345678;Trusted_Connection=False" providerName="System.Data.SqlClient"/>
</connectionStrings>
objAdapter.Fill(objDataSet,"term");
这句话又报错了.
一种方案是使用sqlconnection一种是在连接串后面接一个
Provider=SQLOLEDB
即
="Server=LCEC2000;Database=term;User ID=sa;Password=12345678;Trusted_Connection=False;Provider=SQLOLEDB";
错误是
System.Data.OleDb.OleDbException: REGDB_E_CLASSNOTREG(0x80040154)
System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
还是一样的错误啊.这个错误.是不是本机必须要安装客户端啊.
不是 Provider=SQLOLEDB-----------------------------------------------------------------
(1) SQL Server 2005Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MSPetShop4;Data Source=HARDES\SQLEXPRESS
(2) SQL Server 2000Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=Hardes(3) AccessProvider=Microsoft.Jet.OLEDB.4.0;Data Source=report.mdb;Persist Security Info=False
Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\northwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True把你的data source,attachdbfilename改一下就可以了
改成Provider=SQLOLEDB后objAdapter.Fill(objDataSet,"term");这句报错为
System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server
如果你在此前加一句:
objconnection.open();肯定会报错的..
也就是说连接没有打开,或打不开
用连接字符串就像jc15271149(嘿咻) ( ) 说的那样:
在cs文件中:
(以jc15271149(嘿咻) ( ) 的为例);
string str=ConfigurationManager.AppSettings("MyDatabaseConnectionString");
就可以了