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
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
