Call stored procedure in VB.net : VB.net : Procedure Function SQL / MySQL

SQL / MySQL » Procedure Function » VB.net »

 

Call stored procedure in VB.net


 
Dim myConnectionString As String = "Database=" & myDatabase & _
     " ;Data Source=" & myHost & _
     ";User Id=" & myUserId & ";Password=" & myPassword

Dim myConnection As New MySqlConnection(myConnectionString)

Try
    myConnection.Open()
Catch MyException As MySqlException
    Console.WriteLine("Connection error: MySQL code: " & MyException.Number & _
                      " " + MyException.Message)
End Try

Try

    Dim myCommand As New MySqlCommand("call error_test_proc(1)")
    myCommand.Connection = myConnection
    myCommand.ExecuteNonQuery()

Catch MyException As MySqlException
    Console.WriteLine("Stored procedure error: MySQL code: " & _
            MyException.Number & "  " & _
            MyException.Message)
End Try

*/

        



Leave a Comment / Note


Vérification Refresh
  
Enter code
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

Navioo Procedure Function
» VB.net
Backup LoadBackup Load
Command MySQLCommand MySQL
CursorCursor
Data TypeData Type
DatabaseDatabase
Date TimeDate Time
Flow ControlFlow Control
FunctionFunction
Insert Delete UpdateInsert Delete Update
JoinJoin
KeyKey
MathMath
Procedure FunctionProcedure Function
Select ClauseSelect Clause
StringString
Table IndexTable Index
TransactionTransaction
TriggerTrigger
User PermissionUser Permission
ViewView
Where ClauseWhere Clause