public static DataTable ExecuteQuery(
  string spName,
  params object[] args)
{
  using (SqlConnection conn =
         new SqlConnection(Global.ConnString))
  {
    using (SqlCommand command =
           new SqlCommand(spName, conn))
    {
      command.CommandType = CommandType.StoredProcedure;
      for (int i=0; i<args.Length-1; i+=2)
      {
        command.Parameters.Add(
          args[i].ToString(), args[i+1]);
      }
      using (SqlDataAdapter adapter =
             new SqlDataAdapter(command))
      {
        DataTable table = new DataTable();
        adapter.Fill(table);
        return table;
      }
    }
  }
}