Re: InsertParameters.Add doesn't work in ASP.NET
- From: "ekkehard.horner" <ekkehard.horner@xxxxxxxx>
- Date: Fri, 27 Oct 2006 23:54:07 +0200
Roland wrote:
In my application (ASP.net) I use the following:1 2 3 1 2 ???
MyDataSource.InsertParameters.Clear();
MyDataSource.InsertParameters.Add("AdvID", TypeCode.String, sAdvID);
MyDataSource.InsertParameters.Add("Name", txtName.Text);
MyDataSource.InsertCommand = "INSERT INTO markt.advertizers " +
"(AdvID, Email, Name) VALUES (@AdvID,@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;-)?
- Prev by Date: Re: CONVERT Function in ASPX
- Next by Date: How to retrieve all the rows of a system table whose TABLE_SCHEMA is sys and whose database is master/tempdb ?
- Previous by thread: Re: InsertParameters.Add doesn't work in ASP.NET
- Next by thread: Reinstall Jet
- Index(es):
