In previous posts we have seen how to insert the data into data base using sql server in asp.net with c sharp. Now i will given an example to insert the multiple fields using LINQ in asp.net.Here i have used USING to maintain the scope of the patientinfo.
using (PatientInfo pf = new PatientInfo()) { t_patientDetails objpd =new t_patientDetails() objpd.Name = Name; objpd.Mobile = Mobile; objpd.OPNO = OPNO; objpd.Date = DateTime.Now; pf.t_patientDetails.InsertOnSubmit(objpd); pf.SubmitChanges(); }