Talk in computer language.: ASP.Net with Microsoft Access

Delete data from MS access Database using ASP.Net

This program will delete data from MS access database

Before Delete:-

After Delete:-

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
using System.Data.Odbc;
using System.Data.OleDb;

public partial class oledb : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        OleDbConnection objConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\\mydb.mdb;");

        OleDbCommand objCmd = new OleDbCommand("delete from stud where id=200", objConn);
        OleDbDataReader objReader;
        objConn.Open();
        objReader = objCmd.ExecuteReader();

        objConn.Close();


    }
}

Insert data in access database using ASP.Net

This program will insert data in stud table of Microsoft access database.

Before insert operation:-

After insert Operation:-

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data;

using System.Data.SqlClient;

using System.Data.Odbc;

using System.Data.OleDb;

public partial class oledb : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

OleDbConnection objConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\\mydb.mdb;");

OleDbCommand objCmd = new OleDbCommand("insert into stud values(200,'aaa','aaa')", objConn);

OleDbDataReader objReader;

objConn.Open();

objReader = objCmd.ExecuteReader();

objConn.Close();

}

Fetch Data from Microsoft Access using ASP.Net

This program for fetch data from microsoft access database

Step 1) Add below code in your ASP.Net page

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data;

using System.Data.SqlClient;

using System.Data.Odbc;

using System.Data.OleDb;

public partial class oledb : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

OleDbConnection objConn = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\\mydb.mdb;");

OleDbCommand objCmd = new OleDbCommand("select * from stud", objConn);

OleDbDataReader objReader;

objConn.Open();

objReader = objCmd.ExecuteReader();

while (objReader.Read())

{

Response.Write(objReader.GetValue(1));

Response.Write(objReader.GetValue(2) + "<br>");

}

objConn.Close();

}

Connection with MS Access and ASP.NET using C#

This program will show the connection information ASP.Net with Microsoft Access

Step 1)Add following code in your ASP.Net page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="oledb.aspx.cs" Inherits="oledb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<table>

<tbody>

<tr>

<td>

ConnectionString:

</td>

<td>

<asp:Label id="lblOleDbConnectionString" runat="server">ConnectionString</asp:Label></td>

</tr>

<tr>

<td>

ConnectionTimeout:

</td>

<td>

<asp:Label id="lblOleDbConnectionTimeout" runat="server">ConnectionTimeout</asp:Label></td>

</tr>

<tr>

<td>

Database:

</td>

<td>

<asp:Label id="lblOleDbDatabase" runat="server">Database</asp:Label></td>

</tr>

<tr>

<td>

DataSource:

</td>

<td>

<asp:Label id="lblOleDbDataSource" runat="server">DataSource</asp:Label></td>

</tr>

<tr>

<td>

Provider:

</td>

<td>

<asp:Label id="lblOleDbProvider" runat="server">Provider</asp:Label></td>

</tr>

<tr>

<td>

ServerVersion:

</td>

<td>

<asp:Label id="lblOleDbServerVersion" runat="server">ServerVersion</asp:Label></td>

</tr>

<tr>

<td>

State:

</td>

<td>

<asp:Label id="lblOleDbState" runat="server">State</asp:Label></td>

</tr>

</tbody>

</table>

</div>

</form>

</body>

</html>

Step 2) Add following code in your code back of ASP.Net page

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data;

using System.Data.SqlClient;

using System.Data.Odbc;

using System.Data.OleDb;

public partial class oledb : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

OleDbConnection myOleDbConnection = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:\\ccc.mdb;");

myOleDbConnection.Open();

lblOleDbConnectionString.Text = myOleDbConnection.ConnectionString;

lblOleDbConnectionTimeout.Text = Convert.ToString(myOleDbConnection.ConnectionTimeout);

lblOleDbDatabase.Text = myOleDbConnection.Database;

lblOleDbDataSource.Text = myOleDbConnection.DataSource;

lblOleDbProvider.Text = myOleDbConnection.Provider;

lblOleDbServerVersion.Text = myOleDbConnection.ServerVersion;

lblOleDbState.Text = Convert.ToString(myOleDbConnection.State);

myOleDbConnection.Close();

}

Talk in computer language.

Friday, February 17, 2012

Delete data from MS access Database using ASP.Net

Insert data in access database using ASP.Net

Fetch Data from Microsoft Access using ASP.Net

Connection with MS Access and ASP.NET using C#

About Me