Speeding Up Code That Copies Database Structure To XML
Aug 23, 2010
I have a database structure filled with data that I'm trying to write out to an XML file. Here's a taste of the way the VB code is structured:[code]I can't see or report any progress, because the processing is all tied to one giant LINQ query. Even if I can't make it any faster, I'd like to know how much longer I have to wait. My first version of this code had For loops instead of queries, so I could display progress, but it took a loot longer.Obviously I'd like to speed this up considerably. It seems like there should be a simpler way to convert the data to an XML file, especially since the database structure was created from the XSD in the first place.
View 1 Replies
ADVERTISEMENT
Jun 25, 2012
I want to find a way to speed up this code.if you look at the condition of If calculated Then in the code below, this is what slowing down the code.While the code provided seem fast with Const initBit = 4 try it with something over 12.
I want to be able to use this code (with calculated param as True) with initBit of 20 or more.
Beware that 20 or more might require a gig or more of ram and/or compiled as x64.
C# code (converted with an online tool from VB.NET):
[Code]...
View 2 Replies
Jul 29, 2009
My customers are literally screaming at me about loosing their data everytime a new version of my program is released. I have diagnosed the problem as being that a new blank copy is installed everytime, but I have no idea how to stop that from happening! Visual Studio 2008 with sp1
View 6 Replies
Mar 31, 2010
I have 8 thumbnails on a thumbnail browser page where each thumbnail is just a rectangle from the main image, not the whole thing.
Problem is, this needs to run on some fairly old machines where it's too slow in VB.net although the old VB6 version worked fine. Any obvious ways of speeding the following code up, or do I need to go back to API or use separate thumbnail images?
Private bmp As Bitmap
Private bmp2 As Bitmap
Private gr As Graphics
[code]....
View 4 Replies
Jan 21, 2011
I hoped you could give me som tips about speeding up som code i have to match an item to a collection of items... I have 1250 items that need to find the best match from 16774 items(every item is a class that consist of a string variable containing the path to an image, and 9 fields containg the most dominant color from a collection of 13 colors(the closest color)) The program does not use the filename or do any color matching in this step, only check the 9 fields... but it takes so
[Code]...
View 1 Replies
Sep 14, 2011
I am trying to speed this calculation up because I need it to run every time a textbox or a checkbox is changed within the program. My issue is that it runs so slow that there is a lag between changing the text or checking a checkbox and the actual completed calculation.
Sub CalculateP1LoanAmount()
On Error Resume Next
'create the variables for the calculations
Dim P11stPV As Integer = 0
[CODE]...
View 3 Replies
Nov 23, 2010
Dim Builders As New System.Data.OleDb.OleDbConnectionStringBuilder
Builders("Provider") = "Microsoft.Jet.OLEDB.4.0"
Builders("Data Source") = "C:UsersJohnDocumentsVisual Studio 2008ProjectsSimpleSQLTestSimpleSQLTestdictionary.mdb"
[code]....
So trying to speed up the query. The read of the last item is just to see how long it takes. I do a different method in VB6 and it loads very quickly. Trying to load a dictionary that is over 200,000 rows.
View 1 Replies
Jan 19, 2012
I've wrote this code to accomplish what the image below looks like. This works fine for anything that is around 40x40 but if I try to do 100x100 it takes forever and sometimes errors out with a window handle error. Once it gets around the 40th column the labels start adding slower and slower. Is there anything I can do to make this more efficient? I added the backgroundworker routine in there to see if it would speed things up at all but it doesn't.
vb.net
Private Sub CreateGrid(ByVal rows As Integer, ByVal ranges As Integer)
If Me.InvokeRequired Then
[code]....
View 5 Replies
Aug 27, 2010
How do I change the program path '"logic.txt", "G:"' in the code below to the OpenFileDialog.FileName? Cos when I tried it, I receive String conversion errors and I tried altering the codes but it didn't work out well. [code]...
View 1 Replies
Mar 26, 2009
I am once again struggling with my weekly project. I am assigned to write a program that converts a predetermined english sentence to both french and german. The code is to contain an Array and a structure. Also we have not covered retrieving array data from a TXT file, so we are to hard code in the array data. I coded the structure and the array, I added the array data, but am confused how to access the data. The examples I have found all deal with retrieving data from a TXT file. Can someone give me a nudge in the right direction.[code]....
View 3 Replies
Mar 13, 2009
I am trying to return a structure from a class.vb file to an aspx page. Is this possible, if so how would you do it in the aspx page and the class.vb file?
View 1 Replies
Jan 28, 2011
5 records to add
Try
Do While
Insert Statement
[code]....
When i get an error concerning duplicated values found, it just catch the sqlexception, display a message and exit try. But i want it to continue adding the remaining record even when a record of duplicated values is found.
View 10 Replies
May 18, 2010
What is the Microsoft Standard for Code Commenting
1. In case of Class 'Class header Comments
2. Function Comments
3. Subroutine Comments
There are different ways to comments like XML Documentation using ///
CODE:
Which Stnd should follow? May be something else other than above?
View 1 Replies
Jun 24, 2009
How do I change the program path '"logic.txt", "G:"' in the code below to theOpenFileDialog.FileName? Cos when I tried it, I receive String conversion errors and I tried altering the codes but it didn't work out well
vb.net
Sub Button1Click(ByVal sender As Object, ByVal e As EventArgs)
Dim sb As New StringBuilder(260)
[code]......
View 1 Replies
Feb 2, 2009
I'm trying to write a short program to for work but I'm not quite sure how to structure the code. This is what I currently have;[v
I'm pity sure this is majority the wrong way to structure it as at crashes with the IF/ELSE field going up to around 50000, but it does work (if a little sluggishly) when set to 5000.[code].....
View 13 Replies
Mar 13, 2009
Here is the:
Imports System.Data.OleDb
'Add reference to Access then
Imports Microsoft.Office.Interop
Imports Microsoft.VisualBasic
[CODE]...
I am using this to copy tables in an Access database(2003). the questions I have are:
1. How can I make this more 'obejct oriented'?
2. How can I copy just the structure of the tables and not the data?
(Currently both are occuring)
View 3 Replies
Sep 21, 2009
Just suppose that I define a structure, and an array such as
Structure Person
Dim First_Name as String
Dim Last_Name as String
[code]....
Can I fill in my list of people using a single line of code for each record? Something like this, it doesn't work, but this shows the sort of thing I mean.
My_List(0) = {'John', 'Smith', 24, '555-1234'}
My_List(1) = {'George', 'Jones', 31, '555-8123'}
My_List(2) = {'Tom', 'Green', 40, '555-3434'}
It's easy enough to fill it in line by line. I could do that without problem. But I want to be able to look at the code and see the contents of each line. Doing it as above would make it easier to read.I could make it a multidimensional array of strings, rather than a structure.If it makes any difference I'm using Visual Basic 2005 Express Edition.
View 8 Replies
Jan 9, 2010
Strategy on how to structure a VB.net GUI app. I have a application that is basically an interface to a database. It is comprised of a TabControl with 6 tabs, each tab has a few custom controls and performs a business operation on the database.
Tab Functions:
CODE:
Common Code Functions:
CODE:
Currently I've got most all of the operations built into event handler functions on the GUI thread. I'd like to move to a more object-oriented structure for code reusability and easier multi-threading.
I'm struggling with a few design things:
What objects / classes makes sense? Are there industry-standard best practices or design patterns around separating GUI and backend functionality? Any particularly good articles I should read? Is BackgroundWorker the best way to execute the backend functions?
View 1 Replies
May 10, 2010
i have the code bellow to write a structure to a text file, but nothing is happening,how can i get a error message if the file doen't exist?
Imports System.IO
Imports System.Runtime.Serialization.Formatters.Binary
Public Class Form1
[code]....
View 1 Replies
Apr 23, 2011
Can some one tell me how retrieve database structure in dataset with primary key columns or get the columns that not allow nulls
View 2 Replies
Apr 28, 2009
I m working on a project using vs2008+vb+sqlserver 2008. How can i secure my database, so that user can't see the structure of my database. I mean she shld not able to see tables and fields of my database. Is it possible in sqlserver2008?
View 9 Replies
May 28, 2010
I have a contact manager program and I would like to offer the feature to import csv files. The problem is that different data sources order the fields in different ways.I thought of programming an interface for the user to tell it the field order and how to handle exceptions.Here is an example line in one of many possible field orders:
"ID#","Name","Rank","Address1","Address2","City","State","Country","Zip","Phone#","Email","Join Date","Sponsor ID","Sponsor Name"[code]....
Notice that in one data field "Name" there is a comma to separate last name and first name and in another there is not.My plan is to have a line for each field (ie ID, Name, City etc.) and a statement "import to" and list box with options like: Don't Import, Business>Join Date, First Name, Zip
and the program recognizes those as properties of an object...I'd also like the user to be able to record preset field orders so they can re-use them for csv files from the same download source.Then I also need it to check if a record all ready exists(is there a record for Anson Call all ready?) and allow the user to tell it what to do if there is a record(ie mailing address may have changes, so if that field is filled overwrite it, or this mailing address is invalid,leave the current data untouched for this person, overwrite the rest).
While I'm capable of coding this...i'm not very excited about it and I'm wondering if there's a tool or set of tools out there to all ready perform most of this functionality...
View 2 Replies
May 10, 2010
I am creating an Add-In that I want to create classes and forms based on a database structure. I can't find any information anywhere on how to programatically add code to classes. I know I can write out the files and add them to a project, but that would limit what I can do in the future. I would like the possibility to update a function in the future which would be impossible writing out a file and loading the whole thing back in. It would destroy any modifications made to the class, and since this Add-In will only be creating a framework, there will usually be modifications.
I got this line from the macro recorder:DTE.ActiveDocument.Selection.text = strDACode
But I like to keep Option Strict on, and this is late bound according to the IDE. There seems to be very little help on the IDE and how to use it creating Add-Ins. If I overlooked something please point me there, but I can find nothing. I don't know if it can be done, but I was able to do it in an Add-In for VB6.I would also like to add controls to a form, so if anyone can point me somewhere where it explains
View 3 Replies
Mar 10, 2010
How to Save DataTable Structure And Data Into A Datatbase Table..
View 7 Replies
Jan 5, 2012
Module Module1
Public Structure structure1
Public TRANS() As structure2
End Structure
Public Structure structure2
Public X() As Integer
End Structure
End Module
View 17 Replies
Jan 5, 2010
I'm new to VB 2008 after having spent a long time with VB6, so I apologize if this is a stupid question. But I'd really like to have this straightened out.
Let's say I have a pretty large structure that has lots of properties.
Code:
Now say that I want an internal database with about 10 instances of this structure total, describing, say, 10 different products that a store sells. When these values are loaded from a database, they remain totally static. (However, they can be different each time a program loads)
Now say that I have a class. Each instance of this class is a type of that BaseProduct structure. Meaning, each instance of the class pertains to one of the 10 types of products that the store sells. However, this class has additional properties that pertain specifically to each instance, which are not static.
Code:
Now, the problem here is... If I have 200 different transactions, each one contains an instance of BaseProduct. BaseProduct is HUGE, and is largely redundant (only 10 types possible), so I think it's a little silly to include a whole copy of it with EVERY transaction. However, the Transaction class really needs information regarding the base product it pertains to. Is there a way to, instead of declaring a New BaseProduct in the Transaction class, to simply make one of the properties of the Transaction class a pointer to a BaseProduct variable?
In VB6, I would accomplish this by making a BaseProduct(10) array, and then giving each Transaction an ID number referring to an entry in that array. But in VB 2008, using class structure, this is impossible. I can't define the BaseProduct(10) array outside of a class in a namespace, and if I define it in the actual application's form, then the class loses modularity since it relies on the application that's using it.
View 11 Replies
Aug 29, 2009
I am trying to communicate with an external device and i am trying to send a byte array to the external device via sockets but i am always getting a response the message size is too small so i am not sure what i have done wrong. Between the data type there should be no alignment present and all numbers are represented in little endian format. The char array is not null terminated as mentioned in the protocol specifications.
I have to send data based on a struct that embeds 2 other struct. So here's my vb.net code for the struct used to convert to byte array and the sending part.
Public Structure MESSAGETYPE_OIP_Login
Dim Header() As COMMANDHEADER
Dim UserName() As PSTRING
[Code]....
View 2 Replies
Apr 14, 2012
I'm experiencing a problem with the following c-structure:
typedef struct tagTEXTUREPROP
{
DWORD dwSize;
[Code].....
The Marshal.SizeOf obviously calculates a size of 76 and it works with the DLL function, but it leaves me with some bad feelings.
View 1 Replies
Apr 25, 2010
I'm having a problem that's driving me crazy; I can't understand how to convert the XML structure into a class structure (that I want to use to hydrate a XML document).
The XML document looks like this:
xml
<?xml version="1.0" encoding="utf-8"?>
<artists xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/" xmlns="http://www.spotify.com/ns/music/1">
[code]....
View 2 Replies
Nov 22, 2011
I would like to get the number of copies of a job, in the que and limit the users if they print more than selected copies the the queue should pause it. not the number of pages in a job, the number of copies, and the second thing is , this code works on the local machine, how if a print is sent from the network, is there any way that I can pause that print wich is coming from the network or another machine, on the network, most of my printers are connected through ip, and some are shared printers.
View 4 Replies
