Updating A Database Record in ASp.NEt 2.0

Question

Hi,

I have encountered a strange problem when trying to update a microsoft access database record with ASP.NET 2.0 - C#. I can already Insert and view records but the update doesnt seem to be working at all. Here is a simple segment of my code:

protected void btnUpdate_Click(object sender, EventArgs e)

{

OleDbConnection objConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("/admin/App_Data/DataSynapseAdmin.mdb") + ";");

OleDbCommand objCmd = new OleDbCommand("UPDATE Hospital SET name = @hospitalName WHERE hospitalID = 26", objConn);

OleDbParameter hospitalName = new OleDbParameter("@hospitalName", txtHospitalName.Text);

objCmd.Parameters.Add(hospitalName);

objConn.Open();

objCmd.ExecuteNonQuery();

objConn.Close();

objConn.Dispose();

}

Am I missing an improtant factor? Any help appreciated.

columth06.

Pat Tum · Answer

Hello, Not sure, but you might give this a try. The changes are as follows: Deleted the extra declaration of hospital (unnecessary). and simply put the Command Parameter objCmd equal to the parameter. If you are using .Net 2.0, you should change the (.Add) to (.AddWithValue). Also, the word 'name' in your update command string could be misinterpreted as a reserved word. When using these, it is often a good idea to put them in brackets, so they can be taken literally. Here is the code. Hope it works...Best, Pat OleDbConnection objConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("/admin/App_Data/DataSynapseAdmin.mdb") + ";"); OleDbCommand objCmd = new OleDbCommand("UPDATE Hospital SET [name] = @hospitalName WHERE hospitalID = 26", objConn); objCmd.Parameters.Add("@hospitalName", txtHospitalName.Text); objConn.Open(); objCmd.ExecuteNonQuery(); objConn.Close(); objConn.Dispose(); }

Updating A Database Record in ASp.NEt 2.0

Answers (1)