scropio gurl

scropio gurl

  • NA
  • 147
  • 99.5k

Data continuously inserted in table

Jul 2 2016 12:46 AM

I try to send data in table when time exceed over 5 mint data is inserted successfully but data insert multiple times i want to submit data only one time
i.e. only one row insert for 1 number

this is what i try

if (timediff.TotalMinutes > 5)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var u = db.tbl_urgent_contacts;
foreach (var a in u)
{
tbl_OutBox tb = new tbl_OutBox();
tb.FromSIM_No = a.SimNo;
tb.ToSIM_No = a.SimNo;
tb.ToText = "Check abc";
tb.Reply = "NA";
tb.Response = "NA";
tb.RegNo = "NA";
tb.Datetd = DateTime.Now;
tb.FFID = "NA";
tb.UserId = "You";
tb.FromText = "Check abc";
db.tbl_OutBoxes.InsertOnSubmit(tb);
db.SubmitChanges();
}
}


Answers (3)