Hi,
Add a handler to the datagrid textbox columns key press event. Here
is an example.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim conn As OleDbConnection
Dim strConn As String
Dim strSQL As String
Dim ds As New DataSet
Dim daCustomers As OleDbDataAdapter
strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"
strConn += "Data Source = C:\Northwind.mdb;"
conn = New OleDbConnection(strConn)
daCustomers = New OleDbDataAdapter("Select * from Customers", conn)
daCustomers.Fill(ds, "Customers")
SetupGrid()
DataGrid1.DataSource = ds.Tables("Customers")
End Sub
Private Sub SetupGrid()
Dim ts As New DataGridTableStyle
ts.MappingName = "Customers"
Dim colName As New DataGridTextBoxColumn
With colName
..MappingName = "ContactName"
..HeaderText = "Name"
..Width = 150
End With
AddHandler colName.TextBox.KeyPress, AddressOf ColumnKeyPress
Dim colID As New DataGridTextBoxColumn
With colID
..MappingName = "CustomerID"
..HeaderText = "ID"
..Width = 80
End With
Dim colRegion As New DataGridTextBoxColumn
With colRegion
..MappingName = "Region"
..HeaderText = "Region"
..Width = 80
..NullText = ""
End With
ts.GridColumnStyles.Add(colID)
ts.GridColumnStyles.Add(colName)
ts.GridColumnStyles.Add(colRegion)
DataGrid1.TableStyles.Add(ts)
ts = Nothing
colRegion = Nothing
colName = Nothing
colID = Nothing
End Sub
Private Sub ColumnKeyPress(ByVal sender As System.Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs)
Trace.WriteLine(String.Format("You Press the {0} key", e.KeyChar))
End Sub
Ken
--------------------------------
Hi
Using VB.Net.
We have a datagrid which users can type data directly into, all seems to
work fine but what we want is when a user changes a numeric value in column
3 or 4 (via keypress) we want to call a routine that will change some data
on the screen.
What is the best way of catching the keypress and column number please.
Thanks
