internal static DataTable AdapterFill(string sprocName) { DataTable dataTable = new DataTable(); try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { sda.Fill(dataTable); } } } catch (Exception ex) { DBCommands.RecordError(ex); } finally { EmptyParams(); } return(dataTable); }
internal static bool ExecuteNonQuery(string sprocName) { try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } con.Open(); cmd.ExecuteNonQuery(); return(true); } } catch (Exception ex) { DBCommands.RecordError(ex); return(false); } finally { EmptyParams(); } }
internal static string ExecuteScalar(string sprocName) { try { using (SqlConnection con = new SqlConnection(_Connection)) { SqlCommand cmd = new SqlCommand(sprocName, con); cmd.CommandType = CommandType.StoredProcedure; for (int index = 0; index < _ParamName.Count; index++) { cmd.Parameters.AddWithValue(_ParamName[index], _ParamValue[index]); } con.Open(); var result = cmd.ExecuteScalar(); if (result != null) { return(result.ToString()); } else { return(null); } } } catch (Exception ex) { DBCommands.RecordError(ex); return(null); } finally { EmptyParams(); } }