why GetDataRow returned null ?!

Hi Mohammad,

i think the specific row handle might not map to a data row, resulting in a null return value.

 

please try below code

private void from_Analysis_Load(object sender, EventArgs e)
{
    var db = new DAL.dbDataContext();
    var query = (from anaSheet in db.AnalysisSheets
                 select new DB
                 {
                     ID = anaSheet.ID,
                     Name = anaSheet.Name,
                     Price = anaSheet.Price
                 }).ToList();

    gridControl1.DataSource = query;

    Master.gridViewColumnsColor(gridView1, gridControl1);
    gridView1.DoubleClick += GridView1_DoubleClick;
}

private void GridView1_DoubleClick(object sender, EventArgs e)
{
    foreach (int rowHandle in gridView1.GetSelectedRows())
    {
        if (rowHandle < 0 || rowHandle >= gridView1.DataRowCount)
        {
            continue; // Skip invalid row handles
        }

        DataRow row = gridView1.GetDataRow(rowHandle);
        if (row == null)
        {
            continue; // Skip null rows
        }

        // Proceed with valid, non-null rows
        gridView2.AddNewRow();
        int newRowHandle = gridView2.GetDataSourceRowIndex(gridView2.DataRowCount);
        gridView2.SetRowCellValue(newRowHandle, "ID", row["ID"]);
        gridView1.DeleteRow(rowHandle);
    }
}

Accept the answer if it resolves your issue.