Uploading multi images to SQL Server

Hi Tobe,

sorry for responding a little late. Follow the code below on how to use the SQL transaction feature.

SqlConnection con = new SqlConnection("Server=SUNNY-PC\\SQLEXPRESS;Database=students;Integrated Security=true;");
try
{
con.Open();

SqlCommand cmd = new SqlCommand("...", con);
cmd.CommandType = CommandType.StoredProcedure;

SqlTransaction fileUploadTransaction = con.BeginTransaction();
try
{
for (int i = 0; i < 5; i++)
{
cmd.CommandText = "";
// set the parameters for each file like:
// cmd.Parameters.Add("@filename", .....
cmd.ExecuteNonQuery();

}
fileUploadTransaction.Commit(); // this will commit all the transactions made for current session.
}
catch (Exception ex)
{
fileUploadTransaction.Rollback(); //this will roll back the complete transaction in case of any error.
MessageBox.Show("Error while uploading file: " + ex.Message);
}

}
catch (Exception ex)
{
MessageBox.Show("Database connection error: " + ex.Message);
}

========================================================

Please don't forget to accept this as answer if it helps!
Thanks.