From: Date: June 17 2008 5:41pm
Subject: Connector/NET commit: r1324 - in branches/5.2: . MySql.Data/Provider/Source/docs
List-Archive: http://lists.mysql.com/commits/48017
X-Bug: 37349
Message-Id: <200806171541.m5HFf9Tk004260@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   branches/5.2/CHANGES
   branches/5.2/MySql.Data/Provider/Source/docs/MySqlCommand.xml
   branches/5.2/MySql.Data/Provider/Source/docs/MySqlConnection.xml
   branches/5.2/MySql.Data/Provider/Source/docs/MySqlDataAdapter.xml
Log:
- Fixed documentation surrounding use of ? vs @ for parameters (bug #37349)


Modified: branches/5.2/CHANGES
===================================================================
--- branches/5.2/CHANGES	2008-06-17 15:26:56 UTC (rev 1323)
+++ branches/5.2/CHANGES	2008-06-17 15:41:09 UTC (rev 1324)
@@ -14,6 +14,7 @@
   had the unfortunate side effect of setting the value for all connections that shared that 
   connection string.  This way we isolate it just to our particular command.  
   This may fix bug #37104    
+- Fixed documentation surrounding use of ? vs @ for parameters (bug #37349)
 
 Version 5.2.2 - 
 - Fixed profile provider that would throw an exception if you were updating

Modified: branches/5.2/MySql.Data/Provider/Source/docs/MySqlCommand.xml
===================================================================
--- branches/5.2/MySql.Data/Provider/Source/docs/MySqlCommand.xml	2008-06-17 15:26:56 UTC (rev 1323)
+++ branches/5.2/MySql.Data/Provider/Source/docs/MySqlCommand.xml	2008-06-17 15:41:09 UTC (rev 1324)
@@ -39,11 +39,10 @@
       remains open.  It is the responsibility of the programmer to close the connection.
 
       <note>
-        Prior versions of the provider used the '@' symbol to mark parameters in SQL.  This is incompatible
-        with MySQL user variables, so the provider now uses the '?' symbol to locate parameters in SQL.  To
-        support older code, you can set 'old syntax=yes' on your connection string.  If you do this, please
-        be aware that an exception will not be throw if you fail to define a parameter that  you intended to
-        use in your SQL.
+        Using the '@' symbol for paramters is now the preferred approach although the old pattern of using
+		'?' is still supported.  Please be aware though that using '@' can cause conflicts when user variables
+		are also used.  To help with this situation please see the documentation on the 'allow user variables'
+		connection string option.  The 'old syntax' connection string option has now been deprecated.
       </note>
     </remarks>
 
@@ -611,8 +610,8 @@
       The following example demonstrates the use of the <b>Prepare</b> method.
       <code lang="VB.NET">
         public sub PrepareExample()
-        Dim cmd as New MySqlCommand("INSERT INTO mytable VALUES (?val)", myConnection)
-        cmd.Parameters.Add( "?val", 10 )
+        Dim cmd as New MySqlCommand("INSERT INTO mytable VALUES (@val)", myConnection)
+        cmd.Parameters.Add( "@val", 10 )
         cmd.Prepare()
         cmd.ExecuteNonQuery()
 
@@ -623,8 +622,8 @@
       <code lang="C#">
         private void PrepareExample()
         {
-        MySqlCommand cmd = new MySqlCommand("INSERT INTO mytable VALUES (?val)", myConnection);
-        cmd.Parameters.Add( "?val", 10 );
+        MySqlCommand cmd = new MySqlCommand("INSERT INTO mytable VALUES (@val)", myConnection);
+        cmd.Parameters.Add( "@val", 10 );
         cmd.Prepare();
         cmd.ExecuteNonQuery();
 
@@ -861,7 +860,7 @@
         Public Sub CreateMySqlCommand(myConnection As MySqlConnection, _
         mySelectQuery As String, myParamArray() As MySqlParameter)
         Dim myCommand As New MySqlCommand(mySelectQuery, myConnection)
-        myCommand.CommandText = "SELECT id, name FROM mytable WHERE age=?age"
+        myCommand.CommandText = "SELECT id, name FROM mytable WHERE age=@age"
         myCommand.UpdatedRowSource = UpdateRowSource.Both
         myCommand.Parameters.Add(myParamArray)
         Dim j As Integer
@@ -881,7 +880,7 @@
         MySqlParameter[] myParamArray)
         {
         MySqlCommand myCommand = new MySqlCommand(mySelectQuery, myConnection);
-        myCommand.CommandText = "SELECT id, name FROM mytable WHERE age=?age";
+        myCommand.CommandText = "SELECT id, name FROM mytable WHERE age=@age";
         myCommand.Parameters.Add(myParamArray);
         for (int j=0; j&lt;myParamArray.Length; j++)
         {

Modified: branches/5.2/MySql.Data/Provider/Source/docs/MySqlConnection.xml
===================================================================
--- branches/5.2/MySql.Data/Provider/Source/docs/MySqlConnection.xml	2008-06-17 15:26:56 UTC (rev 1323)
+++ branches/5.2/MySql.Data/Provider/Source/docs/MySqlConnection.xml	2008-06-17 15:41:09 UTC (rev 1324)
@@ -979,20 +979,6 @@
           </tr>
           <tr>
             <td>
-              Old Syntax<para>  -or-  </para>OldSyntax
-            </td>
-            <td>false</td>
-            <td>
-              Allows use of '@' symbol as a parameter marker.  See <see cref="MySqlCommand"/> for more
-              info.
-              <note>
-                This is for compatibility only.  All future code should be written to
-                use the new '?' parameter marker.
-              </note>
-            </td>
-          </tr>
-          <tr>
-            <td>
               Pipe Name<para>  -or-  </para>Pipe
             </td>
             <td>mysql</td>

Modified: branches/5.2/MySql.Data/Provider/Source/docs/MySqlDataAdapter.xml
===================================================================
--- branches/5.2/MySql.Data/Provider/Source/docs/MySqlDataAdapter.xml	2008-06-17 15:26:56 UTC (rev 1323)
+++ branches/5.2/MySql.Data/Provider/Source/docs/MySqlDataAdapter.xml	2008-06-17 15:41:09 UTC (rev 1324)
@@ -121,19 +121,19 @@
 
         da.SelectCommand = New MySqlCommand("SELECT id, name FROM mytable", conn)
         da.InsertCommand = New MySqlCommand("INSERT INTO mytable (id, name) " &amp; _
-        "VALUES (?id, ?name)", conn)
-        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=?id, name=?name " &amp; _
-        "WHERE id=?oldId", conn)
-        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=?id", conn)
+        "VALUES (@id, @name)", conn)
+        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=@id, name=@name " &amp; _
+        "WHERE id=@oldId", conn)
+        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=@id", conn)
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
         End Sub
       </code>
       <code lang="C#">
@@ -145,19 +145,19 @@
 
         da.SelectCommand = new MySqlCommand("SELECT id, name FROM mytable", conn);
         da.InsertCommand = new MySqlCommand("INSERT INTO mytable (id, name) " +
-        "VALUES (?id, ?name)", conn);
-        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=?id, name=?name " +
-        "WHERE id=?oldId", conn);
-        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=?id", conn);
+        "VALUES (@id, @name)", conn);
+        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=@id, name=@name " +
+        "WHERE id=@oldId", conn);
+        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=@id", conn);
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
         }
       </code>
     </example>
