Posted on: 9/4/2012 3:41:30 AM | Views : 433

Hi,
I am retrieving data from My SQL data base but it is slow adding parameters please guide me how i can make it fast
Thanks in advance,
My code is this foreach is making it slow please guide how can i make it fast.

public static DataTable SelectStoredProcedure(string name, params MySqlParameter[] parameters)
{
  DataTable data = new DataTable();
  MySqlCommand cmd = new MySqlCommand(name, new MySqlConnection(connectinonString));
  cmd.CommandType = CommandType.StoredProcedure;
  if (parameters != null)
  {
    foreach (MySqlParameter param in parameters)
    {
      cmd.Parameters.Add(param);
    }
  }
  MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
  adapter.Fill(data);
  return data;
}

...

Go to the complete details ...