How I Bound Field In Gridview With Multiple Queries

See more:

ASP.NET

C#3.5

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>

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