Last post Sep 23, 2013 09:20 PM by oned_gk
Sep 23, 2013 03:46 PM|kpatrick189|LINK
I am new to ASP.net but have some programming experience in VB.net with Visual Studio 2010. What i am trying to do is load 5 fields into an access table when the user clicks a button. We want to create a Web Application that we can put on our intranet
so any user can open up and enter a Maintenance Request. I have searched numerous different websites and found a way to get the page to load but when I click the Button, the screen flickers like something happened but I have no idea where or even if I have
the connection set correctly.
My VB.net programming experience does not include setting up a connection string.
So with that being said, here is where I am at:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim concoaxis As SqlConnection
Dim strInsert As String
Dim cmdInsert As SqlCommand
Dim dtmDate As DateTime
dtmDate = DateTime.Now()
concoaxis = New SqlConnection("Data Source=\\hiwts03\Files\Functional-Maintenance\01_Overall Equipment Effectiveness (OEE);Database=BMS_22.214.171.124_PreventiveMaintenance1.mdb")
'concoaxis = New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("BMS_126.96.36.199_PreventiveMaintenance1ConnectionString").ConnectionString)
strInsert = "INSERT INTO List (RequestorName) Values (@Requestor)"
cmdInsert = New SqlCommand(strInsert, concoaxis)
Response.Write("Updated Successfully!<p> </p><p> </p><p> </p>")
Currently my code is only trying to Insert one field and once I figured it out I was going to add the remaining 4.
Any suggestions or directions?
Thanks is Advance
Sep 23, 2013 04:06 PM|MetalAsp.Net|LINK
This page should help:
Also, as far as the connection string goes, you can refer to this:
Sep 23, 2013 09:20 PM|oned_gk|LINK
Use local file instead of Network shared, use oledb 4 provider