By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,902 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,902 IT Pros & Developers. It's quick & easy.

How to change this to a stored procedure in appliaction

P: 2
Hi I would like to make this more secure by running the sql command as a stored procedure any help appreciated

Expand|Select|Wrap|Line Numbers
  1. Dim Myadapter1 As New MySqlDataAdapter
  2.         Dim sqlquary1 = "SELECT * FROM mjbb_users WHERE username='" & UsernameTextBox.Text & "'AND password='" & RadTextBox2.Text & "';"
  3.         Dim command1 As New MySqlCommand
  4.         command1.Connection = MySqlConnection
  5.         command1.CommandText = sqlquary1
  6.         Myadapter1.SelectCommand = command1
  7.         Dim mydata1 As MySqlDataReader
  8.         Try
  9.             mydata1 = command1.ExecuteReader
  10.  
  11.             If mydata1.HasRows = 0 Then
I am using vb.net vs2013 and mySQL db

thanks
Mar 30 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.