Vb中datagrid数据显示不出来,急~~~
我用的是vb和access
datagrid的datasource已设置,连接语句的部分代码如下:
'设置ADO控件的连接字符串
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
+ App.Path + "\Books.mdb;Persist Security Info=False"
'设置数据源
Adodc1.RecordSource = "SELECT l.Id AS 编号,l.BookNo AS 图书编号,b.BookName AS 图书名称," _
+ "l.BCount AS 借阅数量,l.ReturnDate AS 应归还日期 FROM BorrowList l,BookInfo b " _
+ " WHERE l.BookNo=b.BookNo AND BNo='" + Trim(txtBorrowNo) + "'"
Adodc1.Refresh
触发事件后datagrid控件中会多一行,但是没有任何数据显示,这是怎么回事啊,明天就要答辩了,急~~~