if one installer class in my project and in custom action doing some procedure to validate the serial key using user interface editor during setup creation. while installing the set up if the condition is not true the setup in rolling back it is installing.
[Code]...
I'm calling a third party stored procedure in Oracle from VB that is not rolling back.
Code first (I'm simplifying):
Connection string:
String sqlstr = "SERVER=x.x.x.x;Database=db;uid=sa;pwd=admin;Connect Timeout=60; Min Pool Size=5; Max Pool Size=100;";
The call (I've just forced a rollback immediately after the execute to test it):
Dim Oraclecon As New OracleConnection(_OracleConnection)
Dim sqlCon As New SqlConnection(_SQLConnection)
Dim oTrans As OracleTransaction = Nothing
[Code.....
I can't give the details of the stored procedure but it does a commit and rollback inside it.
Either way, it is doing an insert, and that immediate rollback does not rollback the insert.
I have one multi-row INSERT statement (300 or so sets of values) that I would like to commit to the MySQL database in an all-or-nothing fashion. insert into table VALUES
(1, 2, 3),
(4, 5, 6),
(7, 8, 9);
In some cases, a set of values in the command will not meet the criteria of the table (duplicate key, for example). When that happens I do not want any of the previous sets added to the database. I've implemented this with the following code, however, my rollback command doesn't appear to be making a difference. I've used this documentation: http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqltransaction.html
Dim transaction As MySqlTransaction = sqlConnection.BeginTransaction()
sqlCommand = New MySqlCommand(insertStr, sqlConnection, transaction)
Try
[code]....
I get the DUPLICATE KEY exception thrown, no Rollback Exception thrown, and every set of values up to duplicate key committed to the database.
I'm using an Entity Framework context, and sometimes would like to create a transaction so that the client can do multiple changes and then commit/rollback them all together.However, if many changes were made, and SaveChanges() was called multiple times, after which a rollback is called, entities that were commited already, will remain the way they were commited, and would not roll back.Here's how my transaction-relative functions look like:
Public Sub BeginTransaction()
Dim context = HttpContext.Current.GetObjectContext()
If Not context.Connection.State = ConnectionState.Open Then
context.Connection.Open()
End If
[Code]...
Not only does the test fail, but it also leave the ObjectContext in an unstable mode, because it still has invalid changes in it.
I'm not reciving any errors at all this is Still my homework on the Compound Intrest and it's due tommarow and well an if statement isn't working
Private Sub btnCalc_Click(ByVal sender As Object, _
ByVal e As EventArgs) Handles btnCalc.Click
Dim decAmount As Decimal = 0D
[Code].....
I have a form called LogIn.vb which has no errors. After log-in, it opens the MainForm.vb which IsMDIContainer property is set to true. From the MainMenu, it opens a child form called Assure_Benefits.vb So far no problem up to this point. When Assure_Benefits.vb loads, it displays 2 DataGridViews with datasourses from my 2 tables in my database.
There is still no problem with the loading. Now, to show the difference between different user types, I only allow the admin to edit the DataGrid. SO I set the readonly property to true when UserType = "user".
I have no problem doing that. My problem is I want to add some codes besides the readonly being set to true and false but other codes are not executed and the program does not display any errors at all. i tried to add messageboxes on the if and else conditions to try if added codes will work but even the messagebox does not appear though the codes next to it are properly executed.
When my Assure_Benefits.vb loads I call for the subroutine below.
Private Sub SetControlProperties()
If LogIn.UserType = "admin" Then
MessageBox.Show("Yes") 'This line is not executed
[CODE]...
I can't seem to understand why the first code is not executed when the next codes works fine.
I have a VB.NET Application and I am developing a deployment project in VS 2008.
I need to give the user the choice to allow the application to start when windows start (but this should be optional)
Then in my application there should be an option to remove the application from the windows start up folder.
I'm reviewing some code in VB.net, and in a validation object they have written the following
If Not IsDate(Entity.SelectedDate) Then
ErrorList.Add(New CValidationError("MainReport", "Please select a weekend date"))
SelectedDate is of type Date. It seems to me it would be impossible to ever hit this condition. Is this true?
I have a CheckBoxList on my page that isn't behaving very well.The idea is that once the submit button on the form is clicked, the app should clear the database table of all rows pertaining to the specific user and then re-insert new ones based on the user's CheckBoxList selections.The problem is that regardless of whether or not any (or all) items in the CheckBoxList are selected, the app keeps getting Selected = False.[code]I'm aware of the potential for SQL Injection here. I'll be going over to using Parameters as soon as I have the loop working.
View 3 RepliesI am using MS Visual Studio 2205 Version 8.0.50727.42 and MS.Net Framework Version 2.0.50727 SP2 I created a form that requires the user to enter a date into the textbox.I then use the IsDate function to check if the entry is a valid date. IF Not IsDate(fieldname) then send message back to user on form, otherwise continue.If something like this is enterred - 06/090/10 - It passes the IsDate question and of course fails at the database level when inserting to a datetime field. Although there is a three character day, it still passes.
View 4 RepliesI have a GridView with a Checkbox on the first column: Code: The thing is that the Checkbox.Checked always returns False. How can I get the checked state of the Checkboxes in this scenario? Or what would be the best approach into updating the aforementioned column? P.S. Note that click on the checkboxes doesn't post back. Nothing happens on the page until the user clicks Save (and that is the intended behavior).
View 2 RepliesI have an installer for my application that makes changes to the registry for better application performance However, depending on the language of the operating system installed this input need changes For example (which is the case itself) Systems in Portuguese the entry is called (Padrao)Systems in English the entry is called (Default) I know I have I change the property "Condition" of the entry I created but I do not know what I have to write in this "Condition" I write within this property to validate that The system is in English or The system is in Portuguese I plan to put the project set two registry entries, one that will be done on systems with English language and other entry in systems with Portuguese language?
View 1 RepliesI have placed several PictureBox Images of different colored dots(which represent lights) on an image of a Christmas Tree. I can make the lights randomly flash using a randomGenerator and a Select case statement. However, the code is very long. There are 67 lights on this tree and the code is 71 pages long. There has to be an easier way to do this. So far I have tried the following with two images of lights just to see if it would work and it does not work:
Dim picLight(2) As
Boolean
For intX
[code]....
I'm trying to create a game that involves rolling a dice. When I load the program and click the btnRoll button, the dice works fine and stops after a random number (between 10 and 20) of face changes. It then records the score in the a new line in a ListBox. Only problem is, when I press the roll button again, the face only changes once before recording the result.
I have tried creating a separate program that simply rolls the dice without recording the result, and it works fine. So I used roughly the same code in my game, but it still won't work. I have tried looking online for help for a few days now, so I figured this would be a good time to ask here.[code]...
I would like to have some sort of percentage on the amount of times each button has been pressede.gButton 1 is pressed 5 times, button 2 is pressed 3 times, button 3 is pressed 2 times.I would like this to create a percentage output onto the same form that is updated everytime a button is pressed on the form.
View 5 RepliesHowever in my opinion they require a lot of prior knowledge on how to programatically refer to each item.
Does anyone have a link to or can create a relatively basic example of how to achive a running total in the footer for an ASP:Gridview?
I'm trying to calculate the rolling average in a crystal report. I have got 4 weeks in a month, and I have calculated the average for each week so long. Now I want to calculate a rolling average. eg:
For week1: rolling average = (week1Average)/1
For week2: rolling average = (week1Average + week2Average)/2
For week3: rolling average = (week1Average + week2Average + week3Average)/3
etc.
The problem with the code below is that, it is not looping through,therefore the rolling average for each week is the same as its average value wich is not correct.
Dim i, weekNum as number
Dim tot as double
weekNum =Distinctcount({ItemRating.WeekNo})
[Code].....
I have a certain problem with 2 number generators that I have. My problem is that I want them to act individually. To where they seperatly come up with a random number. Mine is from 1-6 for 2 random number to simulate the rolling of two 6 sided dice. The problem that I have is that when I run the program they always generate the same number no matter what that number is. When I step through it step by step while the program is running in the debug screen they come up with a different number. This is in visual basic 2010 express edition.
Private
Sub
Button1_Click(ByVal
sender As
System.Object,
[Code] .....
I'm doing some maintenance on some software originally built by my predecessor at the company (who has since moved on to greener pastures). I'm currently rolling out a new version of the software. At this company, the installation procedure is basically to just shove the /bin/Release directory out into our automated program updater's magic directory, allowing it to automatically copy the contents of that directory over to the local /Program Files/ and let the magic happen. The magic always seems to happen, so there's no big issue, there, although it does weird me out somewhat, after many years of .msi installers...
[Code]...
Coming form too many years of VB6 I have a natural inclination to write my own data access code, etc. rather than using database wizard, etc. Same goes for using simple databinding to recordset rather than managing object collections and tying those to controls
I am finally moving to VB.NET and find myself on a solo project without any team on which to lean, so I have a couple related questions as I try to get my head around the transition. The project is basically a line of business app with a SQL Server back end.
1. Are the data designers/wizards so good now that rolling your own is no longer worth while?
2. Is the data-binding now fast, flexible, and reliable?
3. Can you recommend a good book or robust on-line tutorial that covers this sort of programming? 2008 or 2010 preferred.
So my question is, I'm wiriting a VERY basic dice rolling program for my computer programming class in high school. I'm using a randomize function to generate numbers but I only want it to do numbers 1 - 6....how do I do this?
Dim x As Integer
Randomize()
x = CInt(10 * Rnd())
Dim Y As Integer
Randomize()
Y = CInt(10 * Rnd())
That is my code for my x and y (each die) to generate code, but how do I make it do 1 - 6 ONLY? Develope a game that in which a player rolls two dice. Each die has 6 faces. Each face contains 1, 2,3,4,5,6 after the dice have come to rest the sum of the spots is calculated, if the sum is 7 or 12 on the first throw, the player wins. If the sum is 2,3, or 11 on the first throw, the player loses, and the house wins. If the sum is 4,5,6,8,9,10 on the first throw the sum becomes the player's point. To win, a player must roll the dice until the plater rolls the point value. The player loses by rolling a 7 before rolling the point. I also have another question, How would I set this up to keep up with points and stuff? and the part that says "The player loses by rolling a 7 before rolling the point." I have no clue what to do on that. I'm not asking for code hand outs. I'm just asking what functions and such I'd use to write the code.
I want to create a real setup project for my application so when someone want to download it he can run only setup, not default setup that provide me VB . How can I do that?
View 4 Repliesadd serial number requirement to Setup & deployment > setup wizard for VB.net application
View 16 RepliesI am using an image button and on click of it i want to go to visited page.Now i am using - Response.Redirect(Request.UrlReferrer.ToString()),It is going to previous page, but when i am in a page of some user details where the link is looks like - users.aspx?userid=25 and i visit some other page and click back(image button) i want to see the same userdetail page. How to track that.
View 2 RepliesI have a search page with a couple of pulldowns. Dependig on the values of them I show a grid matching the searched criteria, basically a table with links the user can navigate to. My problem comes when the user wants to navigate back. At the moment I have a "Back" button which simply redirects the user to the initial search page. I think it would be a good improvement to have the values of the pulldowns filled in with the values the user selected, this way when he presses the "Back" button he would not have to restart the whole search process again.
View 5 RepliesI'm not sure what I did, But I would like to get my toolbox back to normal where I can put it back on auto hide and such.
View 3 RepliesI am using VS 2008 VB and setup my application software in Win XP without any issue. But after installed in Win 7, it doesn't work well (it show one file not found, but I saw the file in the right folder). Could it be the incompatibility of VS 2008 and Win 7? If I upgrade to VS 2010, will the issue be fixed?
View 10 RepliesWe have a server application and a client application that communicates with each other using socket.
When the server application sends 2 messages about 16-31 ms apart, the 1st message is received by the client application with little delay (like 16-32 ms after it was sent). But the 2nd message is received by the client application a lot later (like 200 ms later) than when it was sent.
We already disabled Nagle algorithm (set NoDelay = True) in the socket in both the server and client application.
We are having problems with sending back to back emails on one of our web sites. The site is built with .net framework 2.0.We can send the first email without any problems on every try. But to send a second email you need to wait about 20-30 minutes.the problem.One thing we tried was changing the smtp email server. We tried a third party smtp server but the same problem persisted. So I think the problem is not with the smtp server but with our .net code.
Imports Microsoft.VisualBasic
Imports System.Net
Imports System.Net.Mail
[code].....
I'm a Visual Basic beginner. There are many things that I didn't know about Windows software development as I've been a Mac user for 20 years and just started developing Windows programs several days ago.
Anyway, using Visual Studio Installer (File > Add > New Project > Visual Studio Installer), I have two files inside the Release folder - setup.exe and Setup.msi. I've got some information about these files. So when you publish your software, what do you do with these two files? According to one web site, you can put them together into one with IExpress, which produces a file with an extension of CAB. Another web site suggests SFX Compiler. In the meantime, I downloaded a dozen applications at Download.com earlier. If I click on the download button, the final delivery extension is .exe on most of them. I know that you won't go anywhere by double-clicking on setup.exe from the Release folder without Setup.msi. Meanwhile, Setup.msi is a tand-alone application. But nobody uses this file alone to distribute their product.
