sql存储过程 [英] sql store procedures

问题描述

大家好，



我开发了一个Windows窗体并能够使用sql数据库保存/更新/删除数据。



我在表单代码中使用了所有sql表达式和查询。



如何通过商店程序处理所有sql操作。



问候，

Raju G

Hi All,

I have developed one windows form and able to save/update/delete the data with sql database.

I used all sql expressions in form code with queries.

How to handle all sql operations through store procedures.

Regards,
Raju G

推荐答案

GO

ALTER proc [dbo].[AddNewPatientRecord](@PatientMob varchar(15),@PatientName varchar(50),@PatientAge int,@PatientSex varchar(1),@PatientAddress varchar(60),@FosaUser varchar(1),@DoctName varchar(30))
as
insert into Patient values(@PatientMob,@PatientName,@PatientAge,@PatientSex,@PatientAddress,@FosaUser,@DoctName)

这可以在您编写存储过程时用作示例

填写一张添加新病历的表格



在c＃中休息你可以使用一个函数来使用这个存储过程，例如

This can be used as an example when you write stored procedure
Its populating a table of add a new patient record

Rest in c# you can use a function to use this stored procedure like

public void AddNewRecord(string PatientMob, string PatientName, int PatientAge, string PatientSex, string PatientAddress, string FosaUser, string DoctName)
      {
          cmd = new SqlCommand("AddNewPatientRecord", con);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@PatientMob", SqlDbType.VarChar).Value = PatientMob;
          cmd.Parameters.AddWithValue("@PatientName", SqlDbType.VarChar).Value = PatientName;
          cmd.Parameters.AddWithValue("@PatientAge", SqlDbType.Int).Value = PatientAge;
          cmd.Parameters.AddWithValue("@PatientSex", SqlDbType.VarChar).Value = PatientSex;
          cmd.Parameters.AddWithValue("@PatientAddress", SqlDbType.VarChar).Value = PatientAddress;
          cmd.Parameters.AddWithValue("@FosaUser", SqlDbType.VarChar).Value = FosaUser;
          cmd.Parameters.AddWithValue("@DoctName", SqlDbType.VarChar).Value = DoctName;

          cmd.ExecuteNonQuery();
      }

请参考此链接，为您提供解决方案：



如何在asp.net中调用存储过程c＃code [ ^ ]



如果有帮助，请接受答案。

Refer this link here you get you solution:

how to call stored procedure in asp.net c# code[^]

Accept as answer if help.

请检查以下链接



http://forums.asp.net/t/ 1608207.aspx / 1 [ ^ ]



也可以为你提供帮助

Please check bellow link

http://forums.asp.net/t/1608207.aspx/1[^]

also e.g for your help

-- =============================================
-- Author: Mukesh Ghosh
-- Create date: 09 Jul, 2013
-- Description: Save Settings
/*
  EXEC stp_Save_Settings 
    	@Key = NULL,
		@Value = NULL
*/
-- =============================================
CREATE PROCEDURE stp_Save_Settings
	@Key VARCHAR(50),
	@Value NVARCHAR(500)
AS
BEGIN
	-- SET NOCOUNT ON ADDED TO PREVENT EXTRA RESULT SETS FROM
	SET NOCOUNT ON;
	
	BEGIN TRY
    
		
    
	END TRY
	BEGIN CATCH
	
		DECLARE @ErrorMessage NVARCHAR(4000),
			    @ErrorSeverity INT,
		        @ErrorState INT

		SELECT @ErrorMessage = ERROR_MESSAGE(),
		       @ErrorSeverity = ERROR_SEVERITY(),
		       @ErrorState = ERROR_STATE();

		-- USE RAISERROR INSIDE THE CATCH BLOCK TO RETURN ERROR
		RAISERROR (@ErrorMessage, -- MESSAGE TEXT.
		           @ErrorSeverity, -- SEVERITY.
			       @ErrorState -- STATE. 
		          )
	END CATCH
    
END
GO
-- =============================================
-- Author: Mukesh Ghosh
-- Create date: 09 Jul, 2013
-- Description: Delete Settings
/*
  EXEC stp_Delete_Settings 
    
*/
-- =============================================
CREATE PROCEDURE stp_Delete_Settings
	
AS
BEGIN
	-- SET NOCOUNT ON ADDED TO PREVENT EXTRA RESULT SETS FROM
	SET NOCOUNT ON;
	
	BEGIN TRY
    
		DELETE FROM tbl_App_Settings
		WHERE 

		RETURN 1
    
	END TRY
	BEGIN CATCH
	
		DECLARE @ErrorMessage NVARCHAR(4000),
			    @ErrorSeverity INT,
		        @ErrorState INT

		SELECT @ErrorMessage = ERROR_MESSAGE(),
		       @ErrorSeverity = ERROR_SEVERITY(),
		       @ErrorState = ERROR_STATE();

		-- USE RAISERROR INSIDE THE CATCH BLOCK TO RETURN ERROR
		RAISERROR (@ErrorMessage, -- MESSAGE TEXT.
		           @ErrorSeverity, -- SEVERITY.
			       @ErrorState -- STATE. 
		          )
	END CATCH
    
END
GO
-- =============================================
-- Author: Mukesh Ghosh
-- Create date: 09 Jul, 2013
-- Description: Get Settings Details
/*
  EXEC stp_Get_SettingsDetails 
    
*/
-- =============================================
CREATE PROCEDURE stp_Get_SettingsDetails
	
AS
BEGIN
	-- SET NOCOUNT ON ADDED TO PREVENT EXTRA RESULT SETS FROM
	SET NOCOUNT ON;
	
	BEGIN TRY
    
		SELECT Key,Value
		FROM   tbl_App_Settings
		WHERE  
    
	END TRY
	BEGIN CATCH
	
		DECLARE @ErrorMessage NVARCHAR(4000),
			    @ErrorSeverity INT,
		        @ErrorState INT

		SELECT @ErrorMessage = ERROR_MESSAGE(),
		       @ErrorSeverity = ERROR_SEVERITY(),
		       @ErrorState = ERROR_STATE();

		-- USE RAISERROR INSIDE THE CATCH BLOCK TO RETURN ERROR
		RAISERROR (@ErrorMessage, -- MESSAGE TEXT.
		           @ErrorSeverity, -- SEVERITY.
			       @ErrorState -- STATE. 
		          )
	END CATCH
    
END
GO

这篇关于sql存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！