string insertString =" insert into emp values ('" + textBox1.Text.Trim () + "','" + textBox2.Text .Trim() + "','"+ textBox3.Text.Trim() + "', '" + textBox4.Text.Trim() + "')"
SqlCommand ScalarCommand = new SqlCommand();
try
{
ScalarCommand.CommandText = insertString;
ScalarCommand.Connection = Cnn;
ScalarCommand.ExecuteScalar();
use above code.
make sure all datatype of database is matches with insert value.