trouble with access database c# dataset

See more:

C#

MS-Access

Dear expert
I have acess db which is in a Windows project. You know a dataset is created and components generated like table adapter dataset in toolbox this I have dragged to form and code like
Tableadaper1.fill(dataset.emp);

For insert
Tableadapter1.Insert(Id,nm);

This is shown on data grid on form while form load Nd insert
I have checked in access also data reaches in table.
I have done all this using ado command parameters etc earlier several times but this is first time I'm using the components which get created when u connect to db now if I change some code Nd debug it the data I inserted just goes Nd if I keep access open to see what happens

It shows #Error in the columns Nd data gets deleted. Sorry if some typos on a mobile phone. The data which is present earlier to the inclusion of access file remains intact.

Should I use ado cmd.param.adwitval stuff or can I save coding effort using this method only if data does not get deleted like a ghost