Web Development

Ask something
Question Locked

Sql Quriery in Visual Basic

0 helpful
2 replies

by amolsuryansh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Software Developer

2 replies

by p.j.hutchison

You need to use ADO DB (ActiveX Data Objects) components to use sql
e.g.

Dim con as new ADODB.Connection
Dim cmd as new ADODB.Command
Dim recs as new ADODB.Recordset
Set con=Open "connection string"
cmd.ActiveConnection = con
cmd.CommandText="Select * from MyTable"
Set recs = cmd.Execute

This discussion is closed to new replies.