C#

Matt Casto wrote:

would it be possible to read the file using WinAPI?

FileStream fs = New FileStream("filepath", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
StreamReader sr = New StreamReader(fs);

using (SqlConnection connection = new SqlConnection(connectString))
{
    connection.Open();

    // Start a local transaction.
    SqlTransaction sqlTran = connection.BeginTransaction();

    // Enlist the command in the current transaction.
    SqlCommand command = connection.CreateCommand();
    command.Transaction = sqlTran;

    try
    {
        command.CommandText =
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')";
        command.ExecuteNonQuery();
        command.CommandText =
          "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')";
        command.ExecuteNonQuery();
        sqlTran.Commit();
        Console.WriteLine("Both records were written to database.");
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
        Console.WriteLine("Neither record was written to database.");
        sqlTran.Rollback();
    }
}

using (TransactionScope scope = new TransactionScope()) 
{
    using (SqlConnection connection = new SqlConnection(connectString))
    {
        connection.Open();

        SqlCommand command = connection.CreateCommand();
        try
        {
            command.CommandText =
              "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')";
            command.ExecuteNonQuery();
            command.CommandText =
              "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')";
            command.ExecuteNonQuery();
            scope.Complete();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
            Console.WriteLine("Neither record was written to database.");
        }
    }
}

<br />
Parameter param1=new Parameter("abc",0);<br />
Parameter param2=new Parameter("anotherParam",1);<br />

<br />
string paramName=param1.Name;<br />

hkim_zoro wrote:

i know how to delete but i don't know write it by C#