how to connect asp.net with MS-access and also how to pass data to

Jack · Sep 14, 2006

hI,

Anyone here know how to connect asp.net with MS-access and also how to pass
data to a table?

The following is the code which I have but unfortunately its not working..
Public Connectionstring As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
C:\Inetpub\wwwroot\Dee\ASPdotnet\currt.mdb;Persist Security Info=False;"
Public con As New OleDbConnection(Connectionstring)

Dim strSelect As String
strSelect = "Insert Into UserDetails1 (Username) Values
(@DetailsUser)"
Dim cmd As New OleDbCommand(strSelect, con)
Dim added As Integer
cmd.Parameters.Add("@DetailsUser", txtUserDetails.Text)

Try
con.Open()
cmd.ExecuteNonQuery()
Response.Write("Updated Successfully!<p> </p><p> </p><p> </p>")

con.Close()
Response.Write("Updated Successfully!<p> </p><p> </p><p> </p>")
Catch
con.Close()
End Try

Thanks in advance
Jack

Ken Cox [Microsoft MVP] · Sep 18, 2006

Hi Jack,

Here's some code that seems to do what you want.

Let us know if it helps?

Ken
Microsoft MVP [ASP.NET]

<%@ Page Language="VB" %>

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

<script runat="server">

Protected Sub Button1_Click _
(ByVal sender As Object, ByVal e As System.EventArgs)
Dim Connectionstring As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & _
"C:\ASPNETWeb\App_Data\currt.mdb;Persist Security Info=False;"
Dim con As New Data.OleDb.OleDbConnection _
(Connectionstring)

Dim strSelect As String
strSelect = "Insert Into UserDetails1 (Username) Values " & _
"(@DetailsUser)"
Dim cmd As New Data.OleDb.OleDbCommand(strSelect, con)
Dim pms As Data.OleDb.OleDbParameterCollection
pms = cmd.Parameters
pms.Add("@DetailsUser", Data.OleDb.OleDbType.VarChar, 50)
pms("@DetailsUser").Value = Server.HtmlEncode(txtUserDetails.Text)
Try
con.Open()
cmd.ExecuteNonQuery()
Response.Write _
("Updated Successfully!<p> </p><p> </p><p> </p>")
Catch exc As Exception
Response.Write("Problem: " & exc.Message & _
"<p> </p><p> </p><p> </p>")
Finally
con.Close()
End Try
End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Insert into Access Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:textbox id="txtUserDetails" runat="server"></asp:textbox><br />
<br />
<asp:button id="Button1" runat="server" onclick="Button1_Click"
text="Insert" /> </div>

</form>
</body>
</html>

Operation must use an updateable query. (Urgent)	0	Jun 1, 2009
How to connect to Excel ?	3	Nov 6, 2005
Prevent duplicate entry to MS Access database	0	Feb 8, 2006
inserting into MS access using ASP.NET/VB	2	Oct 18, 2003
How to return value from Stored Procedure to label control?	0	Jan 15, 2009
Error Message could not find a non-generic method	6	Mar 26, 2008
Runtime error when trying to connect to an Access DB	2	Jan 30, 2007
how to use datareader with sqldatasource defined in aspx file?	4	Feb 6, 2007

how to connect asp.net with MS-access and also how to pass data to

Jack

Ken Cox [Microsoft MVP]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads