Advertisement
Guest User

Untitled

a guest
Apr 28th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. Private Function runQuery(ByVal query As String) As MySqlDataReader
  2.  
  3. Dim oConn As MySqlConnection
  4.  
  5. ' Connecting with SQL server
  6. Try
  7. Dim sConnStr As String = String.Format("Server=" & My.Settings.emsServerHost & ";User=" & My.Settings.emsID & "; Password=" & My.Settings.emsPwd & "; Database=" & My.Settings.emsDB & "; Pooling=false;CharSet=utf8") '
  8. oConn = New MySqlConnection(sConnStr)
  9. oConn.Open()
  10. Dim cmd As MySqlCommand = New MySqlCommand(query, oConn)
  11. runQuery = cmd.ExecuteReader()
  12. oConn.Close()
  13. return runQuery
  14. Catch ex As Exception
  15. MsgBox(ex.Message, MsgBoxStyle.OkOnly + MsgBoxStyle.Critical, "Error!")
  16. End Try
  17. Return Nothing
  18. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement