Problemer med parameterized queries og ms access
HejsaJeg undre mig lidt over hvorfor denne her stump kode giver fejl.
Nogle ideer ?
--- fejl ---
System.Data.OleDb.OleDbException: Handlingen skal bruge en opdaterbar forespørgsel.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at ASP.index_aspx.Insert(Object sender, EventArgs e)
--- kode ---
void Insert(object sender, EventArgs e)
{
if(Page.IsValid)
{
try
{
System.Data.OleDb.OleDbConnection link = new System.Data.OleDb.OleDbConnection();
link.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source=C:\IIS\guestbook.mdb";
string SQL = @" INSERT INTO "+
@" guestbook(strName "+
@" ,strEmail "+
@" ,txtMessage) "+
@" VALUES (@name "+
@" ,@email "+
@" ,@message) ";
OleDbCommand cmd = new OleDbCommand(SQL,link);
cmd.Parameters.Add(new OleDbParameter("@name",name.Text));
cmd.Parameters.Add(new OleDbParameter("@email",email.Text));
cmd.Parameters.Add(new OleDbParameter("@message",message.Value));
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
error.Text = ex.ToString();
}
}
}
