如何在具有多个查询的Gridview中绑定字段 [英] How I Bound Field In Gridview With Multiple Queries

问题描述

嗨





我想在gridview中使用多个查询绑定字段，我需要帮助我如何在Select Command中编写多个查询在网格视图中



这是Gridview

Hi


I want to bound field in gridview with Multiple query , I need Help how i write multiple query in Select Command in grid view

That's Gridview

<asp:GridView ID="GridView1" Width="100%" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Department_Id" DataSourceID="SqlDataSource1">
                  <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                  <Columns>
                      <asp:CommandField ShowEditButton="True" />
                      <asp:BoundField DataField="Department_Id" HeaderText="Id" ReadOnly="True" SortExpression="Department_Id" />
                      <asp:BoundField DataField="Department_name" HeaderText="Name" SortExpression="Department_name" />
                      <asp:BoundField DataField="Department_Detail" HeaderText="Detail" SortExpression="Department_Detail" />
                      <asp:BoundField DataField="Created_by_Employee_Id" HeaderText="Added By" SortExpression="Created_by_Employee_Id" />
                  </Columns>
                  <EditRowStyle BackColor="#999999" />
                  <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                  <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                  <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                  <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                  <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                  <SortedAscendingCellStyle BackColor="#E9E7E2" />
                  <SortedAscendingHeaderStyle BackColor="#506C8C" />
                  <SortedDescendingCellStyle BackColor="#FFFDF8" />
                  <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
              </asp:GridView>
              <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CMMS_Standard %>" DeleteCommand="DELETE FROM [Department_Table] WHERE [Department_Id] = @Department_Id" InsertCommand="INSERT INTO [Department_Table] ([Department_Id], [Department_name], [Department_Detail], [Created_by_Employee_Id]) VALUES (@Department_Id, @Department_name, @Department_Detail, @Created_by_Employee_Id)" SelectCommand="Filter_Query" UpdateCommand="UPDATE [Department_Table] SET [Department_name] = @Department_name, [Department_Detail] = @Department_Detail WHERE [Department_Id] = @Department_Id" SelectCommandType="StoredProcedure">
                  <DeleteParameters>
                      <asp:Parameter Name="Department_Id" Type="Byte" />
                  </DeleteParameters>
                  <InsertParameters>
                      <asp:Parameter Name="Department_Id" Type="Byte" />
                      <asp:Parameter Name="Department_name" Type="String" />
                      <asp:Parameter Name="Department_Detail" Type="String" />
                      <asp:Parameter Name="Created_by_Employee_Id" Type="Int16" />
                  </InsertParameters>
                  <SelectParameters>
                      <asp:ControlParameter ControlID="HiddenField_Filter" DefaultValue="SELECT [Department_Id], [Department_name], [Department_Detail], [Created_by_Employee_Id] FROM [Department_Table]" Name="code" PropertyName="Value" Type="String" />
                  </SelectParameters>
                  <UpdateParameters>
                      <asp:Parameter Name="Department_name" Type="String" />
                      <asp:Parameter Name="Department_Detail" Type="String" />
                      <asp:Parameter Name="Department_Id" Type="Byte" />
                  </UpdateParameters>
              </asp:SqlDataSource>

在选择命令中有一个查询SelectCommand =Filter_Query，但我想要Filter_Query并选择*，CreatedBy =（从Employee_Details中选择Employee_Full_Name，其中Employee_Id = Department_Table.Created_by_Employee_Id）来自Department_Table

我如何同时使用

In Select Command There is a query SelectCommand="Filter_Query" , But I want Filter_Query and select *, CreatedBy = (Select Employee_Full_Name from Employee_Details where Employee_Id=Department_Table.Created_by_Employee_Id) from Department_Table
How i use both

推荐答案

