Missing datas when inserting to database

See more:

C#

Dear all,


I have web application and need to insert data to database.

I am using mssql database.
and my query like below;

sqlcommand cmd=new sqlcommand("insert into tbnm values('"+txtNm.text+"',etc..);

but some times when inserting values missing .This is not always but some times.

please help me.

and please tell which is the best method to insert into database


Regards andThanks,
Kalesh:confused: