use DataViewDataView dv = new DataView(DataSet1.Tables["rsda"]); dv.RowFilter = "dm = '11'"; for(int i=0; i < dv.Count; i++) { DataRow dr = dv[i].Row; }
ds.Tables [0].Select ("dm='11'")
to 思归大哥:一定要加循环么 use DataViewDataView dv = new DataView(DataSet1.Tables["rsda"]); dv.RowFilter = "dm = '11'"; for(int i=0; i < dv.Count; i++) { DataRow dr = dv[i].Row; }
that is just an example, if you only need the first one, you can just do DataView dv = new DataView(DataSet1.Tables["rsda"]); dv.RowFilter = "dm = '11'"; DataRow dr = null; if (dv.Count > 0) { dr = dv[0].Row; //... }
DataView dv = new DataView(DataSet1.Tables["rsda"]); dv.RowFilter = "dm = '11'"; 然后把dv绑定到你想绑定的控件 如datagrid.DataSource=dv;
dv.RowFilter = "dm = '11'";
for(int i=0; i < dv.Count; i++)
{
DataRow dr = dv[i].Row;
}
ds.Tables [0].Select ("dm='11'")
use DataViewDataView dv = new DataView(DataSet1.Tables["rsda"]);
dv.RowFilter = "dm = '11'";
for(int i=0; i < dv.Count; i++)
{
DataRow dr = dv[i].Row;
}
DataView dv = new DataView(DataSet1.Tables["rsda"]);
dv.RowFilter = "dm = '11'";
DataRow dr = null;
if (dv.Count > 0)
{
dr = dv[0].Row;
//...
}
dv.RowFilter = "dm = '11'";
然后把dv绑定到你想绑定的控件
如datagrid.DataSource=dv;