deleting selected row in windows form application

Question

3.00/5 (1 vote)

See more:

I have a windows form application where i have displayed the table employee details in a datagrid and i have a delete button while selecting a row and clicking on delete button that row should be deleted based on employee id.I have created a stored procedure for delete and a class file where i have delete function could you please guide after that

Posted 10-Jun-12 4:56am

Member 9100299

Add a Solution

Comments

Shahin Khorshidnia 10-Jun-12 11:05am

Why don't you rebind the new data collection to the datagrid?

2 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)

Sandeep Mewara · Answer 1 · 2012-06-10T05:43:00

Solution 1

What further guidance you need?

Steps further:
1. On delete click, pass on the selected row's EmployeeId to DB layer (if no DB layer, ok. Just keep a note of this ID)
2. Prepare a SQL query that will update your database. Use the EmployeeId you have in your WHERE clause
3. Once executed, refresh your grid with data - either rebind your grid or remove the row from display for the time being

Try!

Posted 10-Jun-12 5:43am

Sandeep Mewara

Comments

Maciej Los 10-Jun-12 17:34pm

Good point, my 5!

Sandeep Mewara 11-Jun-12 1:51am

Thanks losmac.

Saroj Kumar Sahu 11-Jun-12 8:26am

also 5 from me.

Sandeep Mewara 11-Jun-12 9:11am

Thanks.

Maciej Los · Answer 2 · 2012-06-10T11:33:00

Solution 2

As Sandeep Mewara wrote: TRY!

Here you can find a little help:
http://social.msdn.microsoft.com/Forums/pl-PL/adodotnetdataproviders/thread/e9d17dcf-55ce-4a67-9a56-f5955638e51e[^]
http://msdn.microsoft.com/en-us/library/ms171921%28v=vs.80%29.aspx[^]
http://support.microsoft.com/kb/310070[^]
http://www.csharpfriends.com/articles/getarticle.aspx?articleid=78[^]

Posted 10-Jun-12 11:33am

Maciej Los

Comments

VJ Reddy 14-Jun-12 13:27pm

Helpful references. 5!

Maciej Los 14-Jun-12 14:00pm

Thank you, VJ ;)