| List: | Commits | « Previous MessageNext Message » | |
| From: | rburnett | Date: | June 17 2008 5:41pm |
| Subject: | Connector/NET commit: r1324 - in branches/5.2: . MySql.Data/Provider/Source/docs | ||
| View as plain text | |||
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<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) " & _ - "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 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) " & _ - "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 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) " & _ - "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 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) " & _ - "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 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;
| Thread | ||
|---|---|---|
| • Connector/NET commit: r1324 - in branches/5.2: . MySql.Data/Provider/Source/docs | rburnett | 17 Jun |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.687 sec. using MySQL 5.1.14-beta-log