110,536
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
string path = "";
try
{
path = filePath.Items[0].ToString();
}
catch (Exception ex)
{
}
DataTable DT = importExcelToDataSet(path, "Sheet1").Tables["[" + "Sheet1" + "$]"];
var q = from u in DT.AsEnumerable()
select u;
if (stuLevel.Text != "无限制")
{
q = q.Where(p => p.Field<string>("学生水平") == stuLevel.Text);
}
if (schLevel.Text != "无限制")
{
q = q.Where(p => p.Field<string>("学校等级") == schLevel.Text);
}
if (sex.Text != "无限制")
{
q = q.Where(p => p.Field<string>("学生性别") == sex.Text);
}
if (stuNum.Text != "无限制")
{
q = q.Where(p => p.Field<string>("学生人数") == stuNum.Text);
}
if (major.Text != "无限制")
{
q = q.Where(p => p.Field<string>("学生专业") == major.Text);
}
if (topic.Text != "无限制")
{
q = q.Where(p => p.Field<string>("话题类别") == topic.Text);
}
q.ToList();
dataGridView1.DataSource = q.CopyToDataTable();
}