Remove a row from gridview but not from database in Asp.Net

Question

How to remove a row from gridview but not from database using asp.net..? Is there any solution please send me.....

Piyush Pansuriya · Answer

So in your select query sQuery = "SELECT A.UniqueId, A.RequestNo, A.AssessmentNo,CONVERT(VARCHAR(50),B.RequestDate,103) as 'RequestDate'," + " CONVERT(Varchar(50),A.AssignedDate,103)as 'AssignedDate', CONVERT(Varchar(50), A.CleanRequestDate, 103) as 'CleaningDate'," + " A.CleanRequestTime,A.VehicleNo,A.CleaningStatus, A.NumberofTrip,A.TripNo,A.CleaningReceiptNo,A.ImgExtension FROM DMS_CompletedCleaningRequest AS A" + " LEFT JOIN DMS_CleaningRequest AS B ON A.RequestNo = B.UniqueId WHERE A.District = '" + hfDistrict.Value.Trim() + "' AND" + " A.Panchayat = '" + hfPanchayat.Value.Trim() + "'"; You have to put condition in where clause, which returns records only not paid. You are inserting record in table while its get paid. so join that table with select query and put conditon in where clause.

Amit Kumar · Answer

Hi, You can do it many ways. First store your dataTalble or dataset in view state when you click on delete then fire OnRowDeleting event of gridview and get unique id and remvoe this id from viewstate and bind it on again gridview. protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int index = Convert.ToInt32(e.RowIndex); DataTable dt = ViewState["dt"] as DataTable; dt.Rows[index].Delete(); ViewState["dt"] = dt; BindGrid(); }

Piyush Pansuriya · Answer

Hi, Please go through the below link: https://www.c-sharpcorner.com/uploadfile/61b832/adding-bound-columns-to-gridview-in-Asp-Net/ Use only the columns which you need.

Piyush Pansuriya · Answer

Thanks buddy, Sure contact me when you need help. I am happy to help.

Sourav Kumar Das · Answer

I got solution.... SELECT A.UniqueId, A.RequestNo, A.AssessmentNo,CONVERT(VARCHAR(50),B.RequestDate,103) as 'RequestDate', CONVERT(Varchar(50),A.AssignedDate,103)as 'AssignedDate', CONVERT(Varchar(50), A.CleanRequestDate, 103) as 'CleaningDate', A.CleanRequestTime,A.VehicleNo,A.CleaningStatus, A.NumberofTrip,A.TripNo,A.CleaningReceiptNo,A.ImgExtension FROM DMS_CompletedCleaningRequest AS A LEFT JOIN DMS_CleaningRequest AS B ON A.RequestNo = B.UniqueId WHERE A.District = '" + hfDistrict.Value.Trim() + "' AND" + " A.Panchayat = '" + hfPanchayat.Value.Trim() + "' AND A.UniqueId NOT IN (SELECT RequestNo FROM DMS_PaymentDetails) Thanks for your hints and solution.....if there's any problem I will contact you... @Piyush Pansuriya

Sourav Kumar Das · Answer

This is the solution for removing a row from gridview but not in database ..... By Using Query SELECT A.UniqueId, A.RequestNo, A.AssessmentNo,CONVERT(VARCHAR(50),B.RequestDate,103) as 'RequestDate', CONVERT(Varchar(50),A.AssignedDate,103)as 'AssignedDate', CONVERT(Varchar(50), A.CleanRequestDate, 103) as 'CleaningDate', A.CleanRequestTime,A.VehicleNo,A.CleaningStatus, A.NumberofTrip,A.TripNo,A.CleaningReceiptNo,A.ImgExtension FROM DMS_CompletedCleaningRequest AS A LEFT JOIN DMS_CleaningRequest AS B ON A.RequestNo = B.UniqueId WHERE A.District = '" + hfDistrict.Value.Trim() + "' AND" + " A.Panchayat = '" + hfPanchayat.Value.Trim() + "' AND A.UniqueId NOT IN (SELECT RequestNo FROM DMS_PaymentDetails)

Sourav Kumar Das · Answer

From this query I have taken requestNo as an UniqueId if it gets matches with the insertion table and then it is assigned as paid as well as referenceid..... @Piyush Pansuriya

Piyush Pansuriya · Answer

Thats fine, but when and which raw you want to remove from grid?

Sourav Kumar Das · Answer

I will share you the code and there should be not there any button format to remove it... @Piyush Pansuriya

Piyush Pansuriya · Answer

Please share your code while you assign the itemsource to girdview. Or you want to remove on button click etc..

Sourav Kumar Das · Answer

Will you please process the query elaborately.... @ Piyush Pansuriya

Sourav Kumar Das · Answer

i no need of row deleting...if I use it, it gets affected in database... @ Amit Kumar

Sourav Kumar Das · Answer

Whenever I select a row to pay, it gets paid... Once it is paid it should not show that row in the gridview... @Piyush Pansuriya

Sourav Kumar Das · Answer

I need to remove the row record in gridview and it should not affect the database in Asp.Net @ Piyush Pansuriya

Remove a row from gridview but not from database in Asp.Net

Answers (14)