VS 2005 - Loading From A Database - Too Slow
May 6, 2009
I've got a database that's 13,000 lines long and I'm trying to load this into a string array when the program loads but it takes approx 5-6 minutes for it to load it.I've got a MS Access database or an Excel file that I can load this information from, each has two rows: SVONo, Description This is my current MS Access
[code]...
Does anyone have any idea of how to make it faster? Or does anyone have a better way?I did have the idea of loading it by letting the user select the first letter and then only loading the ones that begin with that letter but I've got 4000-5000 'S' ones and it still takes about 2-3 minutes to load it All I want is to load the data from the database or the excel file and then put the products into 'cboProducts' and the 'cboProducts AutoCompleSourceList' and the descriptions into the 'txtDescriptions' AutoCompleteSourceList and a string array.Then when the user selects a product using 'cboProducts' the description will automatically be put into 'txtDescription'.
View 12 Replies
ADVERTISEMENT
Oct 3, 2011
I'm creating my first Report in VS2010.I have tried Report Wizard but the loading is too slow.
I'm retrieving the data from access.Does anyone know another way to create Reports,
View 10 Replies
Jul 9, 2010
column name = CustomerName
SQL server database name = SQLDEV6.
I have been given a task to create a application in vb that is supose to load data from a table named tblCustomers from a DataBase.
View 6 Replies
Jul 13, 2010
I am trying to load CustomerName and PrintStreamACNO from tblCustomers to my dropdownlist. I am not getting the correct syntax on the binding and displaying.
Imports System
Imports System.IO
Imports System.Reflection
Imports PSXSTL.Data
Imports PSXSTL.Data.DataAccess
[Code]...
View 2 Replies
Aug 2, 2009
I would like to enable my app to run from a central database, but I dont want to recompile should the DB server change. Are my only two options saving the connection string to an XML file or the registry?
If so I think the XML file will probably be the way I go at least for me. I dont really want to mess with the registry. I just wanted to check what my options are.
View 10 Replies
Dec 12, 2009
The main problem is when I try to type code for Visual Basic 2005 onto my new Windows 7 computer ( using the Virtual XP set up) it is very slow. There is a big delay when I type a word and it appears.
View 2 Replies
Apr 2, 2009
I have built an application using VB 2005 express edition with backend Ms Access 2000. In main form(which is loaded on startup), I am having 9 datagridviews, each bound with databindingsources. I am refreshing this data every 15 seconds by refilling the table adapters and updating the datagridviews.Now, this access database is shared in the network and is accessed by about 5-6 users concurrently. There are other forms which are used to edit the data.My problem is poor performance of the application. Its very slow in opening up forms, not responding sometimes and using the network resources fully.
View 5 Replies
Mar 29, 2011
I am using VB.NET with a MySQL database. I want to update this code to do it all in ONE SQL instead of THREE. Here's the code I'm using, works fine but too slow with multiple lines...
If count3 = "1" Then
Dim myCommand As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
Dim SQL As String
myCommand.Connection = conn
[Code] .....
View 1 Replies
Jun 2, 2009
I am using a DLL in my application that will probably be experiencing frequent updates. I want the DLL to detect the new version (I know how to do this), load the new version of the DLL into memory, and continue running. Is this even possible? So I need to know how to: Unload the current DLL. Load the new DLL. If possible, do this from the DLL in question. Is this even possible? If not, how close can I get to this?
View 6 Replies
Mar 29, 2012
i have a problem with loading forms in VB and i was hoping someone can help me. this is the code i made:1st form.form name: formload.vb [code]now the thing is whenever the loginform appears when i successfully entered the accounts the form the userinterface will appear and the loginform disappears for a few seconds then reappears again.i wanted the loginform to disappear the only form that is visible is the userinterface.how to make database of accounts where the login form depends on?
View 4 Replies
Apr 2, 2012
I am doing a project for part of my coursework which involves the creation of a series circuit designer.
I am having some trouble with the saving and loading functions; I had intended to save them to a text file with commas separating the component name and the value (if any) attributed with it.
Grid(xcoord, ycoord, 0) contains the component name. Grid(xcoord, ycoord, 1) contains the attached value (resistance or voltage- components such as wires have a value here of 0)
Once the save button is pressed, the text file contains 50 rows of "0".
P.S. Let me know if any other parts of my program are required.
Dim comp(maxsize) as ccircuits[globally declared]
Const maxsize = 50
Structure ccircuits
[Code]....
View 2 Replies
Aug 15, 2009
I have a main form when loaded will display a login form. I want that when the main from loads, the login form and another form will be loaded side by side.How do I show two modal forms?
View 2 Replies
Nov 11, 2009
I have a desktop application that shows a list of pdfs, and when the user selects one it shows it to him/her. I use the AcroPDF control for this, and it seems to work, but if the user goes back and forth between viewing the file and viewing the list, then the control randomly decides not to show the file (showing a blank page instead).
View 4 Replies
Nov 25, 2009
Instead of loading a crsytal report from a path like this:myCrystalReport1.Load("C:Program FilesAstec IndustriesPlantDailyShiftReport.rpt")Is it possible to include the crystal report in the solution and load it from there? I've used this is asp:
Dim myPath As String = (Server.MapPath("PlantDailyShiftReport.rpt"))
myCrystalReport1.Load(myPath)
View 1 Replies
Jan 28, 2010
i am hiding a form and showing another form by this bit of
form1.show()
form2.hide()
form 2 contains of a dgv and by the form1 i am editing the contents of the dgv present in the form 2.......
after making the changes when again i show the form2 and hide the form1,then the changes made did not appears in the form2............
i have this bit of code at the form load of the form2:
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=LibraryManagement.mdb")
con.Open()
[Code]....
now when i close my application and again reload it then then changes that i made appears in the dgv of the form2........
if i am showing the hidden form then at the time of showing it,does the form load event of the hidden form is raised?
or,
the hidden form is already loaded and there is NO form load event and only the form is shown and hidden...
View 3 Replies
Aug 26, 2009
I have been given the below form but here i cant understand the use of this checkbox named LoanCredit card number.I am told that when user checks it then all master data will be displayed. does it mean that when i am entering some data in the database then the data will not not appear in the dropdownlist of the creditcard no. combobox automatically,on checking the checkbox the creditcard no. which is saved in the database will be added in its dropdown list? again when i uncheck it then again the dropdownlist of the combobox will become empty?
View 3 Replies
Aug 22, 2010
I have a main form when loaded will display a login form. I want that when the main from loads, the login form and another form will be loaded side by side.How do I show two modal forms?
View 19 Replies
Mar 16, 2009
I am currently developing an application that will be the "base" for several components (business reporting systems, order management, etc). The idea is that our customers will install this "mother application", and we will offer components that will slot into it, expanding the functionality.
Now, here's my idea for how to make this work. I have some of this basic functionality down, but I want to get other people's opinions, ideas and experiences with this sort of thing before I move too far in a direction that might not be the best way to go:
[Code]....
View 11 Replies
Mar 2, 2009
I am currently trying to load an XML file into my app. However, it keeps throwing an exception error (InvalidOperationException - Object reference not set to an instance of an object) and I can't work out why. have a look at the code below and see if you can spot the error? I'm still very much a beginner so i'm sure it will be something simple..
Public Class FrmXMLReaderTest
Inherits Form
Friend WithEvents txtOutput As TextBox
[Code].....
View 7 Replies
Aug 17, 2010
Why my form loads takes time the first time I clicked the menu to load it (I even see not responding on the title bar), but when it is already loaded, I will close it and clicked the menu to load it again then it load fast already....
Here is what I have in my declaration section
Private cnn As New SqlConnection(My.Settings.MyConnectionString)
Dim cmdLocked As New SqlCommand
Dim daGrade As New SqlDataAdapter
Dim daLocked As New SqlDataAdapter
Dim builder As New SqlCommandBuilder
[Code] .....
View 13 Replies
Aug 19, 2010
I have a menu which when clicked will load form which take quite sometimes (although not very long) but the user keeps on clicking the menu and so the "not responding" message appears on the title bar of the app. I am thinking of displaying "Loading....Please Wait" so that users will stop clicking the menu or will wait until the loading of the form is completed. I tried these code but the form is still displayed even if form has loaded completely. [Code] I like to use the same concept also when the user clicked the save button, to tell the user to wait while changes are being saved.
View 36 Replies
Jan 9, 2010
Get information from an MP3/WMA without loading it in a WindowsMediaPlayer control?
View 4 Replies
Nov 25, 2009
How do I get message box to stop loading new form I have the following code on a button that loads new form
h
If Me.File_Name.Text = "" Then
MessageBox.Show("No DataFile Has Been Selected", "Please Select a DataFile", MessageBoxButtons.OK)
I want to stop loading the form is the message box appears
View 4 Replies
Apr 27, 2009
i have a listview and everytime I load a 10,000 data my listview hang up. Is there any alternative on how to load data to listview that will not hang up.
View 10 Replies
Jun 23, 2009
am trying to load data from an excel worksheet & its really giving me headache. A particular column contains both string and numeric data. its picking only the numeric data & loading the string data as blank entries. I tried checking what may be wrong, i think i saw a documentation that says Excel scans the first 8 rows of a column & determines it data type.plz, how can i load everything on the sheet (i can get everything as string, but i dont want to lose any entry)
View 3 Replies
Dec 17, 2009
I have a form with about 50 controls on it. labels, check boxes, combo boxes. text boxes and so on. Now I have a image on the back ground of the form and have made the checkbox text with transparent back ground so the picture can show through. the problem is that it is so slow to load. I see each one appearing on the form one by one. I have tried this on multiple machines and it does it on all of them. I have tried making the checkboxes not transparent but it still is slow.
how can I allow the form to load completely before it displays it. This is the initial form that loads and shows up.
View 3 Replies
Jan 18, 2009
I keep getting an IOException, because the file is apparently already in use. I'm pretty sure I closed every handle, and I don't know what to do.
High-Score
If haswon Then
Dim strFormat As New StringFormat()
[code]....
View 4 Replies
Aug 10, 2010
I am trying to load contents of an Excel file in a datagrid. The data in the Excel file is arranged in rows and columns. Every column has a column header. Now here is the anomaly. For some reason when I put a less than sign (<) before some of the values in the last column, the values become blank before they are loaded into the data grid. This behavior is not observed when the less than sign is put into the other columns. More strangely the values are retained in the datagrid even if the the < is put before the values of the first few rows of the last columns within the Excel file. I used the following code in loading data into the Excel file:
Dim con As OleDbConnection
Dim da As OleDbDataAdapter
Dim ds As New DataSet
[code]....
View 5 Replies
Jan 1, 2010
Im having a problem loading a html file to a webbrowser in a program im writing. What it does if I press a button or menu item a form is loaded and a html help file is loaded to the WebBrowser1. here is the code
Public Class frmWeb
Private Sub frmWeb_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim path As String
[code]....
View 2 Replies
Jul 12, 2010
this is a reference to the thread:he problem I was having while loading data into a datagrid from Excel is solved when I have changed the connection string property IMEX to 1 in:
HTML
con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filename & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1;""")
[code].....
View 1 Replies