我有一个数据表,其中只有一列包含姓名。我想将下拉框与数据表一起加载,使得姓名按字母顺序排列,例如:以a开头的名字排在第一个,以b开头的名字排在第二个。我该如何对数据表进行排序?有人能帮忙吗?
我有一个数据表,其中只有一列包含姓名。我想将下拉框与数据表一起加载,使得姓名按字母顺序排列,例如:以a开头的名字排在第一个,以b开头的名字排在第二个。我该如何对数据表进行排序?有人能帮忙吗?
使用DataView:
DataTable dt; //comes from somewhere...
DataView dv = new DataView(dt)
dv.Sort = "Name ASC";
foreach(DataRowView drv in dv)
//....
方法一
// orderby "FistName" column
EnumerableRowCollection<DataRow> query =
from order in datatable.AsEnumerable()
orderby datatable.Field<string>("FirstName")
select datatable;
DataView view = query.AsDataView();
// bind to your combobox
combobox.DataSource = view;
combobox.DataBind()
方法二: 如果使用数据集(DataSets)
DataTable datatable = dataSet.Tables["yourDataTable"];
DataView view = datatable .AsDataView();
view.Sort = "FirstName desc, LastName desc";
combobox.DataSource = view;
combobox.DataBind();
DataTable MyDataTable;
const string SortByClause = "[SomeCol] ASC";
MyDataTable.DefaultView.Sort = SortByClause ;
DsAppointment dsAppointmentTmp = new DsAppointment();
DsAppointment dsAppointment = new DsAppointment();
//add all appointment
dsAppointmentTmp.Appointment.AddAppointmentRow(name,start,end,body)
//use select(filter,sort(name of columns)
DataRow[] rows1 = dsAppointmentTmp.Tables[0].Select(string.Empty, dsAppointmentTmp.Tables[0].Columns[1].ToString());
foreach (DataRow thisRow in rows1)
{
dsAppointment.Tables[0].Rows.Add(thisRow.ItemArray);
}
//返回已排序的dsAppointment return dsAppointment;