public byte[] GetCompressDataSet(ref string err, string strDB, string strSQL) { byte[] bArranyResult = null; try { bArranyResult = DataSetCompression.CompressionDataSet(SqlHelper.ExecuteDataset(this.GetConStr(strDB), CommandType.Text, strSQL)); } catch (Exception ee) { err = ee.Message.ToString(); } return(bArranyResult); }
public byte[] GetOtherByte(ref string err, string strDB, string strSQL, Hashtable htParm) { byte[] bArranyResult = null; try { SqlParameter[] sqlParm = new SqlParameter[htParm.Count]; int i = 0; foreach (DictionaryEntry de in htParm) { sqlParm[i] = new SqlParameter(de.Key.ToString(), de.Value); i++; } bArranyResult = DataSetCompression.CompressionDataSet(SqlHelper.ExecuteDataset(this.GetConStr(strDB), CommandType.Text, strSQL, sqlParm)); } catch (Exception ee) { err = ee.Message.ToString(); } return(bArranyResult); }