
vs2008 access数据库访问出现 From子句语法错误
try{stringconstr="Provider=Microsoft.JET.OLEDB.4.0;DataSource=D:\\music\\project\\Img...
try
{
string constr = "Provider = Microsoft.JET.OLEDB.4.0; Data Source=D:\\music\\project\\ImgSearch\\ImgSearch\\bin\\Debug\\image.mdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
string str = "Select * from user ";
// OleDbDataAdapter dataAdapter = new OleDbDataAdapter(str, con);
OleDbDataAdapter mdt = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(str, con);
mdt.SelectCommand = cmd;
DataSet ds = new DataSet();
mdt.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
catch { }
//运行到mdt.fill(ds)时捕捉到异常:From子句语法错误
//求高人指点 展开
{
string constr = "Provider = Microsoft.JET.OLEDB.4.0; Data Source=D:\\music\\project\\ImgSearch\\ImgSearch\\bin\\Debug\\image.mdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
string str = "Select * from user ";
// OleDbDataAdapter dataAdapter = new OleDbDataAdapter(str, con);
OleDbDataAdapter mdt = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(str, con);
mdt.SelectCommand = cmd;
DataSet ds = new DataSet();
mdt.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
catch { }
//运行到mdt.fill(ds)时捕捉到异常:From子句语法错误
//求高人指点 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询