using System;
using System.Data;
using System.Data.SqlClient;
namespace DbConsoleDemo
{
using System.Data;
using System.Data.SqlClient;
namespace DbConsoleDemo
{
public class InsertDemo
{
public InsertDemo() {}
public static void Test1()
{
SqlConnection conn = new SqlConnection(Config.RChenConnection);
using (conn)
{
SqlCommand cmd = new SqlCommand(@ "insert into IdStore(nextid) values (@nextid)select SCOPE_IDENTITY() ", conn);cmd.Parameters.Add( "@nextid ", 123);conn.Open();object o = cmd.ExecuteScalar();int newId = Convert.ToInt32(o);Console.WriteLine( "新的 id 是:{0} ", newId);conn.Close();
}Console.ReadLine();
}
}}