Updating dataset with gridview shaved head intimidating
STEP 6 : write code in Data Access Layer In above we have used Data Set method for sql connectivity.
Now, let’s create Business logic layer for use all data access method of user select, insert, update and delete.
I am working on a page to let a user import an excel file into our database.
I want to allow the user to manipulate certain fields before committing the information so I loaded a Data Set from the Excel file and bound that to a Grid View.
first import namespace using Data Layer; using System; using System.
Create new Data Set in Data Layer Class Library project and bind select and insert stored procedure in Data Set.Here we set ID column Primary Key and Auto Increment by updating the ID column property.After creating new table create new stored procedure for Insert records, Select records, Update and Delete records.After importing references create data layer class object in business logic layer class. write code in business layer for communicate data layer and presentation layer.