有点纳闷？！多表联接查询却报奇怪错:字符串"后的引号不完整
现有三个表:
读者表:读者编号,读者姓名
图书表:图书编号,图书名称
借阅表:图书编号,读者编号,借书时间,还书时间
根据 输入的读者编号,在gridview中显示该读者所借书的"图书编号,图书名称,借书时间,还书时间"
请问怎样实现?
con.Open()
Dim myda As New SqlDataAdapter("select bno,bname,lenddate,returndate from bookinfo join readerinfo join booklend on bookinfo.bno=booklend.bno on readerinfo.rno=booklend.rno where rno=textbox1.text " & "'", con)
Dim myds As New DataSet
myda.Fill(myds, "bookinfo") //运行时这句上有问题提示
Me.DataGrid1.DataSource = myds
Me.DataGrid1.DataMember = "bookinfo"
我通过查阅了几本相关书籍都没能搞明白错在哪里,请高手指点!(解决后必给分)
[解决办法]
where rno=textbox1.text " & "'",
这段貌似也很奇怪啊。。。
textbox1.text 这种东西怎么会直接出现在SQL中？还有&?
[解决办法]
select bno,bname,lenddate,returndate from bookinfo join readerinfo join booklend on bookinfo.bno=booklend.bno on readerinfo.rno=booklend.rno where rno='"&textbox1.text& "'
[解决办法]
select bno,bname,lenddate,returndate from bookinfo join readerinfo join booklend on bookinfo.bno=booklend.bno on readerinfo.rno=booklend.rno where rno='"&textbox1.text& "'
