how to use subtract operation in windows form applicaion

[sri apple]

i am using this command in sql server it is executed.... /** update product set quantity= quantity - 10 where productname='sugar' ****/ but how to use same command in windows form app... please give me any idea about this..

[Pete OHanlon]

Use a SqlCommand for the actual sql text, and use a SqlConnection for the connection to the database. A simple search will reveal millions of hits on these topics. You need to use the ExecuteNonQuery method for your command.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

[Lost User]

You can downvote Pete's answer, but that doesn't make it less correct. It's a very basic piece of work, and there's an copy/paste example in the documentation. If that's too complex, then start studying.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

[Lost User]

+5

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

[Pete OHanlon]

Univote countered.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

[Lost User]

Pete O'Hanlon wrote:

Univote countered.

Once again.

[KiranKumar Roy]

Dear, May be you need something like below code..

protected void UpdateData()
{
int intQuantity = 0;
SqlConnection con = new SqlConnection("Your Connectionstring here");
SqlCommand cmd = new SqlCommand("update product set quantity=@Quantity where productname=@Product", con); ;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Quantity", intQuantity - 10);
cmd.Parameters.AddWithValue("@Product", "Sugar");
cmd.ExecuteNonQuery();
}

KiranKumar Roy