linq to datatable Distinct
填充至 combobox
DSTableAdapters.AdjMkApplyTableAdapter adtMkApp = new StockCheck.DSTableAdapters.AdjMkApplyTableAdapter();
DS.AdjMkApplyDataTable dtMkApp = adtMkApp.GetData();
var q = (from c in dtMkApp.AsEnumerable()
select c.mkStatus).Distinct();
if (q.AsQueryable().Count() > 0)
{
foreach (string items in q)
{
cbxMkStatus.Items.Add(items);
}
cbxMkStatus.SelectedIndex = 0;
}