Insert query parameters not working

Roland · Joined: 08 Aug 2007 Posts: 1

In my application (ASP.net) I use the following:

MyDataSource.InsertParameters.Clear();
MyDataSource.InsertParameters.Add("AdvID", TypeCode.String, sAdvID);
MyDataSource.InsertParameters.Add("Email", txtEmail.Text);
MyDataSource.InsertParameters.Add("Name", txtName.Text);
MyDataSource.InsertCommand = "INSERT INTO markt.advertizers " +
"(AdvID, Email, Name) VALUES (@AdvertiserID,@Email,@Name)";
MyDataSource.Insert();

When I run the app, I get the excheption:
"ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Column
'AdvID' cannot be null"

What do I do wrong here (except for using MySQL;-)?

Archived from group: microsoft>public>dotnet>framework>odbcnet

Paul Clement · Joined: 08 Aug 2007 Posts: 154

On Thu, 26 Oct 2006 03:05:02 -0700, Roland wrote:

¤ In my application (ASP.net) I use the following:
¤
¤ MyDataSource.InsertParameters.Clear();
¤ MyDataSource.InsertParameters.Add("AdvID", TypeCode.String, sAdvID);
¤ MyDataSource.InsertParameters.Add("Email", txtEmail.Text);
¤ MyDataSource.InsertParameters.Add("Name", txtName.Text);
¤ MyDataSource.InsertCommand = "INSERT INTO markt.advertizers " +
¤ "(AdvID, Email, Name) VALUES (@AdvertiserID,@Email,@Name)";
¤ MyDataSource.Insert();
¤
¤ When I run the app, I get the excheption:
¤ "ERROR [HYT00] [MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Column
¤ 'AdvID' cannot be null"
¤
¤ What do I do wrong here (except for using MySQL;-)?

It looks like your parameter is misnamed. The parameter name in your query is @AdvertiserID while
the name of the parameter you are adding to the Parameter collection is AdvID.

Paul
~~~~
Microsoft MVP (Visual Basic)

Discovering parameters to Access queries? How can you discover parameters to queries, specifically Access queries, with ODBC.NET? For example, "Sales by Year" in I've read that such queries look more like stored procedures, but and return noth

Error 07002 SQLBindParameter not used for all parameters Hi, I created a simple VB.NET 2003 application through Visual Studio that connects to a MySQL database and loads a table into a Dataset, and then displays that table information in a DataGrid on a form for editing. The table fill works fine, the delete f

Trying to Insert a Record I'm trying to insert a new record into an MS Access table. The code below compiles and runs, but it doesn't write a record into the table. Can someone tell me why? Dim As New * FROM Sessions",

"Connection is dead" on ODBC insert of decimal into DB2 I am having problems inserting Decimal values into a DB2 database via a .NET/C# application which is using an Other field types such as VarChar, Int, Date, etc work ok, and I can insert literal values into a decimal field, but any attempt

System.Data.ODBC Blob insert problem Hi all, I am trying to use to insert a file into a binary field in SQL Server 2000. Now, before you yell at me, the reason I am doing this is that I am only writing intitial code against SQL, but this app will need to be able to run aga