数据控件

Question

SqlDataSource1的配置为:SELECT [WdID], [Applicant], [ApplicationTime] FROM [Jy]

GridView1的数据源选择:SqlDataSource1

SqlDataSource2的配置为:SELECT [WdID], [Applicant], [ApplicationTime], [Purpose] FROM [Jy] WHERE (([WdID] = @WdID) AND ([Applicant] = @Applicant))   备注: @WdID和@Applicant为GridView1选择行的值.

DetailsView1的数据源选择:SqlDataSource2

问题:如果SqlDataSource2如上配置,DetailsView1无法显示数据. 如果SqlDataSource2的配置为:SELECT [WdID], [Applicant], [ApplicationTime], [Purpose] FROM [Jy] WHERE ([WdID] = @WdID) ,DetailsView1显示数据.

如何解决以上问题?谢谢回答 

Answer 1

Hi Tjstsl,

>> SELECT [WdID], [Applicant], [ApplicationTime], [Purpose] FROM [Jy] WHERE (([WdID] = @WdID) AND ([Applicant] = @Applicant))  ，如果SqlDataSource2如上配置,DetailsView1无法显示数据

这里说的无法显示数据指的是获取不到数据还是前端无法显示呢？如果where后面的条件无法满足，SQL Server是不会返回数据的，按照你的描述，问题应该是出在@Applicant返回的数据上，SQL Server匹配不到同时满足[Applicant] = @Applicant和[WdID] = @WdID的行，你检查一下@Applicant的返回值是不是有什么问题。

我们可以使用SQL Server Profiler来辅助检查，这个工具可以抓取对应客户端在SQL Server上执行的查询语句，然后用SSMS执行一下这个语句，看一下是不是没有对应的行。

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].