Scribd
Upload
7 views5 pages

ASP.NET Customer Database Management

The document describes code for an ASP.NET web page that connects to an Access database and performs CRUD operations on customer records. It opens a connection, fills a dataset by selecting all records from the Customers table. It provides buttons to navigate between records, and buttons to update, edit, and delete the current record.

Uploaded by

Muazzam Kazmi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views5 pages

ASP.NET Customer Database Management

The document describes code for an ASP.NET web page that connects to an Access database and performs CRUD operations on customer records. It opens a connection, fills a dataset by selecting all records from the Customers table. It provides buttons to navigate between records, and buttons to update, edit, and delete the current record.

Uploaded by

Muazzam Kazmi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

using using using using using using using using using using using using using

System; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link]; [Link];

namespace NewOne { public partial class _Default : [Link] { OleDbConnection Con; OleDbCommand Cmd; OleDbDataAdapter da; OleDbDataReader dr; DataSet ds; int recordcount = 0; int i; protected void Page_Load(object sender, EventArgs e) { Con = new OleDbConnection("Provider = [Link].4.0;data source = F:\\[Link]"); Cmd = new OleDbCommand("SELECT * FROM Customers", Con); da = new OleDbDataAdapter(Cmd); ds = new DataSet("Customers"); [Link](); [Link](ds,"Customers"); [Link]("Connection is Open Now!!");

dr = [Link](); recordcount = [Link][0].[Link]; [Link]("Record Count : " +recordcount);

if (recordcount > i) { [Link] = [Link][0].Rows[i]["CustomerID"].ToString();

[Link] = [Link][0].Rows[i]["CompanyName"].ToString(); [Link] = [Link][0].Rows[i]["ContactName"].ToString(); [Link] = [Link][0].Rows[i]["Address"].ToString(); [Link] = [Link][0].Rows[i]["City"].ToString(); [Link] = [Link][0].Rows[i]["Region"].ToString(); [Link] = [Link][0].Rows[i]["Country"].ToString(); [Link] = [Link][0].Rows[i]["Phone"].ToString(); } else { [Link]("There are no records in this category"); } [Link]();

[Link](); [Link]("Connection is Closed Now!!"); }

protected void btnFirst_Click(object sender, EventArgs e) { if ([Link][0].[Link] > 0) { i = 0; [Link] = [Link][0].Rows[i]["CustomerID"].ToString(); [Link] = [Link][0].Rows[i]["CompanyName"].ToString(); [Link] = [Link][0].Rows[i]["ContactName"].ToString(); [Link] = [Link][0].Rows[i]["Address"].ToString(); [Link] = [Link][0].Rows[i]["City"].ToString(); [Link] = [Link][0].Rows[i]["Region"].ToString(); [Link] = [Link][0].Rows[i]["Country"].ToString(); [Link] = [Link][0].Rows[i]["Phone"].ToString(); } else { [Link]("You have reached the First record in this Category"); }

protected void btnPrevious_Click(object sender, EventArgs e) {

if (i == [Link][0].[Link] - 1) { i--; [Link] = [Link][0].Rows[i]["CustomerID"].ToString(); [Link] = [Link][0].Rows[i]["CompanyName"].ToString(); [Link] = [Link][0].Rows[i]["ContactName"].ToString(); [Link] = [Link][0].Rows[i]["Address"].ToString(); [Link] = [Link][0].Rows[i]["City"].ToString(); [Link] = [Link][0].Rows[i]["Region"].ToString(); [Link] = [Link][0].Rows[i]["Country"].ToString(); [Link] = [Link][0].Rows[i]["Phone"].ToString(); } else { [Link]("You have reached the begining of the records in this category"); }

protected void btnNext_Click(object sender, EventArgs e) {

if (i < [Link][0].[Link] - 1) { i++; [Link] = [Link][0].Rows[i]["CustomerID"].ToString(); [Link] = [Link][0].Rows[i]["CompanyName"].ToString(); [Link] = [Link][0].Rows[i]["ContactName"].ToString(); [Link] = [Link][0].Rows[i]["Address"].ToString(); [Link] = [Link][0].Rows[i]["City"].ToString(); [Link] = [Link][0].Rows[i]["Region"].ToString(); [Link] = [Link][0].Rows[i]["Country"].ToString(); [Link] = [Link][0].Rows[i]["Phone"].ToString(); } else { [Link]("You have reached the end of records in this category!!"); } }

protected void btnLast_Click(object sender, EventArgs e)

{ i = [Link][0].[Link] - 1;

[Link] = [Link][0].Rows[i]["CustomerID"].ToString(); [Link] = [Link][0].Rows[i]["CompanyName"].ToString(); [Link] = [Link][0].Rows[i]["ContactName"].ToString(); [Link] = [Link][0].Rows[i]["Address"].ToString(); [Link] = [Link][0].Rows[i]["City"].ToString(); [Link] = [Link][0].Rows[i]["Region"].ToString(); [Link] = [Link][0].Rows[i]["Country"].ToString(); [Link] = [Link][0].Rows[i]["Phone"].ToString();

[Link]("You have reached the last record in this category!!"); }

protected void btnUpdate_Click(object sender, EventArgs e) { Con = new OleDbConnection("Provider = [Link].4.0;data source = F:\\[Link]"); Cmd = new OleDbCommand("UPDATE record set CompanyName =" + [Link] + "ContactName=" + [Link] + "Address=" + [Link] + "City=" + [Link] + "Region=" + [Link] + "Country=" + [Link] + "Phone=" + [Link] + "WHERE CustomerID=" + [Link] + " "); [Link](); //[Link](); [Link](); }

protected void btnEdit_Click(object sender, EventArgs e) { Con = new OleDbConnection("Provider = [Link].4.0;data source = F:\\[Link]"); Cmd = new OleDbCommand("EDIT record set CompanyName =" + [Link] + "ContactName =" + [Link] + "Address=" + [Link] + "City=" + [Link] + "Region=" + [Link] + "Country=" + [Link] + "Phone=" + [Link] + "WHERE CustomerID=" + [Link] + " "); [Link](); //[Link](); [Link]();

protected void btnDelete_Click(object sender, EventArgs e) { Con = new OleDbConnection("Provider = [Link].4.0;data source = F:\\[Link]"); Cmd = new OleDbCommand("DELETE FROM Customers WHERE CustomerID = " + [Link] + " "); [Link](); //[Link](); [Link](); }

You might also like