@@ -224,19 +224,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey
 
         da.InsertCommand = New MySqlCommand("INSERT INTO mytable (id, name) " &amp; _
-        "VALUES (?id, ?name)", conn)
-        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=?id, name=?name " &amp; _
-        "WHERE id=?oldId", conn)
-        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=?id", conn)
+        "VALUES (@id, @name)", conn)
+        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=@id, name=@name " &amp; _
+        "WHERE id=@oldId", conn)
+        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=@id", conn)
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
         End Sub
       </code>
       <code lang="C#">
@@ -248,19 +248,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
         da.InsertCommand = new MySqlCommand("INSERT INTO mytable (id, name) " +
-        "VALUES (?id, ?name)", conn);
-        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=?id, name=?name " +
-        "WHERE id=?oldId", conn);
-        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=?id", conn);
+        "VALUES (@id, @name)", conn);
+        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=@id, name=@name " +
+        "WHERE id=@oldId", conn);
+        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=@id", conn);
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
         }
       </code>
     </example>
@@ -329,19 +329,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey
 
         da.InsertCommand = New MySqlCommand("INSERT INTO mytable (id, name) " &amp; _
-        "VALUES (?id, ?name)", conn)
-        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=?id, name=?name " &amp; _
-        "WHERE id=?oldId", conn)
-        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=?id", conn)
+        "VALUES (@id, @name)", conn)
+        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=@id, name=@name " &amp; _
+        "WHERE id=@oldId", conn)
+        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=@id", conn)
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
         End Sub
       </code>
       <code lang="C#">
