public static object Exist_DB(string query, string HoleID, decimal FromV) { try { object oRes; SqlParameter[] arr = oData.GetParameters(2); arr[0].ParameterName = "@HoleID"; arr[0].Value = HoleID; arr[1].ParameterName = "@SKDHSamples"; arr[1].Value = FromV; oRes = oData.ExecuteScalar(query, arr, CommandType.Text); return(oRes); } catch (Exception eX) { throw new Exception("Save error LabSubmitIn. " + eX.Message);; } }
public DataTable getRfVeinsCodes() { DataTable result; try { DataSet dataSet = new DataSet(); SqlParameter[] parameters = oData.GetParameters(0); dataSet = oData.ExecuteDataset("[dbo].[usp_getRfVeinsCodes]", parameters, CommandType.StoredProcedure); result = dataSet.Tables[0]; } catch (Exception ex) { throw new Exception("Error in dtRfVeinsCodesAll: " + ex.Message); } return(result); }