如何使用存储过程执行插入，更新，删除操作.

http://www.telerik.com/community/code-library/aspnet-ajax/grid/update-insert-delete-with-stored-procedures-and-sqldatasource-control.aspx [ http://www.mikesdotnetting.com/Article/15/Insert-Single-Value-With-Stored-Procedure-ASP.NET-CSharp [ ^ ]

http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx [ ^ ]

http://www.telerik.com/community/code-library/aspnet-ajax/grid/update-insert-delete-with-stored-procedures-and-sqldatasource-control.aspx[^]

http://www.mikesdotnetting.com/Article/15/Insert-Single-Value-With-Stored-Procedure-ASP.NET-CSharp[^]

http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx[^]

只需包含参数&在存储过程中进行查询，仅此而已.

普通查询

Just include the parameters & query inside the stored procedure, thats all.

Normal query

INSERT INTO Emp(EmpID, EmpName) VALUES(@EmpID, @EmpName)

存储过程

Stored procedure

CREATE PROCEDURE usp_InsertEmployee
(
  @EmpID int,
  @EmpName varchar(50)
)
AS
BEGIN
     INSERT INTO Emp(EmpID, EmpName) VALUES(@EmpID, @EmpName)
END

嗨Narmatha，

您可以像这样尝试正常工作

创建过程[dbo].[InsertCourse](

@CourseCode nvarchar(250)，
@CourseName nvarchar(250)，
@CourseDescription ntext
)
AS
开始
INSERT INTO课程(课程代码，
课程名称，
课程说明)

值(@CourseCode，
@CourseName，
@CourseDescription)
END


更新/////////////


更改过程[dbo].[UpdateCourse](
@CourseCode nvarchar(250)，
@CourseName nvarchar(250)，
@CourseDescription ntext，
@CourseID int
)
AS
开始
更新课程设置CourseCode = @ CourseCode，
CourseName = @ CourseName，
CourseDescription = @ CourseDescription
WHERE CourseID = @ CourseID

END


/////////////////

更改程序[dbo].[DeleteCourse](
@CourseCode nvarchar(250)，
@CourseName nvarchar(250)，
@CourseDescription ntext，
@CourseID int
)
AS
开始
从课程WHERE中删除CourseID = @ CourseID

END

////////////选择///////////


USE [BW HRM]
GO
/******对象:StoredProcedure [dbo].[GetAllCourse]脚本日期:09/24/2010 12:45:25 ******/
设置ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
更改过程[dbo].[GetAllCourse]
(@CourseCode nvarchar(250)，
@CourseName nvarchar(250)，
@CourseDescription ntext，
@CourseID int)

AS
开始
从课程中选择课程ID，课程代码，课程名称，课程说明
END
///////////////id选择////////////

USE [BW HRM]
GO
/******对象:StoredProcedure [dbo].[GetAllCourseIDdetails]脚本日期:09/24/2010 12:45:44 ******/
设置ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
更改过程[dbo].[GetAllCourseIDdetails]
(

@CourseCode nvarchar(250)，
@CourseName nvarchar(250)，
@CourseDescription ntext，
@CourseID int
)

AS
开始
从课程中选择CourseCode，CourseName，CourseDescription，其中CourseID = @ CourseID
END

并且这是sql formate，一旦粘贴了此站点并复制paste => sql看到sql formate的区别
http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz [ ^ ]

Hi Narmatha,

you can try like this working fine

CREATE PROCEDURE [dbo].[InsertCourse](

@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext
)
AS
BEGIN
INSERT INTO Course(CourseCode,
CourseName,
CourseDescription)

values(@CourseCode,
@CourseName,
@CourseDescription)
END


update//////////////


ALTER PROCEDURE [dbo].[UpdateCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
BEGIN
UPDATE Course SET CourseCode=@CourseCode,
CourseName=@CourseName,
CourseDescription=@CourseDescription
WHERE CourseID=@CourseID

END


//////////////delete//////////////

ALTER PROCEDURE [dbo].[DeleteCourse](
@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)
AS
BEGIN
delete from Course WHERE CourseID=@CourseID

END

///////////select/////////////


USE [BW HRM]
GO
/****** Object: StoredProcedure [dbo].[GetAllCourse] Script Date: 09/24/2010 12:45:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetAllCourse]
(@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int)

AS
BEGIN
SELECT CourseID, CourseCode, CourseName, CourseDescription FROM Course
END
////////////////id select/////////////

USE [BW HRM]
GO
/****** Object: StoredProcedure [dbo].[GetAllCourseIDdetails] Script Date: 09/24/2010 12:45:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetAllCourseIDdetails]
(

@CourseCode nvarchar(250),
@CourseName nvarchar(250),
@CourseDescription ntext,
@CourseID int
)

AS
BEGIN
SELECT CourseCode,CourseName,CourseDescription FROM Course where CourseID=@CourseID
END

and this is sql formate once paste this site and copy paste=>sql see difference of sql formate
http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz[^]