ConnectionStrings ：CMMS_Standard％> DeleteCommand = DELETE FROM [Department_Table] WHERE [Department_Id] = @Department_Id InsertCommand = INSERT INTO [Department_Table]（[Department_Id]，[Departm] ent_name]，[Department_Detail]，[Created_by_Employee_Id]）VALUES（@Department_Id，@ Department_name，@ Department_Detail，@ Management_by_Employee_Id） SelectCommand = Filter_Query UpdateCommand = UPDATE [Department_Table] SET [Department_name] = @ Department_name，[Department_Detail] = @Department_Detail WHERE [Department_Id] = @Department_Id SelectCommandType = StoredProcedure >
< DeleteParameters>
< asp：参数名称= Department_Id Type = 字节 />
< / DeleteParameters >
< InsertParameters>
< asp：参数名称= Department_Id Type = 字节 />
< asp：参数名称= Department_name Type = String />
< asp：参数名称= Department_Detail Type = String />
< asp：参数名称= Created_by_Employee_Id Type = Int16 />
< / InsertParameters >
< SelectParameters>
< asp：ControlParameter ControlID = HiddenField_Filter DefaultValue = SELECT [Department_Id]，[Department_name]，[Department_Detail]，[Created_by_Employee_Id] FROM [Department_Table]名称= code PropertyName = Value Type = String />
< / SelectParameters >
< UpdateParameters>
< asp：参数名称= Department_name Type = String />
< asp：参数名称= Department_Detail Type = String />
< asp：参数名称= Department_Id Type = 字节 />
< / UpdateParameters >
< / asp：SqlDataSource >

ConnectionStrings:CMMS_Standard %>" DeleteCommand="DELETE FROM [Department_Table] WHERE [Department_Id] = @Department_Id" InsertCommand="INSERT INTO [Department_Table] ([Department_Id], [Department_name], [Department_Detail], [Created_by_Employee_Id]) VALUES (@Department_Id, @Department_name, @Department_Detail, @Created_by_Employee_Id)" SelectCommand="Filter_Query" UpdateCommand="UPDATE [Department_Table] SET [Department_name] = @Department_name, [Department_Detail] = @Department_Detail WHERE [Department_Id] = @Department_Id" SelectCommandType="StoredProcedure"> <DeleteParameters> <asp:Parameter Name="Department_Id" Type="Byte" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Department_Id" Type="Byte" /> <asp:Parameter Name="Department_name" Type="String" /> <asp:Parameter Name="Department_Detail" Type="String" /> <asp:Parameter Name="Created_by_Employee_Id" Type="Int16" /> </InsertParameters> <SelectParameters> <asp:ControlParameter ControlID="HiddenField_Filter" DefaultValue="SELECT [Department_Id], [Department_name], [Department_Detail], [Created_by_Employee_Id] FROM [Department_Table]" Name="code" PropertyName="Value" Type="String" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="Department_name" Type="String" /> <asp:Parameter Name="Department_Detail" Type="String" /> <asp:Parameter Name="Department_Id" Type="Byte" /> </UpdateParameters> </asp:SqlDataSource>

在选择命令中有一个查询SelectCommand =Filter_Query，但我想要Filter_Query并选择*，CreatedBy =（从Employee_Details中选择Employee_Full_Name，其中Employee_Id = Department_Table.Created_by_Employee_Id）来自Department_Table

我如何使用

In Select Command There is a query SelectCommand="Filter_Query" , But I want Filter_Query and select *, CreatedBy = (Select Employee_Full_Name from Employee_Details where Employee_Id=Department_Table.Created_by_Employee_Id) from Department_Table
How i use both

请看下面的链接，





https://msdn.microsoft.com/en-us/library/fkzs2t3h(v = vs.140）.aspx [ ^ ]



提前致谢

please see this link below,


https://msdn.microsoft.com/en-us/library/fkzs2t3h(v=vs.140).aspx[^]

Thanks in advance

这篇关于如何在具有多个查询的Gridview中绑定字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！