Here is my code:

Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click

        Dim user As String

        Dim response As String

        Dim msg As String

        Dim myconnection As SqlClient.SqlConnection = New SqlClient.SqlConnection

        myconnection.ConnectionString = "Data Source=WJEVIS;database=WJEVISION;User ID=xx;Password=xxx"

        myconnection.Open()

        Dim comSQL As SqlClient.SqlCommand = New SqlClient.SqlCommand



        'Add code to set CommandText and Connection properties of the command

        'If (txtLogin.Text = "" Or txtLogin.Text = "Please enter something.") Then

        ' txtLogin.Text = "Please enter a valid Login."

        ' Return

        'End If



        comSQL.CommandText = "select username,password from seuser where username = '" & txtLogin.Text & "'"

        comSQL.CommandText = "select * from seuser where username = '" & txtLogin.Text & "'"

        comSQL.Connection = myconnection





        Dim readerSQL As SqlClient.SqlDataReader

        'Add code to execute the command

        readerSQL = comSQL.ExecuteReader()

        user = txtLogin.Text





        'Add code to loop through the records, add each to the listbox

        If readerSQL.HasRows Then

            Do While readerSQL.Read

                'Display in list box

                'lstUsers.Items.Add(readerSQL.Item("username").ToS tring) '& " " & readerSQL.Item("LastName").ToString)

                Dim file As New System.IO.StreamWriter("C:\test.txt", True)

                file.WriteLine("Here is the first line." & " " & user)

                file.Close()

                Server.Transfer("Webform1.aspx")

            Loop

        Else

            Page.RegisterStartupScript("MyScript", _

            "<script language=javascript>" & _

   "function AlertHello() { alert('Please enter the correct username'); }</script>")



            btnLogin.Attributes("onclick") = "AlertHello()"

            txtLogin.Text = ""

            Return



        End If


Renee C. Walker

__________________
Renee C. Walker

as i mean from your words:
i don't think that you could generate online Alerts after checking for any errors in code behind , the code behind only generate the page with it's client scripts and displayed on client side.

if you want this client code to work each time you have to put is at page load event,

note: you can use validators controls to work as client check and also you could use in code behind.

Ahmed Ali
Software Developer

Okay, thanks.

Renee C. Walker

I agree with alyeng2000 to use Validation Controls.

in order to run JavaScript Alert from ur Code BehindePage:
Always:),
Hovik Melkomian.

Renee,

You're almost entirely correct with what you have. The only problem is with that attribute assignment and the javascript function. You don't need either...try this:

Page.RegisterStartupScript("MyScript", _
    "<script language=javascript>" & _
    "alert('Please enter the correct username');</script>")


Peter
------------------------------------------------------
Work smarter, not harder.

Hi Peter,

I changed my code and it's still working the same way. When I enter the wrong username the first time it does not display the alert. If I enter a wrong username the second time, it does display the alert. But, when I enter the correct username after that, it displays the alert again, but execute the correct procedure after that.

Renee C. Walker

That doesn't make sense. You have the alert in the right place. From what you have up there, I can't see why you would get this problem.

Peter
------------------------------------------------------
Work smarter, not harder.

Okay, Thanks.

Renee C. Walker