Tuesday, February 23, 2016

Insert Update & Delete using LINQ to SQL

DBClassesDataContext db = new DBClassesDataContext();
            Table tblContact = new Table();

            tblContact.FirstName = txtFN.Text;
            tblContact.LastName = txtLN.Text;

            db.Tables.InsertOnSubmit(tblContact);
            db.SubmitChanges();
response.redirect("default.aspx");


====================================

CREATE TABLE Persons
(
ID int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (ID)
)

===================

https://www.youtube.com/watch?v=B9GEcteOLkg&ebc=ANyPxKpkDV8Zq4bfePA54iWmeVSLuK3OK12F98G78bDI070N2KUpKkHksahXis2BfQKH6RoNuyl7YKr6Koph5FAfbTSykUBbJg

No comments: