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

Sourav Kumar Das

8y2.9k.NET

How to remove a row from gridview but not from database using asp.net..?

Is there any solution please send me.....

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya8y ago
Accepted 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.
+3
Piyush Pansuriya8y ago
Thanks buddy,
Sure contact me when you need help. I am happy to help.
+1
Sourav Kumar Das8y ago
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
0
Sourav Kumar Das8y ago
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)
0
Sourav Kumar Das8y ago
Will you please process the query elaborately....
@ Piyush Pansuriya
0
Sourav Kumar Das8y ago
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
0
Sourav Kumar Das8y ago
i no need of row deleting...if I use it, it gets affected in database...
@ Amit Kumar
0
Sourav Kumar Das8y ago
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
0
Amit Kumar8y ago
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();
}

+2
Piyush Pansuriya8y ago
Thats fine, but when and which raw you want to remove from grid?
+1
Sourav Kumar Das8y ago
I will share you the code and there should be not there any button format to remove it...
@Piyush Pansuriya
0
Piyush Pansuriya8y ago
Please share your code while you assign the itemsource to girdview.

Or you want to remove on button click etc..
+1
Sourav Kumar Das8y ago
I need to remove the row record in gridview and it should not affect the database in Asp.Net

@ Piyush Pansuriya
0
Piyush Pansuriya8y ago
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.
+1