how to update database using sql in c#
using (var sqlConnection = new SqlConnection(config.ConnectionString))
{
foreach(var position in positions)
{
var sql =
$"UPDATE BillOfMaterial SET Position = '{pos}' WHERE Creator = '{position.Creator}' AND Idx = '{position.Idx}' AND ArtNumber = '{position.ArtNumber}'";
using (var sqlCommand = new SqlCommand(sql,sqlConnection))
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
}
3.8
4
// Query the database for the row to be updated.
var query =
from ord in db.Orders
where ord.OrderID == 11000
select ord;
// Execute the query, and change the column values
// you want to change.
foreach (Order ord in query)
{
ord.ShipName = "Mariner";
ord.ShipVia = 2;
// Insert any additional changes to column values.
}
// Submit the changes to the database.
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
// Provide for exceptions.
}
Thank you!
4
3.8
(5 Votes)
0
Are there any code examples left?
New code examples in category C#
Relative searches
update data sql c#
update-database command in c#
c# update database from entity
how to update data in sql database in asp.net using c#
how to update database rows from c#
how to update data in database
update sql database c# example
update in database C#
how to update sql database in c#
C# update database command
C# update database
update-database c# sql
how to update SQL using C#
update data to database C#
How to update Data in access database using c#
c# how to update database
update database table in c#
how to update a database in sql using c#
how to update a database in c#
how to update database using sql in c#
how to update database in c# using sql
.net update database
how to update data in database using c#
.net framework update in db
.net core update database
update db from entity framework bool value
update data in sql database as[.net
.net core migration update database
razor pages ef read data from database
asp.net core data table free
refresh dbset entity from database
EF DbSet get from database
