如何在C#中的数据表中来回转换 [英] How to go back and forth in datatable in C#
问题描述
大家好。我有两个按钮 btn_Next
和 btn_Back
和 DataTable
这是通过适配器从数据库填充的。
我希望在填充数据库后我按 btn_Next
或 btn_Back
我可以遍历行,所以如果我按 btn_Next
必须选择行索引1作为响应,如果我按 btn_Back
行索引0等等。
我尝试过:
我试图计算数据行的行数,然后将其用作数据行的长度,并且每次点击 btn_Next
或 btn_Back
我相应地增加或减少索引。但我不知道在哪里使用这个索引以及如何使用。
Hello guys.I have a two buttons btn_Next
and btn_Back
and DataTable
which is populated from database through a Adapter.
I want that after Database is Populated When i pressbtn_Next
or btn_Back
i can iterate over rows so if i press btn_Next
row index 1 must be selected in response and if i press btn_Back
rows index 0 and so on.
What I have tried:
I tried to count rows of datatable and then use it as length of datatable rows and for every click on btn_Next
or btn_Back
i m increasing or decreasing index accordingly.but i don't know where to use this index and how to use.
推荐答案
private int _currRow =0; // declared in the class before any methods
private Datatable _theData // instaniated somewhere in the class
private DataRow _dataRow;
private DataRow btn_Next_clicked(object sender, EventArgs e)
{
if(_currRow<_theData.Rows.Count)
{
++_currRow;
}
_dataRow =_theTable.Rows[_currRow];
}
我将为您保留上一个按钮操作
I'll leave the prev button action for you
这篇关于如何在C#中的数据表中来回转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!