如何在具有多个查询的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屋!