I have a dataset with two tables, and i modified rows in both.
Can i use adapter to update both tables in one command.
Also i'd like to do that with transaction (all or none changes apply)
Is it possible to use VS generated adapters for this purpose?
Thanx.
Re: Microsoft: Making a simple process impossible to use in .NET 2.0 ...adapter, you need the executescalar for that. ... What you want is a command on its own. ... The connection you can get very easy by getting that from whatever ... able to get a count of items contained in a SQL table by creating a ... (microsoft.public.dotnet.framework.adonet)
Re: DataTable before DataAdapter possible? ...command but that command must map to the datatable in order for you to call ... > Dim datCol as DataColumn ... and you never technically attach a datatable to an adapter.... The adapter doesn't care.... (microsoft.public.dotnet.general)
Re: what am I doing wrong ? ... We're not generating parameters on the DataSet, ... corresponding fields in the database.... The adapter doesn't process your SQL statement, ... all DataTables) and check the RowState to determine which command (e.g., ... (microsoft.public.dotnet.languages.csharp)
Re: what am I doing wrong ? ... corresponding fields in the database.... The adapter doesn't process your SQL statement, ... all DataTables) and check the RowState to determine which command (e.g., ...command chosen for that row and grabs the values for the parameters from the ... (microsoft.public.dotnet.languages.csharp)
Re: what am I doing wrong ? ... We're not generating parameters on the DataSet, ... corresponding fields in the database.... The adapter doesn't process your SQL statement, ...command chosen for that row and grabs the values for the parameters from the ... (microsoft.public.dotnet.languages.csharp)
