How do I show the datagrid? [Resolved]

[mendhak]

I've bound my datagrid to a dataset:

DataGrid1.DataSource = ds
'I dont need to tell you what ds is :)

But when I run the application, the grid shows up all collapsed. I have to expand it, then click "table1" and then it shows the contents.

Is there any code I can use to have the grid displaying everything, so that I don't need to click click click?

[mendhak]

Looky here:

[CyberHawke]

Actually this is one of the easier questions that get asked here pretty often, I wish I could find one of the other threads I answered this on. The answer is this:

Dim dt As DataTable
dt = ds.Tables(0)
DataGrid1.DataSource = dt

or you could do it this way

DataGrid1.DataSource = ds
DataGrid1.DataMember = "Table"

[mendhak]

Easy question?

[CyberHawke]

Perhaps it's because I have done so much work with ADO.NET that this is easy for me, but it basically comes down to this:
A dataset is a container for one or more datatables, if you attach your dataset to a datagrid then unless you tell it which table to use it has no other option than to display them all in a list so that you can select the one that you want to view. Setting the datamember property tells the table which table in your dataset is the one to use for display.

[mendhak]

Originally posted by CyberHawke
Perhaps it's because I have done so much work with ADO.NET that this is easy for me, but it basically comes down to this:
A dataset is a container for one or more datatables, if you attach your dataset to a datagrid then unless you tell it which table to use it has no other option than to display them all in a list so that you can select the one that you want to view. Setting the datamember property tells the table which table in your dataset is the one to use for display.

I was aware of the concept of datasets and ADO.NET, but this is the first time I've used a datagrid. I was just testing out some Data Access Application Blocks.

Do you have any idea of those? If so, please look at my other thread.

http://www.vbforums.com/showthread.p...hreadid=294922


If not, go have yourself a nice cold beer.

[CyberHawke]

I had read this post previously and had navigated to the page that you had the link for. I haven't had time to dive in and determine if my methodology is in line with this pattern but I'm doing that as soon as I type this post and click the submit button...

[mendhak]

[CyberHawke]

Although I have code modules that are similar in nature to this, they are nowhere near as complex as what Microsoft has written. It's taking what I have written in my projects and streched it out to the n'th degree.

Good stuff, and it's received great ratings from the developer community. I'm probably going to compile and use it in my future projects where data access involvs Sql Server.

[mendhak]

Thanks a lot for your time. Mucho appreciatedo.