i want to delete just account no but the query deleting complete row. help me with this, thanx in advance

Question

0.00/5 (No votes)

See more:

query = "DELETE FROM Customer WHERE Account_No=@Account_No";

                                       SqlCommand cmd = new SqlCommand(query, cn);
                                       cmd.Parameters.AddWithValue("@Account_No", txtaccount1.Text + "-" + txtaccount2.Text);
                                       cn.Open();
                                       cmd.ExecuteNonQuery();
                                       cn.Close();
                                        MessageBox.Show("Record Deleted Successfully", "Success Message", MessageBoxButtons.OK, MessageBoxIcon.Information);

Posted 3-Jan-13 5:16am

zeshanazam

Add a Solution

Comments

CHill60 3-Jan-13 11:25am

Are you saying that you want to set the Customer.Account_No to blank? If so then you need to use an UPDATE clause in your SQL not DELETE

[no name] 3-Jan-13 12:01pm

Share your table structure here.

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)

Tharaka MTR · Answer 1 · 2013-01-03T05:30:00

Solution 1

TRY THIS

SQL

query = "UPDATE Customer 
SET Account_No=NULL
WHERE Account_No=@Account_No";

Posted 3-Jan-13 5:30am

Tharaka MTR

Updated 3-Jan-13 7:21am

v2

Reza Alipour Fard · Answer 2 · 2013-01-03T07:18:00

Solution 2

Hi
You need Update Account_No to a value for example Null or other not exist value.

If you need more help, please share your table structure with current values and final values you need.

Posted 3-Jan-13 7:18am

Reza Alipour Fard

Comments

[no name] 3-Jan-13 13:26pm

If you need any clarification then add that in the comments not in the solution.

Reza Alipour Fard 3-Jan-13 13:34pm

I present a solution and for more detail I said if need to more help clarification.
Why you get Down voted???
I think you have wrong in this action.
However, Thank you for your attention.

[no name] 3-Jan-13 13:41pm

The answer that you have given is not correct. There is lack of data in the question so u should have asked for the appropriate knowledge.
Thanks