I have table "Student"
P_ID LastName FirstName Address City 1 Hansen Ola 2 Svendson Tove 3 Petterson Kari 4 Nilsen Johan ...and so on
How do i change edit code in C#
string firstName = "Ola"; string lastName ="Hansen"; string address = "ABC"; string city = "Salzburg"; string connectionString = System.Configuration.ConfigurationManager .ConnectionStrings["LocalDB"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "INSERT INTO Student (LastName, FirstName, Address, City) VALUES (@ln, @fn, @add, @cit)"; command.Parameters.AddWithValue("@ln", lastName); command.Parameters.AddWithValue("@fn", firstName); command.Parameters.AddWithValue("@add", address); command.Parameters.AddWithValue("@cit", city); connection.Open(); command.ExecuteNonQuery(); connection.Close(); }
to edit entry where Lastname field has lastname value and FirstName field has firstname value.
I dont want to use like this
UPDATE Persons SET Address='Nissestien 67', City='Sandnes' WHERE LastName='Tjessem' AND FirstName='Jakob'
and i edited my original statement to
command.CommandText = "UPDATE Student(LastName, FirstName, Address, City) VALUES (@ln, @fn, @add, @cit) WHERE LastName='" + lastName + "' AND FirstName='" + firstName+"'";
but the statement is not getting executed, why is it throwing SQL exception ? Is there nay solution to it ?