Mysqlparameter issue while mysql in aspl.net

Karthik K

Hi ,

I am new to mysql and i have created the stored procedure for insert the data into mysql database .When i am using the mysqlparameter its shows like :

I share the code , suggest me the solution for this ,

public int InsertCompanyMaster(PLCOMMON ObjPL)

{

try

{

MySqlParameter[] _param = {

//new MySqlParameter("@cm_id ",ObjPL.Comp_ID),

new MySqlParameter("cm_no ",ObjPL.Cm_no),

new MySqlParameter("cm_name,",ObjPL.Comp_Name),

new MySqlParameter("cm_address ",ObjPL.Comp_Address),

new MySqlParameter("cm_contactperson ",ObjPL.Comp_ContactPerson),

new MySqlParameter("cm_contactno ",ObjPL.Cm_ContacNumber),

new MySqlParameter("cm_email ",ObjPL.Cm_Email),

new MySqlParameter("cm_alias",ObjPL.Comp_Alias),

};

_INS = ObjMain.ExecuteProcedure("SP_CompanyMaster_Insert", _param);

}

catch (Exception ex)

{

throw ex;

}

return _INS;

}

Thanks in advance

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo7y ago
1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
6. using System.Data;
7. using MySql.Data;
8. using MySql.Data.MySqlClient;
10. namespace UsingStoredRoutines
11. {
12. class Program
13. {
14. static void Main(string[] args)
15. {
16. MySqlConnection conn = new MySqlConnection();
17. conn.ConnectionString = "server=localhost;user=root;database=employees;port=3306;password=******";
18. MySqlCommand cmd = new MySqlCommand();
20. try
21. {
22. Console.WriteLine("Connecting to MySQL...");
23. conn.Open();
24. cmd.Connection = conn;
25. cmd.CommandText = "DROP PROCEDURE IF EXISTS add_emp";
26. cmd.ExecuteNonQuery();
27. cmd.CommandText = "DROP TABLE IF EXISTS emp";
28. cmd.ExecuteNonQuery();
29. cmd.CommandText = "CREATE TABLE emp (empno INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), birthdate DATE)";
30. cmd.ExecuteNonQuery();
32. cmd.CommandText = "CREATE PROCEDURE add_emp(" +
33. "IN fname VARCHAR(20), IN lname VARCHAR(20), IN bday DATETIME, OUT empno INT)" +
34. "BEGIN INSERT INTO emp(first_name, last_name, birthdate) " +
35. "VALUES(fname, lname, DATE(bday)); SET empno = LAST_INSERT_ID(); END";
37. cmd.ExecuteNonQuery();
38. }
39. catch (MySqlException ex)
40. {
41. Console.WriteLine ("Error " + ex.Number + " has occurred: " + ex.Message);
42. }
43. conn.Close();
44. Console.WriteLine("Connection closed.");
45. try
46. {
47. Console.WriteLine("Connecting to MySQL...");
48. conn.Open();
49. cmd.Connection = conn;
51. cmd.CommandText = "add_emp";
52. cmd.CommandType = CommandType.StoredProcedure;
54. cmd.Parameters.AddWithValue("@lname", "Jones");
55. cmd.Parameters["@lname"].Direction = ParameterDirection.Input;
57. cmd.Parameters.AddWithValue("@fname", "Tom");
58. cmd.Parameters["@fname"].Direction = ParameterDirection.Input;
60. cmd.Parameters.AddWithValue("@bday", "1940-06-07");
61. cmd.Parameters["@bday"].Direction = ParameterDirection.Input;
63. cmd.Parameters.AddWithValue("@empno", MySqlDbType.Int32);
64. cmd.Parameters["@empno"].Direction = ParameterDirection.Output;
66. cmd.ExecuteNonQuery();
68. Console.WriteLine("Employee number: "+cmd.Parameters["@empno"].Value);
69. Console.WriteLine("Birthday: " + cmd.Parameters["@bday"].Value);
70. }
71. catch (MySql.Data.MySqlClient.MySqlException ex)
72. {
73. Console.WriteLine("Error " + ex.Number + " has occurred: " + ex.Message);
74. }
75. conn.Close();
76. Console.WriteLine("Done.");
77. }
78. }
79. }
0

Rajeesh Menoth7y ago

Hi,

You missed '@' symbol in the parameter. Please check the following example in the given reference article. Eg "@CustId"

Code :

private void GetCustomer(int customerId)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("Customers_GetCustomer", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CustId", customerId);
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}