public partial class triggers
{
     [Microsoft.SqlServer.Server.SqlTrigger(Name = "SyncInsert", Target = "TestRemoteExec", Event = "After Insert")]
     public static void SyncInsert()
     {
          using (SqlConnection conn = new SqlConnection("context          connection=true"))
          {
               conn.Open();
               sqlCommand sqlComm = new SqlCommand();
               sqlComm.Connection = conn;
               sqlComm.CommandText = "SELECT * FROM INSERTED";
               DataSet ds = new DataSet();
               SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM INSERTED",conn);
               da.Fill(ds,"INSERTED");
               foreach(DataRow drIns in ds.Tables["INSERTED"].Rows)
               {
                    field1 = drIns["Field1"].ToString().Trim();
                    field2 = drIns["Field2"].ToString().Trim();
               }
               for(int i=0; i<50; i++)
               {
                    sqlComm.CommandText = "SELECT * FROM TBL WHERE                ID="+i
                    da.SelectCommand = sqlComm;
                    da.Fill(ds,"GROUP");
                    foreach(DataRow drGroup in ds.Tables["GROUP"].Rows)
                    {
                         sqlComm.CommandText = "SELECT * FROM TBLACCT WHERE ID="+drGroup["ID"].ToString().TRIM();
                         da.SelectCommand = sqlComm;
                         da.Fill(ds,"ACCT");
                         foreach(DataRow drAcct in ds.Tables["ACCT"].Rows)
                         {
                              //Do some validations/math/configurations.
                         }
                    }
               }
          }
     }