将方法链接到数据源
问题描述:
因此ATM我的代码工作正常。我使用SqlDataSource链接到网格数据源并显示一个表。它显示表格中的一列,并用作超链接来导航到不同的页面。将方法链接到数据源
<asp:BoundField DataField="Company Name" HeaderText="Company Name" SortExpression="false" />
<asp:TemplateField>
<ItemTemplate>
<asp:HyperLink ID="LoadSubContractorDetails" runat="server" Text="Show Details"/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
There are currently no items in this table.
</EmptyDataTemplate>
</asp:GridView>
<asp:SqlDataSource ID="GridDataSource1" runat="server"
ConnectionString="<%$ConnectionStrings:ClarkesTest4FromMaster1ConnectionString %>"
SelectCommand="SELECT id, [Company Name] FROM [Sub Contractor] ORDER BY [Company Name]" >
</asp:SqlDataSource>
protected void passSubContractorInfoToNewPage(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView view = (DataRowView)e.Row.DataItem;
HyperLink LoadSubContractorDetails = (HyperLink)e.Row.FindControl("LoadSubContractorDetails");
LoadSubContractorDetails.NavigateUrl = ResolveUrl(@"~/SubContractDetails.aspx?id=" + view["id"].ToString() + "&InvoiceId=" + this.CurrentInvoiceId.ToString());
}
}
但是正如我所说的代码工作正常,但它显示在数据库表中的所有记录,我只想要显示我有这从另一个函数返回的subcontractos:
LoadSubContractors();
我该怎么做? 请指教? 感谢
认为你需要一个WHERE子句在你的SQL查询? – codingbiz 2013-02-21 12:07:35