Hi.

I have created a Typed Data Set using visual studio 2005 designer. I drag-dropped a table from database and it created a typed data table into it. When I insert data into this table using TableAdapter generated by Visual sudio designer it does not insert in physical database.

I can retrieve it till application is running and lost as the inserted data is in memory not in physical database.

here is the sample code I wrote:

DefectTrackerDataSetTableAdapters.tblDefectsTableAdapter ta = new DefectTracker.DefectTrackerDataSetTableAdapters.tblDefectsTableAdapter();

ta.InsertDefect(Convert.ToInt32(txtDefectNo.Text), "MQC", dpAssignDate.Value, "Open");