Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
I have a problem with connecting the MS access database with ASP.net web application in Vb language. I'm using the Visual Studio 2010 and MS access 2010.If you know the correct coding and the way of connection, and add data to the database with text box, please reply.
Thanks.
Posted 17-Jan-11 1:44am
Edited 17-Jan-11 2:16am
v4
Comments
[raju.m][makhaai] at 17-Jan-11 6:57am
   
google your question you will get number of answers. if you need connection string go to http://www.connectionstrings.com/
   
I changed your tags because many of them were redundant - If it's asp.net involving hooking up a database, the tag "winforms", web development", and "visual studio" are not necessary.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hi,
 

Here is complete working code
 
 string ConnectString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("db\\database.mdb;");
        OleDbConnection objCon;
        OleDbCommand objCmd;
        DataSet Ds = new DataSet();
 
        string GetSql = string.Empty;
        GetSql = "(SELECT * FROM table)";
        using (objCon = new OleDbConnection(ConnectString))
        {
            using (objCmd = new OleDbCommand(GetSql, objCon))
            {
                OleDbDataAdapter Da = new OleDbDataAdapter(objCmd);
                Da.Fill(Ds);
            }
        }
 
You have to just convert it into vb.net.
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load
dim dbconn
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("northwind.mdb"))
dbconn.Open()
end sub
</script>
  Permalink  
Comments
SMRITI1231 at 13-Jul-13 10:25am
   
Is working with asp.net with Access at background advisable or are there better database options
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Googled the phrase "asp.net ms-access database", and among the 6.5 MILLION hits returned by google:
 
http://www.aspfree.com/c/a/Microsoft-Access/Connecting-to-a-Microsoft-Access-database-with-ASPNET/[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 17 Jan 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100