how to use Store Procedure in VC# 2005 and SQL 2005 ?

[=?Utf-8?B?SGFtZWRfMTk4Mw==?=]

hi
i want to use Store Procedure for Insert,Update and Delete operation in my
c# app, but how to do ??
please give me an example,source or article or ...
thanks

[Marcel Beutner]

Hi hamed,

first of all, you have to create the stored procedures on your sql-server
with help of query analyser:

CREATE PROCEDURE your_insert_sp
(@field1 [int],
@field2 [nvarchar](15)

AS INSERT INTO Categories
( [field1],
[field2]

VALUES
(@field1,
@field2
GO


to use these stored procedured in c# you can do the following:

SqlConnection con = new SqlConnection(<your constring>);
con.Open();
SqlCommand cmd = new SqlCommand("your_insert_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteScalar();
con.Close();
hope it helps

marcel beutner
PS: the parameters @field1 and @field2 must define in the
SqlParameterCollection of your command object

[Ignacio Machin \( .NET/ C# MVP \)]

hi

Did you google this question?

There are examples all over the internet of how to use SP in C#
--
Ignacio Machin
machin AT laceupsolutions com

"Hamed_1983" <Ha*******@discussions.microsoft.comwrote in message
news:93**********************************@microsof t.com...

hi
i want to use Store Procedure for Insert,Update and Delete operation in my
c# app, but how to do ??
please give me an example,source or article or ...
thanks