GUI Ado.net connectivity with SQL

From your query I think so you want to minus the value given in textbox from stock column if it is instead of this write the stored procedure like

Create Procedure Sp_UpdateStock
(
@stockval int,
@name Varchar(50)
)
as
Begin
Declare @oldstock int
Set @oldstock=(Select Stock From Entry Where Name=@name)
Begin
Update Entry Set Stock=@oldstock-@stockval Where Name=@name
End
End

And call this procedure from your front end but make sure your old stock value not be null if it is null then set it default to 0.

Hi shahzeb,

Try this...


SqlCommand cmd1 = new SqlCommand("UPDATE entry SET stock ='" + textBox22.Text + "' Where name='" + textBox1.Text + "'", conn);


Thanks