C#

using (SqlConnection con = new SqlConnection("data source=.;initial catalog=test;Trusted_Connection=Yes"))
            {
                SqlCommand cmd = con.CreateCommand();
                cmd.CommandText = "insert Person(titleId,fname,lname) values(@titleId,@fname,@lname)";
                con.Open();

                System.Transactions.TransactionOptions trOptions = new System.Transactions.TransactionOptions();
                trOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
                trOptions.Timeout = new TimeSpan(0, 0, 15);
                using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required, trOptions))
                {
                    try
                    {
                        foreach (DataRow row in this.dt1.Rows)
                        {
                            int titleId = int.Parse(row["titleId"].ToString());
                            string fname = row["fname"].ToString();
                            string lname = row["lname"].ToString();

                            if (cmd.Parameters.Count > 0)
                                cmd.Parameters.Clear();

                            cmd.Parameters.AddWithValue("@titleId", titleId);
                            cmd.Parameters.AddWithValue("@fname", fname);
                            cmd.Parameters.AddWithValue("@lname", lname);
                            cmd.ExecuteNonQuery();

                        }
                        con.Close();
                        ts.Complete();
                    }
                    catch (Exception ex)
                    {

                    }                    
                }
            }

using Project = My.Namespace.XMLProjectNode;