datagrid [RESOLVED]

[EyeTalion]

I am filling up a datagrid using a dataset on the page load event. The user is going to click on a row and I need the value of certain fields in that row. How can I get those values of the row they click on?

Dim cmdView As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("select * from pcms.pcms_pcard_transaction_header ", objCon) 
        ds = New DataSet() 
        cmdView.Fill(ds, "cards") 
        dgView.DataSource = ds 
        dgView.DataMember = "cards"

[Slow_Learner]

Probably you want to examine DataGrid.CurrentRowIndex
ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwindowsformsdatagridclasscurrentrowindextopic.htm

...and maybe .CurrentCell
ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwindowsformsdatagridclasscurrentcelltopic.htm

Although I'm not 100% certain whether the CurrentRowIndex is of the table itself, or of the view in the DataGrid.

[EyeTalion]

can you paste the entire link...thanks

[Slow_Learner]

That is the entire link, if you have the environment help installed. Just stick that string into the Browser toolbar field in the dev environment. Or if you want to get it off of the online MSDN, you can go to:
http://msdn.microsoft.com/library/de...IndexTopic.asp

Gives you the same text, although once in a while there's an updated piece of info on the online version that obsoletes the local help.

[EyeTalion]

can someone convert this code, so I can use it in VB.NET. I'm getting an error becuse it's not a web control...

Private Sub dgView_EditCommand( _ 
  ByVal source As Object, _ 
  ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs _ 
    ) Handles dgView.EditCommand 
 
        Dim sFirstCell As String = e.Item.Cells(0).Text 
        Dim sSecondCell As String = e.Item.Cells(1).Text 
        ' And so on... 
    End Sub

[Slow_Learner]

Doesn't look to me like there is a simple equivalent of DataGrid.EditCommand in Windows Forms. What behavior are you trying to get out of DataGrid?

[EyeTalion]

I need to know the value of the first cell of the row that was clicked

[Slow_Learner]

Then you probably want the DataGrid.CurrentCellChanged event.
ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwindowsformsdatagridclasscurrentcellchangedtopic.htm

e.g.:
Private Sub DataGrid1_CurrentCellChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.CurrentCellChanged

Oh and as to:

        Dim sFirstCell As String = e.Item.Cells(0).Text 
        Dim sSecondCell As String = e.Item.Cells(1).Text

based on:
ms-help://MS.VSCC/MS.MSDNVS/cpref/html/frlrfsystemwindowsformsdatagridclassitemtopic.htm

it would end up being (at least the way I would do it):

        Dim sFirstCell As String = DataGrid1(DataGrid1.CurrentRowIndex, 0)   'cell 0
        Dim sFirstCell As String = DataGrid1(DataGrid1.CurrentRowIndex, 1)   'cell 1

[EyeTalion]

thanks..works great..

[EyeTalion]

slow, another question...how do you change the names of the column headings?