How to disable a record in a gridvew?

Question

1.00/5 (1 vote)

See more:

Hi,

I have a requirement in my project that if the user clicks the disable button inside the grid view, the record will be disabled. That record will not anymore appear in the grid view but it should NOT be deleted in the database.Each record in the grid view has their own Disable button. How to make that? I am new in Asp.Net

Posted 27-Jul-14 15:06pm

DarkDreamer08

Updated 27-Jul-14 15:14pm

v3

Add a Solution

4 solutions

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)

DamithSL · Answer 1 · 2014-07-27T16:27:00

Solution 1

read documentation of GridView.RowCommand Event[^]
in your database add another column to save disable status of the record. when you load you can load only the enabled rows. on disable button click you can update database record as disabled.

Posted 27-Jul-14 16:27pm

DamithSL

Comments

DarkDreamer08 27-Jul-14 22:57pm

can you show me some codes about it, please :)

DamithSL 27-Jul-14 23:09pm

you need to try, see the last example in the given link

DarkDreamer08 27-Jul-14 23:23pm

actually, I am trying that last example. but i am wondering and really got confused on some things in the last example of your given link to me. like the e.CommandName=="Increase", What is that 'Increase'? taht is why I am asking for some short codes for it. Hope you understand since I am a new in this language. Thank you so much.

DamithSL 27-Jul-14 23:24pm

in your button you need to set command name property, here you have CommandName="Increase"

Thanks7872 28-Jul-14 1:51am

Asking questions like this is merely a waste of time. You are expected to try something your self. Don't you have access to google.com? If you just read about rowcommand event everything will be clear to you.

DarkDreamer08 28-Jul-14 1:58am

Rohan I hope you do understand me. I just said from above conversation that I am "ACTUALLY TRYING" since I AM NEW IN ASP.NET. I am asking those kind of questions since I really do not understand some things in the example provided by the link given to me. I am sorry if you find my questions a waste of time. so if you do find them a waste of time, then do not post a comment or do not reply like that cause I do not know if you are insulting me. Just ignore that question, okay? I am sorry again. I am new here and new in that language.

Thanks7872 28-Jul-14 2:03am

Its not just waste of time for us, its for you as well. Just see this asp.net rowcommand event

_Amy 28-Jul-14 7:16am

You need to read the basics of GridView. We are here to help you only if you are learning and trying. We cannot sit and do your homework.

_Amy 28-Jul-14 7:16am

My +5! :)
Little faster then me. ;)

DamithSL 28-Jul-14 7:23am

thank you Amy, bdw you think 8 hrs as little O_0

_Amy 28-Jul-14 7:29am

Oops! Fully diverted now a days. (Y)

DarkDreamer08 18-Aug-14 23:23pm

Help me please here.. http://www.codeproject.com/Questions/808919/How-to-insert-records-from-database-to-a-label I really need this thing. :(

DarkDreamer08 18-Aug-14 1:56am

please help here, http://www.codeproject.com/Questions/808534/How-to-search-records-in-a-database.. Pleaseeee :)

DarkDreamer08 18-Aug-14 23:23pm

Help me out here pleaseee, I really need a hand here, http://www.codeproject.com/Questions/808919/How-to-insert-records-from-database-to-a-label

*Abhijit Ghosh (Subho)* · Answer 2 · 2014-07-27T16:35:00

Solution 2

You can add a IsActive bit to you database table
when you disable a record, the bit is set to 0(false) else it is 1(true)
now just add a disable button to the grid and write the code against the gridview event handler event for the disable button

You can read all about gridview event handlers here GridView [^]

Posted 27-Jul-14 16:35pm

Abhijit Ghosh (Subho)

Comments

DarkDreamer08 27-Jul-14 22:58pm

please, show me some codes about it XD

u mani · Answer 3 · 2014-07-27T23:07:00

Solution 3

http://examples-program-codes.blogspot.in/2013/04/gridview-rowcommand-with-insert-update.html[^]

this will help you. .

Posted 27-Jul-14 23:07pm

u mani

_Amy · Answer 4 · 2014-07-28T01:01:00

I would recommend you to follow the steps:

Steps:
1. Keep an Indicator "IsDisable"(Type : Boolean) in your DataSource of GridView.
2. Set that indicator to false by default.
3. OnRowCommand event of GridView, set the indicator to true in your datasource.
4. While binding GridView filter the DataSource with IsDisable value.

--Amy