Create Mysql Stored Procedure using in vb .NET
How do I create a stored procedure for mysql using VB .NET programmatically?
EDIT:
Apologize to be so brief. I have tried using ExecuteNonQuery provided by MySQL .NET Connector. It prompts me error. Maybe it's because I put "Delimiter $$"?
I know I can create using script (batch file) if I want to send it to my client (as commented below). But my objective is to keep MySQL password safe. So script开发者_如何学C is not the way.
- Connect to the database.
- Run the create procedure SQL command using ExecuteNonQuery
精彩评论