In the project, often need to essentially a database to write operation, but often encounter such problems, write Data program logic problems, also do not have feedback abnormal , and the Data is occasionally missing , for example: I was in a Data table Data (set fixed length is 4) inserts a string column in the "1234", but actually only preserved the "12" or "4", such as half data , this kind of circumstance is occasionally happen, although it is not allowed,
I'm in the c # winform use ExecuteNonQuery () function to perform " insert into Tb_Data values () " data insert,
I am using sqlserver2012 version

Excuse me how to guarantee the integrity of data insert ? You have good? Thank you for your guidance!