how to insert data to the specified row column of the multi column list box

[user_1]

Hi All

How do i insert data into the specified column of the multi cplumn list box?

I have a table that containsall station nos and name.Then another table contains the data the various stations having at  for 24 hrs.That is 12 am to 11 pm.

And i want to display each stations details as follows using a multi column list box/table

My stationinfo table

stnno   stnname......................

s1           stn1

s2            stn2

s3             stn3

The other table

stnno      sysdatetime       data

s1             12am                   1

s2              12am                   4

s1               1  am                 2

......

.......

So the station s1,s2.... will have data for 24 hrs.

And i want to display it as follows using a multicolumn listbox

stnname        12am   1 am ......................................11pm

s1                   ...................

s2                 ........................

What i have in my  mind is to get all station nos

and in a for loop get the station's data from 12 am to 11 pm

or

select every statios data for each hor.But in this case i have to query the database 24 times.So i dont think its a good way.

Or any other better query available?

Can anybody suggest me a good idea?

One more thing...how to insert data into the specified field row or column of a multi column list box?

Thanks in advance

[indrajit]

hi
i want to know,,can u say ur need clearly...and i attached two image u see that one

[indrajit]

hi
 u can use property node....... just convert what u want to insert into the table to string format and then as shown in the diagram u can insert in to the multicoloumn list box....the multi.col.list box is in the format of 2 D array so that u just give the index of row and column and  using insert into the array u can insert where u want .. i think this help u ,,,,,,ok further u a having doubt send to me....ok

[user_1]

Hi Indrajit,

Thank u so much 4 the timely help.

I will try and if any doubt i vl get back 2 u.

thanks one again