Try
            SqlTrans = Db.BeginTransaction
            SqlCmd.Transaction = SqlTrans
                SqlCmd.CommandText = "InsC59"
                SqlCmd.Parameters.Add("@Nschedina", SqlDbType.Int).Value = ObjC59.NumeroSchedina
                SqlCmd.Parameters.Add("@Data_arrivo", SqlDbType.SmallDateTime).Value = ObjC59.DataArrivo
                SqlCmd.Parameters.Add("@data_partenza", SqlDbType.SmallDateTime).Value = ObjC59.DataPartenza
                SqlCmd.Parameters.Add("@Stato_res", SqlDbType.VarChar).Value = ObjC59.StatoResidenza
                SqlCmd.Parameters.Add("@Comune", SqlDbType.VarChar).Value = ObjC59.ComuneResidenza
                SqlCmd.Parameters.Add("@Prov", SqlDbType.VarChar).Value = ObjC59.ProvinciaResidenza
                SqlCmd.Parameters.Add("@Stato", SqlDbType.VarChar).Value = ObjC59.Tipostato
            SqlCmd.Connection = Db
            SqlCmd.CommandType = CommandType.StoredProcedure
            SqlCmd.ExecuteNonQuery()
            SqlTrans.Commit()
        Catch ex As Exception
            SqlTrans.Rollback()
            Throw ex
        Finally
            SqlCmd.Parameters.Clear()
            SqlCmd.Dispose()
        End Try