Now run the application and select the file other than Excel which shows the following error as shown in the following: Now select the Excel file, which shows the following message after Suceessfully Uploaded: Now click on view files details.The gridview is shows uploaded files with details as shown below.The easiest way is to create your Grid View with some data source in ASP and call that data source in Row_Deletinng Event. Data Bind(); Ah, sorry, I was looking at Abdul Rahman code and there it was an SQL Data Source. Execute Non Query(); I know this is a late answer but still it would help someone in need of a solution.For example if you have Sql Data Source1 as your Grid View data source, your Row_Deleting event would be: When you call Gridview1. So then user913947, where do you save the list of items ? I recommend to use On Row Command for delete operation along with Data Key Names, keep On Row Deleting function to avoid exception.It is also important to provide visually pleasing and user friendly pages particularly when the page involves more user interaction for operations like creating, updating or deleting records in a database. NET Grid View with the simple and rich Twitter Bootstrap's Modal j Query plugin to implement a complete CRUD package in ASP. In this article, I am going to use a table in My Sql Database for demonstration purpose.To run the sample application provided in the above link, you have to create required table in My Sql database as explained below.har(50), Region varchar(50), Population bigint, Indep Year int); For your ease I am giving few insert statements with dummy values with which you can add a few rows in the table you have created instantly. Now let us proceed and add a Web Page to our Web forms application.
Now switch to design mode and double click on upload button and put the following code to validate the Only Excel files to be allowed to upload.
Then let us add an Update Panel with Gridview and add asynchronouspostback trigger for Grid View Row Command Event.
We are not going to use the default crud functionality that Grid View provides but going to achieve the same using Grid View Row Command Event just like how we displayed details in my previous article.
When a beginner joins a company or if there is a final round of interviews, known as a machine round, then most of the time the team leader gives the Candidate the first assignment to create an application which allows the end user to upload only Excel files and display it in a grid view and download it.
When I joined a company the same task was given to me by my team leader; instead I was expecting him to give me the task of inserting, updating and deleting in a grid view.
In practical scenario you should use your existing architecture to populate and update the data.