Thanks for all who spared their precious time in answering me. I finally had it working and it was very simple. At first d textboxes are not known inside the c# code. i right clicked each text box and clicked view code which opens the c# code page. there i used d syntax
txtboxname.Text;
stmt to retrive it and used the query "Insert into tablename values ('"+txtboxname.Text+"'....);" to accomplish the insertion.. and it worked fine.