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

[Carter Langley]

Dim Cnn As ADODB.Connection Dim Rst As ADODB.Recordset set cnn = new adodb.connection Cnn.Open "Your database connection statement goes here" set rst = new adodb.recordset rst.open "Your SQL Query Statement",Cnn,adOpenDynamic, adLockOptimistic you can now manipulate your database information, like add, delete, etc. hope this helps. this works for VB6 when you have referenced ado.