Member Avatar for jacob21

hello

i am new in entityframwork. i want to bind particular data column after joining three table with gridview how can do it.
any body can help me..........

plz reply me as soon as possible...

  • 2 Contributors
  • 1 Reply
  • 72 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by sufyan2011
Member Avatar for sufyan2011

You question is not clear, if you want to query data from three tables, you will definalty do some join etc but the result set will be one table with your desired columns you selected in query which you can easily bind to gridview. e.g:

select a.FT as FC, b.ST as SC, d.TT as TC from First a inner join Second b on a.id = b.id inner join Third d on d.id=b.id (this is just example, might be doesn't make sense)

<asp:gridview>
<Columns>
<asp:BoundField DataField="FC" HeaderText="xxx" />
<asp:BoundField DataField="SC" HeaderText="xxx" />
<asp:BoundField DataField="TC" HeaderText="xxx" />

</Columns>

<asp:gridview>

Edited by sufyan2011 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.