Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Cannot update records...
Mfwamba Tshimanga
Jul 19 2014 2:07 PM
689
Reply
Hi!
Why I cannot update my record on my database. I receive this message (
not saved
). Please have a look on my codes to see if somethink is wrong.
private void btnUpdate_ProdutoStock_Click(object sender, EventArgs e)
{
{
conn = new SqlConnection(connstr);
comm = new SqlCommand();
conn.Open();
SqlParameter code = new SqlParameter("@cod", SqlDbType.VarChar);
SqlParameter product = new SqlParameter("@prod", SqlDbType.NChar);
SqlParameter price = new SqlParameter("@price", SqlDbType.NChar);
SqlParameter n_stock = new SqlParameter("@stock", SqlDbType.NChar);
comm.Parameters.Add(code );
comm.Parameters.Add(product );
comm.Parameters.Add(price );
comm.Parameters.Add(n_stock);
code .Value = codigoBarraStocks.Text;
product .Value = produtoStocks.Text;
price .Value = precoStocks.Text;
n_stock.Value = nStocksStocks.Text;
comm.Connection = conn;
comm.CommandText ="UPDATE consult SET code = @cod, product= @prod, price = @preco, n_stock= @stock WHERE (code = @cod)";
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Saved");
}
catch (Exception)
{
MessageBox.Show("Not saved");
}
finally
{
conn.Close();
}
}
}
}
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Best technology for developing web application
eRROR