How can I make my data grid to view childtable data from multiple related tables? and avoid some column from child
table and add one or two column which is not in child table and how to upd[u]</u>ate,insert,delete? please help me

Ajaidass: If i have understand your problem, then check this link
http://www.codeproject.com/vb/net/grid101.asp


siraj

ajaidass:
You have not provided enough information to give you an exact answer. You DID NOT specify whether all the tables were of Access DB, SQL Server 2000 DB, or Oracle DB, nor did you specify that all the tables were from the same DB or tables from different DB's. However, the secret lies in your SQL Statement which include the FROM portion that exacts parent and child tables, into a DataSet,if parent and child tables are from same DB. If child table(s) is/are from different DB AND unrelated the you MUST create the relation ship between parent and child, before you ADD, DELETE or UPDATE.

Hope this helps.