Partial Class forget_password
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim securityDr As Data.SqlClient.SqlDataReader
        Dim securityConn As Data.SqlClient.SqlConnection
        Dim securityCmd As Data.SqlClient.SqlCommand
        Dim strUsername As String = TextBox1.Text
        Dim strPassword As String = TextBox2.Text
        Dim Conn As String = "Data Source=r-shiya;Initial Catalog=sportstore;Integrated Security=True"
        Dim SQL As String = "SELECT username FROM userpass WHERE username = '"
        SQL += strUsername & "' or email = '" & strPassword & "'"
        securityConn = New Data.SqlClient.SqlConnection(Conn)
        securityCmd = New Data.SqlClient.SqlCommand(SQL, securityConn)
        securityConn.Open()

        securityDr = securityCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

        If securityDr.Read() Then
            securityDr.Close()
            DetailsView1.DataBind()
          
        Else
            securityDr.Close()
            MsgBox("دوباره شناسه و آدرس ایمیل خود را وارد کنید", MsgBoxStyle.OkOnly, "sport store")


        End If
    End Sub

   
   
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub
End Class