parent rows...newbie

bzeus

Member
Joined
Feb 22, 2005
Messages
14
Programming Experience
Beginner
I have a datagrid with a dataset, the coding is as below....the coding works well...but it shows the parent rows before the child rows...to see the child rows i have to click a tree menu with my table name than only i'm able to view my child rows...my question is can i disable or merge the parent table so that when the form loads i see the child rows first not the parent........plss help...thank you in advance.........

strSQL = "SELECT * FROM customer"
cnSQL =
New SqlConnection(ConnectionString)
Dim da As SqlDataAdapter = New SqlDataAdapter(strSQL, cnSQL)
Dim ds = set1()
da.Fill(ds, "Customers")
datagrid3.DataSource = ds.DefaultViewManager
 
Top Bottom