SqlConnection sconn = null;

            SqlCommand scmd = null;

            SqlTransaction strans = null;

            try

            {

                string sqlInsert = string.Format(@"insert into MyName (myid,myfname,mymname,mylname) values

                    ('{0}','c','c','c')", Guid.NewGuid().ToString());

                sconn = new SqlConnection(dbConnStr);

                sconn.Open();

                scmd = new SqlCommand(sqlInsert, sconn);

                strans = sconn.BeginTransaction();

                scmd.Transaction = strans;

                scmd.ExecuteNonQuery();

                strans.Commit();

                int[] myi = new int[] {  };

                int myr = myi[];

            }

            catch (Exception exp)

            {

                if (strans != null && strans.Connection != null)

                    strans.Rollback();

                MessageBox.Show(exp.Message);

            }

            finally

            {

                if (sconn != null)

                    sconn.Close();

            }