Newbie needs data access help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 26 Oct 2004 20:29 GMT

I've just begun using VS.net2003 and am having a problem
getting records to fill a DataGrid in a Windows form.
Using Server Explorer I dragged the Categories table from
my <local> SQL Server NorthWind db onto the form. The
SQLConnection and SQLDataAdapter were created with no
problem and I can "Preview Data" with the SQLDataAdapter.
I generated DataSet1 based on the DataAdapter, dragged in
a DataGrid and set the DataSource property to DataSet1.
When I open the form no data is diplayed - only a single
record with (null) in every field. What am I missing?

Thanks!

Reply to this Message

Christoph Wienands - 26 Oct 2004 22:20 GMT

Well, there's a little bit manual work involved ;-) At some point you'll
have to fill the dataset.

DataAdpater1.Fill(DataSet1);

That should do the trick.

CU Christoph

> I've just begun using VS.net2003 and am having a problem
> getting records to fill a DataGrid in a Windows form.
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...