[Help]SQL Sever with FTP [Solved]

I'm messing with ftp in visual basic, I got it working good but now I want to be-able to have it read a sql database (that online) which contains user passwords, if one of those passwords are entered then it allows them to upload, if its a wrong password then error message box shows (which I can do that part...).

How would I set that up? I already have the sql sever online and working...just need to connect it to the program and have it check the passwords when the button is clicked. All of which has to be done securely as possible

.

Right now I got:

Code:

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
        If TextBox12.Text = "Username" And TextBox11.Text = "Password" Then
            Dim request As System.Net.FtpWebRequest = DirectCast(System.Net.WebRequest.Create("ftp://ftp.site.org/path" & IO.Path.GetFileName(TextBox10.Text)), System.Net.FtpWebRequest)
            request.Credentials = New System.Net.NetworkCredential(TextBox12.Text, TextBox11.Text)
            request.Method = System.Net.WebRequestMethods.Ftp.UploadFile

            Dim file() As Byte = System.IO.File.ReadAllBytes(TextBox10.Text)

            Dim strz As System.IO.Stream = request.GetRequestStream()
            strz.Write(file, 0, file.Length)
            strz.Close()
            strz.Dispose()
            Label9.Visible = True
        Else
            MsgBox("Incorrect Username, Password, or File path not set!", MsgBoxStyle.Critical)
        End If
    End Sub

+rep +1 thanks

[Help]SQL Sever with FTP [Solved]

Post a Reply

Tags for this Thread