Community discussion forum

[vb.net / vs 2008] how to create an array from a column in a datagridview.

• • Reply

  1 year ago

  by mojojoj0

  Yuuki Cross

  Manila, Philippines

  Joined 1 year ago
  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.
  Report abuse
• • Reply

  1 year ago

  by mojojoj0

  Yuuki Cross

  Manila, Philippines

  Joined 1 year ago
  oh my, the sample table didnt show the way as i expected it. but thats a table bytheway that shows on the datagridview... :)
  Report abuse