Login System cannot open?

Question

0.00/5 (No votes)

See more:

hello sir got a problem here. As you see last week everything works fine and im on the debugging mode. But my partner accidentally(>_<) change my work and now it has an error i havent encountered at all. Please help me
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
pointing at FoundUser = SearchUser.GetDataUser
my codes are as follows

VB

Partial Class HomeLogIn
    Inherits System.Web.UI.Page

    Protected Sub btnLogIn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogIn.Click
        Dim SearchUser As New DataSet1TableAdapters.tblUserTableAdapter
        Dim FoundUser As New DataSet1.tblUserDataTable

        FoundUser = SearchUser.GetDataUser
        Dim Found As Boolean = False
        Session("UserID") = ""
        For Each Srow As DataSet1.tblUserRow In FoundUser
            If txtUserID.Text = Srow.UserID And txtPassword.Text = Srow.PassID Then
                Found = True
                Session("UserID") = txtUserID.Text

                Response.Redirect("Home.aspx")
            End If
        Next

        If Not Found Then
            '            Image1.Visible = True
            lblUserID.Visible = True
            lblUserID.Text = "Incorrect UserID or Password"
            Session("UserID") = txtUserID.Text
        End If
        If Found Then
            'lblUserID.Text = "Matagumpay ka!"
        End If
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        lblDate1.Text = DateTime.Today.ToString("dd-MMM-yyyy")
        txtUserID.Focus()
    End Sub
End Class

Posted 16-Aug-11 14:45pm

janwel

Add a Solution

Comments

Chris Maunder 16-Aug-11 22:31pm

Show us the code for GetDataUser. That's where the error is. Have you checked your connection strings?

Dr.Walt Fair, PE 16-Aug-11 22:33pm

It sounds like you need to have a forceful heart-to-heart discussion with your partner ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Accepted Answer · 2011-08-16T15:25:00

janwel wrote:
But my partner accidentally(>_<) change my work and now it has an error…

So, before sorting out the problem with you SQL connection sort our the problem of owning your code. You're not really own it, because you can mess it up any minute. My advice is: stop doing what you're doing and start working under Revision Control System. It's easy, inexpensive it terms of required resource and free of charge (if you make a right decision and use Open Source system; don't risk your valuable code asserts by trusting a proprietary code: they support it today but tomorrow may disappear from the market).

See this discussion: Revision control systems, which to choose from?[^] in general and my solution in particular.

Good luck,

—SA