-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Swimmy
Message 3 in Discussion
New Message on MumbaiUserGroup
Error in ASP.NET
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
Swimmy
Dear All, I am getting an error in ASP.NET as follows:
________________________________________________________________________________________________________________________________________________
Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'SOFTWARE\ASPNET'. Source Error:
Line 14: cmdInsert.CommandType = CommandType.Text
Line 15: cmdInsert.CommandText = "Insert into LoginDetails
(Name,Gender,Age,Address,Country,Zip,EMailId,TelephoneNo,MobileNo,UserName,Password)
values ('" & Name & "','" & Gender & "','" & Age & "','" & Address & "','" &
Country & "','" & Zip & "','" & EMailId & "','" & TelNo & "','" & MobileNo &
"','" & UserName & "','" & Password & "')"
Line 16: Conn.Open()
Line 17: cmdInsert.ExecuteNonQuery()
Line 18: Conn.Close()
Source File: f:\inetpub\wwwroot\WebApplication1\clsDataLayer.vb Line: 16
______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
The code in my datalayer is as follows: Dim Conn As New
SqlClient.SqlConnection Public Function fnConnectionString()
Conn.ConnectionString = "Data Source=Localhost;Initial
Catalog=IndiaOneNet;Integrated Security=SSPI" End Function Public
Function fnInsertPerson(ByVal Name, ByVal Gender, ByVal Age, ByVal Address,
ByVal Country, ByVal Zip, ByVal EMailId, ByVal TelNo, ByVal MobileNo, ByVal
UserName, ByVal Password) fnConnectionString()
Dim cmdInsert As New SqlClient.SqlCommand
cmdInsert.Connection = Conn
cmdInsert.CommandType = CommandType.Text
cmdInsert.CommandText = "Insert into LoginDetails
(Name,Gender,Age,Address,Country,Zip,EMailId,TelephoneNo,MobileNo,UserName,Password)
values ('" & Name & "','" & Gender & "','" & Age & "','" & Address & "','" &
Country & "','" & Zip & "','" & EMailId & "','" & TelNo & "','" & MobileNo &
"','" & UserName & "','" & Password & "')"
Conn.Open()
cmdInsert.ExecuteNonQuery()
Conn.Close() End Function
_______________________________________________________________________________________________________________________
Can anyone help me solve this error. Thanking you.
Sincerely,
swimmy.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
