mySQL Problem with .NET

[rover_boy]

Hi i am tryin to write a login page in asp.net using c# i have created the following method which passes 3 parameters into mySQL database stored procedure but i am having problems extracting the ouptut value from the database and the server returns the following error Only MySqlParameter objects may be stored Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. the piece of code with the error is Line 65: connection.Close(); //Closes DB connection Line 66: Line 67: int valid = cmdString.Parameters.Add ("?p_valid"); Line 68: Line 69: //Builds .net mysql connection and passes connection string into method MySqlConnection connection = new MySqlConnection (connectionString); //Create mySql command string for passing query or SPROC(Stored Procedure) MySqlCommand cmdString = new MySqlCommand(); //Set Command to equal mySql connection,t so can pass SQL query cmdString.Connection = connection; //Set command string to equal SPROC cmdString.CommandText = "login"; cmdString.CommandType = CommandType.StoredProcedure; MySqlParameter param ; //Creats paramter to send to SPROC param = cmdString.Parameters.Add("?p_username", MySqlDbType.VarChar); //Sets parameter type to input parameter param.Direction = ParameterDirection.Input; //Sets parameter value to text box param.Value = txtUsername.Text; //Creats paramter to send to SPROC param = cmdString.Parameters.Add("?p_password", MySqlDbType.VarChar); //Sets parameter type to input parameter param.Direction = ParameterDirection.Input; //Sets parameter value to text box param.Value = txtPassword.Text; //Creates parameter to be passed into procedure param = cmdString.Parameters.Add("?p_valid", MySqlDbType.Int32); //Sets parameter direction to be equal to output param.Direction = ParameterDirection.Output; connection.Open(); //Opens DB connection cmdString.ExecuteNonQuery(); //Runs query connection.Close(); //Closes DB connection

[Paul Conrad]

Have you resolved this?

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon