mysql dataadapter.fill_C#使用MySqlDataAdapter作为数据源时保持DataGrid的选择

我的目标是保持选择后，数据已刷新。

这是我当前的代码，我如何将数据加载到数据网格视图中。public void RefreshGrid()

{

try

{

// MySQL connection string

using (var conn = new MySqlConnection(ConnectionString.ConnString))

{

using (var mySqlDataAdapter = new MySqlDataAdapter("select id, customer from table;", conn))

{

using (var dataSet = new DataSet())

{

DataSet DS = new DataSet();

mySqlDataAdapter.Fill(DS);

labelOrderData.DataSource = DS.Tables[0];

labelOrderData.Columns[0].HeaderText = "ID";

labelOrderData.Columns[1].HeaderText = "Customer";

labelOrderData.Columns[0].Visible = false;

}

}

}

}

catch(Exception ex)

{

MessageBox.Show(ex.ToString(), "Refresh - Error",