Connection string for ASP.NET aplication (language=VB)Closed

Question

Hello, 
I have an SQL database located in the "APP_Data" folder of my ASP.net application (Language=VB). Please can someone help me with what the connection string should look like i have search and tried so many but no luck. I am using Microsoft visual studio 2012 and the ASP.net language i am doing the project in is "VB".
Thank you guys


Configuration: Windows / Firefox 28.0

ac3mark · Answer

Ok, hang in there.

Here is the connections strings:

<%
dbsource="\theserversetuff\wwwroot\someotherrootfolder\DATA\P1.mdb"
strServername = LCase(Request.ServerVariables("SERVER_NAME"))

Set conn = CreateObject("ADODB.CONNECTION")
set rsdev = CreateObject("ADODB.recordset")

strcxn="Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Data Source=" & dbsource & ";Persist Security Info=False"

conn.Open strcxn

'get the querystring into the DB
STRRSdate = "SELECT * FROM tbl_contacts;"

'here is the magic-
'RSDEV is the recordset the connections streams to
'STRRSdate is the query string
'CONN is the connection to the DB
'************************************
RSDEV.OPEN STRRSdate, CONN

AD=0
DO WHILE NOT RSDEV.EOF 'says keep doiing as long as the RSDEV has a record
RSDEV.MOVENEXT 'get the next record in the set
LOOP 'restart the loop
RSDEV.CLOSE 'ALWAYS CLOSE THE RECORDSET
SET RSDEV=NOTHING 'ALWAYS SET THE RECORDSET TO NOTHING OR MEMORY LEAK
conn.close ' ALWAY CLOSE THE DB CONNECTIONS FOR OTHER RESOURCES
set conn = nothing 'ALWAYS DESTROY YOUR CONNECTIONS
%>

 

I HOPE THIS HELPS!

Have FUN!

mikeoe2003 · Answer

Thanks alot ac3mack, this was really informative to me. I tried out a few things on my own and below is my code
CODE
========================
Imports System.Data
Imports System.Data.SqlClient
Public Class Registration_Form
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub btnSubmit_Click(sender As Object, e As EventArgs) Handles btnSubmit.Click
        Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
        Try

            Dim cmd As New SqlCommand("INSERT INTO Contacts (SurName,FirstName,Gender,Age,Email,Phone,Occupation,State_of_Residence,State_of_Origin,Date) VALUES (@Sname,@Fname,@Ggender,@Aage,@Eemail,@Pphone,@Ooccupation,@Rstate,@Ostate,@Ddate)", con)
            cmd.Parameters.AddWithValue("@Sname", txtSurname)
            cmd.Parameters.AddWithValue("@Fname", txtFirstname)
            cmd.Parameters.AddWithValue("@Ggender", txtGender)
            cmd.Parameters.AddWithValue("@Aage", txtAge)
            cmd.Parameters.AddWithValue("@Eemail", txtEmail)
            cmd.Parameters.AddWithValue("@Pphone", txtPhone)
            cmd.Parameters.AddWithValue("@Ooccupation", txtoccupation)
            cmd.Parameters.AddWithValue("@Rstate", txtResidence)
            cmd.Parameters.AddWithValue("@Ostate", txtOrigin)
            cmd.Parameters.AddWithValue("@Ddate", txtDate)
            con.Open()
            'Response.Write("Conection opened")
            cmd.ExecuteNonQuery()

        Catch ex As Exception
            con.Close()
        End Try
    End Sub

End Class
=========================================

The error message i get when i try to insert data into the DB is below:
ERROR message
=========================
Server Error in '/' Application.
No mapping exists from object type System.Web.UI.WebControls.TextBox to a known managed provider native type.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: No mapping exists from object type System.Web.UI.WebControls.TextBox to a known managed provider native type.

Source Error:


Line 23:             cmd.Parameters.AddWithValue("@Ostate", txtOrigin)
Line 24:             cmd.Parameters.AddWithValue("@Ddate", txtDate)
Line 25:             con.Open()
Line 26:             'Response.Write("Conection opened")
Line 27:             cmd.ExecuteNonQuery()


Source File: C:\Users\MIKE ONYENMA\Documents\NPA_Web_Proposal\UnitedTest1\UnitedTest1\Registration_Form.aspx.vb    Line: 25

ac3mark · Answer

You need to register a system DB in your server....


Have you done that?

I am here for a little more tonight, but nothing too heavy....

Connection string for ASP.NET aplication (language=VB)

3 responses

Similar discussions

Subscribe To Our Newsletter!