visual basic programming

[markgri]

how can i access data that i have entered to the database in msflexgrid. like for example i have putting three categories the noofitem,scores, and totals. that was displayed on the top of msflexgrid horizontally..? is there anyone can help me... please...

[debasisdas]

are you trying to change the column caption on the grid ?

[guest11]

Try our this code:

dim i as integer
dim j as integer
dim cnt as integer
dim rs as adodb.recordset

set rs=new adodb.recordset
rs.open urQuery,urDatabaseConnectionPath

msflexgrid.cols=3
msflexgrid.rows=rs.recordcount

for i=0 to 3 
    k=0
   for j=1 to rs.recordcount
        MSFlexGrid1.textmatrix(i,j)=rs.fields(k).value
         k=k+1
   next j
next i