[Elda]

Hello...

My Datagridview displays data perfectly. What I want is that
if I click or doubleclick cell of datagrid it will shows my
edit form...

code to displays data

  sqlstmt = "SELECT * FROM GMOIR where " & cbfield.Text & " Like '%" & txtdata.Text & "%' "
       


        Dim cmd As New SqlCommand(sqlstmt, con2)
        da = New SqlDataAdapter(cmd)
        ds = New DataSet
        da.Fill(ds, "CB")
        t = ds.Tables(0)
        dgv1.DataSource = t

Anybody could give link or reference please?

[DimitriV]

In your DataGridView, add this to your Double-Click sub:

myeditform.show()
'Code to populate edit box fields here

Is this what you meant? Or something else?
HTH

[fixo]

Elda, on 17 September 2011 - 12:58 AM, said:

Hello...

My Datagridview displays data perfectly. What I want is that
if I click or doubleclick cell of datagrid it will shows my
edit form...

code to displays data

  sqlstmt = "SELECT * FROM GMOIR where " & cbfield.Text & " Like '%" & txtdata.Text & "%' "
       


        Dim cmd As New SqlCommand(sqlstmt, con2)
        da = New SqlDataAdapter(cmd)
        ds = New DataSet
        da.Fill(ds, "CB")
        t = ds.Tables(0)
        dgv1.DataSource = t

Anybody could give link or reference please?

Take a look at MSDN docs here:

http://msdn.microsof...oubleclick.aspx

[Elda]

Thanks for the reference fixo.
I have this code reading perfectly if rows has data but got error if it
is null.

 Private Sub dgv1_CellDoubleClick

        frmEdit.Show()
        dc = dgv1.CurrentRow.Index
        datafill(dc)

end sub


  Public Sub datafill(ByVal i As Integer)



        r = t.Rows(i)
        frmEdit.txtIrNo.Text = r("IR_No")
        frmEdit.txtDate.Text = r("Date")

End Sub

It says 'Conversion from type 'DBNull' to type 'String' is not valid'..

[Elda]

Got it.... should be like this

frmEdit.txtIrNo.Text = dgv1.Item(0, i).Value.ToString

[Elda]

By the way I'm getting error with this.

 frmEdit.rtDecision.Text = dgv1.Item(10, dc).Value.ToString

It says

"vb.net Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

?????