Dynamic arrays

[macca24]

Anyone have any code that reads a number of records from a database table into a Dynamic Array? macca

[toxcct]

you can do two things : 1st way : use an ArrayList and Add() each element you want... 2nd way : select sum(column) from table... then create a simple array (non redimentionable), which size is the length read previously...

---

TOXCCT >>> GEII power
[toxcct][VisualCalc]

[macca24]

Thanks for the reply toxxct, but do you have any example code for this? macca

[Mandar Patankar]

Dim RecordArray() as string Dim SqlAdap as New sqlAdapter(QueryString,ConnectionString) Dim RowTable as New datatable SqlAdap.fill(RowTable) Dim Myrow as Datarow redim recordArray(rowtable.rows.count-1) as String Dim i as integer=0 'If u need to inser all the fields from the row ' u can create two dimensional array For each myrow in Rowtable.rows recordArray(i) = myRow(0) i+=1 next Mandar Patankar Microsoft Certified professional