I've written some code in VB.NET that exports data to Excel. The data is mostly numbers but text can occur as well. So I send it as String values to Excel. I get the error "Number stored as text".I checked the format of the cells that show the error and it is General and not Text.
how to avoid this error or prevent Excel from showing this error.
How to create an error log system, which will log all errors(caused in my app) to a text file with line number, sub/function in which the error occurred, error details, etc. ?
View 11 RepliesHi,in my application i have to read from an excel files and check the value of every cell i'm using an OleDb connection to open it and reading but i have this issue if some of the cells in the excel sheet is having this warning when i try to read it returns DBNull .knowing that i can not force the user for not having this warning ...i have to solve this within my code .
View 5 Replies[code] I am getting a run time error for this code. How can I change it. and how to limit the loop to print number from 1 to 42 and not 5 in the list ?
View 2 RepliesI have sql server2000 encypted stored procedure. I can not modify them. Typicaly all the procedures manipulate row by row different tables using cursors etc. When the stored procedure is executed at the Query Analyser screen, I see error being thrown in between but the procedures continues till all the records have been processed. This behavior is acceptable to the client. I now need to automate the process using VB.net 2002 windows application. I call the procedure from vb.net but the program throws runtime error on the 1st occurance of a error in the stored procedure.
View 2 RepliesGetting some errors with a loop. It's a log-in app that has username, passwords & account type stored in a SqlCe database. I would like it to sync with a larger database for updates that has not been made so i left it out but I have started to make a loop that would connect it to the larger DB and if connection failed would try a set number of times before stopping the program. I'm coding this project with Visual Studio 08 pro
Dim conndb As New SqlCeConnection("Data Source = |DataDirectory|\Mydb.sdf")
Dim x, y, z As Double
x = 1
y = x + 1
z = 5
[CODE]...
I have 10 number in a set a variables. (say: 25, 33, 11, 4, 3. I want to get the biggest number in a message. How do I get it?
View 2 RepliesI am trying to make a program in Visual Basic 2008 Express edition which have a textbox where the user can write information to search for in a simple database stored in the program-code.
What I would like is that when the user types a word, a string variable connected to that textbox.text will be treated as a string. BUT if the user types a number in the textbox, the textbox.text will be treated as an integer (for example a "Double")
Need to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:
Example (the "@" is the separator):
@
The character The Code End of line
A @ 4gh EOL
B @ 84!9 EOL
Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:
� Read any private key file
separator = readline(file);
while not EOF(file) do
tempStr = readline(file);
[code].....
one of our programmers is having an issue with a asp.net app. i had him rebuild and recompile the app to the network share on the staging server and received the same. i even deleted the files in this folder(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files). to make sure that the server was not the issue i installed it on another server and received the same error.i found a article on msdn that states that its a source code issue.
Compiler Error Message: BC30041: Maximum number of errors has been exceeded.
Source Error:
[No relevant source lines]
Source File: vbc : Line: 0
I have a list of 100 assets that are pulled from AS400 and shown on a gridview alongside a dropdown box with 6 possible status and a textbox.
If the user selects a status other than "Found" (whether it's "Not Found", "Scrapped", "Sold", "Transferred","Other"), the user cannot leave the textbox empty. They must insert a comment into the textbox. Once the user is done he clicks "Save" and if, let's say, the status is "Sold" and the textbox is empty for all assets then a Message Box pops up saying "Please fill the textbox".
The problem is, the message box pops up 100 times (or once for every asset that has the error).
1) What can I do so that the message box only appears once even when 100 assets have the error?
2) Also, when the message box appears and I click "OK" the information the user had filled up to that point gets erased.
SAVE CLICK EVENT
Protected Sub Save_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Grabar.Click
Dim comando As String = ""
[Code].....
i have to convert a visual basic 6 program to the visual basic 2008. i used the wizard that is provided to upgrade but that just doesn't work. It comes up with many errors. most of them are End of statement expected and Number of indexes exceeds the number of dimensions of the indexed array. I really don't know what to do with them and i have to fix them in order for it to run.
View 18 RepliesAfter exporting data using a third party component the data in the excel sheet isn't type correctly. Excel thinks that some values are string while they are numbers and a little green triangle shows up.
We've coded the following to fix this:
For Each objCell As Microsoft.Office.Interop.Excel.Range In objWorkSheetReport.Range(objWorkSheetReport.Cells(1, 1), objWorkSheetReport.Cells(Me.RowCount + 10, Columns.Count + 10)).Cells
[Code].....
This removes all those little green triangles but is really slow.
Is there a faster way to convert a Range of data quickly so the green triangles don't show up?
I am making a little application to provide a simple GUI for editing controls for some old games that use INI files to store their config.I have just come across the following ini file key but I can't see how it is storing the controls. It is meant to be for an NES pad, which has 8 buttons - Up, Down, Left, Right, Start, Select, A, B.
Quote:
[Controller 1]
Keys=C800D000CB00CD002D002C000000000036001C00000000000000000000000000000000000000000000000
[code].....
I'm back again as I'm waiting for the coffee to kick in and have another question that seems to be not causing my brain cells to fire correctly.
I've set the following code to determine the line numbers of all rows returned from the procedure loop.
linenum = 0
Do While (rsData.Read())
linenum = linenum + 1
loop
Now I'm trying to code a button that will move users to different sections depending on the linenumber returned.
So if there's only one linenum with a value of 1, they get a button to 'Apply'.
If the total linenum values are greater than 1, they get a button to 'select apply date'.
Now again I'm having a brain fart and can't think of the logic if theres a linenum of 1+ how to determine the button should be displayed. It needs to include the value of 1 as well as there are more than one linenums so the button should display the 'select apply button'.
Write a function that will take one integer input parameter, create a sequence of numbers stored in an array from 0 to that number, and the numbers are a summation. For example, given 7
View 17 RepliesI am trying to test a number of stored procedures through SQL Server Query Analyzer. But am stuck when I try to test stored procedures that contain Output parameters.
Code:
DECLARE @Counterbigint
DECLARE @GUIDuniqueidentifier
exec usp_tbl_User_Add @Counter, @GUID, 'UserName', 'First Name','Surname',
[Code]....
When I put the Select statement though in the 'usp_tbl_User_Add' stored procedure in works fine and gives me the correct values.
So I've recently been vexed by problems similar to this one: Oracle .NET error - Wrong number or type of arguments. I know oracle is famous for its terrible error reporting, but this is a giant pain to debug -- if you have ten parameters, that's twenty things to check by hand (types and names,) not to mention the actual number of parameters, and if they're actually legitimate values.
Is there some way to get better diagnostics on stored procedure calls to oracle?
I recently upgraded a project from 2003 to 2005, and there were errors in them, but I am unable to view any in the error list. Only one error displays in the list
[Code]...
Write a complete Visual Basic program to do the following: Joe's Pizza Palace needs an application to calculate the number of slicesa pizza of any size can be divided into.
The application should do the following:
Allow the user to enter the diameter of the pizza, in inches.
Calculate the number of slices that can be cut from a pizza that size.
Display a message that indicates the number of slices.
To calculate the number of slices that can be cut from the pizza, you must know these facts:
Each slice should have an area of 14.125 inches.
To calculate the number of slices, divide the area of the pizza by 14.125.
The area of the pizza is calculated with the formula: Area = π r2
Note: The π is pi which is equal to 3.14159.The r is the radius of the pizza. Divide the diameter
by 2 to get the radius.
Form:
The application should be done form-based. You may design your own form. It must have the following:
a label indicating that it is Joe's Pizza Palace
a field with label to enter the size (diameter) of the pizza
a field with label to display the number of slices
buttons to calculate the number of slices and to exit the application
Output:
Use the following test data to determine if the application is calculating properly:
Diameter of Pizza Number of Slices
22 inches 27
15 inches 13
12 inches 8
Requirements:
Name the project Pizza.
Be sure to include your name included in a comment
No credit is given for a program that will not execute.
All rules of academic integrity should be applied as stated in the syllabus.
Submit the zipped project into Moodle.
I have errors saying "With Held " events
WHAT IS WRONG WITH what I HAVE
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles button3.Click
' End the application
End
End Sub
[CODE]...
I have declared an array of text boxes created dynamically at run time. The textboxes are assigned some values by user. The text boxes are located in a Form so that once the user fills in the info and clicks the "ok" button, these values are passed at the back end and the form dissappears. However the user can bring back the form again by clicking another button.
The problem is that once the form reappears, the information previously provided in the form remains. Even the user clears the text boxes to provide new value, the text boxes at code behind do not receive these values.
How do I get text stored in a text document from a website? I know it is possible, just dont know how.
View 2 RepliesIn VB if you prompt the user for a number between 1-20, then a word, how do you get a text box to show the word the same number of time as the number selected using loops?... Ex: please select a number: 4 / select a word: cat....the text box should display ::: catcatcatcat ........
I am doing this for a class and my brain has locked up. Prob. just over thinking it though. Thanks in advance for any help!
I have a hardware which sends out packets containing 17 bytes to the comport in bursts of 3. the little test VB that I have written receives and displays the bytes in a line of 17 bytes long and works fine until it gets to around 170th packet, then it starts to mix up (looks like shifting the data left) the bytes shift mostly by one digit sometimes by two. then it will continue to give almost a packet correct and a packet shifted for about 50 packets. Then it will correct itself for a long while, but then the speed at which it receives drops. All the packets are sent 3 times, and before things go wrong (within the first 170 packets) the packet counter shows that it receives 3 packet each time but after the problem it goes to 2 packet per burst and then to one.
If i close my VB monitoring program say at packet 165 and immediately open it again, it wont go wrong for another 170 packets, this points the finger at VB. I have check my hardware, there is no problem with that.The program reads port - waits for 17 bytes - once 17 has been received it will go and buffer the packet in an array. In fact they are 2 arrays but printing fro either results in the same problem.I have tried whatever i could think of but to no avail, i am wondering if some kind of house keeping needs to be done to clear something... I am sorry the program is a bit messy but I have been making many changes to find out what the problem is - my code below:[code]
I am creating xml files that contain chinese posts and it seemed to be working but I started getting an error:
This page contains the following errors:
error on line 4165 at column 25: Input is not proper UTF-8, indicate encoding ! Bytes: 0x0B 0xC3 0xA5 0xC2 Below is a rendering of the page up to the first error.
When trying to open some of the resulting files.The line it references contains chinese characters and this occurs only in some situations and my guess is that the text is sometimes containing some characters that throw it off. How can I ensure that the text for that field will always be properly encoded? I don't even understand why the issue yet.
Public Shared xwriter As XmlTextWriter = New XmlTextWriter(xmlfile, Encoding.UTF8)
I make sure the xmltextwriter is properly declared.
EDIT:
The issue is that I use vb.net and apparantly it encodes everything in utf-16 so I assume this is fine. The problem is that the text I am receiving is probably double encoded or incorrectly encoded and I need to clean it before using it; so that my xml is valid.
EDIT:
so if I need to fix my data, my question is how can I detect what encoding is used for a specific text and how do I convert into utf8 format that can be viewed in an xml file and make the file valid.
When I publish the program. Is there any way to get VB to publish the text files with the program so that no errors can occur. When I install and run the published program I get a series of errors relating to text files that are not found.
View 4 RepliesI have a .net application that uses customerrors web.config module to display meaningful messages for errors. It works without any issues for 500 errors/exceptions caused by non-ajax and ajax components (updatepanel). However, in a scenario where updatepanel's asynchronous request times out, there is no error raised at all. I was able to see the timeout in firebug and come up with a solution that would at least display the error message as an alert and then redirect the user to the 500 error page using javascript but it's not quite doing what the rest of the application does in case of an unhandled errors like these. I basically just want everything to go through "LogEvent" mechanism so based on the severity of the error, it does the necessary work.This 500 error page doesn't have anything in the Server.GetLastError() for these timeout scenarios. Is this an expected behaviour? Can it be changed so I do have access to these timeouts in Server.GetLastError() OR maybe just run this error through "LogEvent" mechanism? Is there a better/more graceful way to handle this issue?
Below is my code to give you an idea, not exactly what I have in my application but pretty close.
Web.Config
<customErrors mode="On" defaultRedirect="~/Errors/ErrorUnknown.aspx" redirectMode="ResponseRewrite">
<error statusCode="500" redirect="~/Errors/Error500.aspx" />
</customErrors>
[code]....
My application crashes when trying to save a word document as text. The error at SaveAs is "Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" I am opening and manipulating a Word 2003 Document (using Word 2007) and then trying to save it as a text file.
[Code]...
[code]The two Location lines throw errors but the Text line works fine. I've played around with this until I'm blue in the face but can't get it to compile.
View 4 Repliesi was just wondering if there was a way that i could compare data stored in a text file such as usernames and passwords with data input into text boxes in visual studio vb2008?
View 6 Replies