title: Mysql stored procedure with two OUT parameters and c#
body: <p>I have a MySQL stored procedure with two OUT parameters as below.</p>
  
  <pre><code>CREATE `GetCourses`(out UG varchar(20),out PG varchar(20))
  BEGIN
   SELECT course_name into UG FROM test_db.courses where group_id=1;
   select course_name into PG from test_db.courses where group_id=2;
  END
  </code></pre>
  
  <p>Now in windows Form, I have two Comboboxes where first combo box should be bind with OUT variable UG and the other combobox should be bind with another OUT variable PG.</p>
  
  <p>How to achieve this using c#?</p>
  
  <p>Thanks in advance.</p>