delete the raw data from database if one data is zero pls help me

Question

5.00/5 (1 vote)

See more:

I have Four fields in my table Item,Quantity,Price,Date
my table name is Items

Item Quantity Price Date
..............................
Maida 9 7 12/24/2012
onion 12 8 12/24/2012
salt 0 0 12/24/2012
oil 6 4 12/24/2012

i want to delete the raw that containing Quantity equal to zero.
i want to delete the raw data from database

C#

string po = "0";
        string j = "select Quantity from Item";
        SqlCommand vvn = new SqlCommand(j, DbConnection.mCon);
        SqlDataAdapter lk = new SqlDataAdapter(vvn);
        DataTable ui = new DataTable();
        lk.Fill(ui);
        if (ui.Columns[0][0].ToString()==po)
        {
            string d6 = "delete from Item where Item='" + TextBox1.Text + "' and Quantity='" + TextBox2.Text + "' and Price='" + TextBox3.Text + "' and Date='" + TextBox4.Text + "'";
            SqlCommand cnm6 = new SqlCommand(d6, DbConnection.mCon);
            cnm6.ExecuteNonQuery();
        }

Pls Correct it The mistake occur in if (ui.Columns[0][0].ToString()==po) this statement pls help me

Posted 23-Dec-12 19:55pm

ravuravu

Updated 23-Dec-12 20:15pm

v6

Add a Solution

Comments

[no name] 24-Dec-12 1:57am

What is po over here ?

Orcun Iyigun 24-Dec-12 4:29am

OP;that i am checking the condition that column containing zero
po is equal to zero
suppose i gave the condition if(ui.Columns[0][0]==0)

i got errorr

ravuravu 24-Dec-12 2:00am

that i am checking the condition that column containing zero
po is equal to zero

ravuravu 24-Dec-12 2:02am

suppose i gave the condition if(ui.Columns[0][0]==0)

i got errorr

__TR__ 24-Dec-12 2:05am

What's the error message?

Orcun Iyigun 24-Dec-12 4:29am

nothing ,no error message ,when i compile it, it Exiting from if loop it doesn't go to if loop

ravuravu 24-Dec-12 2:12am

nothing ,no error message ,when i compile it, it Exiting from if loop it doesn't go to if loop

Orcun Iyigun 24-Dec-12 4:30am

When you comment try the reply button... otherwise the person who asked you the question will not be notified.

__TR__ 24-Dec-12 4:42am

Check the value of ui.Columns[0][0].ToString() in debug mode. Looks like the expression of If statement is not true, hence your code is not entering the block inside If statement.

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)

_Amy · Answer 1 · 2012-12-23T20:33:00

Try this:

C#

string po = "0";
string j = "select Quantity from Item";
SqlCommand vvn = new SqlCommand(j, DbConnection.mCon);
SqlDataReader lk =vvn.ExecuteReader();
while(lk.Read()){
    if (lk[0].ToString()==po)
    {
        string d6 = "delete from Item where Item='" + TextBox1.Text + "' and Quantity='" + TextBox2.Text + "' and Price='" + TextBox3.Text + "' and Date='" + TextBox4.Text + "'";
        SqlCommand cnm6 = new SqlCommand(d6, DbConnection.mCon);
        cnm6.ExecuteNonQuery();
    }
}

This may help you.

--Amit

it.sudhiryadav · Answer 2 · 2012-12-23T22:25:00

Solution 3

Your SQL query will be like as,

SQL

DELETE FROM Items WHERE Quantity=0

Posted 23-Dec-12 22:25pm

it.sudhiryadav

Zafar Sultan · Answer 3 · 2012-12-23T22:29:00

Why do you need to do it this way only? As you are already passing Item, Quantity, Price and Date you can do that in a single query. For example:

SQL

"delete from Item where Item='" + TextBox1.Text + "' and Quantity='" + TextBox2.Text + "' and Price='" + TextBox3.Text + "' and Date='" + TextBox4.Text + "'" +" and Quantity = 0";

Also, I am not sure this is going to work as you are comparing date which at times can be quite tricky to deal with. And, if you want it in your way only try this:

C#

string po = "0";
        string j = "select Quantity from Item";
        SqlCommand vvn = new SqlCommand(j, DbConnection.mCon);
        SqlDataAdapter lk = new SqlDataAdapter(vvn);
        DataTable ui = new DataTable();
        lk.Fill(ui);
for(int i = 0; i < ui.Rows.Count; i++)
{
        if (ui.Rows[i][0].ToString().Trim()==po)
        {
            string d6 = "delete from Item where Item='" + TextBox1.Text + "' and Quantity='" + TextBox2.Text + "' and Price='" + TextBox3.Text + "' and Date='" + TextBox4.Text + "'";
            SqlCommand cnm6 = new SqlCommand(d6, DbConnection.mCon);
            cnm6.ExecuteNonQuery();
        }
}

This might not work also as suppose the quantity of first record is "0" but the item,price and Date does not match the passed parameters. You will have to do it the "other" way. Think of it and share with us. We will definitely help you out.

Krunal Rohit · Answer 4 · 2012-12-23T20:15:00

C#

 string j = "select Quantity from Item";
        SqlCommand vvn = new SqlCommand(j, DbConnection.mCon);
        SqlDataAdapter lk = new SqlDataAdapter(vvn);
        DataTable ui = new DataTable();
        lk.Fill(ui);
foreach(DataRow dr in ui.Rows)
{
    if(dr == null)
    {
        string d6 = "delete from Item where Item='" + TextBox1.Text + "' and Quantity='" + TextBox2.Text + "' and Price='" + TextBox3.Text + "' and Date='" + TextBox4.Text + "'";
            SqlCommand cnm6 = new SqlCommand(d6, DbConnection.mCon);
            cnm6.ExecuteNonQuery();
    }
}

Its my blind assumption, hope it will solve your issue..

delete the raw data from database if one data is zero pls help me

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0