Wizard generated code doesn't display data from database.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin Burton - 06 Jul 2006 10:32 GMT

I am sure this is an FAQ but I could not find it and I was wondering if
someone could help me.

I wanted to quickly generated a view of a couple of tables in our database.
I pulled up the wizard and generated a couple of data sets and data adapters.
The wizard inserted for the DataGridView the following code:

Me.AmazonOutbound2TableAdapter.Fill(Me.TestServiceBusDataSet.AmazonOutbound2)

I look at the dataset and the dataset is indeed getting populated (I stepped
into the debugger and examined the data after this line was executed). The
problem is that the data grid view does not show the data. How do I make the
data grid view show this data? Also I would like to display only a subset of
the data maybe by adding a where-clause constraining the data returned by one
of the column values. I see a command set but it seems to be read only. How
would be the best way to dynamically change the command set that is used for
the selection?

Thank you.

Kevin

Reply to this Message

rhaazy - 06 Jul 2006 20:17 GMT

> I look at the dataset and the dataset is indeed getting populated (I stepped
> into the debugger and examined the data after this line was executed). The
> problem is that the data grid view does not show the data. How do I make the
> data grid view show this data?

-set the datasource property of the datagrid to the datasource...
datagrid1.datasource = datasource;

Also I would like to display only a subset of

> the data maybe by adding a where-clause constraining the data returned by one
> of the column values. I see a command set but it seems to be read only. How
> would be the best way to dynamically change the command set that is used for
> the selection?

Maybe I am confused but it sounds like you want to take a look at
tablestyles
I would also suggest learning enough to be able to do this without the
wizard...sounds like you want to do more than the wizard is designed to
make "easy"

Reply to this Message

Kevin Burton - 06 Jul 2006 23:25 GMT

Thank you for your reply. I was afraid that I was pushing the wizard too
hard. I wanted to avoid doing it myself (lazy) but it looks like that is what
I wil have to do.

> > I look at the dataset and the dataset is indeed getting populated (I stepped
> > into the debugger and examined the data after this line was executed). The
[quoted text clipped - 15 lines]
> wizard...sounds like you want to do more than the wizard is designed to
> make "easy"

Reply to this Message

Wizard generated code doesn't display data from database.

Free Magazines