Is it me? Or don't data adapters and access work?

microsoft.public.dotnet.framework.adonet

10 Dec 2004 9:31 AM

Daren Hawes

I am having great troubles with Data Adapters, Access and Concurrency.

Does everyone have to modify the SQL statements to get tit to work?

I am only using a single Access DB per application, so I really do not
need to worry about concurrency.

Can I turn it off?

Thx

10 Dec 2004 8:22 PM

Sahil Malik

Umm .. How exactly are you generating your commands? Command (don't use)
Builder?

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

Show quote

"Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...
> I am having great troubles with Data Adapters, Access and Concurrency.
>
> Does everyone have to modify the SQL statements to get tit to work?
>
> I am only using a single Access DB per application, so I really do not
> need to worry about concurrency.
>
> Can I turn it off?
>
> Thx
>
>
>

10 Dec 2004 8:37 PM

Daren Hawes

I simply drag and drop the table from the server explorer. Below is an
example of an update..

'
        'OleDbUpdateCommand1
        '
        Me.OleDbUpdateCommand1.CommandText = "UPDATE Events SET
Alkalinity = ?, Ammonia = ?, Calcium = ?, [Date Of Test] = ?, N" & _
        "itrate = ?, Nitrite = ?, pH = ?, Phosphate = ?, [Salt Level] =
?, Temperature = " & _
        "?, [Test Notes] = ? WHERE (EventID = ?) AND (Alkalinity = ? OR
? IS NULL AND Alk" & _
        "alinity IS NULL) AND (Ammonia = ? OR ? IS NULL AND Ammonia IS
NULL) AND (Calcium" & _
        " = ? OR ? IS NULL AND Calcium IS NULL) AND ([Date Of Test] = ?
OR ? IS NULL AND " & _
        "[Date Of Test] IS NULL) AND (Nitrate = ? OR ? IS NULL AND
Nitrate IS NULL) AND (" & _
        "Nitrite = ? OR ? IS NULL AND Nitrite IS NULL) AND (Phosphate =
? OR ? IS NULL AN" & _
        "D Phosphate IS NULL) AND ([Salt Level] = ? OR ? IS NULL AND
[Salt Level] IS NULL" & _
        ") AND (Temperature = ? OR ? IS NULL AND Temperature IS NULL)
AND (pH = ? OR ? IS" & _
        " NULL AND pH IS NULL)"
        Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection1
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Alkalinity",
System.Data.OleDb.OleDbType.Single, 0, "Alkalinity"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Ammonia",
System.Data.OleDb.OleDbType.Single, 0, "Ammonia"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Calcium",
System.Data.OleDb.OleDbType.Single, 0, "Calcium"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Date_Of_Test",
System.Data.OleDb.OleDbType.DBDate, 0, "Date Of Test"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Nitrate",
System.Data.OleDb.OleDbType.Single, 0, "Nitrate"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Nitrite",
System.Data.OleDb.OleDbType.Single, 0, "Nitrite"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("pH",
System.Data.OleDb.OleDbType.Single, 0, "pH"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Phosphate",
System.Data.OleDb.OleDbType.Single, 0, "Phosphate"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Salt_Level",
System.Data.OleDb.OleDbType.Single, 0, "Salt Level"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Temperature",
System.Data.OleDb.OleDbType.Single, 0, "Temperature"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Test_Notes",
System.Data.OleDb.OleDbType.VarWChar, 0, "Test Notes"))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_EventID",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Alkalinity",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Alkalinity1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Ammonia",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Ammonia1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Calcium",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Calcium1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Date_Of_Test",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Date_Of_Test1",
System.Data.OleDb.OleDbType.DBDate, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Nitrate",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Nitrate1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Nitrite",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Nitrite1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Phosphate",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Phosphate1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Salt_Level",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Salt_Level1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Temperature",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_Temperature1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_pH",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
        Me.OleDbUpdateCommand1.Parameters.Add(New
System.Data.OleDb.OleDbParameter("Original_pH1",
System.Data.OleDb.OleDbType.Single, 0,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "pH", System.Data.DataRowVersion.Original, Nothing))

-----Original Message-----
From: Sahil Malik [mailto:contactmethrumyblog@nospam.com]
Posted At: Saturday, 11 December 2004 6:23 AM
Posted To: microsoft.public.dotnet.framework.adonet
Conversation: Is it me? Or don't data adapters and access work?
Subject: Re: Is it me? Or don't data adapters and access work?

Umm .. How exactly are you generating your commands? Command (don't use)
Builder?

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
http://blogs.apress.com/authors.php?author=Sahil Malik

Show quote

"Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...
> I am having great troubles with Data Adapters, Access and Concurrency.
>
> Does everyone have to modify the SQL statements to get tit to work?
>
> I am only using a single Access DB per application, so I really do not

> need to worry about concurrency.
>
> Can I turn it off?
>
> Thx
>
>
>

10 Dec 2004 10:34 PM

Sahil Malik

The DataForm Wizard and autogenerated code make a fairly good attempt at
making code that prevents concurrency issues. However, as you can see the
SQL commands generated are inefficient and ugly. To get the fine grained
control you need to get your hands dirty and write out code yourself - which
is not that hard to be quite honest. And frankly I am glad it doesn't
because then someone would create a VisualStudio.exe /codeautomatically=true
switch and we'd all loose our jobs.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

Show quote

"Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
news:#JH3Xhv3EHA.2568@TK2MSFTNGP11.phx.gbl...
> I simply drag and drop the table from the server explorer. Below is an
> example of an update..
>
> '
>         'OleDbUpdateCommand1
>         '
>         Me.OleDbUpdateCommand1.CommandText = "UPDATE Events SET
> Alkalinity = ?, Ammonia = ?, Calcium = ?, [Date Of Test] = ?, N" & _
>         "itrate = ?, Nitrite = ?, pH = ?, Phosphate = ?, [Salt Level] =
> ?, Temperature = " & _
>         "?, [Test Notes] = ? WHERE (EventID = ?) AND (Alkalinity = ? OR
> ? IS NULL AND Alk" & _
>         "alinity IS NULL) AND (Ammonia = ? OR ? IS NULL AND Ammonia IS
> NULL) AND (Calcium" & _
>         " = ? OR ? IS NULL AND Calcium IS NULL) AND ([Date Of Test] = ?
> OR ? IS NULL AND " & _
>         "[Date Of Test] IS NULL) AND (Nitrate = ? OR ? IS NULL AND
> Nitrate IS NULL) AND (" & _
>         "Nitrite = ? OR ? IS NULL AND Nitrite IS NULL) AND (Phosphate =
> ? OR ? IS NULL AN" & _
>         "D Phosphate IS NULL) AND ([Salt Level] = ? OR ? IS NULL AND
> [Salt Level] IS NULL" & _
>         ") AND (Temperature = ? OR ? IS NULL AND Temperature IS NULL)
> AND (pH = ? OR ? IS" & _
>         " NULL AND pH IS NULL)"
>         Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection1
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Alkalinity",
> System.Data.OleDb.OleDbType.Single, 0, "Alkalinity"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Ammonia",
> System.Data.OleDb.OleDbType.Single, 0, "Ammonia"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Calcium",
> System.Data.OleDb.OleDbType.Single, 0, "Calcium"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Date_Of_Test",
> System.Data.OleDb.OleDbType.DBDate, 0, "Date Of Test"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Nitrate",
> System.Data.OleDb.OleDbType.Single, 0, "Nitrate"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Nitrite",
> System.Data.OleDb.OleDbType.Single, 0, "Nitrite"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("pH",
> System.Data.OleDb.OleDbType.Single, 0, "pH"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Phosphate",
> System.Data.OleDb.OleDbType.Single, 0, "Phosphate"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Salt_Level",
> System.Data.OleDb.OleDbType.Single, 0, "Salt Level"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Temperature",
> System.Data.OleDb.OleDbType.Single, 0, "Temperature"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Test_Notes",
> System.Data.OleDb.OleDbType.VarWChar, 0, "Test Notes"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_EventID",
> System.Data.OleDb.OleDbType.Integer, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Alkalinity",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Alkalinity1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Ammonia",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Ammonia1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Calcium",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Calcium1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Date_Of_Test",
> System.Data.OleDb.OleDbType.DBDate, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Date_Of_Test1",
> System.Data.OleDb.OleDbType.DBDate, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrate",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrate1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrite",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrite1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Phosphate",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Phosphate1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Salt_Level",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Salt_Level1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Temperature",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Temperature1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_pH",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_pH1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
>
>
> -----Original Message-----
> From: Sahil Malik [mailto:contactmethrumyblog@nospam.com]
> Posted At: Saturday, 11 December 2004 6:23 AM
> Posted To: microsoft.public.dotnet.framework.adonet
> Conversation: Is it me? Or don't data adapters and access work?
> Subject: Re: Is it me? Or don't data adapters and access work?
>
>
> Umm .. How exactly are you generating your commands? Command (don't use)
> Builder?
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
> http://blogs.apress.com/authors.php?author=Sahil Malik
>
>
>
> "Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
> news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...
> > I am having great troubles with Data Adapters, Access and Concurrency.
> >
> > Does everyone have to modify the SQL statements to get tit to work?
> >
> > I am only using a single Access DB per application, so I really do not
>
> > need to worry about concurrency.
> >
> > Can I turn it off?
> >
> > Thx
> >
> >
> >
>
>

10 Dec 2004 10:39 PM

Rich

In my experience, I've frequently found myself modifying commands that were
generated by the DataAdapter wizard. Your example typifies one of the
reasons. That WHERE clause is an absolute bear. I would look for some other
way to uniquely identify records for use in the WHERE clause; a primary key
would be an obvious choice. Just change the where clause to use the primary
key (of the actual database table - I'm don't mean a primary key of the
internal DataTable). Then, make sure the column mapping is set up for that.
You'll be good to go. It will make for a much more straightforward solution
and likely to be significantly more efficient.

I still like to use the wizard to generate the commands. It eliminates
quite a bit of grunt work. But I agree with Sahil Malik to the extent that
you don't want to accept those commands on blind faith.

Show quote

"Daren Hawes" wrote:

> I simply drag and drop the table from the server explorer. Below is an
> example of an update..
>
> '
>         'OleDbUpdateCommand1
>         '
>         Me.OleDbUpdateCommand1.CommandText = "UPDATE Events SET
> Alkalinity = ?, Ammonia = ?, Calcium = ?, [Date Of Test] = ?, N" & _
>         "itrate = ?, Nitrite = ?, pH = ?, Phosphate = ?, [Salt Level] =
> ?, Temperature = " & _
>         "?, [Test Notes] = ? WHERE (EventID = ?) AND (Alkalinity = ? OR
> ? IS NULL AND Alk" & _
>         "alinity IS NULL) AND (Ammonia = ? OR ? IS NULL AND Ammonia IS
> NULL) AND (Calcium" & _
>         " = ? OR ? IS NULL AND Calcium IS NULL) AND ([Date Of Test] = ?
> OR ? IS NULL AND " & _
>         "[Date Of Test] IS NULL) AND (Nitrate = ? OR ? IS NULL AND
> Nitrate IS NULL) AND (" & _
>         "Nitrite = ? OR ? IS NULL AND Nitrite IS NULL) AND (Phosphate =
> ? OR ? IS NULL AN" & _
>         "D Phosphate IS NULL) AND ([Salt Level] = ? OR ? IS NULL AND
> [Salt Level] IS NULL" & _
>         ") AND (Temperature = ? OR ? IS NULL AND Temperature IS NULL)
> AND (pH = ? OR ? IS" & _
>         " NULL AND pH IS NULL)"
>         Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection1
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Alkalinity",
> System.Data.OleDb.OleDbType.Single, 0, "Alkalinity"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Ammonia",
> System.Data.OleDb.OleDbType.Single, 0, "Ammonia"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Calcium",
> System.Data.OleDb.OleDbType.Single, 0, "Calcium"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Date_Of_Test",
> System.Data.OleDb.OleDbType.DBDate, 0, "Date Of Test"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Nitrate",
> System.Data.OleDb.OleDbType.Single, 0, "Nitrate"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Nitrite",
> System.Data.OleDb.OleDbType.Single, 0, "Nitrite"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("pH",
> System.Data.OleDb.OleDbType.Single, 0, "pH"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Phosphate",
> System.Data.OleDb.OleDbType.Single, 0, "Phosphate"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Salt_Level",
> System.Data.OleDb.OleDbType.Single, 0, "Salt Level"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Temperature",
> System.Data.OleDb.OleDbType.Single, 0, "Temperature"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Test_Notes",
> System.Data.OleDb.OleDbType.VarWChar, 0, "Test Notes"))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_EventID",
> System.Data.OleDb.OleDbType.Integer, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Alkalinity",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Alkalinity1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Ammonia",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Ammonia1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Calcium",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Calcium1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Date_Of_Test",
> System.Data.OleDb.OleDbType.DBDate, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Date_Of_Test1",
> System.Data.OleDb.OleDbType.DBDate, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrate",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrate1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrite",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Nitrite1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Phosphate",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Phosphate1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Salt_Level",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Salt_Level1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Temperature",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_Temperature1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_pH",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
>         Me.OleDbUpdateCommand1.Parameters.Add(New
> System.Data.OleDb.OleDbParameter("Original_pH1",
> System.Data.OleDb.OleDbType.Single, 0,
> System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
>
>
> -----Original Message-----
> From: Sahil Malik [mailto:contactmethrumyblog@nospam.com]
> Posted At: Saturday, 11 December 2004 6:23 AM
> Posted To: microsoft.public.dotnet.framework.adonet
> Conversation: Is it me? Or don't data adapters and access work?
> Subject: Re: Is it me? Or don't data adapters and access work?
>
>
> Umm .. How exactly are you generating your commands? Command (don't use)
> Builder?
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
> http://blogs.apress.com/authors.php?author=Sahil Malik
>
>
>
> "Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
> news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...
> > I am having great troubles with Data Adapters, Access and Concurrency.
> >
> > Does everyone have to modify the SQL statements to get tit to work?
> >
> > I am only using a single Access DB per application, so I really do not
>
> > need to worry about concurrency.
> >
> > Can I turn it off?
> >
> > Thx
> >
> >
> >
>
>
>

10 Dec 2004 11:13 PM

Sahil Malik

Exactly my thoughts.

So far (atleast in my head) it looks like as below ----

Level of effort: Automatic
............................................................. Manual
Code Quality : Bad
.........................................................................
Good

ASP.NET 2.0 DataBinding promises to change that - we'll see.

Also a fully manual implementation of ADO.NET calling a Sql Command is .. oh
well about 5 lines of code ... not that bad. The autogenerated is a pig in
comparison. OINK OINK !!

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

Show quote

"Rich" <R***@discussions.microsoft.com> wrote in message
news:229C369B-16F2-4501-963E-1731E21FBCAC@microsoft.com...
> In my experience, I've frequently found myself modifying commands that
were
> generated by the DataAdapter wizard. Your example typifies one of the
> reasons. That WHERE clause is an absolute bear. I would look for some
other
> way to uniquely identify records for use in the WHERE clause; a primary
key
> would be an obvious choice. Just change the where clause to use the
primary
> key (of the actual database table - I'm don't mean a primary key of the
> internal DataTable). Then, make sure the column mapping is set up for
that.
> You'll be good to go. It will make for a much more straightforward
solution
> and likely to be significantly more efficient.
>
> I still like to use the wizard to generate the commands. It eliminates
> quite a bit of grunt work. But I agree with Sahil Malik to the extent
that
> you don't want to accept those commands on blind faith.
>
> "Daren Hawes" wrote:
>
> > I simply drag and drop the table from the server explorer. Below is an
> > example of an update..
> >
> > '
> >         'OleDbUpdateCommand1
> >         '
> >         Me.OleDbUpdateCommand1.CommandText = "UPDATE Events SET
> > Alkalinity = ?, Ammonia = ?, Calcium = ?, [Date Of Test] = ?, N" & _
> >         "itrate = ?, Nitrite = ?, pH = ?, Phosphate = ?, [Salt Level] =
> > ?, Temperature = " & _
> >         "?, [Test Notes] = ? WHERE (EventID = ?) AND (Alkalinity = ? OR
> > ? IS NULL AND Alk" & _
> >         "alinity IS NULL) AND (Ammonia = ? OR ? IS NULL AND Ammonia IS
> > NULL) AND (Calcium" & _
> >         " = ? OR ? IS NULL AND Calcium IS NULL) AND ([Date Of Test] = ?
> > OR ? IS NULL AND " & _
> >         "[Date Of Test] IS NULL) AND (Nitrate = ? OR ? IS NULL AND
> > Nitrate IS NULL) AND (" & _
> >         "Nitrite = ? OR ? IS NULL AND Nitrite IS NULL) AND (Phosphate =
> > ? OR ? IS NULL AN" & _
> >         "D Phosphate IS NULL) AND ([Salt Level] = ? OR ? IS NULL AND
> > [Salt Level] IS NULL" & _
> >         ") AND (Temperature = ? OR ? IS NULL AND Temperature IS NULL)
> > AND (pH = ? OR ? IS" & _
> >         " NULL AND pH IS NULL)"
> >         Me.OleDbUpdateCommand1.Connection = Me.OleDbConnection1
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Alkalinity",
> > System.Data.OleDb.OleDbType.Single, 0, "Alkalinity"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Ammonia",
> > System.Data.OleDb.OleDbType.Single, 0, "Ammonia"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Calcium",
> > System.Data.OleDb.OleDbType.Single, 0, "Calcium"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Date_Of_Test",
> > System.Data.OleDb.OleDbType.DBDate, 0, "Date Of Test"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Nitrate",
> > System.Data.OleDb.OleDbType.Single, 0, "Nitrate"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Nitrite",
> > System.Data.OleDb.OleDbType.Single, 0, "Nitrite"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("pH",
> > System.Data.OleDb.OleDbType.Single, 0, "pH"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Phosphate",
> > System.Data.OleDb.OleDbType.Single, 0, "Phosphate"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Salt_Level",
> > System.Data.OleDb.OleDbType.Single, 0, "Salt Level"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Temperature",
> > System.Data.OleDb.OleDbType.Single, 0, "Temperature"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Test_Notes",
> > System.Data.OleDb.OleDbType.VarWChar, 0, "Test Notes"))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_EventID",
> > System.Data.OleDb.OleDbType.Integer, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "EventID", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Alkalinity",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Alkalinity1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Alkalinity", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Ammonia",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Ammonia1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Ammonia", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Calcium",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Calcium1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Calcium", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Date_Of_Test",
> > System.Data.OleDb.OleDbType.DBDate, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Date_Of_Test1",
> > System.Data.OleDb.OleDbType.DBDate, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Date Of Test", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Nitrate",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Nitrate1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Nitrate", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Nitrite",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Nitrite1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Nitrite", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Phosphate",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Phosphate1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Phosphate", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Salt_Level",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Salt_Level1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Salt Level", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Temperature",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_Temperature1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "Temperature", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_pH",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
> >         Me.OleDbUpdateCommand1.Parameters.Add(New
> > System.Data.OleDb.OleDbParameter("Original_pH1",
> > System.Data.OleDb.OleDbType.Single, 0,
> > System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
> > Byte), "pH", System.Data.DataRowVersion.Original, Nothing))
> >
> >
> > -----Original Message-----
> > From: Sahil Malik [mailto:contactmethrumyblog@nospam.com]
> > Posted At: Saturday, 11 December 2004 6:23 AM
> > Posted To: microsoft.public.dotnet.framework.adonet
> > Conversation: Is it me? Or don't data adapters and access work?
> > Subject: Re: Is it me? Or don't data adapters and access work?
> >
> >
> > Umm .. How exactly are you generating your commands? Command (don't use)
> > Builder?
> >
> > - Sahil Malik
> > http://dotnetjunkies.com/weblog/sahilmalik
> > http://blogs.apress.com/authors.php?author=Sahil Malik
> >
> >
> >
> > "Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message
> > news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...
> > > I am having great troubles with Data Adapters, Access and Concurrency.
> > >
> > > Does everyone have to modify the SQL statements to get tit to work?
> > >
> > > I am only using a single Access DB per application, so I really do not
> >
> > > need to worry about concurrency.
> > >
> > > Can I turn it off?
> > >
> > > Thx
> > >
> > >
> > >
> >
> >
> >

13 Dec 2004 1:54 AM

David Jessee

You do have to change the generated SQL a lot of times. Here's how my company dealt with it....

We implemented a Table Design Policy that all tables would have a certian standardized format. For our purposes we made sure that every table had an ID field (autonumber) DateCreates, CreateUser, LastUpdateDateTime, LastUpdateUser. This didn't mean that some of the tables can not have complex keys, but those fields always had to exist.

Once we had a standardives set of fields that we could always rely on, we built scripts that would generate the Stored Procedures and Data Adapter code for the tables the way we needed them to be made. (e.g. kep management, cuncurrency checks and table locking).

I hope this helps you out a little

"Daren Hawes" <Newsgro***@webdesignmagic.com.au> wrote in message news:uccV9tp3EHA.1264@TK2MSFTNGP12.phx.gbl...

I am having great troubles with Data Adapters, Access and Concurrency.

Does everyone have to modify the SQL statements to get tit to work?

I am only using a single Access DB per application, so I really do not need to worry about concurrency.

Can I turn it off?

Thx