Kako napraviti UPDATE query u asp.net-u?

[Bluesmaster]

U Accessovoj bazi postoji samo jedna table 'tablica', jedan record i dva fields 'id' i 'sadrzaj'.
Zanima me gdje grijesim...

moj kod:

string putanja = Server.MapPath("baza.mdb");
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + putanja;
OleDbConnection conn = new OleDbConnection(connStr);
string sqlUpit = "UPDATE tablica SET sadrzaj = 'jagode' WHERE id = 1";
OleDbCommand cmd = new OleDbCommand(sqlUpit, conn);

conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

ovo je greska koja mi se javi:

System.Data.OleDb.OleDbException: Operation must use an updateable query. 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 web_forma.upis.gumb_ServerClick(Object sender, EventArgs e) in e:\inetpub\wwwroot\web_forma\upis.aspx.cs:line 65

[:cosmos:]

evo sto kaze uncle google, usto, i kod errora se vidi sto bi moglo biti

http://www.dotnet247.com/247reference/msgs/49/245671.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=498377&SiteID=1

[Moebius]

vrlo vjerojatno nemas write permissions na bazu.

[killa]

nazovi hosting providera i zatraži read/write premisije na bazi ili na cijelom sajtu

[wxyzrusmir]

read/write permisija

[Bluesmaster]

Hvala svima!
Puno ste mi pomogli!

[Ivan Markulin]

Probaj ovaj kod:
Sub Update(sender as Object, e as EventArgs)
Dim con As OleDbConnection
Dim cmd As OleDbCommand
Dim strSQL As String


con = New OleDbConnection ("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & MapPath("baza.mdb"))
strSQL="Update tablica Set sadrzaj=? Where ID=1"
cmd=New OleDbCommand(strSQL, con)
cmd.Parameters.Add("@sadrzaj", "jagode")


con.Open()
cmd.ExecuteNonQuery()
con.Close()

End Sub

I stavi u page direktivu da ti je debug True kako bi u error poruci bolje vidi gdje je doslo do problema (<%@ Page Language = "VB" Debug = "True"%>)

pozdrav