after delete row from dataset gridview is not refreshing

Question

0.00/5 (No votes)

See more:

I thought it should be a simple question so I can get the result from codebehind....but now I understand..how difficult question this is...

after deleting a row from gridview/dataset....gridview is not refreshing...

I tried

C#

UpdatePanel1.Update();
Cache.Insert("RewardDS", MyDs);
MyDs = null;
MyDs = (DataSet)Cache["RewardDS"];
GridView1.DataSource = null;
GridView1.DataSource = MyDs;
GridView1.DataBind();

delete is happening but gridview is not refreshing
plz someone help

Posted 24-Aug-13 0:26am

Miss Maheshwari

Updated 26-Aug-13 1:23am

v6

Add a Solution

Comments

VICK 26-Aug-13 4:44am

MyDs = (DataSet)Cache["RewardDS"];

What is the output of the above line.. use the break point to check either its extracting the data set properly from cache or not...

Miss Maheshwari 26-Aug-13 5:47am

in MyDs dataset from cache is fetched...I used it in complete project

VICK 26-Aug-13 5:59am

You are getting dataset from DB,
deleting a row from there and than binding your gridview with the DS....

RYt???

In this case gridview is getting bind with the old gridview..

You have to get the dataset ,
delete the row, update the db,
Reget the dataset with updated data,
and than bind with gridview....

HOpe that gonna work.

OR do the deletion before putting dataset in cache or update the cache with updated dataset....

Miss Maheshwari 26-Aug-13 6:41am

I am binding gridview with dataset...
deleting a row from dataset den updating the dataset and again rebind my gridview that updated dataset

Dholakiya Ankit 26-Aug-13 7:42am

u are using single dataset in entire project that is not good idea
in above scenario you are fetching data from cache so check by debugging that in cache data is refreshing or not
regards..:)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahesh Bailwal · Answer 1 · 2013-08-24T02:38:00

Solution 1

I believe you should not call "AcceptChanges" on dataset in your delete function. Please follow below link for more information.

differences between update and acceptchanges[^]

Posted 24-Aug-13 2:38am

Mahesh Bailwal