title: calling mysql storedprocedure from c#?
body: <p>im trying to call a mysql stored procedure from my c# application , the procedure has 3 parameters which im passing dynamically, the problem is im not error nor the output, just im getting empty datatable </p>
  
  <pre><code> MySqlConnection con = new MySqlConnection(myConnectionString);
   con.Open();
   MySqlCommand cmd = new MySqlCommand("User_details", con);
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.Parameters.AddWithValue("username", "aditya");
  cmd.Parameters.AddWithValue("password", "123");
  cmd.Parameters.AddWithValue("gender", "male");
   MySqlDataAdapter da= new MySqlDataAdapter(cmd);
   DataTable dt = new DataTable();
   da.Fill(dt);
   dataGridView2.DataSource = dt; 
  </code></pre>