Insert methods in LINQ to SQL

Question

I need to insert Data but I have some error in project I use two table from Database and I use LINQ to SQL but I can't Insert Data I need Help!

agron sverka · Answer

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(); }

Sanjay Kumar · Answer

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

Sumit Jolly · Answer

can you please share code is there any error that's generated via Insert?