In place of
System.Data.SqlClient.SqlParameter sp = new System.Data.SqlClient.SqlParameter("Name", System.Data.SqlDbType.NVarChar, 50);
sp.Value = txtName.Text ;
cmd.Parameters.Add(sp);
You can write:
cmd.Parameters.AddWithValue("@Name",txtName.Text.Trim());