Hi.  I am a newbie to VB Express 2005.

I am trying to build a Dbase and have got the DB Designer part done and all the right bits appear in the Data Source, including the links (relationships).

Looking at the illustrations in Murach, each Table has its own TableAdapter attached.

I have tried creating a Table Adapter but it seems to be a separate entity - you can't make it a "part" of a Table.  

Can anyone kindly guide me on this, please?  (Remembering my newbie status, words of one syllable will be helpful!)

Thanks.

NigeLost

Hi NigeLost,
As requested - in words of one syllable. Table Adapters - don't even think about it!! VB.Net 2005 creates them automatically for you as part of the whole process of creating the strongly typed dataset. If you make changes to your data source in any way then the system will automatically adjust the Table Adapter for you.
If you really want to find out more about Table Adapters then take a look at the VB Developer Centre on MSDN :-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/newdtastvs05.asp


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Hi Geoffs,

Thanks for the reply.  However, since then, I have spent many hours trying again and found where I had missed out.  I now have the Adaptors in place.

Thanks for the link - looks good.  It may help me with the next bit - creating a new query - because I am having trouble getting that to work, even though I am following the instructions (Murach & "Build a Program Now!") but missing something important somewhere!  

Trying to get a SELECT wsName FROM WordSurvey WHERE sessionID = @sessionID to work from the Query Configuration to the ListBox.

I will list this under a separate thread


Any clues you can offer?

Regards

[Edited by NigeLost on 05-12-2006 at 10:03 PM GMT]

[Edited by NigeLost on 06-12-2006 at 07:15 AM GMT]