private void BindData()
{ SqlConnection conn1 = OAconn.conn();
conn1.Open();
SqlDataAdapter sda = new SqlDataAdapter("select Uid,Uname,Ucode,identifyID,Ure from User", conn1);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}运行的时候总说“关键字User附近有语法错误”,就是找不到,求助!急用,大家帮帮忙啊!
{ SqlConnection conn1 = OAconn.conn();
conn1.Open();
SqlDataAdapter sda = new SqlDataAdapter("select Uid,Uname,Ucode,identifyID,Ure from User", conn1);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}运行的时候总说“关键字User附近有语法错误”,就是找不到,求助!急用,大家帮帮忙啊!
user在数据库是关键字 所以要这样
select Uid,Uname,Ucode,identifyID,Ure from User这里的USER表与数据库默认的User冲突了select Uid,Uname,Ucode,identifyID,Ure from [User]试一试
这句sql语句报错了,估计是全角或者什么错误,去数据库执行以下看看就知道了!