public string GetString(int iSeGroupID )
{
string sTempTitle; sSQL = "select [栏目标识]=A.GROUPID,[栏目名称]=A.GROUPNAME from WQ_NEWSGROUP_S A left join WQ_NEWINFO_S B on A.GROUPID=B.GROUPID where A.GROUPID=" + iSeGroupID + " order by B.POSTDATE desc"; oCmd = new System.Data.SqlClient.SqlCommand(sSQL, oConn);
oReader = oCmd.ExecuteReader();
while (oReader.Read())
{
sTempTitle =sTempTitle+oReader["新闻标题"])
}
}用EnterpriseLibrary 类库怎么改写这段代码??
{
string sTempTitle; sSQL = "select [栏目标识]=A.GROUPID,[栏目名称]=A.GROUPNAME from WQ_NEWSGROUP_S A left join WQ_NEWINFO_S B on A.GROUPID=B.GROUPID where A.GROUPID=" + iSeGroupID + " order by B.POSTDATE desc"; oCmd = new System.Data.SqlClient.SqlCommand(sSQL, oConn);
oReader = oCmd.ExecuteReader();
while (oReader.Read())
{
sTempTitle =sTempTitle+oReader["新闻标题"])
}
}用EnterpriseLibrary 类库怎么改写这段代码??
解决方案 »
- 德广火车票助手登录12306代码详解-登录
- foreach一组Button,在其中调用每个Button的click事件的代码要如何写?
- 本地机器上的两个进程,互相发一些短的消息,请问用哪种通信方式好呢?匿名管道,命名管道还是消息机制?原因是什么?好实现吗?
- 有个难题,帮忙解决一下!谢谢!
- 在WebCustomerControl中能引用其它的服务器端WebControl吗?
- 如何设置“竖着放”的字体?
- 接口 AxPlayer._AxPlayer1 的queryinterface 失败,高分求解!!
- 怎么使用API操作菜单栏?
- for(i=pointIndex;i>0;i--)result/=10;for(i=pointIndex;i>0;i--,result/=10);区别在那?
- 看谁能答得出我这个问题我散分~
- 请教高手成绩的正则表达式怎么写,谢谢!!!
- 连接符(&)如何存储在资源文件(.resx)中?
{
StringBuilder sTempTitle = new StringBuilder();
Database db = DatabaseFactory.CreateDatabase();
sSQL = "select [栏目标识]=A.GROUPID,[栏目名称]=A.GROUPNAME from WQ_NEWSGROUP_S A left join WQ_NEWINFO_S B on A.GROUPID=B.GROUPID where A.GROUPID=" + iSeGroupID + " order by B.POSTDATE desc"; DBCommandWrapper dbCommandWrapper = db.GetSqlStringCommandWrapper(sSQL );
using (IDataReader dataReader = db.ExecuteReader(dbCommandWrapper))
{
while (dataReader.Read())
{
sTempTitle.Append(dataReader["新闻标题"])
}
}
return sTempTitle.ToString();
}
--谢谢saucer(思归)
--感动,测试后,马上就接贴!!!!!