Question how to create an array from a column in a datagridview

mojojoj0

New member
Joined
Nov 23, 2008
Messages
1
Programming Experience
Beginner
hi there: im new to programming and i have the following code:

Dim dt As New DataTable
Dim da As New SqlClient.SqlDataAdapter("SELECT FEE_NAME, convert(varchar(50), convert(money, FEE_AMOUNT), 1) FROM FEE_TABLE ", m_Connection)
da.Fill(dt)

DataGridView1.DataSource = dt

now this will show in the datagridview as:

_______________________
FEE_NAME ..| FEE_AMOUNT
---------------------------
registration..| 8,000.00
---------------------------
books..........| 4,500.00
---------------------------
uniform........| 7,300.00
---------------------------
library..........| 3,000.00
________________________
(the dots are just so i could align them)

is it possible to put all the rows from FEE_NAME into an array when its already in the datagridview.

so the array will show
array1 = ["registration" , "uniform" , "books" , "library" ]

i have reAd that i needed to use a for each statement like:

For Each row As DataGridViewRow In DataGridView1.Rows

DONT KNOW WHAT TO PUT HERE. :D

Next

because i need to add the data from the array to a new table in the database or create a view. im using ms sql server 2005 as my db. a sample code will really really help me. thanks in advance.
 
Hi

Try putting the follwoing:
Array(i) = row.Cells("FEE_NAME").Value
i += 1

Where i is an integer datatype and helps in moving across array indexes.
 
Back
Top