He friends, I have added a Local Database in My project(it's an SDF database) by following this:
Right Click Solution Explorer > Add.. > New Item > Local Database
I have created a table in this database. Now I want to insert data into this database via windows form. I don't know how to do this. I know the syntax for SQL SERVER. But I don't know what is to be done in this case. Should I use ODBC, OLEDB or SQL or some other connection for doing this.

see this Link it tell s about Sdf file.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.