0) Your query is incorrect, you didn't close that properly(missing closing parenthesis at end)
SqlCommand sqlCmd = new SqlCommand(@"INSERT INTO Table_Name(Name) VALUES (@name)",con);
1) You forgot to execute, below line is missing.
sqlCmd.ExecuteNonQuery();
2) Don't use hard-code connectionstrings. Get those details from config files. Check the below one for sample
How to get Connection String from App.Config in C#[
^]
3) Don't use Reserved keywords for columns. Use meaningful column names like Emp_Name(instead of Name)
Check it out for more details.
Reserved Keywords[
^]
4) Learn more before use things.