C# SQLSERVER 调用存储过程得id
来源:互联网 发布:淘宝人肉搜索服务 编辑:程序博客网 时间:2024/06/04 19:27
CREATE PROCEDURE dbo.getOneID
(
@name varchar,
@age int,
@id int OUTPUT
)
AS
/* SET NOCOUNT ON */
INSERT INTO T_stu VALUES(@name,@age);
SET @id=@@identity;
RETURN
然后在C#中调用:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace db3
{
class test
{
static void Main(String[] args)
{
setDomain();
string connectionString = ConfigurationManager.AppSettings["connectString"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = connection.CreateCommand();
// SqlTransaction transaction;
// Start a local transaction.
transaction = connection.BeginTransaction("SampleTransaction");
// Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = connection;
command.Transaction = transaction;
try
{
command.CommandText = "getOneID";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@id", SqlDbType.Int);
command.Parameters["@id"].Direction = ParameterDirection.Output;
command.Parameters.AddWithValue("name", "wan2");
command.Parameters.AddWithValue("age", 20);
// Attempt to commit the transaction.
command.ExecuteNonQuery();
transaction.Commit();
Console.WriteLine(command.Parameters["@id"].Value.ToString());
Console.WriteLine("Both records are written to database.");
Console.ReadKey();
}
catch (Exception ex)
{
Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message);
// Attempt to roll back the transaction.
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
Console.ReadKey();
}
}
}
private static void setDomain()
{
string datadir = AppDomain.CurrentDomain.BaseDirectory;
if (datadir.EndsWith(@"\bin\Debug\") || datadir.EndsWith(@"\bin\Release\"))
{
datadir = System.IO.Directory.GetParent(datadir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", datadir);
}
}
}
}
- C# SQLSERVER 调用存储过程得id
- C# asp.net调用Sqlserver 存储过程
- c#调用SqlServer中的存储过程
- sqlserver存储过程调用
- c# Sqlserver存储过程
- sqlserver调用外部存储过程
- java调用SQLSERVER存储过程
- Hibernate 调用sqlserver存储过程
- Hibernate调用SQLserver存储过程
- ibatis调用sqlserver存储过程
- C#调用存储过程
- C#调用存储过程
- C#调用存储过程
- C#调用存储过程
- C#调用存储过程
- C# 调用存储过程
- c# 调用存储过程
- C#调用存储过程
- php,apache官方文档下载
- 黑马程序员--struts2基础学习
- 关于CSDN, cnblog, iteye和51cto四个博客网站的比较与分析
- 最常被程序员们谎称读过的计算机书籍
- twisted的入门讲解(很不错)
- C# SQLSERVER 调用存储过程得id
- 【转】HTML代码实例:详细讲解超级链接
- PHP Pear Package 应用
- How to detect Normal or Large font size settings (DPI)
- java中判断一个字符串是否“都为数字”和“是否包含数字”和“截取数字”
- 挺漂亮的文字太长自动截断,鼠标移上显示全部信息例子
- OMAP4平台设置时钟频率
- linux下i2c接口的电容触摸屏驱动开发
- T-SQL技术收集——删除重复数据