DataTable ds = new DataTable();
ds = CD.getDatabySQL("select A_ID,A_T_ID,A_TITLE,A_DETAILS,A_DATE,UPLOADFILE,NAME from ARTICLE left join ARTICLE_TYPE on ARTICLE.A_T_ID=ARTICLE_TYPE.ID order by A_ID desc");
this.DataList.DataSource = ds;
this.DataList.DataBind();
就这几行代码
public DataTable getDatabySQL(string sql)
{
Database db = null;
db = DatabaseFactory.CreateDatabase("Data");
DbCommand DbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(DbCommand);
return ds.Tables[0];
}
这是返回数据集的函数
[Quote=引用 10 楼 csplayer_hello 的回复:]
DataTable ds = new DataTable();
ds = CD.getDatabySQL("select A_ID,A_T_ID,A_TITLE,A_DETAILS,A_DATE,UPLOADFILE,NAME from ARTICLE left join ARTICLE_TYPE on ARTICLE.A_T_ID=ARTICLE_TYPE.ID order by A_ID desc");
this.DataList.DataSource = ds;
this.DataList.DataBind();
就这几行代码
public DataTable getDatabySQL(string sql)
{
Database db = null;
db = DatabaseFactory.CreateDatabase("Data");
DbCommand DbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(DbCommand);
return ds.Tables[0];
}
这是返回数据集的函数
[/Quote]
[Quote=引用 10 楼 csplayer_hello 的回复:]
DataTable ds = new DataTable();
ds = CD.getDatabySQL("select A_ID,A_T_ID,A_TITLE,A_DETAILS,A_DATE,UPLOADFILE,NAME from ARTICLE left join ARTICLE_TYPE on ARTICLE.A_T_ID=ARTICLE_TYPE.ID order by A_ID desc");
this.DataList.DataSource = ds;
this.DataList.DataBind();
就这几行代码
public DataTable getDatabySQL(string sql)
{
Database db = null;
db = DatabaseFactory.CreateDatabase("Data");
DbCommand DbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(DbCommand);
return ds.Tables[0];
}
这是返回数据集的函数
[/Quote]
ORACLE里的左连接不用LEFT JOIN 用加号就可以了
SELECT A.* FROM TA A,TB B WHERE A.COL1=B.COL1(+)