Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2006, 07:43 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP.NET 2.0 Updating Database Record

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
updating database after record deletion marcstrong Visual Basic 2008 Essentials 1 July 22nd, 2008 05:25 PM
VB.Net Code for updating a record damanka2001 Access VBA 0 July 26th, 2007 04:59 PM
Updating database record shrisangeeta Classic ASP Basics 4 February 28th, 2007 05:25 PM
Updating the record in database lwebzem ASP.NET 1.0 and 1.1 Basics 4 March 8th, 2006 09:40 AM
Updating the record in the database lwebzem ASP.NET 1.0 and 1.1 Basics 3 February 28th, 2006 07:57 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.