Insert methods in LINQ to SQL

private void Insert_Data()
{
int nxnId = -1;

using (var db = new dbDataContext())
{
var query = new TblNxenesi() { Emri = txtEmri.Text, Mbiemri = txtMbiemri.Text };
db.TblNxenesis.InsertOnSubmit(query);
db.SubmitChanges();
nxnId = query.Nnr;

//DataTable dt = (DataTable)dgNxenesit.DataSource;
//foreach (DataRow row in dt.Rows)
foreach (DataRow row in dgNxenesit.Rows)
{
var query1 = new TblNota();

query1.Lenda = row["Lenda"].ToString();
query1.Nota = (int)row["Nota"];
query1.Nnr = nxnId;

db.TblNotas.InsertOnSubmit(query1);

}
db.SubmitChanges();

}

Hi

try this

http://www.c-sharpcorner.com/UploadFile/3d39b4/simple-select-insert-update-and-delete-using-linq-to-sql/


http://stackoverflow.com/questions/287594/insert-into-multiple-database-tables-using-linq-asp-net-mvc

using Transactionscope

http://stackoverflow.com/questions/15452565/insert-data-in-two-different-tables-on-insertonsubmit-using-linq-asp-net-c-sha