stringSelect为sql语句,DataSetResult为DataSet ,stringTableName为结果存放table
public bool ExecQueryDataSet(string stringSelect,DataSet DataSetResult,string stringTableName)
{
if(!OpenConnection())
{
return false;
}
bool bSuccessed = true;
try
{
SqlCommand SqlCommandInfo = new SqlCommand();
SqlCommandInfo.Connection = m_SqlConnectionInfo;
SqlCommandInfo.CommandType = CommandType.Text;
SqlDataAdapter SqlDataAdapterInfo = new SqlDataAdapter(SqlCommandInfo);
SqlCommandInfo.CommandText = stringSelect;
SqlDataAdapterInfo.Fill(DataSetResult,stringTableName);
}
catch(Exception /*ex*/)
{
bSuccessed = false;
}
CloseConnection();
if(DataSetResult.Tables[stringTableName].Rows.Count == 0)
{
bSuccessed = false;
}
return bSuccessed;
}