editing datagridview cells

[svibuk]

Dim cmd As New SqlCommand(SQLSTR, conn)
reader = cmd.ExecuteReader()

Dim myDataTable As New DataTable
myDataTable.Load(reader)

If myDataTable.Rows.Count > 0 Then

datagridview1.DataSource = myDataTable
datagridview1.Columns(2).HeaderText = "QUANTITY"

datagridview1.AllowUserToAddRows = False
datagridview1.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2

datagridview1.Focus()
datagridview1.CurrentCell = datagridview1(2, 0)
datagridview1.BeginEdit(True)

Else
datagridview1.DataSource = myDataTable
End If

m_reader.Close()
cmd.Dispose()

i hve the follwoing code by which i bind the data to the grid
the grid has 4 columns PRODUCTNAME, QTY,RATE, AMOUNT

the user shld be able to edit the data in the column qty for as many rows it has
but i m not able to edit this column
how do i edit the values in the cells of column(1) ie qty

[marcellus7]

An easier way to do this would be to use the BindingSource tool. You can simply set your dataset to the BindingSource, and set your DataGrid datasource to the BindingSource, and it will automatically handle the functions that would allow a user to edit the data in the DataGrid, and you could modify it by just using the properties of the datagrid.