string m_TotalSoldStr=Convert.ToString(table.DefaultView[i][7]);
 if(m_TotalSoldStr.Length >4)
 {
  m_TotalSoldStr=m_TotalSoldStr.Substring(0,4);
 }
  int m_TotalSold;
  if(m_TotalSoldStr=="")
  {
   m_TotalSold=0;
  }
  else
  {
   m_TotalSold=Convert.ToInt32(m_TotalSoldStr);
  }

  string m_RebateReserveStr=Convert.ToString(table.DefaultView[i][8]);
  if(m_RebateReserveStr.Length>9)
  {
   m_RebateReserveStr=m_RebateReserveStr.Substring(0,9);
  }
  decimal m_RebateReserve;
  if(m_RebateReserveStr=="")
  {
          m_RebateReserve=0;
  }
  else
  {
   m_RebateReserve=Convert.ToDecimal(m_RebateReserveStr);
         
  }

  string m_RedeemedStr=Convert.ToString(table.DefaultView[i][17]);
  if(m_RedeemedStr.Length >8)
  {
   m_RedeemedStr=m_RedeemedStr.Substring(0,8);
  }
  decimal m_Redeemed;
  if(m_RedeemedStr=="")
  {
   m_Redeemed=0;
  }
  else
  {
   m_Redeemed=Convert.ToDecimal(m_RedeemedStr);
  }
  string m_PromoItem=Convert.ToString(table.DefaultView[i][23]);
  if(m_PromoItem.Length >50)
  {
   m_PromoItem=m_PromoItem.Substring(0,50);
  }

  DateTime m_InDate;
  m_InDate=DateTime.Now;
      
  string m_sqlMaster="INSERT INTO act.dbo.Newegg_GMailRebate(PromoCode,PromoItem,RebateAmount,ItemDescription,BeginPromoPeriodDate,
EndPromoPeriodEndDate,PostMaskDate,TotalSold,RebateReserve,Redeemed,InDate)VALUES(’"+m_PromoCode+"’,’"+m_PromoItem+"’,’"+m_RebateAmount+"’,
’"+m_ItemDescription+"’,’"+m_BeginPromoPeriodDate+"’,’"+m_EndPromoPeriodEndDate+"’,
’"+m_InDate+"’,’"+m_TotalSold+"’,’"+m_RebateReserve+"’,’"+m_Redeemed+"’,’"+m_InDate+"’)";
  comm=new SqlCommand(m_sqlMaster,con);
  comm.Transaction =tran;
  comm.ExecuteNonQuery ();
  comm.Dispose();
     
  }
     
    
  for(int i=1;i<table.Rows.Count;i++)
  {
     
   string m_PromoCode=Convert.ToString(table.Rows[i][0]);
   if(m_PromoCode=="")
   {