DataTable的选择 [英] DataTable Select
本文介绍了DataTable的选择的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何使用一个DataTable的选择方法只获取以'M'用户名。让我们假设UserNameTextBox有一个字符串的 M
How can I use Select method of a DataTable just to fetch UserNames starting with 'M'. Lets assume that UserNameTextBox has a string M
oDataTable.Select("UserName = '" + UserNameTextBox.Text + "'");
DataView oDataView = oDataTable.DefaultView;
oDataView.Sort = "UserName";
UserGridView.DataSource = oDataView;
UserGridView.DataBind();
当我输入全名成文本,这点我敢肯定DataTable包含,它列出一切不只是我所输入的。有人可以帮我吗?
and when I typed full name into textbox, which I am sure DataTable contains, it list everything not just what I typed. Can someone help me please?
推荐答案
您既可以使用的 DataTable.Select
,的 DatView.RowFilter
方法或的 LINQ到数据集
:
You could either use the DataTable.Select
, DatView.RowFilter
methods or LINQ-to-DataSet
:
LINQ:
var tblFiltered = (from row in oDataTable.AsEnumerable()
where row.Field<String>("UserName").Contains(UserNameTextBox.Text)
select row).CopyToDataTable();
ADO.NET(DataTable.Select):
ADO.NET(DataTable.Select):
DataRow[] filteredRows = oDataTable.Select("UserName LIKE '%" + UserNameTextBox.Text + "%'");
ADO.NET(DataView.RowFilter):
ADO.NET(DataView.RowFilter):
oDataView.RowFilter = "UserName LIKE '%" + UserNameTextBox.Text + "%'";
这篇关于DataTable的选择的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文