C#

ServiceInstaller si = new ServiceInstaller();<br />
si.ServicesDependedOn = new string[] { "DependingOnThisService" };<br />
this.Installers.Add(si);<br />

private DataTable GetDbUsers()<br />
        {<br />
            string spName = "sp_helplogins";<br />
            SqlConnection con = new SqlConnection(GlobalUtil.GetConnectionString());<br />
            SqlCommand cmd = new SqlCommand(spName, con);<br />
            SqlDataReader dr;<br />
            DataTable dtDbUsers = new DataTable();<br />
            cmd.CommandType = CommandType.StoredProcedure;<br />
            try<br />
            {<br />
                if (con.State == ConnectionState.Closed)<br />
                    con.Open();<br />
                dr = cmd.ExecuteReader();<br />
                dtDbUsers.Load(dr);<br />
                foreach (DataRow row in dtDbUsers.Rows)<br />
                {<br />
                    if (row["LoginName"].ToString() == "##MS_AgentSigningCertificate##")<br />
                        dtDbUsers.Rows.Remove(row); // error in this line<br />
                }<br />
                return dtDbUsers;<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                if (con.State == ConnectionState.Open)<br />
                    con.Close();<br />
                this.toolStripStatusLabel1.Text = ex.Message;<br />
                MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
                return null;<br />
            }<br />
            finally<br />
            {<br />
                if (con.State == ConnectionState.Open)<br />
                    con.Close();<br />
            }