Public snipts » robin's snipts » 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();
                 }
  
             }
         }
  

  csharp

  1

  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

0 Comments