using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace WebApplication9
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
protected void Button1_Click(object sender, EventArgs e)
{
using (OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Users\\Lenovo\\Desktop\\mini
project\\WebApplication8\\WebApplication8\\Database2.mdb"))
{
try
{
con.Open();
string query = "INSERT INTO [user] (username, email, phone,
[password]) VALUES (?, ?, ?, ?)";
using (OleDbCommand cmd = new OleDbCommand(query, con))
{
cmd.Parameters.AddWithValue("?", TextBox2.Text);
cmd.Parameters.AddWithValue("?", TextBox3.Text);
cmd.Parameters.AddWithValue("?", TextBox4.Text);
cmd.Parameters.AddWithValue("?", TextBox5.Text);
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
using (OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Users\\Lenovo\\Desktop\\mini
project\\WebApplication8\\WebApplication8\\Database2.mdb"))
{
try
{
con.Open();
string query = "UPDATE [user] SET username = ?, email = ?, phone = ?,
[password] = ? WHERE ID = ?";
using (OleDbCommand cmd = new OleDbCommand(query, con))
{
cmd.Parameters.AddWithValue("?", TextBox2.Text); // username
cmd.Parameters.AddWithValue("?", TextBox3.Text); // email
cmd.Parameters.AddWithValue("?", Convert.ToInt64(TextBox4.Text));
// phone
cmd.Parameters.AddWithValue("?", TextBox5.Text); // password
cmd.Parameters.AddWithValue("?", Convert.ToInt32(TextBox6.Text));
// ID (assuming it's an integer)
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
MessageBox.Show("User updated successfully!");
}
else
{
MessageBox.Show("No user found with the given ID.");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
using (OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Users\\Lenovo\\Desktop\\mini
project\\WebApplication8\\WebApplication8\\Database2.mdb"))
{
try
{
con.Open();
string query = "DELETE FROM [user] WHERE ID = ?";
using (OleDbCommand cmd = new OleDbCommand(query, con))
{
cmd.Parameters.AddWithValue("?", Convert.ToInt32(TextBox6.Text));
// ID
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
MessageBox.Show("User deleted successfully!");
}
else
{
MessageBox.Show("No user found with the given ID.");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
}
}
}
}
}
