Asp.net+access2000，数据库操作问题

leoAAAA 2002-09-04 09:32:11

各位高手，用Asp.net读取表中的关键字段，怎么读不出来啊，例如
tbla(aid,aname)现在插入一个值给aname,aid会自动增量，这时读取aid 却说为空，可是表里边已经插入新的aname,并且自动生成了一个aid。这个是在onclickbutton过程完成的。谢谢指教

...全文

24 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

leoAAAA 2002-09-04

打赏
举报

非常感谢你的帮助，我用的方法是如下
Sub LoginBtn_Click(Sender As Object, E As EventArgs)
dim strcnn as string
dim strsql as string
dim objdataset as new dataset
dim objcnn as new oledbconnection
dim objadapter as new oledbdataadapter

' set the connection and query details
strcnn="provider=microsoft.jet.oledb.4.0;" & _
"data source=mydriver:\mydata.mdb"
strsql="SELECT tbla.Aid, tbla.Aname FROM tbla "& _
"WHERE (((tbla.Aname)='" & user.identity.name & "'))"
'open the connection and set the command
objcnn=new oledbconnection(strcnn)
objadapter=new oledbdataadapter(strsql,objcnn)

'fill the dataset with the data
objadapter.fill(objdataset,"tbla")

'add new row to the table
dim objtable as datatable
dim objnewrow as datarow

objtable=objdataset.tables("tbla")
objnewrow=objtable.newrow()
objnewrow("aname")=user.identity.name
objtable.rows.add(objnewrow)

'generate the update commands
dim objbuilder as oledbcommandbuilder

objbuilder=new oledbcommandbuilder(objadapter)
objadapter.updatecommand=objbuilder.getupdatecommand()
objadapter.insertcommand=objbuilder.getinsertcommand()
objadapter.deletecommand=objbuilder.getdeletecommand()
'update the data store

objadapter1.update(objdataset,"tbla")

'get the aid
strsql="SELECT tbla.Aid, tbla.Aname FROM tblaccount "& _
"WHERE (((tbla.Aname)='" & user.identity.name & "'))"

dim objcmd as new oledbcommand(strsql,objcnn)
dim objdatareader as oledbdatareader
dim aIDnmb as string

objcnn.open
objdatareader=objcmd.executereader()

aidnmb=objdatareader("aid")

objdatareader.close
objcnn.close
'objdatareader=nothing

spring_ok 2002-09-04