Advertisement.

TransHimalaya.in

Everest Helicopter Tour for a day

Book exciting packages at www.transhimalaya.in

How to insert Form records in MS Access database using asp.net

First of all give full access permission to all database .mdb files by right click> properties> permissions

Make a function

Function insertRecord(ByVal mysql As String) As Boolean
Dim DBconn = New OleDb.OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "DATA SOURCE=" & Server.MapPath("") & "\database\circulars.mdb;")
Dim DBcmd As New OleDb.OleDbCommand(mysql, DBconn)
Try

DBcmd.Connection.Open()
DBcmd.ExecuteNonQuery()
DBcmd.Connection.Close()
insertRecord = True


Catch exc As Exception

DBcmd.Connection.Close()
Span1.InnerHtml = "Error: Unable To Submit Circular : Please Contact IT Dept
" & exc.Message()

insertRecord = False
End Try

End Function

You can call this function by getting data from Form like this at submit button click event.

Dim mysql As String = "Insert Into circulars ( cno, cdate,cdatetxt,vdate,sub,scope, name,dept, filename)" & _
"VALUES (" & _
"'" & Replace(txtCno.Text, "'", "''") & "', " & _
"'" & ddlDate.SelectedItem.Text & "-" & ddlMonth.SelectedItem.Text & "-" & ddlYear.SelectedItem.Text & "', " & _
"'" & ddlDate.SelectedItem.Text & "-" & ddlMonth.SelectedItem.Text & "-" & ddlYear.SelectedItem.Text & "', " & _
"'" & ddlVdate.SelectedItem.Value & "-" & ddlVmonth.SelectedItem.Value & "-" & ddlVyear.SelectedItem.Text & "', " & _
"'" & Replace(txtSub.Text, "'", "''") & "', " & _
"'" & Replace(Scope, "'", "''") & "', " & _
"'" & Replace(Session("ename"), "'", "''") & "', " & _
"'" & Replace(Session("dept"), "'", "''") & "', " & _
"'" & Replace(TheFile, "'", "''") & "') "
If insertRecord(mysql) = False Then
Span1.InnerHtml = "Unable to insert in to users " & mysql
Return
Else
txtCno.Text = ""
txtSub.Text = ""
End If

It will look like this

Comments

praveen said…
PRAVEEN::I tried many times but i didn't get any ip address as you said............Is there any other way to get it.....?????
If so please help me out to get it.

E-mail::pavi.praveen7@gmail.com
THE ONE said…
why do u need ip address in msaccess

Most Viewed Post

solution for facebook static.ak.fbcdn.net waiting

Connect Sony XPLOD MEX-BT2500 Bluetooth CD Receiver with ur mobile

Crystal Report : Show data horizontally (Left to right) i.e. columns as rows

Google+ Followers