I have do some calculation in C# and i want insert that value to MySql database. Example totalPrice= Price1+Price2; I want pass the totalPrice into my table. How to do that?
-
You pass it as a parameter in your INSERT statement.J. Steen– J. Steen2013-07-23 08:00:41 +00:00Commented Jul 23, 2013 at 8:00
-
ya...i want pass it as decimal. Is it possible?user2601433– user26014332013-07-23 08:02:02 +00:00Commented Jul 23, 2013 at 8:02
Add a comment
|
2 Answers
You need to use an INSERT statement. It's probably best to use parameterized queries rather than just an INSERT command.
MySqlCommand command = new MySqlCommand();
string sql = "INSERT INTO YourTable (TotalPrice) VALUES (@TotalPrice)";
command.Parameters.AddWithValue("@TotalPrice", totalPrice);
Then remember to execute your query. command.ExecuteNonQuery();
1 Comment
Corak
+1 for parameterized queries. Can't be stressed too much to use 'em!
If you are using EntityFramework...
yourTable obj = new yourTable();
obj.name = "name";
obj.created = DateTime.Now;
etc.......
ctx.yourTable.Add(obj);
ctx.SaveChanges();
or
ctx.Database.ExecuteSqlCommand("Insert intoy YourTable values etc..");
