问题描述
PrivateSubclick(ByValsenderAsObject,_ByValeAsSystem.EventArgs)Dimstrconn,strsqlAsStringDimmyconnAsOleDbConnectionaddress.Text=Replace(address.Text,Chr(39),"'")DimcmdAsOleDbCommandstrconn="Provider=Microsoft.Jet.OLEDB.4.0;DataSource="&Server.MapPath("App_Data/db1.mdb")myconn=NewOleDbConnection(strconn)myconn.Open()strsql="Insertintomember(Firstname,Surname,E-mail,Address,Postcode,Password,Username)Values('"&firstname.Text&"','"&surname.Text&"','"&email.Text&"','"&address.Text&"','"&postcode.Text&"','"&password.Text&"','"&username.Text&"')"cmd=NewOleDbCommand(strsql,myconn)cmd.ExecuteNonQuery()myconn.Close()EndSub一调试就说insert语句错误....求高手帮看看在线等~~
解决方案
解决方案二:
数据库文件的权限?
解决方案三:
好象没有设到...access我只新建表然后设计插入了2个数据...
时间: 2024-09-20 00:19:28