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?

Insert methods in LINQ to SQL

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)