110,538
社区成员
发帖
与我相关
我的任务
分享
//先上我的代码吧(这个可以排序):
//按奖金的升序排序.
void OrderDataByPriceAscending(object sender, EventArgs e) {
var sorted = from employee in set.Tables["T_Employee"].AsEnumerable()
orderby employee.Field<int>("FAge") ascending
select employee;
dataGV.DataSource = sorted.AsDataView();
}
//(这个不可以排序)
//按奖金的升序排序.
void OrderDataByPriceAscending(object sender, EventArgs e) {
var sorted = from employee in set.Tables["T_Employee"].AsEnumerable()
orderby employee.Field<float>("FPrice") ascending
select employee;
dataGV.DataSource = sorted.AsDataView();
}
public partial class Form1: Form {
private string _strConn = @"Data Source=.\SQLExpress;Initial Catalog=DB_Person;Integrated Security=True"; //连接字符串.
private LinqToSQLServerAdderDataContext _linq; //Linq对象.
public Form1() {
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e) {
ShowPerson();
}
private void btnAdd_Click(object sender, EventArgs e) {
T_Person p = new T_Person(); //新增的对象.
p.FName = txtName.Text;
p.FAge = int.Parse(txtAge.Text);
_linq.T_Persons.InsertOnSubmit(p);
_linq.SubmitChanges();
ShowPerson(); //新增后重显示.
}
//显示数据.
void ShowPerson() {
_linq = new LinqToSQLServerAdderDataContext(_strConn);
var result = from person in _linq.T_Persons
select new {
序号 = person.FId,
姓名 = person.FName,
年龄 = person.FAge
};
dataGV.DataSource = result;
}
}
[/quote]
是的,但如果有分层就更好了~
搜搜 三层架构public partial class Form1: Form {
private string _strConn = @"Data Source=.\SQLExpress;Initial Catalog=DB_Person;Integrated Security=True"; //连接字符串.
private LinqToSQLServerAdderDataContext _linq; //Linq对象.
public Form1() {
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e) {
ShowPerson();
}
private void btnAdd_Click(object sender, EventArgs e) {
T_Person p = new T_Person(); //新增的对象.
p.FName = txtName.Text;
p.FAge = int.Parse(txtAge.Text);
_linq.T_Persons.InsertOnSubmit(p);
_linq.SubmitChanges();
ShowPerson(); //新增后重显示.
}
//显示数据.
void ShowPerson() {
_linq = new LinqToSQLServerAdderDataContext(_strConn);
var result = from person in _linq.T_Persons
select new {
序号 = person.FId,
姓名 = person.FName,
年龄 = person.FAge
};
dataGV.DataSource = result;
}
}