用gridview显示数据，重复两行，检查了数据库是视图的问题

[sue7617]

[於黾]

那把视图改了不就得了,有什么问题

[sue7617]

关键是我不会该啊！这是做的毕业谁，图书管理系统。

[sue7617]

SELECT dbo.Book.bookid, dbo.Book.bookname, dbo.Reader.rid,dbo.Reader.Rname, dbo.tb_borrowback.rid, dbo.tb_borrowback.id, dbo.tb_borrowback.bookid, dbo.Book.publish, dbo.Book.stack, dbo.Book.price,
dbo.tb_borrowback.borrowTime, dbo.tb_borrowback.shouldbackTime, dbo.tb_borrowback.isback, dbo.Reader.rid AS Expr1, dbo.Book.bookid AS Expr2
FROM dbo.Book INNER JOIN
dbo.tb_borrowback ON dbo.Book.bookid = dbo.tb_borrowback.bookid CROSS JOIN
dbo.Reader

[-小蕾-]

引用 7 楼 sue7617 的回复:

SELECT dbo.Book.bookid, dbo.Book.bookname, dbo.Reader.rid,dbo.Reader.Rname, dbo.tb_borrowback.rid, dbo.tb_borrowback.id, dbo.tb_borrowback.bookid, dbo.Book.publish, dbo.Book.stack, dbo.Book.price, dbo.tb_borrowback.borrowTime, dbo.tb_borrowback.shouldbackTime, dbo.tb_borrowback.isback, dbo.Reader.rid AS Expr1, dbo.Book.bookid AS Expr2 FROM dbo.Book INNER JOIN dbo.tb_borrowback ON dbo.Book.bookid = dbo.tb_borrowback.bookid CROSS JOIN dbo.Reader

改成我上面写的 select * from tb_borrowback as a,Book as b,Reader as c where a.bookid=b.bookid and a.rid=c.rid试试

[sue7617]

在VS2005里用的gridview，调试时间数据重复两行显示，刚开始以为是数据绑定的问题，去视图里面看看，视图就重复了。

[昵称不能为空噢噢噢噢]

那你 查看视图sql脚本怎么写的

[exception92]

脚本 贴出来看看 rid，bookid 应该对应 左边的2个表

[-小蕾-]

视图的SQL脚本贴出来看看，表应该是这么关联： select * from tb_borrowback as a,Book as b,Reader as c where a.bookid=b.id and a.rid=c.rid