public static DataSet GetDataSetQuery(string sql, ArrayList paramList, string name)
       {

           using (MySqlConnection conn = new MySqlConnection(getHostString(name)))
           {
               try
               {
                   conn.Open();
                   MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
                   da.SelectCommand.Parameters.Clear();
                   
                   if (paramList != null)
                   {
                       for (int i = 0; i < paramList.Count; i++)
                       {
                   
                           da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);
                       }
                   }

                   DataSet ds = new DataSet();
                   da.Fill(ds);
                   return ds;

               }
               finally
               {

                   conn.Close();
               }

           }
       }

csharp

1

dataset mysql

public static DataSet GetDataSetQuery(string sql, ArrayList paramList, string name)
       {

           using (MySqlConnection conn = new MySqlConnection(getHostString(name)))
           {
               try
               {
                   conn.Open();
                   MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
                   da.SelectCommand.Parameters.Clear();
                   
                   if (paramList != null)
                   {
                       for (int i = 0; i < paramList.Count; i++)
                       {
                   
                           da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);
                       }
                   }

                   DataSet ds = new DataSet();
                   da.Fill(ds);
                   return ds;

               }
               finally
               {

                   conn.Close();
               }

           }
       }

copy | embed

• c#, 
• data, 
• mysql