How to edit data in search result in c#

Azzyloth Pakdemol

I managed to create a code for my edit button and search button. My edit button is functional. It can edit my data in database, my search code is also functional. My problem is to edit data in search results. Like if i search "naruto", my datagridview will filter all the names that has "naruto" on the database. After i choose and doubleclick on the result, all data will reappear to my textbox. But when i edit that data, it doesn't work. Instead, the first data on my database is the one that is changing not the one that i choose. My edit code is working if i don't search any names and don't choose on the search result. I think the problem is in my Edit codes. Please share your answers. Much better if you have a code examples. THANKS IN ADVANCE!

here's my codes. Please HELP...

2 Replies

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

Amit Gupta9y ago
Accepted answer
Hey

Your code needs some modification:

1. As your whole scenario is to perform crud with search based on gridview, then make your datatable and SqlDataAdapter as a global variable

2. Load your initial list on the global variable

3. Also perform edit functionality on gridview itself instead of textboxes (that would be more user friendly)

4. For Search function use the below code instead of fetching from the database (as your whole list was already on a global datatable then perform action on it)
void Search(string jobOrder)
{
   var view = datagrid.DataSource as DataView;
    var filter = "";
    if(jobOrder !="")
        filter = "JobOrder ="+ jobOrder;

    viee.Filter = filter;
}
5. Now all done, update code will be same as you had done, just use the global variables

That's all you have to do.

Do let me know, if it solves your issue
Azzyloth Pakdemol8y ago
I can't do that. The one you said that edit in datagridview. The direction says that i need to double click the data in datagridview and edit on the textbox.