display column name and primary key together in gride view

[sagar_p_parakh]

  Dim condition As String() = New String() {Nothing, Nothing, Nothing, Nothing}
          dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Primary_Keys, New Object() {Nothing, Nothing, Nothing})
        
        DataGridView1.DataMember = dt

as this code will display the data of primary key in database, nut if i write code like this way

    dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, Nothing})
        
        DataGridView1.DataMember = dt

[/CODE]

this will display columns data .......


But if i want to display both the primary key data as well as columns name in one code ,,,how shall i write this code again.....


...Thank you

 

[jmcilhinney]

It would be up to you to create a third DataTable yourself and populate it with data from the other two.

 

[sagar_p_parakh]

how can i do this ? thank you

 

[jmcilhinney]

Create a DataTable, add the DataColumns you need, then loop through rows of the other two DataTables and transfer the data.