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();
}
}