title: Is it possible to bind gridview with multiple table data at design time
body: <p>How can i bind multiple table data to grid view while in design mode. </p>
  
  <p>This is my design</p>
  
  <pre><code>  &lt;asp:GridView ID="grdACH" runat="server" AutoGenerateColumns="False" BackColor="White"
              BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black"
              GridLines="Vertical" Style="left: 121px; position: absolute; top: 133px"&gt;
              &lt;Columns&gt;
                  &lt;asp:TemplateField&gt;
                      &lt;HeaderTemplate&gt;
                          &lt;asp:CheckBox ID="CheckAll" runat="server" onclick="return check_uncheck (this );" /&gt;
                      &lt;/HeaderTemplate&gt;
                      &lt;ItemTemplate&gt;
                          &lt;asp:Label ID="ID" runat="server" Text='&lt;%# DataBinder.Eval (Container.DataItem, "FedTaxID") %&gt;'
                              Visible="false"&gt;&lt;/asp:Label&gt;
                          &lt;asp:CheckBox ID="checkRec" runat="server" onclick="return check_uncheck (this );" /&gt;
                      &lt;/ItemTemplate&gt;
                  &lt;/asp:TemplateField&gt;
                  &lt;asp:TemplateField HeaderText="FedTaxID" SortExpression="FedTaxID"&gt;
                      &lt;EditItemTemplate&gt;
                          &lt;asp:Label ID="lblFedTaxID" runat="server" Text='&lt;%# Eval("FedTaxID") %&gt;'&gt;&lt;/asp:Label&gt;
                      &lt;/EditItemTemplate&gt;
                      &lt;ItemTemplate&gt;
                          &lt;asp:Label ID="lblFedTaxID1" runat="server" Text='&lt;%# Bind("FedTaxID") %&gt;'&gt;&lt;/asp:Label&gt;
                      &lt;/ItemTemplate&gt;
                  &lt;/asp:TemplateField&gt;
                  &lt;asp:BoundField DataField="CompanyName" HeaderText="CompanyName"&gt;&lt;/asp:BoundField&gt;
                  &lt;asp:BoundField DataField="EntryDescription" HeaderText="CompanyEntryDescription"&gt;&lt;/asp:BoundField&gt;
                  &lt;asp:BoundField DataField="BankRoutingNumber" HeaderText="RoutingNumber"&gt;&lt;/asp:BoundField&gt;
                  &lt;asp:BoundField DataField="Amount" HeaderText="Amount"&gt;&lt;/asp:BoundField&gt;
  </code></pre>
  
  <blockquote>
    <p>This is from another table</p>
  </blockquote>
  
  <pre><code>    &lt;asp:TemplateField HeaderText="TaxAuthority" SortExpression="Taxing_Auth_Name"&gt;
                      &lt;EditItemTemplate&gt;
                          &lt;asp:Label ID="lblTaxAuthority" runat="server" Text='&lt;%# Eval("Taxing_Auth_Name") %&gt;'&gt;&lt;/asp:Label&gt;
                      &lt;/EditItemTemplate&gt;
                      &lt;ItemTemplate&gt;
                          &lt;asp:Label ID="lblTaxAuthority" runat="server" Text='&lt;%# Bind("Taxing_Auth_Name") %&gt;'&gt;&lt;/asp:Label&gt;
                      &lt;/ItemTemplate&gt;
                  &lt;/asp:TemplateField&gt;
  
  
              &lt;/Columns&gt;
              &lt;RowStyle BackColor="#F7F7DE" /&gt;
              &lt;FooterStyle BackColor="#CCCC99" /&gt;
              &lt;PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /&gt;
              &lt;SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /&gt;
              &lt;HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /&gt;
              &lt;AlternatingRowStyle BackColor="White" /&gt;
          &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>But i am getting an error as <code>DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Taxing_Auth_Name'.</code></p>
  
  <p>So can any one tell what to do</p>
  
  <p>My stored proc that executes for binding </p>
  
  <pre><code>  select c.fedtaxid,companyname,'comapany desc',c.entrydescription,
    c.BankRoutingNumber,
    g.Amount,g.TaxAuthority from tblcustomer c join (
    select swc.fedtaxid As FedTaxID,sum(amount)  Amount, taxing_auth_name TaxAuthority from tbl_employees_swc_grosswagedetails swc where wage_code='GRTT' and    taxing_auth_name='FED' and (empid,payperiodnumber,payyear)  in (select distinct  empid,PayPeriodID,payyear  from tblcpyresults cpyr where  cpyr.fedtaxid=swc.fedtaxid )   group by swc.fedtaxid) g on c.fedtaxid=g.fedtaxid;
  </code></pre>