Can I use shape query in .net

Hi all,

I am trying to show the data as the shape query, where in the left part of the table is unique and the other right fields in the grid are many in number. That is a one to many relation ship. Can I use shape query using ADO.net or Oledb please tell me how? Or else if there is any other alternative please let me know.

Thanks and regards.

You should use DataSet Relation Features.. No need to use shape query.. Relations are inbuilt in Ado.net

http://www.c-sharpcorner.com/UploadFile/cvinodkumar/DataRelationVK11292005072318AM/DataRelationVK.aspx

|||

Thanks a lot dear,

I am trying to assign it to grid view in asp.net using vb as code behind language. will it raise an error.

Thanks

|||

http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/

Try with this.. looks helpful in your case. Though in asp.net grid there is no direct support with parent and child records..