我们可以从1个Gridview中的多个SqlDataSources绑定吗？ [英] Can we bind from Multiple SqlDataSources in 1 Gridview?

问题描述

你好......

我想在一个gridview中显示一个sqldatasource（第一个）中的一个项目，第二个数据源中的一个项目和另一个（第三个）数据源中的另一个项目。知道如何在一个gridview中显示三个sqldatasources吗？



这只是一个例子：

 <   asp：GridView     ID   =  GridView1    runat   = 服务器    AutoGenerateColumns   =  False    DataSourceID   =  SqlDataSource1    DataKeyNames   =  ID >  
 <  列 >  
 < ;   asp：BoundField     DataField   =  item1    HeaderText   =  item1 >  <   / asp：BoundField  >  
 <   asp：BoundField     DataField   =  item2    HeaderText   =  item2 >  <   / asp：BoundField  >  
 <   asp：BoundField     DataField   =  item3    HeaderText   =   item3 >  <   / asp：BoundField  >  <  列 >  <   / asp：GridView  >  
 
 <   asp：SqlDataSource     ID   =  SqlDataSource1 < span class =code-attribute>   runat   =  server    ConnectionString   = '  <％ $ ConnectionStrings：ConnectionString1％>'    SelectComma nd   = 从table1中选择item1  < / asp：SqlDataSource  >  
 <   asp：SqlDataSource     ID   =  SqlDataSource2    runat   =  server   < span class =code-attribute> ConnectionString   ='   <％ $ ConnectionStrings：ConnectionString1％>'    SelectCommand   = 表2中的SELECT item2 < / asp：SqlDataSource  >  
 <   asp：SqlDataSource     ID   =  SqlDataSource2    runat   =  server    ConnectionString   ='  <％ $ ConnectionStrings：ConnectionString1％>'    SelectCommand   = 从table3中选择item3 < / asp：SqlDataSource  >  

解决方案

ConnectionStrings：ConnectionString1％>' SelectCommand = 从table1中选择item1 < / asp：SqlDataSource >
< asp ：SqlDataSource ID = SqlDataSource2 runat = server ConnectionString =' <％

ConnectionStrings ：ConnectionString1％>' SelectCommand = 表2中的SELECT item2 < / asp：SqlDataSource >
< asp：SqlDataSource ID = SqlDataSource2 runat = server ConnectionString =' <跨度class =code-keyword> <％

ConnectionStrings：ConnectionString1％>' SelectCommand = 从表3中选择item3 < / asp：SqlDataSource >

Hello there...
I want to show in one gridview one item from one sqldatasource(first), one item from a second datasource and one other item from another (third)datasource. Any idea how it can be shown three sqldatasources in one gridview?

This is just an example:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="ID">
    <Columns>            
        <asp:BoundField DataField="item1" HeaderText="item1"></asp:BoundField>
        <asp:BoundField DataField="item2" HeaderText="item2"></asp:BoundField>
        <asp:BoundField DataField="item3" HeaderText="item3"></asp:BoundField> <Columns></asp:GridView>

  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item1 from table1"</asp:SqlDataSource>    
  <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item2 from table2"</asp:SqlDataSource> 
  <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString='<%$ ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item3 from table3"</asp:SqlDataSource>

解决方案

ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item1 from table1"</asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString='<%

ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item2 from table2"</asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString='<%

ConnectionStrings:ConnectionString1 %>' SelectCommand="SELECT item3 from table3"</asp:SqlDataSource>

这篇关于我们可以从1个Gridview中的多个SqlDataSources绑定吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！