OleDb & ASP.NET - Exception - Operation must use an updateable query

[mp]

Hi,

I have following problem:

Operation must use an updateable query

I have use OleDb, C# and ASP.NET and MS Access DB named pubs.

Code:

private void Button1_Click(o bject sender, System.EventArg s e)
{
@OleDbConnectio n thisConnection = new OleDbConnection (
@"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data Source=" +
@"C:\base\pubs. mdb");

String insertCmd = "insert into Authors (au_id, au_lname) values (@Id,
@LName)";

OleDbCommand myCommand = new OleDbCommand(in sertCmd, thisConnection) ;
myCommand.Param eters.Add(new OleDbParameter( "@Id", OleDbType.VarCh ar,
11));
myCommand.Param eters["@Id"].Value = txtID.Text;
/*Server.HtmlEnc ode(txtID.Text) ;*/

myCommand.Param eters.Add(new OleDbParameter( "@LName", OleDbType.VarCh ar,
40));
myCommand.Param eters["@LName"].Value = txtLName.Text; /*
Server.HtmlEnco de(txtLName.Tex t); */
myCommand.Conne ction.Open();

//myCommand.Execu teNonQuery();
try
{
myCommand.Execu teNonQuery();
}
catch (OleDbException xx)
{
// Exception
lblMessage.Text = "Insert Data Failed - " + xx.Message;
}
myCommand.Conne ction.Close();
}

Thanks

[mp]

Hi,

I have put this example on web and everything works but localy doesn't.

Do you have ideas why does not work locally?

Thanks,

Mirko

"mp" <pl****@volja.n et> wrote in message
news:OH******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

I have following problem:

Operation must use an updateable query

I have use OleDb, C# and ASP.NET and MS Access DB named pubs.

Code:

private void Button1_Click(o bject sender, System.EventArg s e)
{
@OleDbConnectio n thisConnection = new OleDbConnection (
@"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data Source=" +
@"C:\base\pubs. mdb");

String insertCmd = "insert into Authors (au_id, au_lname) values (@Id,
@LName)";

OleDbCommand myCommand = new OleDbCommand(in sertCmd, thisConnection) ;
myCommand.Param eters.Add(new OleDbParameter( "@Id", OleDbType.VarCh ar,
11));
myCommand.Param eters["@Id"].Value = txtID.Text;
/*Server.HtmlEnc ode(txtID.Text) ;*/

myCommand.Param eters.Add(new OleDbParameter( "@LName", OleDbType.VarCh ar, 40));
myCommand.Param eters["@LName"].Value = txtLName.Text; /*
Server.HtmlEnco de(txtLName.Tex t); */
myCommand.Conne ction.Open();

//myCommand.Execu teNonQuery();
try
{
myCommand.Execu teNonQuery();
}
catch (OleDbException xx)
{
// Exception
lblMessage.Text = "Insert Data Failed - " + xx.Message;
}
myCommand.Conne ction.Close();
}

Thanks

[mp]

Hi,

I have put this example on web and everything works but localy doesn't.

Do you have ideas why does not work locally?

Thanks,

Mirko

"mp" <pl****@volja.n et> wrote in message
news:OH******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

I have following problem:

Operation must use an updateable query

I have use OleDb, C# and ASP.NET and MS Access DB named pubs.

Code:

private void Button1_Click(o bject sender, System.EventArg s e)
{
@OleDbConnectio n thisConnection = new OleDbConnection (
@"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data Source=" +
@"C:\base\pubs. mdb");

String insertCmd = "insert into Authors (au_id, au_lname) values (@Id,
@LName)";

OleDbCommand myCommand = new OleDbCommand(in sertCmd, thisConnection) ;
myCommand.Param eters.Add(new OleDbParameter( "@Id", OleDbType.VarCh ar,
11));
myCommand.Param eters["@Id"].Value = txtID.Text;
/*Server.HtmlEnc ode(txtID.Text) ;*/

myCommand.Param eters.Add(new OleDbParameter( "@LName", OleDbType.VarCh ar, 40));
myCommand.Param eters["@LName"].Value = txtLName.Text; /*
Server.HtmlEnco de(txtLName.Tex t); */
myCommand.Conne ction.Open();

//myCommand.Execu teNonQuery();
try
{
myCommand.Execu teNonQuery();
}
catch (OleDbException xx)
{
// Exception
lblMessage.Text = "Insert Data Failed - " + xx.Message;
}
myCommand.Conne ction.Close();
}

Thanks