VB.NET

VB.NET RSS

Accessing data in a datagrid...

Please support our VB.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jun 2008

Posts: 2

Reputation: phantom715 is an unknown quantity at this point

Solved Threads: 0

phantom715 phantom715 is offline

Offline

Newbie Poster

Accessing data in a datagrid...

Jun 2nd, 2008

I have a basic program that access a local Access database, reads data from it into a datagrid, and then allows me to manipulate it by using textboxes. I can add, delete, and search for records. I want to remove the textboxes from the equation completely. Is there any way I can access the data in the datagrid through code so I can use it in SQL statements?

i.e. DataGrid.SelectedRow.Column(3).Value

•

Join Date: Nov 2007

Posts: 2,641

Reputation: Jx_Man is a glorious beacon of light

Solved Threads: 245

Jx_Man

Offline

Posting Maven

Re: Accessing data in a datagrid...

Jun 2nd, 2008

initial condition

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
Dim i As Integer
i = dgUser.CurrentRowIndex()
Dim i As Integer
i = dgUser.CurrentRowIndex()

i.e : (this following code will select user where id user = value of first column from selected datagrid). Of course in datagrid click event :

 Help with Code Tags 
 vb Syntax (Toggle Plain Text) 
Private Sub dgPendidikan_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgPendidikan.Click
...
cmdUser.CommandText = "SELECT * FROM Users where IdUser ='" & Trim(dgUser.Item(i, 0)) & "'"
....
end sub
Private Sub dgPendidikan_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgPendidikan.Click
...
cmdUser.CommandText = "SELECT * FROM Users where IdUser ='" & Trim(dgUser.Item(i, 0)) & "'"
....
end sub