🚀 go-pugleaf

Hi,

I've created an .aspx page which dynamically opens tables in a DataGrid.
The problem I'm facing is adding a EditCommandColumn to the grid so I can 
edit the data.

This is how I'm populating the grid:

procedure TWebForm1.PopulateGrid;
var
  sqlcn : SQLConnection;
  sqlda : SqlDataAdapter;
  ds : DataSet;
  dt : DataTable;
  SQL : String;
  connect : String;
  EdtCmdCol : EditCommandColumn;
begin
  Connect := 
'server=***.***.***.***;database='+DrpDwnCountry.SelectedItem.Text+';user 
ID=*******;password=*******';
  SQL := 'SELECT * FROM '+DrpDwnIndustry.SelectedItem.Text;
  sqlcn := SqlConnection.Create(Connect);
  sqlcn.Open;
  try
    Sqlda := SqlDataAdapter.Create(SQL,sqlcn);
    ds := DataSet.Create;
    sqlDa.Fill(ds,'a');
    dt := ds.Tables['a'];
    DataGrid1.DataSource := dt.DefaultView;

  {Here I try to add the column}
    EdtCmdCol := EditCommandColumn.Create;
    EdtCmdCol.EditText := 'Edit';
    EdtCmdCol.CancelText := 'Cancel';
    EdtCmdCol.UpdateText := 'Update';
    EdtCmdCol.ButtonType := ButtonColumnType.PushButton;
    EdtCmdCol.Visible := True;
    DataGrid1.Columns.Add(EdtCmdCol);

    DataBind;
  finally
    sqlcn.Close;
  end;
end;

This results in the first column of the grid being a column with an edit 
button in each row.
When I press the edit button everything in the grid jumps one column to the 
left and the edit buttons disappear.

This is the EditCommand event:

procedure TWebForm1.DataGrid1_EditCommand(source: System.Object; e: 
System.Web.UI.WebControls.DataGridCommandEventArgs);
begin
  DataGrid1.EditItemIndex := e.Item.ItemIndex;
  PopulateGrid;
end;

Can anyone tell me what I'm doing wrong?

thanks,
  nisbus