mysql存储过程操作

                MySqlConnection conn = GetConn();

                MySqlDataAdapter cmd = new MySqlDataAdapter("pr_pager", conn);

                cmd.SelectCommand.CommandType = CommandType.StoredProcedure;

                cmd.SelectCommand.Parameters.Add(@"p_table_name", MySqlDbType.String);

                cmd.SelectCommand.Parameters.Add(@"p_fields", MySqlDbType.String);

                cmd.SelectCommand.Parameters.Add(@"p_order_string", MySqlDbType.String);

                cmd.SelectCommand.Parameters.Add(@"p_where_string", MySqlDbType.String);

                cmd.SelectCommand.Parameters.Add("p_out_rows", MySqlDbType.Int32);

                cmd.SelectCommand.Parameters["p_out_rows"].Direction = ParameterDirection.Output;

                cmd.SelectCommand.Parameters.Add("p_page_size", MySqlDbType.Int32);

                cmd.SelectCommand.Parameters.Add("p_page_now", MySqlDbType.Int32);

                cmd.SelectCommand.Parameters[@"p_table_name"].Value = tablename;

                cmd.SelectCommand.Parameters[@"p_fields"].Value = fields;

                cmd.SelectCommand.Parameters[@"p_order_string"].Value = order_string;

                cmd.SelectCommand.Parameters[@"p_where_string"].Value = where_string;

                cmd.SelectCommand.Parameters[@"p_page_size"].Value = pagesize;

                cmd.SelectCommand.Parameters[@"p_page_now"].Value = curr_page;

                DataSet ds = new DataSet();

                cmd.Fill(ds);

                conn.Close();

                conn.Dispose();

                return ds;