mysql output parameters
-
Hi, Mikey just sorted out my first problem, the next one is this. In my stored procedure in sqlserver i used OUTPUT Parameters, im not sure i can do this in MYSQL as im not using stored procedure; this is my code; ' the connection string myconnection = New MySqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) ' the query strSQL = "SELECT ?SubDesc=SubDesc, ?SubName=SubCatName FROM SubCategory WHERE SubcatID = ?SubID;" mycommand = New MySqlCommand(strSQL, myconnection) ' Input Parameter Dim parameterSubID As MySqlParameter = New MySqlParameter("?SubID", SubCatID) mycommand.Parameters.Add(parameterSubID) ' Output Parameter Dim parameterSubCatDesc As MySqlParameter = New MySqlParameter("?SubDesc", MySqlDbType.String, 500) parameterSubCatDesc.Direction = ParameterDirection.Output mycommand.Parameters.Add(parameterSubCatDesc) Dim parameterSubName As MySqlParameter = New MySqlParameter("?SubName", MySqlDbType.String, 50) parameterSubName.Direction = ParameterDirection.Output mycommand.Parameters.Add(parameterSubName) ' execute read myconnection.Open() mycommand.ExecuteNonQuery() myconnection.Close() Label1.Text = CStr(parameterSubCatDesc.Value) Label2.Text = CStr(parameterSubName.Value) I dont know if anyone can help me on this? Mike what about this one! Cheers Jetset
-
Hi, Mikey just sorted out my first problem, the next one is this. In my stored procedure in sqlserver i used OUTPUT Parameters, im not sure i can do this in MYSQL as im not using stored procedure; this is my code; ' the connection string myconnection = New MySqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) ' the query strSQL = "SELECT ?SubDesc=SubDesc, ?SubName=SubCatName FROM SubCategory WHERE SubcatID = ?SubID;" mycommand = New MySqlCommand(strSQL, myconnection) ' Input Parameter Dim parameterSubID As MySqlParameter = New MySqlParameter("?SubID", SubCatID) mycommand.Parameters.Add(parameterSubID) ' Output Parameter Dim parameterSubCatDesc As MySqlParameter = New MySqlParameter("?SubDesc", MySqlDbType.String, 500) parameterSubCatDesc.Direction = ParameterDirection.Output mycommand.Parameters.Add(parameterSubCatDesc) Dim parameterSubName As MySqlParameter = New MySqlParameter("?SubName", MySqlDbType.String, 50) parameterSubName.Direction = ParameterDirection.Output mycommand.Parameters.Add(parameterSubName) ' execute read myconnection.Open() mycommand.ExecuteNonQuery() myconnection.Close() Label1.Text = CStr(parameterSubCatDesc.Value) Label2.Text = CStr(parameterSubName.Value) I dont know if anyone can help me on this? Mike what about this one! Cheers Jetset