@@ -352,19 +352,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
         da.InsertCommand = new MySqlCommand("INSERT INTO mytable (id, name) " +
-        "VALUES (?id, ?name)", conn);
-        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=?id, name=?name " +
-        "WHERE id=?oldId", conn);
-        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=?id", conn);
+        "VALUES (@id, @name)", conn);
+        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=@id, name=@name " +
+        "WHERE id=@oldId", conn);
+        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=@id", conn);
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
         }
       </code>
     </example>
@@ -423,19 +423,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey
 
         da.InsertCommand = New MySqlCommand("INSERT INTO mytable (id, name) " &amp; _
-        "VALUES (?id, ?name)", conn)
-        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=?id, name=?name " &amp; _
-        "WHERE id=?oldId", conn)
-        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=?id", conn)
+        "VALUES (@id, @name)", conn)
+        da.UpdateCommand = New MySqlCommand("UPDATE mytable SET id=@id, name=@name " &amp; _
+        "WHERE id=@oldId", conn)
+        da.DeleteCommand = New MySqlCommand("DELETE FROM mytable WHERE id=@id", conn)
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name")
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name")
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original
         End Sub
       </code>
       <code lang="C#">
@@ -446,19 +446,19 @@
         da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
 
         da.InsertCommand = new MySqlCommand("INSERT INTO mytable (id, name) " +
-        "VALUES (?id, ?name)", conn);
-        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=?id, name=?name " +
-        "WHERE id=?oldId", conn);
-        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=?id", conn);
+        "VALUES (@id, @name)", conn);
+        da.UpdateCommand = new MySqlCommand("UPDATE mytable SET id=@id, name=@name " +
+        "WHERE id=@oldId", conn);
+        da.DeleteCommand = new MySqlCommand("DELETE FROM mytable WHERE id=@id", conn);
 
-        da.InsertCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.InsertCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
+        da.InsertCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.InsertCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
 
-        da.UpdateCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
-        da.UpdateCommand.Parameters.Add("?name", MySqlDbType.VarChar, 40, "name");
-        da.UpdateCommand.Parameters.Add("?oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.UpdateCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
+        da.UpdateCommand.Parameters.Add("@name", MySqlDbType.VarChar, 40, "name");
+        da.UpdateCommand.Parameters.Add("@oldId", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
 
-        da.DeleteCommand.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
+        da.DeleteCommand.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id").SourceVersion = DataRowVersion.Original;
         }
       </code>
     </example>
@@ -499,17 +499,17 @@
         Dim parm As MySqlParameter
 
         ' Create the SelectCommand.
-        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn)
+        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn)
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15)
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15)
 
         da.SelectCommand = cmd
 
         ' Create the DeleteCommand.
-        cmd = New MySqlCommand("DELETE FROM mytable WHERE id=?id", conn)
+        cmd = New MySqlCommand("DELETE FROM mytable WHERE id=@id", conn)
 
-        parm = cmd.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id")
+        parm = cmd.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id")
         parm.SourceVersion = DataRowVersion.Original
 
         da.DeleteCommand = cmd
@@ -525,17 +525,17 @@
         MySqlParameter parm;
 
         // Create the SelectCommand.
-        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn);
+        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn);
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15);
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15);
 
         da.SelectCommand = cmd;
 
         // Create the DeleteCommand.
-        cmd = new MySqlCommand("DELETE FROM mytable WHERE id=?id", conn);
+        cmd = new MySqlCommand("DELETE FROM mytable WHERE id=@id", conn);
 
-        parm = cmd.Parameters.Add("?id", MySqlDbType.VarChar, 5, "id");
+        parm = cmd.Parameters.Add("@id", MySqlDbType.VarChar, 5, "id");
         parm.SourceVersion = DataRowVersion.Original;
 
         da.DeleteCommand = cmd;
@@ -585,18 +585,18 @@
         Dim parm As MySqlParameter
 
         ' Create the SelectCommand.
-        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn)
+        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn)
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15)
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15)
 
         da.SelectCommand = cmd
 
         ' Create the InsertCommand.
-        cmd = New MySqlCommand("INSERT INTO mytable (id,name) VALUES (?id, ?name)", conn)
+        cmd = New MySqlCommand("INSERT INTO mytable (id,name) VALUES (@id, @name)", conn)
 
-        cmd.Parameters.Add( "?id", MySqlDbType.VarChar, 15, "id" )
-        cmd.Parameters.Add( "?name", MySqlDbType.VarChar, 15, "name" )
+        cmd.Parameters.Add( "@id", MySqlDbType.VarChar, 15, "id" )
+        cmd.Parameters.Add( "@name", MySqlDbType.VarChar, 15, "name" )
         da.InsertCommand = cmd
 
         Return da
@@ -610,17 +610,17 @@
         MySqlParameter parm;
 
         // Create the SelectCommand.
