在SQL Server数据库中插入数据的问题 [英] Problem with data insertion in sql server database

问题描述

我想在xslt的帮助下使用存储过程将数据插入数据库，但是数据不在数据库中，所以请帮助我哪里出错了.
我的存储过程是这个

I want to insert the data into data base using store procedure with the help of xslt, but data is not going in the data base, so please help me where am i doing fault.
my stored procedure is this-

USE [DTITSWEB]
GO
/****** Object:  StoredProcedure [dbo].[webinsert]    Script Date: 08/10/2011 17:07:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[webinsert]
(	@v_strUsername NVARCHAR(20),	
	@v_strPassword NVARCHAR(50))
AS
BEGIN
	DECLARE @intAutoId INT
	SELECT @intAutoId  = MAX(AutoId)FROM AdminLogin
		IF @intAutoId IS NULL 
			SET @intAutoId = 1 
		ELSE        
			SET @intAutoId = @intAutoId + 1
	

   INSERT INTO AdminLogin
		(
			AutoId,	
			UserName,
			Password
				) 
		VALUES
		(
			@intAutoId,
@v_strUsername ,	
	@v_strPassword )
			
		
END

我的地图是这个

and my maping is this-

string strSPName;
bool blnSuccess;

try
{
  strSPName = "webinsert";
  SqlParameter[] arProcParams = {
        new SqlParameter("@v_strUsername", vstrUsername),
        new SqlParameter("@v_strPassword", vstrPassword)
  };

  blnSuccess = oDU.ExecuteStoredProc(strSPName, arProcParams);
  if (!blnSuccess)
     throw new Exception("There were some problem with Add.");
     return true;
  }
catch
{
   throw;
}

推荐答案

为什么要手动创建ID?只需将ID字段设置为自动递增，然后在您插入新行时就会为您处理.

WHY are you manually creating the ID? Just set the ID field to be auto-increment, and it will take care of this for you when you insert a new row.

这篇关于在SQL Server数据库中插入数据的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！