创建测试表:
use test
create table test(
id int identity(1,1) not null, --id字段为自增字段
test1 int,
test2 int
)
C#代码:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace 返回最后一次插入数据的id
{
class Program
{
static void Main(string[] args)
{
string str="server=.;database=test;uid=sa;pwd=sa";
SqlConnection conn = new SqlConnection(str);
string CommandText="insert into test(test1,test2) values(90,30) SELECT CAST(scope_identity() AS int)";
SqlCommand cmd = new SqlCommand(CommandText, conn);
conn.Open();
int i=(int)cmd.ExecuteScalar();
conn.Close();
Console.WriteLine(i);
}
}
}