Execute stored procedure in mysql database
Posted on 2016-09-07
I have setup a mysql database that successfully connects and populates datagrids in my VS2015-c# application under development.
I have created a stored procedure:
CREATE DEFINER=`glsinger684`@`%` PROCEDURE `create_co_record`(IN `PrincipalID` VARCHAR(50))
SQL SECURITY DEFINER
COMMENT 'Creates new company record with PrincipalID'
insert into company_info (PrincipalID)
I can successfully execute the stored procedure from a query using the management utility.
Next to test from my asp.net app I have the following code linked to a button:
protected void btnAddCo_Click(object sender, EventArgs e)
string conn = "server=mysqlcluster8.registeredsite.com;user id=glsinger684;persistsecurityinfo=True;password=<mypassword>;database=estimating";
MySqlConnection sql_conn = new MySqlConnection(conn);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = sql_conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CALL create_co_record (PrincipalID)";
cmd.Parameters["PrincipalID"].Direction = ParameterDirection.Input;
When I run the app and hit the button nothing appears to happen. I get no errors, but the desired effect of the SP does not occur. Since the datagrids populate I don't see why this would be a permissions issue, but in any event any research on granting permissions that I have tried does not work.
Any suggestions would be much appreciated.