GUI Ado.net connectivity with SQL

Question

hi everyone i need ur help in the following code as i had tried this code many times but doesn't got the desired results. so plz help me out . SqlCommand cmd1 = new SqlCommand(UPDATE entry SET stock = stock - '+textBox22.Text+ 'Where name=' + textBox1.Text + ' conn);

Krishna Garad · Answer

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.

Satyapriya Nayak · Answer

Hi shahzeb Try this... SqlCommand cmd1 = new SqlCommand(UPDATE entry SET stock =' + textBox22.Text + ' Where name=' + textBox1.Text + ' conn); Thanks