-        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn);
+        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn);
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15);
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15);
 
         da.SelectCommand = cmd;
 
         // Create the InsertCommand.
-        cmd = new MySqlCommand("INSERT INTO mytable (id,name) VALUES (?id,?name)", conn);
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15, "id" );
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15, "name" );
+        cmd = new MySqlCommand("INSERT INTO mytable (id,name) VALUES (@id,@name)", conn);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15, "id" );
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15, "name" );
 
         da.InsertCommand = cmd;
 
@@ -669,20 +669,20 @@
         Dim parm As MySqlParameter
 
         ' Create the SelectCommand.
-        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn)
+        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn)
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15)
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15)
 
         da.SelectCommand = cmd
 
         ' Create the UpdateCommand.
-        cmd = New MySqlCommand("UPDATE mytable SET id=?id, name=?name WHERE id=?oldId", conn)
+        cmd = New MySqlCommand("UPDATE mytable SET id=@id, name=@name WHERE id=@oldId", conn)
 
-        cmd.Parameters.Add( "?id", MySqlDbType.VarChar, 15, "id" )
-        cmd.Parameters.Add( "?name", MySqlDbType.VarChar, 15, "name" )
+        cmd.Parameters.Add( "@id", MySqlDbType.VarChar, 15, "id" )
+        cmd.Parameters.Add( "@name", MySqlDbType.VarChar, 15, "name" )
 
-        parm = cmd.Parameters.Add("?oldId", MySqlDbType.VarChar, 15, "id")
+        parm = cmd.Parameters.Add("@oldId", MySqlDbType.VarChar, 15, "id")
         parm.SourceVersion = DataRowVersion.Original
 
         da.UpdateCommand = cmd
@@ -698,19 +698,19 @@
         MySqlParameter parm;
 
         // Create the SelectCommand.
-        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn);
+        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn);
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15);
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15);
 
         da.SelectCommand = cmd;
 
         // Create the UpdateCommand.
-        cmd = new MySqlCommand("UPDATE mytable SET id=?id, name=?name WHERE id=?oldId", conn);
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15, "id" );
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15, "name" );
+        cmd = new MySqlCommand("UPDATE mytable SET id=@id, name=@name WHERE id=@oldId", conn);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15, "id" );
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15, "name" );
 
-        parm = cmd.Parameters.Add( "?oldId", MySqlDbType.VarChar, 15, "id" );
+        parm = cmd.Parameters.Add( "@oldId", MySqlDbType.VarChar, 15, "id" );
         parm.SourceVersion = DataRowVersion.Original;
 
         da.UpdateCommand = cmd;
@@ -752,18 +752,18 @@
         Dim parm As MySqlParameter
 
         ' Create the SelectCommand.
-        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn)
+        cmd = New MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn)
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15)
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15)
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15)
 
         da.SelectCommand = cmd
 
         ' Create the InsertCommand.
-        cmd = New MySqlCommand("INSERT INTO mytable (id,name) VALUES (?id, ?name)", conn)
+        cmd = New MySqlCommand("INSERT INTO mytable (id,name) VALUES (@id, @name)", conn)
 
-        cmd.Parameters.Add( "?id", MySqlDbType.VarChar, 15, "id" )
-        cmd.Parameters.Add( "?name", MySqlDbType.VarChar, 15, "name" )
+        cmd.Parameters.Add( "@id", MySqlDbType.VarChar, 15, "id" )
+        cmd.Parameters.Add( "@name", MySqlDbType.VarChar, 15, "name" )
         da.InsertCommand = cmd
 
         Return da
@@ -777,17 +777,17 @@
         MySqlParameter parm;
 
         // Create the SelectCommand.
-        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=?id AND name=?name", conn);
+        cmd = new MySqlCommand("SELECT * FROM mytable WHERE id=@id AND name=@name", conn);
 
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15);
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15);
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15);
 
         da.SelectCommand = cmd;
 
         // Create the InsertCommand.
-        cmd = new MySqlCommand("INSERT INTO mytable (id,name) VALUES (?id,?name)", conn);
-        cmd.Parameters.Add("?id", MySqlDbType.VarChar, 15, "id" );
-        cmd.Parameters.Add("?name", MySqlDbType.VarChar, 15, "name" );
+        cmd = new MySqlCommand("INSERT INTO mytable (id,name) VALUES (@id,@name)", conn);
+        cmd.Parameters.Add("@id", MySqlDbType.VarChar, 15, "id" );
+        cmd.Parameters.Add("@name", MySqlDbType.VarChar, 15, "name" );
 
         da.InsertCommand = cmd;