Rowupdating in asp net c
Now, create a class named Person BAL3 into App_Code folder by right clicking it and write respective methods for calling Insert, Delete, Update and Load methods of Data Access Layer class file (Person DAL3) (In my case I have a 3-Tier folder inside App_Code folder, you can directly add inside App_Code or you can create a separate project for BAL and add reference of this project into your Presentation Layer). In the above method, I am instantiating Person BAL3 and calling the Update method by p[assing required parameters. I am not goint into details of how I am connecting database and manipulating the data just to make this tutorials short. Code to Update records Above method will fire when Update link will be clicked for a particular row of the Grid View in edit mode.For this demo application, I have taken a very simple example. 1) Fix for the code block For the css 'pre', add new property 'min-width: 730px;' and add width nn percentage.
Here, I have assumed that you will create the respective stored procedure yourself into the database or you may download attachment from using System; using System. In this case definitely the passing number of variable will not be good idea.
As we don't have any business logic here so simply instantiate the Person DAL3 class of DAL and call methods. Now we have all set to go, now just run your project and try inserting records.
I have separate method for inserting, deleting, updating records into database and loading records from database. In the above code, I am instantiating Person BAL3 and calling Delete method by passing person ID as parameter so that select reocrds will be deleted from datbase.
Sql Client; /// In the above code, I have a member variable called conn Str that is getting database connection string from my web.config file that is being used through out the class. Code for Grid View Data Key Names="Person ID" Auto Generate Edit Button="True" Auto Generate Columns="False" On Row Editing="Edit Record" On Row Updating="Update Record" On Row Canceling Edit="Cancel Record" On Row Deleting="Delete Record" Page Size="5" Above method will fire when Delete link will be clicked on the Grid View.
Download source code for 3-Tier Architecture in ASP. Seperation - the functionality is seperated from the data access and presentation so that it is more maintainable 2.