对于IBatisnet执行查询返回DataTable,网上有很多代码,下面简单列出一下:
private IDbCommand GetDbCommand(string statementName, object paramObject)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
IStatement statement = sqlMap.GetMappedStatement(statementName).Statement;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
IMappedStatement mapStatement = sqlMap.GetMappedStatement(statementName);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
IDalSession session = new SqlMapSession(sqlMap);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (sqlMap.LocalSession != null)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session = sqlMap.LocalSession;
}
else
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session = sqlMap.OpenConnection();
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
RequestScope request = statement.Sql.GetRequestScope(mapStatement, paramObject, session);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
mapStatement.PreparedCommand.Create(request, session, statement, paramObject);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return request.IDbCommand;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
/// 通用的以DataTable的方式得到Select的结果(xml文件中参数要使用$标记的占位参数)
/// </summary>
/// <param name="statementName">语句ID</param>
/// <param name="paramObject">语句所需要的参数</param>
/// <returns>得到的DataTable</returns>
protected DataTable ExecuteQueryForDataTable(string statementName, object paramObject)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DataSet ds = new DataSet();
bool isSessionLocal = false;
IDalSession session = sqlMap.LocalSession;
if (session == null)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session = new SqlMapSession(sqlMap);
session.OpenConnection();
isSessionLocal = true;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
IDbCommand cmd = GetDbCommand(statementName, paramObject);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
try
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
cmd.Connection = session.Connection;
IDbDataAdapter adapter = session.CreateDataAdapter(cmd);
adapter.Fill(ds);
}
finally
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (isSessionLocal)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session.CloseConnection();
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return ds.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
理论上来说是没任何问题的,但前几天我做了有Output参数的存储过程来返回DataTable,如果用上面的ExecuteQueryForDataTable方法就会获得不到Output的参数,因为它在返回值的时候没有用到IBatisNet内部的方法了,所以上面的方法严谨的写法应该改成下面这样:
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
/// 通用的以DataTable的方式得到Select的结果(xml文件中参数要使用$标记的占位参数)
/// </summary>
/// <param name="statementName">语句ID</param>
/// <param name="paramObject">语句所需要的参数</param>
/// <param name="htOutPutParameter)">Output参数值哈希表</param>
/// <returns>得到的DataTable</returns>
protected DataTable ExecuteQueryForDataTable(string statementName, object paramObject, out Hashtable htOutPutParameter)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DataSet ds = new DataSet();
bool isSessionLocal = false;
IDalSession session = sqlMap.LocalSession;
if (session == null)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session = new SqlMapSession(sqlMap);
session.OpenConnection();
isSessionLocal = true;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
IDbCommand cmd = GetDbCommand(statementName, paramObject);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
try
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
cmd.Connection = session.Connection;
IDbDataAdapter adapter = session.CreateDataAdapter(cmd);
adapter.Fill(ds);
}
finally
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (isSessionLocal)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
session.CloseConnection();
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (IDataParameter parameter in cmd.Parameters)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (parameter.Direction == ParameterDirection.Output)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
htOutPutParameter[parameter.ParameterName] = parameter.Value;
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return ds.Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}