Inserting to database

[davebat]

I have created a windows application in visual studio 2005, I need to insert a record into a local access database.

I have set up a .xsd, but the problem is im not sure what I'm doing. I have created the insert query, called it from a button click using

 Dim PatientUpdate As New AnteNatalBookerDataSetTableAdapters.tblPatientDetailTableAdapter
        PatientUpdate.NewPatient(nhsNumber, DOB, RBHNumber, surname, forename, prevSurname, title, addStreet, addCity, AddCounty, AddPost, AddAppStreet, AddAppCity, AddAppCounty, AddAppPost, homePhone, workPhone, language, Interpreter, Resident, Visitor, RegGp)

and although the page doesn't error a record isn'y inserted, I suspect it has inserted a record into a local recordset, if this is the case how do i update my actual database?

[circuits2]

Did you add the DataBase as a DataSource in your project? If so, you can click on it in the DataSource Viewer and change it's CopyToOutputFolder property to never.

[jmcilhinney]

I think circuits meant to select your database file in the Solution Explorer, then open the Properties window and set Copy To Output Folder property. Also, I'd recommend setting it to Copy If Newer. That way if you make any changes to your original database then a new copy will be created in your output folder and you'll start using the new schema immediately.