public void GetList <T>(string sQuery, TGenerateListFormReader <T> hnd, ref List <T> listData)
{
DbCommand objCommand;
try
{
objCommand = GetDbCommand(sQuery);
if (objCommand == null)
{
return;
}
objCommand.CommandType = CommandType.Text;
DbDataReader objReader = objCommand.ExecuteReader();
hnd(objReader, ref listData);
objReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
}
public void GetList <T>(string sQuery, CommandType cmdtype, DbParameter[] parms, TGenerateListFormReader <T> hnd, ref List <T> listData)
{
DbCommand objCommand;
try
{
objCommand = GetDbCommand(sQuery);
if (objCommand == null)
{
return;
}
objCommand.CommandType = cmdtype;
objCommand.Parameters.AddRange(parms);
DbDataReader objReader = objCommand.ExecuteReader();
hnd(objReader, ref listData);
objReader.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
}
