.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Connect Msaccess 2007 in asp.net

Posted By:satyapriyanayak       Posted Date: January 13, 2015    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

In this Code Snippets we will know how to Connect Msaccess 2007 in asp.net

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Msaccess_in_asp.net_Connect._Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
    <form id="form1" runat="server">
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView><br />
        <asp:Button ID="btn_show" runat="server" Text="Show Records"
            onclick="btn_show_Click" />

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
namespace Msaccess_in_asp.net_Connect
    public partial class _Default : System.Web.UI.Page
        OleDbConnection con;
        OleDbCommand com;
        OleDbDataAdapter oledbda;
        DataSet ds;
        string str;

        protected void btn_show_Click(object sender, EventArgs e)
            con = new OleDbConnection();
            con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data source=" + Server.MapPath("Bin/mydb.accdb") + "";
            //con.ConnectionString = @"Provider = Microsoft.Jet.OLEDB.4.0;" + @"Data source=" + Server.MapPath("Bin/mydb.mdb") + "";
            str = "select * from students";
            com = new OleDbCommand(str, con);
            oledbda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oledbda.Fill(ds, "students");
            GridView1.DataMember = "students";
            GridView1.DataSource = ds;


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend