datasets?? 2

[lizzieborden]

I have created an application that uses a sql connection to retrieve, edit, change data. The application worked fine when I had my data adapter, connection and dataset on just one form to fill a grid. Now I have created two more sets of connections, adapter and datasets but my grids don't fill on execution. Nor can I preview the data in the dataset any longer. If I take out the additional connection, adapters and datasets it works????

I am using sql server with 3 different tables of data. I have created an inner join with two tables on two different forms?

My questions is first of all what am I doing wrong? I did have it working at one point.

Do I need a connection, data adapter and dataset on all three forms within the app???

I also have the following code on form load:
da_profiles.Fill(ds_profiles)

 

[lizzieborden]

Okay... I figured out how to run the watch but which values am I supposed to be looking at. I see the text that I entered for the textbox in that watch but can't find it in the corresponding dataset field watch. Need some guidance on this one...

 

[lizzieborden]

Chrissie1 -

Just for grins I went back and created a new form with a grid along with code from my app and it still works with a grid but not a form.

Please help??

 

[chrissie1]

lizzie if you want you can send your project to this adress and i'll see what I can do.

chris.baes at skynet.be

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting