Why its updating only on one column. Not other one?

Israel

Hi!

I have three records: "search","product" and "stock".

When I make a search its show me the records searched on my textboxs ("produtoStocks.Text" and "nStocksStocks.Text"). Then when I am updating it's update only on column"product". Not on "stocks". why???

Please could you help pn it:

private void button1_Click(object sender, EventArgs e)

{

conn = new SqlConnection(connstr);

conn.Open();

comm = new SqlCommand("update searching set product= '" + produtoStocks.Text + ", stocks=' " + nStocksStocks.Text + "' where code = " + codigoBarraStocks.Text + " ", conn);// Its happen here

try

{

comm.ExecuteNonQuery();

MessageBox.Show("Dado atualizado com exito!");

}

catch (Exception)

{

MessageBox.Show("Dado não atualizado!");

}

finally

{

conn.Close();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
As the 'nstocks' column has a numeric data type you don't want to surround the value with single quotes when updating.

So instead of:

comm = new SqlCommand("update searching set product= '" + produtoStocks.Text + ", stocks=' " + nStocksStocks.Text + "' where code = " + codigoBarraStocks.Text + " ", conn);

you want:

comm = new SqlCommand("update searching set product= '" + produtoStocks.Text + ", stocks= " + nStocksStocks.Text + " where code = " + codigoBarraStocks.Text + " ", conn);
Israel12y ago
Hi!

The table name is: "Searching"

The structure table is:
Column Data type Alow null
Code numeric(18,20) yes
Product nchar(20) yes
nstocks numeric(18,20) yes

Then when I click the only error its given me is: "Not saved". That's all!
The code target on the button is:

private void button1_Click(object sender, EventArgs e)
{
{
conn = new SqlConnection(connstr);
conn.Open();
comm = new SqlCommand("update searching set product= '" + produtoStocks.Text + ", stocks=' " + nStocksStocks.Text + "' where code = " + codigoBarraStocks.Text + " ", conn);// Its happen here
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Saved!");
}
catch (Exception)
{
MessageBox.Show("Not saved!");
}
finally
{
conn.Close();
}
}
Israel12y ago
Hi!

The table name is: "Searching"
The structure table is:
Column Data type Alow null
Code numeric(18,20) yes
Product nchar(20) yes
nstocks numeric(18,20)
Israel12y ago
Hi!

The table name is: "Searching"
The structure table is:
Column Data type Alow null
Code numeric(18,20) yes
Product nchar(20) yes
nstocks numeric(18,20)
Abhay Shanker12y ago
could you please explain your table name and table structure.

do you get any error when you click button