1 parent table and 5 child tables

Question

I have 1 parent table and 5 child tables. how can source datagrid without using a view sqlserver? grazie....thanks!!!

viviano · Answer

thanks but i have 1 parent and 5 child? Schema database is into ado.net (file dbmx) with relactions. Must i repeat relactions in the query linq o no? thanks

Prabhu Raja · Answer

yes. You can just bind the IQueryable result from LINQ to the DataGridView. for example : var q = from cust in dc.Customers where cust.FirstName == someString select cust; gridview1.DataSource = q; gridview2.DataBind();

viviano · Answer

but if i want use linq to crate query to datagrid?? it'possible? how do I tie the query result to a datagrid ?

viviano · Answer

Thanks to all ... If I use to populate a viewsql unadatagrid  when I update the data datagrid does not update. The datagrid does not update either by forcing the refresh of the domain Contex by XAML . i try with storedprocedure.... thankssss viviano

Dhaval Patel · Answer

Dear viviano Are you want to without using view make query for source display in gridview right but i tell you one thing View is also Sql Query . and also you can use join for one parent and five child to show all record one parent table p1 five child table c1c2c3c4c5 select p1.namec1.namec2.namec3.namec4.namec5.name from p1 inner join c1 on p1.p_id =c1.c1_id inner join c2 on p1.p_id =c2.c2_id inner join c3 on p1.p_id =c3.c3_id inner join c4 on p1.p_id =c4.c4_id inner join c5 on p1.p_id =c5.c5_id You are try to change this query regarding you want and if you create view is not effect on this query create view vwtemp as select p1.namec1.namec2.namec3.namec4.namec5.name from p1 inner join c1 on p1.p_id =c1.c1_id inner join c2 on p1.p_id =c2.c2_id inner join c3 on p1.p_id =c3.c3_id inner join c4 on p1.p_id =c4.c4_id inner join c5 on p1.p_id =c5.c5_id

Narayan · Answer

Try to create a sql query of stored procedure by joining those tables Then use the selected result to bind the datagrid.

Prabhu Raja · Answer

i can't understand your requirement Viviano. mention it briefly .