string strconn="Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source="C:\Documents and Settings\chengjunlin1\My Documents\Visual Studio Projects\db1.mdb";Mode=Share Deny None;Jet OLEDB:Engine Type=5;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
其中
Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
老提示缺少;号,跪求!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
其中
Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
老提示缺少;号,跪求!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
问题依旧!求高手指点!
sqlConnection objCon=new sqlConnection(strCon);
依然缺少分号
给你一个参考一下吧
呵呵
this.myConnection.ConnectionString = "Data Source=\'D:\\Visual Studio Projects\\db1.mdb\';Provider=\'Microsoft.Jet.OLEDB.4.0" +
"\';User ID=Admin";
{
string username;
string mima;
username=this.textBox1.Text;
mima=this.textBox2.Text;
string sql="";
sql="select * from [user] where username='"+username+"' and password='"+mima+"'";
string strconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\db1.mdb"; OleDbConnection oleDbConnection1=new OleDbConnection(strconn);
}