再问gridview与detailsview关联的有关问题
日期：2014-05-18 浏览次数：20442 次
再问gridview与detailsview关联的问题
刚才问了有关gridview与detailsview关联的问题
就是如何选定gridview的一行后在detailsview中显示这行的详细信息
我按着大家给的方法试了一下，将两个控件都绑定到同一个数据源控件，再加上如下代码。但是还有问题
<asp:SqlDataSource ID= "SqlDataSource1 " runat= "server "FilterExpression= "CproductName= '@CproductName ' "selectcommand= "Select * FROM [product] "...>
<filterparameters>
<asp:ControlParameter Name= "CproductName "
ControlId= "GridView1 "
PropertyName= "SelectedValue " />
</filterparameters>
但是在gridview中点了select之后 页面上什么都没有，请问 这是怎么回事啊？
请高手解决！
------解决方案--------------------
似乎得两个 SqlDataSource
Demo
<%@ Page Language= "C# " %>
<html>
<body>
<form id= "Form1 " runat= "server ">
<div>
<table>
<tr>
<td>
<asp:GridView ID= "GridView1 " runat= "server "
AutoGenerateColumns= "False " DataSourceID= "Customers "
DataKeyNames= "CustomerID ">
<Columns>
<asp:CommandField ShowSelectButton= "True " />
<asp:BoundField DataField= "ContactName " HeaderText= "ContactName " />
<asp:BoundField DataField= "CompanyName " HeaderText= "CompanyName " />
</Columns>
</asp:GridView>
</td>
<td valign= "top ">
<asp:DetailsView ID= "DetailsView1 " runat= "server "
AutoGenerateRows= "True " DataKeyNames= "CustomerID "
DataSourceID= "Details " Height= "50px " Width= "301px ">
</asp:DetailsView>
</td>
</tr>
</table>
<asp:SqlDataSource ID= "Details " runat= "server "
ConnectionString= "server=.;database=Northwind;uid=sa;pwd= "
SelectCommand= "SELECT * FROM [Customers] WHERE ([CustomerID] = @CustomerID) ">
<SelectParameters>
<asp:ControlParameter ControlID= "GridView1 " Name= "CustomerID "
PropertyName= "SelectedValue "
Type= "String " />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID= "Customers " runat= "server "
ConnectionString= "server=.;database=Northwind;uid=sa;pwd= "
SelectCommand= "SELECT [CompanyName], [ContactName], [CustomerID] FROM [Customers] ">
</
刚才问了有关gridview与detailsview关联的问题
就是如何选定gridview的一行后在detailsview中显示这行的详细信息
我按着大家给的方法试了一下，将两个控件都绑定到同一个数据源控件，再加上如下代码。但是还有问题
<asp:SqlDataSource ID= "SqlDataSource1 " runat= "server "FilterExpression= "CproductName= '@CproductName ' "selectcommand= "Select * FROM [product] "...>
<filterparameters>
<asp:ControlParameter Name= "CproductName "
ControlId= "GridView1 "
PropertyName= "SelectedValue " />
</filterparameters>
但是在gridview中点了select之后 页面上什么都没有，请问 这是怎么回事啊？
请高手解决！
------解决方案--------------------
似乎得两个 SqlDataSource
Demo
<%@ Page Language= "C# " %>
<html>
<body>
<form id= "Form1 " runat= "server ">
<div>
<table>
<tr>
<td>
<asp:GridView ID= "GridView1 " runat= "server "
AutoGenerateColumns= "False " DataSourceID= "Customers "
DataKeyNames= "CustomerID ">
<Columns>
<asp:CommandField ShowSelectButton= "True " />
<asp:BoundField DataField= "ContactName " HeaderText= "ContactName " />
<asp:BoundField DataField= "CompanyName " HeaderText= "CompanyName " />
</Columns>
</asp:GridView>
</td>
<td valign= "top ">
<asp:DetailsView ID= "DetailsView1 " runat= "server "
AutoGenerateRows= "True " DataKeyNames= "CustomerID "
DataSourceID= "Details " Height= "50px " Width= "301px ">
</asp:DetailsView>
</td>
</tr>
</table>
<asp:SqlDataSource ID= "Details " runat= "server "
ConnectionString= "server=.;database=Northwind;uid=sa;pwd= "
SelectCommand= "SELECT * FROM [Customers] WHERE ([CustomerID] = @CustomerID) ">
<SelectParameters>
<asp:ControlParameter ControlID= "GridView1 " Name= "CustomerID "
PropertyName= "SelectedValue "
Type= "String " />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID= "Customers " runat= "server "
ConnectionString= "server=.;database=Northwind;uid=sa;pwd= "
SelectCommand= "SELECT [CompanyName], [ContactName], [CustomerID] FROM [Customers] ">
</
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
