SqlDataReader rdr = cmd.ExecuteReader();
                    if (rdr.HasRows)
                    {
                        while (rdr.Read())
                        {
                            if (rdr[0] != null)
                            {
                                PARAM1 = rdr[0].ToString();
                            }
                            if (rdr[1] != null)
                            {
                                PARAM2 = rdr[1].ToString();
                            }
                            if (rdr[2] != null)
                            {
                                PARAM3 = rdr[2].ToString();
                            }
                            if (rdr[3] != null)
                            {
                                PARAM4 = rdr[3].ToString();
                            }
                        }
                    }
                    rdr.Close();