Error: By Specific Numbers
Oct 16, 2011I didi this code to take the number only between 7 to 1 but didin't succeed
What is the error
code:
I didi this code to take the number only between 7 to 1 but didin't succeed
What is the error
code:
I am making a program, where the user enters 6 numbers in 6 different text boxes, and it displays the larger of those 6 numbers. But I also want to make it where if the user enters a string value (like S for instance) in the text boxes, it gives an message and says "please enter the numbers again" and the user gets to enter the 6 numbers again. But when I do try to do that, it gives an error message saying conversion from "w/e the user entered" to Double is not valid. If the user just enters the numbers, it works fine. However, I am trying to make it if the user does enter non numeric value, it gives a message window and the user can reenter the numbers again.
Here is my code Example
CODE:
This is where I am trying to use IsNumeric to show a message if a user does not enter a string so the user can renter the numbers again, but when the user does enter a string value (say in textbox 1) it gives me an error message saying conversion from "S" to 'double' is not valid.
CODE:
Then right here this is where I have my series of ifs statements, this part works fine, it displays the largest numbers of the 6 textboxes every time. Error free.
CODE:
And do this with variable number 2, 3, 4, 5.
I know there are easier ways to do these with arrays and stuff. But I am not there yet. I am still learning about ifs and stuff.
I'm trying to add certain numbers together from a textbox full of numbers from 1 to 10. This is my
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub[code]....
When the button is clicked, it gathers the list of numbers from the test.txt file and displays it in the textbox. Now what I want to do is make a label so that after it streams the data and displays it in it's multi-line text box, is for every 10 and 1 displayed on one line, it will subtract 1 from the number in the label. For every 2,3,4,5,6 I want it to add 1. For every 7,8,9 it will not add anything.For those who can tell I'm a blackjack fan and I was curious on how to keep a running count in a label from a multi line list of numbers.
From within Excel, I want to import data from Access. This is simple enough using Microsoft Query. What is not so simple, at least to me, is how to get the SUM of numbers in a specific field in a specific table in Access. I do not need to import every number in the field only the SUM of the field. I need this 'total figure' to be placed in a cell in an Excel spreadsheet.
The data is listed in the Access table in this order: (there are others but these are the three I am interested in)
TimeStamp, Terminal, TransActionTotal
Simplistically, there are three cells (A2, B2, C2) on on the spreadsheet (one for each terminal). The first should show a total for the day for Terminal 1, the second for Terminal 2 and the third for Terminal 3. Is there a way to get Excel to read the data in the table, add up the appropriate fields by date and then write this total in the appropriate cell? If it makes it any easier, the date is recorded in another cell on the spreadsheet (let's say E1).
I'm trying to transfer only the numbers after the £ Character from Textbox1 into Textbox2. If textbox1 contains numbers before the £ character then it just transfers the first numbers before the £ character which is not required.[code]
View 5 RepliesWhen I deployed my project on a server, in certain circumstances, I get an error page that indicates I should create a custom error page. I was wondering how exactly I would implement this custom error page the server asks for to give me a precise and helpful message or preferably, how I would get the error to just display on the main page?This is the error message I got below
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code]....
Trying to create a form where user enters a lower bound, upper bound, and an amount of random numbers to generate (that are between the lower and upper)
I was able to get it to generate random numbers but only 1 per a click of the calculate button...I would like user to be able to click button and it to generate and display all the numbers on seperate numbers all at once[code]...
how to loop an SWF file using specific frame numbers. I don't want the SWF file to play thoroughly. I know that frame 1 in Flash is 0 in VB, frame 2 in Flash is 1 in VB, etc.
View 5 RepliesI am currently taking a introductory level class to vb.net. For the assignment it asks to create two functions. One function should create a random number within a given range. I have completed that part. What I am having trouble with is the second function. It wants the next function to use the previous function three times so that it displays 3 separate random numbers within a given range and display it in a D2 string format.
View 1 RepliesI know it's possible in asp.net to create a custom error page in a web app, by putting the following line in the web.config: <customErrors mode="RemoteOnly" defaultRedirect="frmErrorPage.aspx" />
I have had to do this for my web app, since it is clearly much tidier than letting the program bomb out with it's ugly default error page. My custom error page just has the customer's logo and a brief message saying "Error has occurred. Please return to homepage"The trouble now is that I have no way of knowing what caused the error, when a customer reports it.
Is there a way to make the actual error message appear on this custom error page too?
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 Repliestrying to get my hands wet on vs 2010 and i downloaded samples from ms site but when i tried to run some of the DB samples i received this sql error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) any ideas how to get around on this?
View 5 RepliesI developed one application in VB.Net 2010. It worked fine on my laptop.[code]...
View 1 RepliesHow do I correctly extract specific info from an sql error message number 547? [code]
View 2 Repliesi am facing a problem that is frustrating i have a VB.NET application that i need to connect to an sql 2005 server .its giving this error when i publish the application "a network related or instance-specific error occured while stablishing a connection to sql server . the server was not found or was not accessible .verify that the instance name is correct and that the sql server is configured to allow remote connections" the pc has windows xp on it i configured my sql to allow remote connections its working on one mashine but not the other ??
View 5 RepliesI got an error message saying "Network-related or instance specific error occured while establishing a connection to SQL server............" when opening a connection in form_load event.Tried restarting computer it worked few a times,but still would get the same message again after sometime.How can i fix this error?.
View 3 RepliesI used the following code to click mouse on the specific co-ordinates on an open windows application
Private Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long, ByVal dx As Long, ByVal dy As Long, ByVal cButtons As Long, ByVal dwExtraInfo As Long)
Private Const MOUSEEVENTF_LEFTDOWN = &H2
[code].....
When two computers are connected through TCP, and one of them closes and breaks the connection, it throws error 10054 "Remote host forcibly closed the connection".I want to handle this error because I know it will happen more often than not with the application I'm building. In System.Net.Sockets.SocketException, there is an on the error code. But when I run the program, the exception that is being thrown is System.IO.IOException, and the GetType for IOException is the socket exception. I don't know how to handle the socket exception if it's not the root cause of the exception.
Here is the code for my Try Catch block:
For infiniteCounter = 1 To 2
infiniteCounter = 1
[code].....
I have a situation in which I must execute a dynamically built stored procedure against tables that may, or may not be in the database. The data retrieved is then shunted to a VB.Net backed ASP based report page. By design, if the tables are not present in the database, the relevant data is automatically hidden on the report page. Currently, I'm doing this by checking for the inevitable error, and hiding the div in the catch block. A bit kludgy, but it worked.I can't include the VB code-behind, but the relevant stored procedure is included below.However, a problem with this method was recently brought to my attention when, for no apparent reason, the div was being hidden even though the proper data was available. As it turned out, the user trying to select the table in the dynamic SQL call didn't have the proper select permissions, an easy enough fix once I could track it down.First and foremost - is there a better way to check for a missing table than through catching the error in the VB.Net codebehind? All things considered, I'd rather save the error checking for an actual error. Secondly, is there a preferred method to squirrel out a particular OLE DB error out of the general object caught by the try->catch block other than just checking the actual stack trace string?
SQL Query - The main gist of the code is that, due to the design of the database, I have to determine the name of the actual table being targeted manually. The database records jobs in a single table, but each job also gets its own table for processing data on the items processed in that job, and it's data from those tables I have to retrieve. Absolutely nothing I can do about this setup, unfortunately. [code]
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour , First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)But when I was trying the application in another pc (Windows 7 32bit)I got this exception: A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when the app reaches the DataAdpter.Insert(....) It runs without any problem .
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception before .
I tried these things as a solution:
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALISQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
what is the difference between fill and insert? My app. runs smoothly on the original pc ,What should I do?
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...
[URL]
Then following error occurs ....
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network
Interfaces, error: 26 - Error Locating
Server/Instance Specified)
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;
[code]....
...before publishing and uploading my website to webserver ...I m confused the problem is from my local computer or the webserver ....and how to fix this error ?
i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 RepliesError message receiving A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The project is written in VB.Net 2008. Production server uses SQL 2008, Dev Server uses SQL 2000. The application has been built and published.
Prod Connection String: strCN = "server=SGMAGNCPQ03.;Initial Catalog=APO_Tax;Integrated Security=True"
Dev Connection String: strCN = "server=S04423711940995.;Initial Catalog=APO_Tax;Integrated Security=True"
The Problem: When I change the connect string from dev back to prod and try to run my app, I get the above error message. If I reboot everything works fine but if I switch the connect string from prod to dev and try to go back to prod, I'm back to the same problem.
I have six textboxes, and upon button press it randomly generates six numbers, one in eact text box e.g. [43] [85] [93] [1] [0] [17]..i create another six textboxes and at the same time allocate these numbers in ascending/descending numbers.I am not looking for any codes whatsoever, as i love the challenge of VB.Net.
View 2 RepliesIm trying to write a program that will do:
1.The average of the four numbers. This answer will be placed into a text box reserved for that value. This text box cannot be changed by the user.
2.The maximum and minimum values. These will be denoted by changing the color of the largest number green and the smallest number red.
3.The range of the numbers. The range is defined as the difference between the largest and smallest numbers. The range will be placed into its own text box, labeled as such. This text box cannot be changed by the user."
Im using visual studio 2008 and it has to be written in VB
So how would I use .next (random numbers) to randomly select something from a list of numbers but it can't repeat the number?I could do:
dim num as integer
dim r as new random
num = r.next(1,5)
if num = 1 then
elseif num = 2 then
etc.
That wouldn't work because it would repeat.If I donwload someone's game can I disect it in VS? :0 I tried going to open project, then I went to the folder and clicked open. It brought me inside of the folder so I tried to open the game but there is no form1 there. It says the games name then .exe in the explorer-like thing in the top right?Also, how would I have a value or something in a label and access it from a button.
Example:This is in a label.
Dim number as Integer
number = 0
Then in the button do
Label.number = 0
How would I do something like that? I want to use that a lot as I did in a different language.
I have a program that allows a user to input numbers from an inputbox and it displays the Total numbers entered, the sum of the numbers entered, and the average of the numbers entered. What I can not seem to find it how to have it display the largest number entered. The code I have so far is,
[Code]...
how can i add two excel sheets with numbers and the equal (similar)numbers to save once
View 1 RepliesI have just about completed a .NET project to write a program to randomly select numbers for a Bingo caller. Over the last month or so Ive learned a lot about .NET but heres something that I consider to be odd and maybe one of you guys can offer an opinion.
One of the features of calling Bingo in a small local club is that callers often use little sayings to accompany certain numbers, I expect youve all heard of (say) All the sixes, clickety click for 66 or 5 and 9 the Brighton line for 59 etc. My little program gives an option to incorporate these with a prompt for the caller that can be edited outside of the program. One of these conventional sayings is used when a number is reversed 12 followed by 21 or 45 followed by 54 for example, when the caller might call (say) 1 and 2, one dozen, number 12 And the other way round 2 and 1, twenty one.
So, I programmed in a bit of code to detect this and to over-ride whatever might otherwise have been the quote with And the other way round and set about testing it. Ive been through literally dozens of full 90 calls watching for the occurrence of a reversed number, spent a few hours doing it, and not once has it occurred which is to say the least, unusual.
So, Im wondering about the Rand Function, could it be that it isnt possible for a reversed number to be selected? Just so you know, I randomly pre-select the order of all 90 numbers, I fill each of the 90 elements of an array with a random number first checking that the number selected hasnt already been stored, if it has, I just get the next random number (and check that too of course), but I cant see how that could prevent reversed numbers being selected, especially in light of the fact that frequently it's not the 'next' number that's used.
am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, it should be saved in the database access.
View 9 Replies