写一个proc,在代码中和数据库勾通时调用这个proc 例子: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[ProcInsertTArea] ( @AreaName nvarchar(50), @ParentAreaID int, @Description nvarchar(50), @PK int output ) AS SET NOCOUNT OFF; INSERT INTO TArea (AreaName, ParentAreaID,Description) VALUES (@AreaName, @ParentAreaID,@Description); SET @PK= SCOPE_IDENTITY() return @PK 仿照写
// 声明一个DataRow实例dr
DataRow dr;
// 说明DataTable表里的包含哪些字段
dt.Columns.Add(new DataColumn("UserId", typeof(string)));
dt.Columns.Add(new DataColumn("FunctionId", typeof(Int32)));
foreach (string listValue in listNum)
{
if (listValue.Length != 0)
{
//i = Convert.ToInt16(listValue);
// 用DataTable的NewRow方法新建一个DataRow对象的实例dr
dr = dt.NewRow();
dr[0] = userId;
dr[1] = listValue;
dt.Rows.Add(dr);
}
}
例子:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[ProcInsertTArea]
(
@AreaName nvarchar(50),
@ParentAreaID int,
@Description nvarchar(50),
@PK int output
)
AS
SET NOCOUNT OFF;
INSERT INTO TArea (AreaName, ParentAreaID,Description)
VALUES (@AreaName, @ParentAreaID,@Description);
SET @PK= SCOPE_IDENTITY()
return @PK
仿照写