Datagrid Question

[dagoose]

Hi All,

I have created a form with a datagrid. What i would like to do is double click on a row within the datagrid to open another form displaying the contents of that record.

I already have the other form to display the selected record but I don't know how to get the value of cell containing the primary key so i can open the form and jump to that record.

any help or examples appreciated.

[SeanGrebey]

I'm in the middle of pulling some data, so you have to give me a while so I can actually look and see what exactly it is, but the datagrid has a double click method, and it also has a CurrentCell property with the row and column number in it...so:

get the cell data by:

CellData = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, DataGrid1.CurrentCell.ColumnNumber)

[dagoose]

Many thanks for your reply, it got me on the right track and I am now starting to make some progress.

[siomai]

hi!

Just a few questions...what is the datatype of the variable CellData? Where will i put this code? in the datagrid.doubleclick event or in the new form that will pop up? please help a newbie! Thanks!

[dagoose]

celldata is a public variable stored within a module.

Public celldata as Int

This is then available for use in any of the forms. Remember to re-set it everytime you load your form.

celldata = ''

[siomai]

thanks for replying! Since you've been nice enough to share your knowledge with me, would you mind sharing the code you used in your program? It's ok if you don't want to. I understand. But I'd be very grateful if you do. Thanks! Thanks!

PS:
1. Was your second form in datagrid also or you used textboxes/comboboxes?
2. Was your datagrid bound to a dataset or a datatable?

[dagoose]

Hello again,

i will explain how i achieved it. I had two forms, the first contained a datagrid containing the records. Once i double clicked a record, the second form then opened showing all the details for the record i had chosen.

Private Sub grdData_Doubleclick(ByVal sender As Object, ByVal e AS System.EventArgs) Handles grdData.DoubleClick
 
'grab the row
CellData = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, DataGrid1.CurrentCell.ColumnNumber)
 
If CellData = '' Then
msgBox("No Record")
Else
'make call to public function in Module
Call Open_Form1
End If
 
End Sub

Now you need to add a module to your project and make sure you have the function Open_Form1 (or whatever you call it)

'you need to declare you celldata variable here
Public celldata as Int
 
 
    Public Function Open_Form1 ()
 
        'open a new instance of the form
        Dim frm1 As New frm1
        frm1.Show()
        'on my form I have a combobox so i use this to pass the value of celldata to.
        frm1.cboData.SelectedValue = celldata
 
    End Function

It's a bit rough and ready but it works.

Hope this helps

[siomai]

hi again!

I'm having a blue line in this line:

If celldata = ' '  Then

It says "Expression Expected."

Is this in vb.net code? Cause single quote is for comments. Think it's commenting the succeeding code out. Btw, I declared variable celldata as integer. Was that right?

[siomai]

Ok...instead of putting the ' ' in the expression, I used 0. It didn't give me any errors but did not even open my form. what happend?

Also, after (for example) I have already editted the data in my second form, how will I overwrite the old celldata with the new and editted data? Please help!

[dagoose]

oops! should have been "" not ''

did you put the function inside the module?

[siomai]

hi dagoose!

I changed my code and placed "not" in the expression...i got this error:

An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll

Additional information: Cast from string "not" to type 'Double' is not valid.

Hope you could help me...i need this very badly. Thanks in advance!

[siomai]

hope you'd reply soon...

btw, what is 'Int' in your code?

Public celldata as Int

[dagoose]

int = Integer

You mis-understood my post, don't use the word not, use "" (empty quotes).

[siomai]

ok i used revised my code but still i got this error:

An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll

Additional information: Cast from string "" to type 'Double' is not valid.

why? what am i doing wrong?

[dagoose]

could be that you field in the database is a different datatype, try changing to:

Public celldata as String

[siomai]

dagoose!!!!hooray! i got it! I want to thank you cause you've been very nice and helpful to me.

Now, i'm facing a problem on how to put the data on my textboxes and comboboxes from my second form (the one that popped up when my datagrid was double clicked) back to the row that i clicked on in my datagrid.

Could you help me on this? what did you do with your program if you don't mind me asking?

Super thanks dagoose! You've been a great help to me! Take care now.

[siomai]

help! please! I can't do it...
i'm getting dizzy already....please help me! anyone?

[siomai]

please help me do this...

I'm able to doubleclick on my datagrid and transfer the data from the datagrid row to my 2nd form. What I want to do now is to have the edited data from my 2nd form to my main form (in the datagrid). How will I do this? I've been trying to solve this by myself but I just can't! Please somebody help me!

[siomai]

anyone? please...i've been working on this for a couple of days now...but still to no avail! hope someone could show me how to do this.