How to save data with special characters

Question

here I want to update name but while updating I am getting an error because special character is there in name string but i want to save like what we were given I don't want to remove special characters same with special characters, i want to save. in db

 

string name = "BRAD'S STATUS";

var stdf = responseFromServer;

string str = stdf.ToString();

//string ext = str.Substring(0, str.First("/") + 1);

Console.WriteLine(responseFromServer);

conn = new SqlConnection(connstring);

conn.Open();

comm = new SqlCommand("update Ticketbookinginfo set EventPlace= '" + name + "' where ID = 1", conn);

comm.ExecuteNonQuery();