VS 2005 Where - How To Handle Data Mis Match
Dec 16, 2009
I have a small databse program that reads a .csv or text file.
my code
Public Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OpenToolStripMenuItem.Click
OpenFileDialog1.InitialDirectory = "c:"
OpenFileDialog1.Filter = "CSV Files (*.csv)|*.csv|Text Files (*.txt)|*.txt"
Me.OpenFileDialog1.FileName = ""
[Code]...
i am trying to Catch a data mismatch, if the user happens to select a .csv or text file but they arent of the right type of data. Dim result As DialogResult = MessageBox.Show("Wrong Data Type", "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Stop)If result = Windows.Forms.DialogResult.OK Then
(not sure what to put here)
End If
Catch
End Try
I want to make it so that if the user selects the wrong file, it stops executing shows the message box , the user is only given the option to hit "OK"then it starts the openfiledialog click event again or stops and the user can open the filedialog again It seems that even though the ex is caught the rest of the code will keep running and from what I can tell from the documentation thats by design?
View 11 Replies
ADVERTISEMENT
May 29, 2010
Am trying to match characters or combination of the characters i specify in any order they appears
vb
Regex.IsMatch(teststring "[nuls]")
what i want matched is either any single character, or combination of any of them in any oder. this means that it should not match any character not specified in the pattern.
For example
it should match
n,u,l,s,nu,un,lun, sl etc
not
ny, nx so etc or any other
View 9 Replies
Jan 2, 2011
I am working on my project as I am trying to reads the whole strings in the php page while read the strings from the textbox. When I input 4 matched digit numbers, it displaying the messagebox that says the number is incorrect which it does.[code]I am trying to achieve by read the strings in the php and find the strings if it matched with the textbox strings and then display the messagebox??
View 11 Replies
Jan 10, 2011
if i want to match the first recod with database so i use the following procedure. If it finds the record so it binds the data which i mentiond in bind function. right. suppose if i want to match the data which is rows 0 item 0 and rows 0 and item 1 then please assist me what chagnes i made in this for loop?
dss.Clear()
[Code]...
View 1 Replies
Sep 1, 2009
I execute a stored procedure which updates data. Is there a way to refresh the data in a datagridview to match the database's data.
View 9 Replies
Mar 27, 2010
I'm making a photo editor and the size of the image depends on the size of the window, like the Zoom mode in the BackgroundImageLayout property of a form. It works sometimes: when resized only a small amount, it does nothing, but when the image is resized more than that, it jumps to the right position.
vb.net
Private Function GetImageRect() As Rectangle
Dim r As New Rectangle()
If Me.ClientSize.Width > Me.ClientSize.Height Then
[Code]....
View 3 Replies
Mar 31, 2011
I have a table that has a "date" column and an "amount" column. I also have a form with two DateTimePickers ("dtp1" and "dtp2"), a button and a label. The label should show the total amount calculated from the rows whose "date" value is between the dates picked by the user with the DateTimePicker controls.
I keep getting an error with my SQL statement, and I don't know what to try. My code is as follows:
Private Sub getData(ByRef total As Double)
Dim connection As OleDbConnection
connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\proyectogestion.mdb")
[Code]....
View 4 Replies
Apr 6, 2011
I have 2 representations of similar data from 2 different systems and I need to match each entity in one system with the entities in the other.[code]...
View 1 Replies
Apr 21, 2010
Is there any limit to the no. of handles assigned to an routine. Well actually my form form has about 80 controls and when ever the user press the enter key, focus must be to the next control. so can I handle all the 80 keydown events in one routine, or is there an better way.
View 3 Replies
Apr 9, 2009
The app Im working on is dunning on an embedded xp machine. It recieves input from the serial port from an industrial process, and then a backgroundworker class calculates and updates the single form GUI with the results from the process. Very simple.Now, the customer want to allow automatic download of log files by an USB memory. The process should work like this:
1)User plug in an usb memory
2)SHow a virtual keypad (touch screen) where the user enter a security code
3)If code ok, show a 3 choice screen, if not ok show error message and allow the user to try again.
4) If user choose the "export all" button, this choose form will close and i display another form with a progress bar that show how all files are copied to the usb memory. When this process is complete, I will display teh form that says "remove the usb memory and press ok to restart the application.
As you see here lots of forms are created and disposed based on user choices. My biggest issue here is that I have no clear design pattern to work from.For example.. should I have this "chain" in the main gui form, or should I let each form create the next form. For example on the "select action" form, when I press export, should this form create and show the "copy progress" form, or should all forms be created and destroyed from the main gui form?
Also, such an issue like with the password. I put it as a constant on the main form, to avoid "magic numbers" in the code. And then I ran into problem because the "keypad" form is created on another thread and I can't access the costant on the main form, so I got a cross thread exception.Everything starts when an USB memory is connected. And the OnConnected eventhandler is running on a different thread than the main UI thread. how to design this chain of window creation/deletion is greatly appreciated. I show all forms with the SHowDialog because I dont want the user to be able to close the form unless he/she presses a button. And not by accident press somewhere else.
View 2 Replies
Feb 12, 2009
I was just wondering if their was an easy way to create one handle for several controls. For instance, I have 20 buttons and I want them all to do the same thing when clicked. Instead of having 20 handles for each button.click, is there a way to create one handle that can cover them all, such as a grouping or something?
View 16 Replies
Dec 11, 2010
I am developing a vb.net application with MS Access Database . I have a field(cut) with double data type in table marks of markss.mdb.[code]On debugging , when I enter ,say 7.9 , in Textbox 1 ,I get an error saying Data type mismatch in criteria expression.
View 1 Replies
Apr 6, 2011
So I have a relatively small website with growing amounts of data - the fastest growing table is pageviews, as we do all our analytics ourselves. The website is made using VB.Net, SQL Server 2008 and jQuery. I am limited to .net 2.5.I currently handle all the data and validation using objects with a list of attributes. Each attribute is of a specific datatype and has a validation function when a new value is given to it. If the data does not validate then it won't even get as far as updating the database and feeds back an error to the user. Currently I have "Manager" classes and "Item" classes - Items are managed by a particular Manager class, for example Users are managed by the UserManager, so to get all the users I just have to call UserManager.Items. These Manager classes are stored in the cache and are created as needed - but once a Manager class is referenced it creates all of the Items within it. This is getting rather slow now, as the company is growing fast. It takes 2 - 3 seconds to load the first page (the page which makes most first-time requests to data) but I am not happy with this time. After that it is nearly instant.
Now the way I see it I have 3 options to speed the website up: Keep it as it is, but try to make it more efficient through other techniques;Change to creating all these objects on every page load, in the hope that it is simply so slow because I am using the cache to store a fair amount of data (about 10 MB or so at least);Forgetting using object oriented techniques and just use straight SQL queries and loop through records.
View 1 Replies
Nov 13, 2010
I have written a program that reads a 3rd party .txt file database. In one of the fields "City" the 3rd party adds a city abbreviation code. Example [code[The probelm is now the 3rd party has added an additional abbreviation Sacramento (Sac)(City)..They dont always have the addional abbreviation so I am trying to determine what is the best way to write a program that would handle the different situations.
View 10 Replies
May 19, 2011
I have a form with a TabControl on it. On the first tab I have a DataGridView and I have a series of controls to represent six separate filters that can be applied to the data in the DataGridView. Each of these filters consists of 1. a ComboBox to display the columns in the DGV so the user can select one to filter on2. a ComboBox to contain the different filter conditions ("Equal to", "Greater Than", etc...)3. a TextBox to allow the user to enter the string to filter againstSo that's what's on the first tab. Tabs 2,3, and 4 are visually identical to tab 1 although they will hold different data and have different capabilities.
View 4 Replies
Oct 22, 2009
(I tried with this question but this code isolates the problem better. I have this code:
Public Shared Sub PopulateTextFields(ByRef stuffList As List(Of Stuff))
Dim aStuff As New Stuff
For Each aStuff In stuffList
DoStuff(aStuff)
Next
End Sub
[Code]...
View 3 Replies
Sep 4, 2009
I have a standard windows application called winap. I have a com component which acts as an api to the winap. I have a class in winap call classapi which has all the methods that the api calls and all works well. The problem is that one of the methods in my class api needs to get a handle on form elements in the main worker thread. Whenever I try to access an existing form I keep getting null because the for exists in the main worker thread and my api call is in a seperate thread.
[Code]...
View 5 Replies
Mar 14, 2011
how to change the vb.net code to recieve data from serial port. The packect size of data is 23 bytes so the data recevied event is fored after 23 byte. the data from other end is transfering at 10 ms. after recieving data i have to extract data, add it to database & display the extarcted packet in datagridview.the problem is that i m not even handle the data at 100ms properly. it shows 9,10,6,7 packets in 1 sec. and some time thread synchronization error. i am attaching 2 project the vb6 project is transmitting data at 10/100 ms & the vb.net2008 appliction is doing all the stuff.
View 1 Replies
Sep 7, 2010
I tend to use
If Not IsDBNull(dr("data")) Then
myData = dr("data")
End If
to catch nulls. Is there a better way? It seems I use this over and over again? Anyone write a function to check this something like
mydata = IfNotNull("data")
I don't know how to handle the different data types that could be returned.
View 1 Replies
Jul 9, 2009
how to handle the xml data sent from HTTPService request. simply how to receive the xml data, and read the xml data, then insert the xml data into database. I show you my code:
httpservice in flex:
var xmlFile:XML = new XML(createXML) ;//createXML is a xml String,
covert to real xml file
// testing.text=xmlFile; //it works fine.
[Code].....
View 4 Replies
Feb 16, 2011
I have a data grid view with columns created when it was filled from a sql table. some of the data types are "bit" (meaning 0 or 1 and automatically shows a check box in the column of in the data grid view).I need to get a handle of the cell that has a check box in it so that when a check box in one column is checked or unchecked, i can change the status of the rest of the columns (only one column can be checked at a time) and then update the entire row in the sql server..when column 3 in the data grid view is checked, app will uncheck column 2,4,5 run sql statement to update changes?
View 8 Replies
Jan 19, 2009
I'm wondering what a best practice is for handling this.I've got a standard vendor table - with VendorId (which is PK, numeric) and a field the users call SimpleId (which is usually a name - don't let the column name of SimpleId make you think it's numeric!).I've got one datatable that comes from a data adapter that looks like this. And this already changes the table in the SQL database...SqlDataAdapter("Select VendorId, SimpleId From Vendor_T", _connection)I've got this datatable on one panel of my form with a binding navigator - and you can change the SimpleId for a vendor with this.
View 16 Replies
Jan 4, 2009
I am new to VB and I have a database that has three related tables. These tables show information about computer engineers.
table one is engineers details
table two is engineers allocated
table three is jobs
My form needs to have buttons where a user can obtain information
View details of all Engineers
View Names of all the Engineers working on a specified job.
Add a new engineer
I have set up the connection to the data base using the wizards and also made the dataset. How to handle retrieving the data from multiple tables.
Here is a screen shot of my data set
View 3 Replies
May 10, 2010
Is this class normally slow or maybe there is something in my process making it slow.I have to import 170,000 rows of data from a fixed length text file into a SQL table. It takes about 2 minutes in a DTS package on SQL server 2000. But we are migrating to a SQL 2008 server and since this code has several manual steps and does not manipulate the data I thought it would be easier to use the TextFieldParser object to handle reading in the data.
Here is the code:
CODE:
View 15 Replies
Sep 3, 2010
I've looked through a lot of snippets online and I see a lot of things similar to
Dim bytes(tcpClient.ReceiveBufferSize) As Byte
networkStream.Read(bytes, 0, CInt(tcpClient.ReceiveBufferSize))
but what I am unsure of when to call such a thing? How do I know when there is data to receive...in visual basic 6 with winsock, there was a specific routine which was called upon data arrival, but I see nothing of the sort for vbNet.
View 2 Replies
Sep 24, 2009
How do I handle user submitted data to ensure best practice programming? I would like to know what are the best practice programming tasks in relation to users submitting data through a web form to a website. I am particularly interested in any C# or VB.NET commands that should be used through out the process from the moment the user hits the submit button until the data hits the database. I have been reading about reasons why you may want to take precautions such as SQL injections etc.
View 4 Replies
Mar 22, 2012
I'm trying to handle DBNull exception while reading data from database. It's my code:
...
Dim SQLRDAs SqlDataReader
...
val1= GetStringFromDB(Trim(SQLRD("Name")))
val2= GetStringFromDB(Trim(SQLRD("Level")))
[Code]...
But still I get Conversion from type 'DBNull' to type 'String' is not valid. error.
View 4 Replies
Apr 13, 2009
I am new to Viisual Basic 2008 and looking for some help or suggestions on what is the best way to handle a spreadsheet style data entery in an application.What is the best way to have data entry on a form that is in the style of a spreadsheet?I have tried it with the Gridview but I do not care for the interface style.I would like to be able to multiple columns under one heading, allow for tabbing from entry field to entry field on a row and have the ability to sort by different columns,to allow for calculations by fiedls in a row (havoing multiple calculations, etc.Is there something in VB 2005/2008 that will allow that or is there a third party add-on that is recommended.
View 6 Replies
Feb 27, 2012
Say I have a 5 GB file. I want to split it in the following way.
First 100 MB is on the file
The rest go some reserve file
I do not want to use readalllines kind of function because it's too slow for large files.
I do not want to read the whole file to the memory. I want the program to handle only a medium chunk of data at a time.
View 1 Replies
Jan 31, 2011
My tile-based map editor project. So far, it works really awesome. Here, look at a picture: [URL] And the screenshot is outdated: Now I got the Pencil, Rectangle and FloodFill tools too!, the tilesets are from that popular (well, not so popular) game engine called RPGMaker.
Currently, this is how the map is structured:
One ArrayList represents the X coordinates.
One ArrayList in each X represents the Y coordinates.
One ArrayList in each X,Y represents the tile.
The tile is an ArrayList containing three elements:
The Image name (Tileset01 in the screenshot), the X coordinate in the image, and the Y coordinate in the image. Those coordinates are from the TILESET01 image, not map.
Getting the idea?
How do you locate a tile in the map when it is clicked?
First I get the cursor's position on the map picturebox, then convert it to a multiple of 32 (the tiles are 32x32, yes), divide the position X and Y by 32. The results are the indexes I need to get to the tile I clicked.
That method works just fine for me.
When the map picturebox invalidates and needs painting... When that happens, I iterate through each X and Y arrayList. When I get the arrayList that represents the tile, I use it to draw on the map.
For example:
Iterating X arrayList.... step 8......
Iterating Y arrayList..... step 3.......
Found arrayList with three elemetns: ("Tileset01",32,96)
Draw image on the map picturebox, source is "Tileset01" on rectangle (32,96,32,32)... draw it on map picturebox's point (8 * 32) and (3 * 32)
And so on.
Now you understand how I am working with my map editor, how I am locating clicked tiles, and how I am drawing it. Everything goes fine, except for one problem: At some point, the user might want to make a 500x500 map.
That means, an arrayList with 500 elements representing the X tiles. Then an arrayList with 500 elements for each X tile, representing the Y tiles. Then an arrayList in each X,Y pair.
Then multiply that result by 5, because there will be 5 drawing layers. How am I supposed to handle such huge maps?! My app explodes when I set the map dimensions to 500x500! 500x500 is the max setting allowed in my app. I also know that 500x500 map editors are possible, because I have seen others before. With great performance.
View 1 Replies
