query related to vb

[Ms Shaheen]

i am deveoping a project with vb as frontend and sql as back end and any data entered through the vb form should automaticaaly get updated in sql table. I have tried with adodb connection but failed to succeed in it. Plz can u send me the code to connect from front end vb to backend sql with updations done regularly when code is added Thanking you, shaheen

[Kschuler]

There is an SQL Client provider that you can use. I'm not sure if you have to install it or it is part of the core package. Try looking for DataAdapters/Command/other database objects here: System.Data.SqlClient If you need connection string information try this site: http://www.connectionstrings.com/[^] Hope this helps.