getting data from 3 table s

i have three tables

1.   employee(employee_id,name,vahed,tel)
2.   problem(problem_id,problem)
3.   emp_prob(ep_id,employee_id,problem_id,date,status)

i want to have this information on datagrid or gridview
 
name,problem,vahed,tel,date,status

could u tell me how to do that


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "ASP.Net Community" group.
To post to this group, send email to aspnetgooglegroups.com
To unsubscribe from this group, send email to
aspnet-unsubscribegooglegroups.com
For more options, visit this group at http://groups.g
oogle.com/group/aspnet
-~----------~----~----~----~------~----~------~--~---

Mary,

There is a myriad of ways to approach this idea depending on
how
complex you want to get. I would recommend reviewing the
following
articles on this subject. They provide good examples of what
you are
looking for and this is where I started when I began working
with
datagrids.

http://aspnet.4guysfromrolla.com/articles/052103-1.aspx

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

HTH,

Madd Matt


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "ASP.Net Community" group.
To post to this group, send email to aspnetgooglegroups.com
To unsubscribe from this group, send email to
aspnet-unsubscribegooglegroups.com
For more options, visit this group at http://groups.g
oogle.com/group/aspnet
-~----------~----~----~----~------~----~------~--~---

you would use inner joins. in order for me to write a good
join i would
need the relationships between the three tables. here is a
good
tutorial on inner joins:
http://www.
w3schools.com/sql/sql_join.asp

Marty


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "ASP.Net Community" group.
To post to this group, send email to aspnetgooglegroups.com
To unsubscribe from this group, send email to
aspnet-unsubscribegooglegroups.com
For more options, visit this group at http://groups.g
oogle.com/group/aspnet
-~----------~----~----~----~------~----~------~--~---