Tuesday, October 9, 2018

Create Connection With Store Procedure with MySql in c#

MySqlConnection con = new MySqlConnection("server=YourServerName;port=3306;
database=yourdbname;uid=youruid;pwd=your PWD;");
string firstparanamevalue="Your Value";
string secondparanamevalue="Your Value";
MySqlCommand cmd1 = new MySqlCommand();
cmd1 = con.CreateCommand();
cmd1.CommandText = "YourProcedureName";
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("firstparaname", firstparanamevalue);
cmd1.Parameters.AddWithValue("secondparaname", secondparanamevalue);
con.Open();
cmd1.ExecuteNonQuery();
con.Close();


If Any Problem Please Comment.

No comments:

Post a Comment