insertrow.cs

< SQL Server2005程序设计>

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Transactions;

public partial class StoredProcedures
{
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void InsertRow()
    {
        using (SqlConnection contextConn = new SqlConnection("context connection = true"))
        {
            SqlCommand insertCmd = contextConn.CreateCommand();
            insertCmd.CommandText = "Insert Into TestTable(TestColumn) Values(100)";
            contextConn.Open();
            insertCmd.ExecuteNonQuery();
            contextConn.Close();
            //System.Transactions.Transaction.Current.Rollback();
        }
    }
};