111,094
社区成员




using (IDbConnection conn = DbProviderFactories.GetFactory(connStr.ProviderName).CreateConnection())
{
conn.ConnectionString = connStr.ConnectionString;
var sql = "select * from EMP,DEPT where EMP.deptno=DEPT.deptno";
var list = conn.Query<Model.EMP, Model.DEPT, Model.EMP>(sql, (EMP, DEPT) => { return EMP; }, null, null, true, "DEPTNO");
if (list.Count() == 0)
{
MessageBox.Show("没有查询到数据!"); return;
}
dataGridViewDemo.DataSource = list;
}
using (IDbConnection conn = DbProviderFactories.GetFactory(connStr.ProviderName).CreateConnection())
{
conn.ConnectionString = connStr.ConnectionString;
var list = conn.Query("select EMP.* from EMP,DEPT where EMP.deptno=DEPT.deptno");
if (list.Count() == 0)
{
MessageBox.Show("没有查询到数据!"); return;
}
dataGridViewDemo.DataSource = list;
}