How to use Strongly Typed dataset designer to configure multiple updates?

Right-click adapter and choose Add Query, select new Select/Update/SQL statement, then enter UPDATE table1 SET table1. Nationality =? WHERE table1.

Nationality in ( select table2. Nationality from table2 where table2. Gender =?

) give it an appropriate name, ie. UpdateNationalityByGender updateNationalityByGender(string nationality, string gender).

If so, can you not just right-click and choose Add Query, select new Select/Update/SQL statement, then enter UPDATE table1 SET table1. Nationality = @nationality WHERE table1. Nationality in ( select table2.

Nationality from table2 where table2. Gender = @gender ) and give it an appropriate name? This should generate a table-adapter method like updateNationalityByGender(string nationality, string gender) you'll need to use the namespace for the table adapter to get access to it, e.g. Using your.name.space.datasetname.

Datasetnametableadapter.

This works fine on my machine - but i'm using SQL Server, not access... – Steven A. Lowe Feb 17 '09 at 17:37 @Ngu Soon Hui: and by the way, downvoting does not really encourage me to keep trying to help you ;-) – Steven A. Lowe Feb 17 '09 at 17:38 Sorry!

I should have mentioned that @gender isn't working in Microsoft Access, and I am using Microsoft Access... apologies! – Graviton Feb 23 '09 at 1:39 @Ngu Soon Hui:my mistake, I was unaware that Access did not support the @parm syntax (I haven't used Access in many years); thanks to @juliandewitt: for clearing that up! – Steven A.

Lowe Feb 23 '09 at 4:27.

LINQ to DataSet would be your best option. 1) Its all strongly typed. 2) You can use IQueryable/LINQ/lambda to query 3) You can bind to an Access database Sql Express is free and it would be much better to use that.

But if I was forced to use Access, this is how i'd do it. msdn.microsoft.com/en-us/library/bb38697....

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.