How to obtain a data row and move it to another grid

Biggest Thanks for you mister 
but i use linq not SqlConnection how to use it with this code 

Step 1: Set up your GridControls

Assuming you have gridControl1 and gridControl2 on your form, and both are connected to their respective data sources.

Step 2: Load Data into gridControl1

First, you need to load data from TableA in your SQL Server database into gridControl1.

// Method to load data from TableA
private void LoadDataGrid1()
{
    string connectionString = "your_connection_string_here";
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        string query = "SELECT * FROM TableA";
        SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
        DataTable dataTable = new DataTable();
        adapter.Fill(dataTable);
        gridControl1.DataSource = dataTable;
    }
}

Step 3: Select Rows and Move them to gridControl2

Next, you need to handle the click event to move selected rows from gridControl1 to gridControl2.

// Click event to move selected rows from gridControl1 to gridControl2
private void btnMoveToGrid2_Click(object sender, EventArgs e)
{
    DataTable grid2DataTable = gridControl2.DataSource as DataTable;
    if (grid2DataTable == null)
    {
        grid2DataTable = (gridControl1.DataSource as DataTable).Clone(); // Clone structure of gridControl1 DataTable
        gridControl2.DataSource = grid2DataTable;
    }

    int[] selectedRows = gridView1.GetSelectedRows();
    foreach (int rowHandle in selectedRows)
    {
        DataRow row = gridView1.GetDataRow(rowHandle);
        grid2DataTable.ImportRow(row);
    }

    foreach (int rowHandle in selectedRows.OrderByDescending(v => v)) 
    {
        gridView1.DeleteRow(rowHandle);
    }
}

Step 4: Move Rows Back to gridControl1

Similarly, you need to handle the click event to move rows back from gridControl2 to gridControl1.

// Click event to move selected rows from gridControl2 to gridControl1
private void btnMoveToGrid1_Click(object sender, EventArgs e)
{
    DataTable grid1DataTable = gridControl1.DataSource as DataTable;
    int[] selectedRows = gridView2.GetSelectedRows();
    foreach (int rowHandle in selectedRows)
    {
        DataRow row = gridView2.GetDataRow(rowHandle);
        grid1DataTable.ImportRow(row);
    }

    foreach (int rowHandle in selectedRows.OrderByDescending(v => v)) 
    {
        gridView2.DeleteRow(rowHandle);
    }
}

Step 5: Save Data from gridControl2 to TableB

Finally, you can save the data from gridControl2 to TableB in your SQL Server database.

// Method to save data from gridControl2 to TableB
private void SaveDataGrid2ToDB()
{
    DataTable grid2DataTable = gridControl2.DataSource as DataTable;
    if (grid2DataTable == null || grid2DataTable.Rows.Count == 0)
    {
        MessageBox.Show("No data to save.");
        return;
    }

    string connectionString = "your_connection_string_here";
    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        conn.Open();
        using (SqlTransaction transaction = conn.BeginTransaction())
        {
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn, SqlBulkCopyOptions.Default, transaction))
            {
                bulkCopy.DestinationTableName = "TableB";
                try
                {
                    bulkCopy.WriteToServer(grid2DataTable);
                    transaction.Commit();
                    MessageBox.Show("Data saved successfully.");
                }
                catch (Exception ex)
                {
                    transaction.Rollback();
                    MessageBox.Show($"Error: {ex.Message}");
                }
            }
        }
    }
}

Step 6: Add Event Handlers

Don't forget to wire up your button click events to the appropriate handlers.

public Form1()
{
    InitializeComponent();
    LoadDataGrid1();

    btnMoveToGrid2.Click += new EventHandler(btnMoveToGrid2_Click);
    btnMoveToGrid1.Click += new EventHandler(btnMoveToGrid1_Click);
    btnSaveToDB.Click += new EventHandler(SaveDataGrid2ToDB);
}

1. Load data from TableA into gridControl1.
2. Move selected rows from gridControl1 to gridControl2.
3. Move rows back from gridControl2 to gridControl1 if needed.
4. Save the data from gridControl2 to TableB in your SQL Server database.

By following these steps, you should be able to move data between two DevExpress GridControls and save the data to a SQL Server table.