int name = Convert.ToInt32(textBox1.Text.Trim());
DataClasses1DataContext db = new DataClasses1DataContext();
var student = from content in db.tb_Student
join category in db.tb_chengji on
content.xuehao equals category.xuehao
where category.chengji== name
select new
{
name = content.name,
nianling = content.nianling,
chengji = category.chengji
};
dataGridView1.DataSource = student;