Problem with DataGrid. [Resolved]

[albertlse]

I have a datagrid.

For example, my current cell has a text "good".

How can I retrieve the current cell value?

After I change the current cell's text to let say "bad", it will suppose automatically update the database, right? But it don't.

Why? Or do we need to add code to update the database on every changes?

Another problem is, what is the event for DataGrid which will be executed when we changed the text of a cell?

For example, when we change the current cell's text from "good" to "bad", which event is executed?

Please guide me. Can anyone provide me with code for me to refer easily?

Thank you.

[Lunatic3]

1- To retrive the current cell value:

myDatagrid(myDatagrid.CurrentCell)

2- There is an event called CurrentCell changed that fires only if you change the current cell and navigate to another cell. So if you wan to have the real time control over the cell being changed you have to build a custom datagridtextboxcolumn and override its textbox cchange event.
3- The datagrid updates its underlying datasource. If its a table in the dataset the database is not updated unless you update it using your dataset.

[parminder]

How can we access the events of TextBox which is defined in DataGrid Columns ?

Thanks

[albertlse]

Lunatic3,

Can you show me how to add Textbox to a column in DataGrid?

I try to code, but fail.

Please show me the code / ways to do it. Thank you!

[Lunatic3]

Can you show me how to add Textbox to a column in DataGrid?

I was not talking about adding a textbox to a column. I was talking about building your ouwn DatagridTextboxColumn:
Here is the code:

In a class:

Public Class myDGTXT
    Inherits DataGridTextBoxColumn
    Public Sub New()
        MyBase.New()
        AddHandler Me.TextBox.KeyPress, New System.Windows.Forms.KeyPressEventHandler(AddressOf HandleKeyPress)
       ' You can add handler for any of the events of the textbox you desire.
    End Sub
    Private Sub HandleKeyPress(ByVal sender As Object, ByVal e As KeyPressEventArgs)
     'Some code 
    End Sub
End Class

and in your form it goes some thing like these:
Here we assume you have:
A datagrid called myDatagrid
A dataset called myDataset that contains a table called myTable
Now we add one custom DatagridTextboxColumn to it.

Dim ts as New DatagridTableStyle
Dim Dgtextclm as New myDGTXT
 ts.MappingName = mydataset.mytable.TableName ' The Table of the dataset you want to bind to
Dgtextclm.MappingName =mydataset.mytable.Columns(0).ColumnName ' Binds the column to the coulmn 0 of your table
' Here you can set other properties like width, header text and so on
ts.GridColumnStyles.Add(Dgtextclm)
myDatagrid.TableStyles.Add(ts)
myDatagrid.Datasource=myDataset.myTable

[parminder]

Thanks Lunatic3


It is working fine.

My objective is to access the TextChanged event of TextBox of DataGrid's Column. I tried but unable to find how ?

What I do in your example for TextBox_TextChanged event at "?"

=========
AddHandler Me.TextBox.TextChanged, New ? (AddressOf HandleKeyPress)
=========
and
=========
Private Sub HandleKeyPress(ByVal sender As Object, ByVal e As ? )
=========

Thanks

[Lunatic3]

In your case it would be:

AddHandler Me.TextBox.TextChanged, New System.EventHandler(AddressOf handletextchange)
'Alternatively you can shorten it in this way:
'Me.TextBox.TextChanged, Addressof handletextchange
Private Sub handletextchange(ByVal sender As Object, ByVal e As System.EventArgs)
  'some code
End Sub

[parminder]

Thanks Lunatic3,


It is workng fine.

Thanks once again