If the database is stored in SQL server and the front end is designed in visual basic, how can this be linked.which connectivity like odbc,adodb etc supports this activity.please do give me the procedure as well as the hint of codes to link them at run time.......its an urgent please if anyone knows jst share your knowledge...............please..........
If you want to know more things about RSGold can go to this website www.rsgoldfast.com
Our service is the most professional and most secure and convenient
Cheap Runescape Gold Buy RS Gold Your Professiona RS...
Buy Cheapest Runescape Gold RS Gold...
Use adobc <------try this
dim rs as new adobc.recordset
dim cn as new adobc.connection
private sub xn()
cn.cursorlocation = aduseclient
cn.open "CONNECTION STRING" <------
end sub
private sub form_load()
call xn
if rs.state=adstateopen then rs.close
rs.open "select * from TABLENAME" ,cn, adlockstatic, adlockreadonly
if rs.recordcount > 0 then
set datagrid1.datasource = rs
end sub
326 views
Usually answered in minutes!
use adobc <------try this
dim rs as new adobc.recordset
dim cn as new adobc.connection
private sub xn()
cn.cursorlocation = aduseclient
cn.open "CONNECTION STRING" <------
end sub
private sub form_load()
if rs.state=adstateopen then rs.close
rs.open "select * from TABLENAME" ,cn, adlockstatic, adlockreadonly
if rs.recordcount > 0 then
set datagrid1.datasource = rs
end sub
×