C#AutoSize DatagridView由Linq查询填充 [英] C# AutoSize DatagridView Populated By Linq Query
本文介绍了C#AutoSize DatagridView由Linq查询填充的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
public static IQueryable SearchByDepartmentNameInfo(string deptName)
{
ExamineDataContext dc = new ExamineDataContext();
var queryResult = from d in dc.GetTable< Question>()
其中q.Topic.Module.Department.DepartmentName.Equals(deptName)
在dc中连接。解决方案
在q.QuestionID等于s.QuestionID
到qs //注意分组
选择新
{
Module = q.Topic.ModuleTitle,
主题= q.TopicName,
问题= q.QuestionText,
QuestionType = q.QuestionType,
};
return queryResult;
}
dataGridView1.DataSource = Repository.SearchByDepartmentNameInfo(Computer Science);
我希望datagridview根据查询返回的数据自动调整列的大小。 >
非常感谢。
解决方案
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill ;
I have a datagridview control that is populated by a linq query:
public static IQueryable SearchByDepartmentNameInfo(string deptName)
{
ExamineDataContext dc = new ExamineDataContext();
var queryResult = from q in dc.GetTable<Question>()
where q.Topic.Module.Department.DepartmentName.Equals(deptName)
join s in dc.Solutions
on q.QuestionID equals s.QuestionID
into qs // note grouping
select new
{
Module = q.Topic.ModuleTitle,
Topic = q.TopicName,
Question = q.QuestionText,
QuestionType = q.QuestionType,
};
return queryResult;
}
dataGridView1.DataSource = Repository.SearchByDepartmentNameInfo("Computer Science");
I want the datagridview to automatically resize the columns based on the data returned from the query.
Help appreciated greatly.
解决方案
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
这篇关于C#AutoSize DatagridView由Linq查询填充的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文