Howdy, Stranger!

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

Categories

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

mojojoj0mojojoj0 Member Posts: 2
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.