Linq Queries
-
Actually I am very new to Linq. But I have a project where I have to use linq to entities. I have a Gridview in my aspx page and I have a table named Address with 6 columns. I have to bound this Gridview with data from table and I have to delete, update and insert new records using linq quiereies. How can I do that. I really appreciate that. Regards,
-
Actually I am very new to Linq. But I have a project where I have to use linq to entities. I have a Gridview in my aspx page and I have a table named Address with 6 columns. I have to bound this Gridview with data from table and I have to delete, update and insert new records using linq quiereies. How can I do that. I really appreciate that. Regards,
//you have to create a DataClasses1.dbml and drag and drop ur tables and proceed //these are methods and you have to pass the values. public static void insert(int id, string name, string address, string department, string gender, int phone) { // DataClasses1.dbml name DataClasses1DataContext da = new DataClasses1DataContext(); //table name linq_padhu_emp data = new linq_padhu_emp { id = id, name = name, address = address, department = department, gender = gender, phone = phone }; da.linq_padhu_emps.InsertOnSubmit(data); da.SubmitChanges(); } public static void update(int id, string name, string address, string department, string gender, int phone) { DataClasses1DataContext up = new DataClasses1DataContext(); linq_padhu_emp updating = up.linq_padhu_emps.First(P => P.id == id); updating.name = name; updating.address = address; updating.department = department; updating.gender = gender; updating.phone = phone; up.SubmitChanges(); } public static void delete(int id) { DataClasses1DataContext del = new DataClasses1DataContext(); linq_padhu_emp deleting = del.linq_padhu_emps.First(P => P.id == id); del.linq_padhu_emps.DeleteOnSubmit(deleting); del.SubmitChanges(); }
Padmanabhan