problem with connection to sql server

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jun 2005
Posts: 19
Reputation: fineline is an unknown quantity at this point 
Solved Threads: 0
fineline fineline is offline Offline
Newbie Poster

problem with connection to sql server

 
0
  #1
Jun 17th, 2005
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
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Solved Threads: 6
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: problem with connection to sql server

 
0
  #2
Jun 18th, 2005
Try something like this..
Dim cnn as Sqlconnection
cnn = New SqlConnection(ConfigurationSettings.AppSettings("cnnstr"))
Save White Tiger
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Solved Threads: 6
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: problem with connection to sql server

 
0
  #3
Jun 18th, 2005
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"))
Save White Tiger
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 19
Reputation: fineline is an unknown quantity at this point 
Solved Threads: 0
fineline fineline is offline Offline
Newbie Poster

Re: problem with connection to sql server

 
0
  #4
Jun 18th, 2005
Originally Posted by Letscode
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
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Solved Threads: 6
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: problem with connection to sql server

 
0
  #5
Jun 18th, 2005
Can you copy and paste the error code...
Save White Tiger
Reply With Quote Quick reply to this message  
Join Date: Feb 2005
Posts: 175
Reputation: Letscode is an unknown quantity at this point 
Solved Threads: 6
Letscode's Avatar
Letscode Letscode is offline Offline
Junior Poster

Re: problem with connection to sql server

 
0
  #6
Jun 18th, 2005
I need to know where exactly the error is being displayed....
Save White Tiger
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 19
Reputation: fineline is an unknown quantity at this point 
Solved Threads: 0
fineline fineline is offline Offline
Newbie Poster

Re: problem with connection to sql server

 
0
  #7
Jun 18th, 2005
Originally Posted by Letscode
I need to know where exactly the error is being displayed....

THANK YOU VERY MUCH AGAIN
NOW... ITS WORK
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC