[vs 2008] create an array from a column in a datagridview

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

[COLOR="Red"]DONT KNOW WHAT TO PUT HERE. [/COLOR]: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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories