ASP.NET - Databases - Update Records
Here is an example of updating records in an Access database using C# and ASP.NET:
Assuming you have a table named "Students" with columns "ID", "Name", and "Age" in your Access database:
HTML code for the form:
<!DOCTYPE html>
<html>
<head>
<title>Update Student Record</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<label>Enter ID of student to update:</label>
<input type="text" id="txtID" name="txtID" />
<br />
<label>Enter new name:</label>
<input type="text" id="txtName" name="txtName" />
<br />
<label>Enter new age:</label>
<input type="text" id="txtAge" name="txtAge" />
<br />
<input type="submit" id="btnUpdate" name="btnUpdate" value="Update" />
</div>
</form>
</body>
</html>C# code for updating record in code-behind file:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Set initial form state
txtID.Text = "";
txtName.Text = "";
txtAge.Text = "";
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
// Get connection string from web.config file
string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
// Create SQL statement to update record
string sql = "UPDATE Students SET Name = @Name, Age = @Age WHERE ID = @ID";
// Create connection object and open connection
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
// Create command object and set parameters
using (OleDbCommand cmd = new OleDbCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@Name", txtName.Text);
cmd.Parameters.AddWithValue("@Age", txtAge.Text);
cmd.Parameters.AddWithValue("@ID", txtID.Text);
// Execute command
int rowsAffected = cmd.ExecuteNonQuery();
// Check if update was successful
if (rowsAffected > 0)
{
Response.Write("Record updated successfully.");
}
else
{
Response.Write("Update failed.");
}
}
}
}Note: Make sure to replace "MyConnectionString" in the C# code with the actual name of the connection string in your web.config file.
