hi every one

i have a problem with my program
the problem is cant make a chek if the account is exist or not in the data base (for login the web site)
the error message is:
The ConnectionString property has not been initialized.

here is my code

Imports System.Data.SqlClient

Public Class home
Inherits System.Web.UI.Page


Dim cnn As New SqlConnection(ConfigurationSettings.AppSettings("cnnstr"))

Dim cmd As New SqlCommand


Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
cmd.Connection = cnn
End Sub


Private Sub regb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles regb.Click
Response.Redirect("register.aspx")
End Sub

Private Sub loginb_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles loginb.Click
If usern.Text.Trim.Length > 0 And pass.Text.Trim.Length > 0 Then
If found_Cust() = True Then
Session("CID") = usern.Text.Trim
Session("Flag") = 0
Response.Redirect("login.aspx")
Else
Wlbl.Text = "Incorrect User Name Or Password "
End If
Else
Wlbl.Text = "You Must Enter More Information"
End If
End Sub
Function found_Cust() As Boolean
cmd.CommandText = (" select count(*) from reg where username = '" & usern.Text.Trim & "' and Password = '" & pass.Text.Trim & "'")
cnn.Open()
If cmd.ExecuteScalar = 0 Then
cnn.Close()
Return False
Else
cnn.Close()
Return True
End If
End Function
End Class

and i write this statemernt in web conf.
<appSettings>
<add key="workstation" value="data source=shadid;
User ID=admin;initial catalog=sh;persist security info=False;packet size=4096"/>
</appSettings>

please tell me whats the problem

thank you

Recommended Answers

All 6 Replies

Try something like this..
Dim cnn as Sqlconnection
cnn = New SqlConnection(ConfigurationSettings.AppSettings("cnnstr"))

You got two things to keep in mind for Sqlconnection
1.Declare...Dim cnn as Sqlconnection
2.Initilize it..cnn = New SqlConnection(ConfigurationSettings.AppSettings("cnnstr"))

You got two things to keep in mind for Sqlconnection
1.Declare...Dim cnn as Sqlconnection
2.Initilize it..cnn = New SqlConnection(ConfigurationSettings.AppSettings("cnnstr"))

thank you Letscode but its also didnt work i dont whats the problem plz check the code again and tell me any another code is error or wrong

thank you again
iam waiting your message

Can you copy and paste the error code...

I need to know where exactly the error is being displayed....

I need to know where exactly the error is being displayed....

THANK YOU VERY MUCH AGAIN
NOW... ITS WORK

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.