opdate / delete DB data
Hej eksperter,Hvis koden til at hente data fra en mssql db ser sådan her ud :
SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseString"]);
SqlCommand command = new SqlCommand();
connection.Open();
command.Connection = connection;
command.CommandText = "SELECT * FROM users Where user_name = 'test'";
SqlDataReader reader = command.ExecuteReader();
hvad skal der så rettes ved det for at det i stedet for opdater eller sleter data i db istedet for at hente det ud over at sql stringen skal være anderledes såsom :
"UPDATE users SET user_name = 'nytnavn' WHERE user_id= '1'"
og
"DELETE FROM users WHERE user_id= '1'"