My select query goes lik this
Select a.name,a.id,a.dept,b.customer,b.price from tablename a(nolock)
left outer join tablename2 b(Nolock).......
now i m calling this in gridview.
<asp:gridview runat="server" id="gv" autogeneratecolumns="false">
<columns>
<asp:TemplateField HeaderText="column1">
<ItemTemplate>
<asp:Label ID="lbl1" runat="server" Text='<%#Eval("name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="column2">
<ItemTemplate>
<asp:Label ID="lbl2" runat="server" Text='<%#Eval("id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="column3">
<ItemTemplate>
<asp:Label ID="lbl3" runat="server" Text='<%#Eval("customer") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</columns>
</gridview>
in this gridview name and id values gets displayed..
But customer which belongs to second table doesn't giving any values..
why this not working?