第一条:sql = "select * from user where id='" + id.Text + "'and password1='"+password.Text+"'"
改为:sql = "select * from user where id='" + id.Text + "' and password1='"+password.Text+"'"
第二条:SQL没有问题,但是你执行新增操作的话就不用DataAdapter
改为:sql="Insert Into user(id,name,password1,year,month,day) Values('"+id.Text+"','"+name.Text+"','"+password1.Text+"','"+year.Text+"','"+month.Text+"','"+day.Text+"')"
OleDbCommand DBCmd= new OleDbCommand(sql,conn)
DBCmd.ExecuteNonQuery()//新增
conn.Close()
第三条和第二条一样!增、删、改只要用OleDbCommand对象的ExecuteNonQuery函数就行了!
sql = "Update user Set touxiang='"+paths+"' where id='"+Session["id"].ToString()+"'"
OleDbCommand DBCmd= new OleDbCommand(sql,conn)
DBCmd.ExecuteNonQuery()//修改
conn.Close()
再不行就检查一下你的连着字符串吧!!!!
注:SQL语句该用空格号的地方要一定要空格号!不用会报错!