Answer:
Default.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1.Default" %>
<!DOCTYPE html>
<html lang="en">
<head runat="server">
<meta charset="utf-8" />
<title>Employee Management</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2>Employee Management</h2>
<!-- Insert Form -->
<h3>Insert Employee</h3>
<label>Employee No:</label>
<input type="text" id="txtEno" runat="server" /><br /><br />
<label>Employee Name:</label>
<input type="text" id="txtEname" runat="server" /><br /><br />
<label>Designation:</label>
<input type="text" id="txtEdesignation" runat="server" /><br /><br />
<label>Salary:</label>
<input type="text" id="txtSalary" runat="server" /><br /><br />
<label>Join Date:</label>
<input type="date" id="txtJoinDate" runat="server" /><br /><br />
<button type="button" onclick="InsertRecord()">Insert Record</button><br /><br />
<!-- Update Form -->
<h3>Update Employee</h3>
<label>Employee No:</label>
<input type="text" id="txtUpdateEno" runat="server" /><br /><br />
<label>Employee Name:</label>
<input type="text" id="txtUpdateEname" runat="server" /><br /><br />
<label>Designation:</label>
<input type="text" id="txtUpdateEdesignation" runat="server" /><br /><br />
<label>Salary:</label>
<input type="text" id="txtUpdateSalary" runat="server" /><br /><br />
<label>Join Date:</label>
<input type="date" id="txtUpdateJoinDate" runat="server" /><br /><br />
<button type="button" onclick="UpdateRecord()">Update Record</button><br /><br />
</div>
</form>
<script>
function InsertRecord() {
var eno = document.getElementById('<%= txtEno.ClientID %>').value;
var ename = document.getElementById('<%= txtEname.ClientID %>').value;
var edesignation = document.getElementById('<%= txtEdesignation.ClientID %>').value;
var salary = document.getElementById('<%= txtSalary.ClientID %>').value;
var joindate = document.getElementById('<%= txtJoinDate.ClientID %>').value;
var xhttp = new XMLHttpRequest();
xhttp.open("POST", "Default.aspx/InsertEmployee", true);
xhttp.setRequestHeader("Content-type", "application/json");
xhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
alert(this.responseText);
}
};
var data = JSON.stringify({ "eno": eno, "ename": ename, "edesignation": edesignation, "salary": salary, "joindate": joindate });
xhttp.send(data);
}
function UpdateRecord() {
var eno = document.getElementById('<%= txtUpdateEno.ClientID %>').value;
var ename = document.getElementById('<%= txtUpdateEname.ClientID %>').value;
var edesignation = document.getElementById('<%= txtUpdateEdesignation.ClientID %>').value;
var salary = document.getElementById('<%= txtUpdateSalary.ClientID %>').value;
var joindate = document.getElementById('<%= txtUpdateJoinDate.ClientID %>').value;
var xhttp = new XMLHttpRequest();
xhttp.open("POST", "Default.aspx/UpdateEmployee", true);
xhttp.setRequestHeader("Content-type", "application/json");
xhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
alert(this.responseText);
}
};
var data = JSON.stringify({ "eno": eno, "ename": ename, "edesignation": edesignation, "salary": salary, "joindate": joindate });
xhttp.send(data);
}
</script>
</body>
</html>Default.aspx.cs:
using System;
using System.Data;
using System.Data.OleDb;
using System.Web.Services;
namespace WebApplication1
{
public partial class Default : System.Web.UI.Page
{
// Connection string to your Access database
private static string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EmpDBConnectionString"].ToString();
[WebMethod]
public static string InsertEmployee(string eno, string ename, string edesignation, string salary, string joindate)
{
string result = "";
// Using OleDbConnection to interact with Access DB
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
string query = "INSERT INTO EMP (eno, ename, edesignation, salary, joindate) VALUES (?, ?, ?, ?, ?)";
using (OleDbCommand cmd = new OleDbCommand(query, conn))
{
cmd.Parameters.AddWithValue("?", eno);
cmd.Parameters.AddWithValue("?", ename);
cmd.Parameters.AddWithValue("?", edesignation);
cmd.Parameters.AddWithValue("?", salary);
cmd.Parameters.AddWithValue("?", joindate);
// Execute the query and check if any rows were affected
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
result = "Record inserted successfully!";
}
else
{
result = "Failed to insert the record.";
}
}
}
return result;
}
[WebMethod]
public static string UpdateEmployee(string eno, string ename, string edesignation, string salary, string joindate)
{
string result = "";
// Using OleDbConnection to interact with Access DB
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
string query = "UPDATE EMP SET ename = ?, edesignation = ?, salary = ?, joindate = ? WHERE eno = ?";
using (OleDbCommand cmd = new OleDbCommand(query, conn))
{
cmd.Parameters.AddWithValue("?", ename);
cmd.Parameters.AddWithValue("?", edesignation);
cmd.Parameters.AddWithValue("?", salary);
cmd.Parameters.AddWithValue("?", joindate);
cmd.Parameters.AddWithValue("?", eno);
// Execute the query and check if any rows were affected
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
result = "Record updated successfully!";
}
else
{
result = "Failed to update the record.";
}
}
}
return result;
}
}
}