public System.Data.SqlClient.SqlDataReader RunProcedure(string storedProcName, System.Data.IDataParameter[] parameters) { System.Data.SqlClient.SqlDataReader result; using (System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(this.connectionString)) { sqlConnection.Open(); System.Data.SqlClient.SqlCommand sqlCommand = DbHelperSQLP.BuildQueryCommand(sqlConnection, storedProcName, parameters); sqlCommand.CommandType = System.Data.CommandType.StoredProcedure; System.Data.SqlClient.SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection); result = sqlDataReader; } return(result); }
public System.Data.DataSet RunProcedure(string storedProcName, System.Data.IDataParameter[] parameters, string tableName) { System.Data.DataSet result; using (System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(this.connectionString)) { System.Data.DataSet dataSet = new System.Data.DataSet(); sqlConnection.Open(); new System.Data.SqlClient.SqlDataAdapter { SelectCommand = DbHelperSQLP.BuildQueryCommand(sqlConnection, storedProcName, parameters) }.Fill(dataSet, tableName); sqlConnection.Close(); result = dataSet; } return(result); }
private static System.Data.SqlClient.SqlCommand BuildIntCommand(System.Data.SqlClient.SqlConnection connection, string storedProcName, System.Data.IDataParameter[] parameters) { System.Data.SqlClient.SqlCommand sqlCommand = DbHelperSQLP.BuildQueryCommand(connection, storedProcName, parameters); sqlCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("ReturnValue", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, 0, 0, string.Empty, System.Data.DataRowVersion.Default, null)); return(sqlCommand); }