时间戳

首页 > 解决方案 > 在 DataGrid 中的行之间导航

c# - 在 DataGrid 中的行之间导航

问题描述

我创建了一个已加载的 sqlite 数据库，DataGrid但我有两个下一个和上一个按钮，很容易在数据之间导航并将其显示到 Windows 窗体中的相应文本框，DataGridView但我无法找到在DataGrid.

这是我的 sql 数据库代码 -

string dbConnectionString = @"Data Source=emsdatabase.db;version=3;";

将数据加载到 DataGrid 中：

SQLiteConnection sqliteCon = new SQLiteConnection(dbConnectionString);
try
{
    sqliteCon.Open();
    string Query = "select Eid,Name,Mobile,Gender,Email from employeeinfo";
    SQLiteCommand createCommand = new SQLiteCommand(Query, sqliteCon);
    createCommand.ExecuteNonQuery();

    SQLiteDataAdapter dataAdp = new SQLiteDataAdapter(createCommand);
    DataTable dt = new DataTable("employeeinfo");
    dataAdp.Fill(dt);
    TableDataGrid.ItemsSource = dt.DefaultView;
    dataAdp.Update(dt);

    sqliteCon.Close();
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}

我可以在相应的文本框中显示选定的数据：

DataGrid gd = (DataGrid)sender;
DataRowView rowSelected = gd.SelectedItem as DataRowView;
if (rowSelected != null)
{
    EidTextBox.Text = rowSelected["Eid"].ToString();
    NameTextBox.Text = rowSelected["Name"].ToString();
    MobileTextBox.Text = rowSelected["Mobile"].ToString();                
    GenderTextBox.Text = rowSelected["Gender"].ToString();
    EmailTextBox.Text = rowSelected["Email"].ToString();
}

但是无法在下一个或上一个按钮单击时在文本框中显示相应的数据

private void PrevButton_Click(object sender, RoutedEventArgs e)
{
    //?????
}

private void NextButton_Click(object sender, RoutedEventArgs e)
{
    //?????
}

标签： c#wpfdatagrid

解决方案

诀窍是更改 SelectedIndex 或 SelectedItem。

private void PreviousClick(object sender, RoutedEventArgs e)
{
    if (TableDataGrid.SelectedIndex > 0)
        TableDataGrid.SelectedIndex--;
}

private void NextClick(object sender, RoutedEventArgs e)
{
    if (TableDataGrid.SelectedIndex < TableDataGrid.Items.Count - 1)
        TableDataGrid.SelectedIndex++;
}

我们可以在 DataView 中找到上一个和下一个 DataRowView（除非分别选择了第一行或最后一行）。如果可以导航，则更改 DataGrid.SelectedItem：

private void PreviousClick(object sender, RoutedEventArgs e)
{
    DataRowView rowSelected = TableDataGrid.SelectedItem as DataRowView;
    if (rowSelected == null)
        return;
    int idx = GetDataRowViewIndex(rowSelected);
    if (idx > 0)
        TableDataGrid.SelectedItem = rowSelected.DataView[idx - 1];
}

private void NextClick(object sender, RoutedEventArgs e)
{
    DataRowView rowSelected = TableDataGrid.SelectedItem as DataRowView;
    if (rowSelected == null)
        return;
    int idx = GetDataRowViewIndex(rowSelected);
    if (idx < rowSelected.DataView.Count - 1)
        TableDataGrid.SelectedItem = rowSelected.DataView[idx + 1];
}

int GetDataRowViewIndex(DataRowView row)
{
    for (int i = 0; i < row.DataView.Count; i++)
        if (row.DataView[i] == row)
            return i;
    return -1;
}

推荐阅读