New Post: How to configure Paulovich.Data

paulovich — Fri, 27 Mar 2009 19:56:03 GMT

The connectionString must be named "dbPortal".

NEW POST: Using our Stored Procedures

paulovich — Mon, 25 Feb 2008 18:03:45 GMT

Lets execute the procedure spExecuteProcedure like that:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE spExecuteProcedure
@param1 int,
@param2 varchar(50),
@param3 smalldatetime
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO T_TEST (field1,field2 ,field3)
VALUES(@param1 ,@param2 ,@param3)
END
GO

public void ExecuteProcedures(int param1, string param2, DateTime param3) {

//declare a Paulovich Command object
Command command = new Command();

try {

//define a CommandType on Enumerator
command.CommandType = CommandType.StoredProcedure;

//add values to object
command.AddWithValue("param1", param1);
command.AddWithValue("param2", param2);
command.AddWithValue("param3", param3);

//execute the procedure easily
command.ExecuteNonQuery("spExecuteProcedure");

} catch (Exception) {
throw;
}

}

NEW POST: How to configure Paulovich.Data

ivanpaulovich — Sat, 23 Feb 2008 17:27:04 GMT

Follow this steps:

Add Paulovich.Data.dll reference
Set ConnectionString in web.config

paulovich Forum Rss Feed

New Post: How to configure Paulovich.Data

NEW POST: Using our Stored Procedures

NEW POST: How to configure Paulovich.Data