VS 2010 2 Ways Of Reading All Records - Which One Is Best And Why
Oct 17, 2010
I have come up with this 2 methods of reading all records on a database table. Both work nice but I would like your expert opinion on which delivers best performance and why.We are reading table "DATA" and filling an array called lstData with the contents of the "Data" field.
1) Method one is using the bindingsourse to go through all the records.
[code]...
My guess is that the first method, while simpler to the eye could use more overhead. What I really would like to know is if the second method really delivers better performance and if it is worth doing all the manual SQL queries.
View 7 Replies
ADVERTISEMENT
Jun 29, 2006
I am trying to create a bunch of records, there will be a limited number of "Codes", about 50. Each "Code" is associated with a name from a textbox, I was trying to have it save each one when you click a button, to a .txt file.So, from the start the record will be blank, the person will go through the form, choose a number from a numerical up and down box, pick a name associated with it (both of these are mandatory and not implied). When they click the button, it will save the contents I talked about into a .txt file, say the number is #2, and the name is "Bob", the next time they try to change that value for #2, it will overwrite "Bob".
View 6 Replies
Oct 11, 2009
I want to store say like 8 values, that in the end will be combined into one string. What's the best way to store them? They should be reached in a own namespace I did. In a separate .vb file. I want to able to edit them. The values are both text and numbers. So whats the best way according to you?
View 3 Replies
Aug 15, 2011
just as I would read an SQL file in order with code such as:DCReader02 = DCCommand02.ExecuteReader()While DCReader02.Read() End While I am looking for the equivalent code to read each line of an Excel file until end of file. The Excel file was opened with
Microsoft.Office.Interop.Excel.Application / Workbook / Worksheet coding.
View 4 Replies
Aug 29, 2011
I am having dataset with 5000 records.I am reading them in the below 2 functions and writing to excel.
FillDataRows1(worksheet)
FillDataRows2(worksheet)
private sub FillDataRow1(byval ws as worksheet)
[code]....
When I create thread also it is taking same time .
View 1 Replies
Jan 15, 2012
I'm Rather new to coding, and It seems like I skipped some of the basics, and jumped in the deep end.I'm having a couple of problems, as I have an ordinary text file called "Orders", and this file stores Orders, placed by users of my program.The Users write to the Orders.txt file, 5 lines per Order, For Example :
Item Name
Item Quantity
UserName (Of user)
[code].....
View 4 Replies
Apr 22, 2012
I have a database with 3 tables: Student, Unavailability and Duty.The fields for Student are entered in a form I have. One of the fields in Unavailability is filled by a form, the other fields are an autonumber and a foreign key to the Student table.ow I want records in the Duty table to be created and automatically filled in depending on what the values of the fields are in the Student table.For example, If the Boarder field in the Student table is 'yes' then I want the Duty Number field in the Duty table to be '1', '3' and '4'. If it is 'no' then I want the value to be '2' and '5'. I recognize it will have to create several different records to incorporate the different duty numbers for each StudentID. Obviously this will require an if statement, however this is my first time implementing a database with my limited experience with programming and Visual Basic, so I don't know how to refer to the specific fields in a table and set the value of other fields depending on the data in other fields.
View 6 Replies
Mar 18, 2012
I'm having a little trouble trying to read a word document in vb. how to get the text out of the word document would be great.
View 4 Replies
Feb 14, 2011
I have this code List<string> myList = new List<string>();
myList.AddRange(new MyClass1().Load());
myList.AddRange(new MyClass2().Load());
myList.AddRange(new MyClass3().Load());
myList.DoSomethingWithValues();
What's the best way of running an arbitrary number of Load() methods asynchronously and then ensuring DoSomethingWithValues() runs when all asynchronous threads have completed (of course without incrementing a variable every time a callback happens and waiting for == 3)
View 4 Replies
Jan 15, 2010
I'm trying con build a simple chat client/software (whole in on executable) wich start listen from the start on the port 5900 and when a client connect to that port the chat is established.
The problem is that only the client can chat to the server, the server cannot answer the client because the connection is working in one way.The i've tried to connect from "server" to the client when it establishes a connection but the system crash warning me that the port is already on use.
[Code]...
View 1 Replies
Nov 14, 2011
What is the difference between these ways to delete a file.Is one of the methods better than the other?Are there other ways to delete a file (. Net 4)
System.IO.File.Delete(path
to file)
My.Computer.FileSystem.DeleteFile(path to file)
View 3 Replies
Jan 28, 2009
I'm new to VB and have over the last week or two been looking at the different ways to play audio (mp3's). Windows Media Player, Microsoft Multimedia Control, Bass.dll, SndPlaySound, MCI SendString and DirectX (including audiovideoplayback, direct3d and directsound.) I originally decided to use windows mediaplayer, mainly because it seemed the logical choice but quickly found out I couldn't get it to work properly.
So I installed the Directx SDK but now I'm completely overwhelmed about what to use and why. I need to be able run the compiled code on a win 2k box, play an mp3 from start to finish then load and play another mp3 from start to finish and so on. Whats the difference between the varied choices and which would be the best for me to use?
View 5 Replies
Jun 13, 2011
I want to know by how many different ways I can create an object. The most common usage I am aware about is:
Dim obj as ClassA = new ClassA().
View 1 Replies
Aug 20, 2009
I'm new to VB.NET programming.What I'm confused about is the different ways one can declare a variable.Would someone please explain the difference between the two declarations below? [code]
View 2 Replies
Dec 10, 2009
I'm new to VB and have over the last week or two been looking at the different ways to play audio (mp3's). Windows Media Player, Microsoft Multimedia Control, Bass.dll, SndPlaySound, MCI SendString and DirectX (including audiovideoplayback, direct3d and directsound.)I origninally decided to use windows mediaplayer, mainly because it seemed the logical choice but quickly found out i couldn't get it to work properly. So i installed the Directx SDK but now i'm completely overwhelmed about what to use and why.
View 3 Replies
Jul 14, 2009
What are the different ways to send the emails using vb.net?
View 4 Replies
May 4, 2010
I'm looking at creating an mp3 player to keep myself busy. However I'm trying everything I can to avoid using the windows media player COM component. It makes it a little too easyWhile looking around I stumbled upon the DirectX.AudioVideoPlayback namespace and I was wondering if this would be sufficient. Would I be able to create an equalizer and other more advanced things for my application?
View 2 Replies
Jun 20, 2012
Just found out the hardway that there is no longer support for Direcshow for VB.net and C#. Does anyone know other ways of playing mp3s in VB.net, or even video for that matter?
View 9 Replies
Feb 17, 2012
Presuming "instantiate" is the appropriate terminology, may I get some insight as to which of these are better, more efficient,[code]...
View 3 Replies
Oct 6, 2009
Im using VB in VS 2005.I have found several methods of testing if a value from a dataset is null. Are there differences between these two ways of doing it:
[code...]
Is one faster than the other? From some searching online, there seems to be debate about the best way to handle null values.
View 1 Replies
May 7, 2010
I'm using VS 2010 so I have auto-implemented properties.I have a class and I want to access the properties by a string.[code]But, I also want to be able to access the variables something like this way.[code]How can I setup MyClass to work both ways?
View 7 Replies
Feb 12, 2010
This is a VB.Net newbie question. I'm confused at the different ways to declare and define variables.Here's an example:
Dim URL As String = http://www.c-sharpcorner.com/default.asp
Dim request As HttpWebRequest = WebRequest.Create(URL)
Dim response As HttpWebResponse = request.GetResponse()
[code]......
View 1 Replies
Jun 12, 2011
What ways do people know how to speed up vb browser??
View 1 Replies
Sep 5, 2011
I'm trying to get the Affected Records but it always give me -1Here is my code:
cmd.CommandText = "SELECT * FROM persons"
Dim lrd As SqlDataReader = cmd.ExecuteReader()
MessageBox.Show(lrd.RecordsAffected)
[code].....
View 1 Replies
Sep 11, 2011
How can i search a database with multiple search criteria. e.g. search where ata=26/11/2001;department=Security;Payment Type=Expense.I would also like to display this data in datagridview when i click on search button. Or if possible, using crystal reports to view the result so that it can be printed
View 18 Replies
Apr 6, 2012
I have a general question on app.config, or the best way to NOT hard code a SmtpServer.Host = XXXXXXXX setting. I wrote this very simple SMTP texting application and wanted to have the settings not hard code but a form that read or writes to app.config or .ini or registry. my question is the pros and cons? and if anyone hae suggested or a link to sample project that is doing what I'm after. I have a single .exe and am new to vb.net and either want the exe to check for app.config, ini or registry if does not exist to create and then save added config, if the exe runs again it uses the newly created settings.
View 5 Replies
Jun 22, 2010
I've been going through a VB book I had while in College, and was trying to figure out different ways of making programs work.One assignment was to create a multi-dimensional array to figure out wind chill factors. The only part I really can't get to work right is using 2 numericUpDown controls. Using 2 dropdown menus was obviously easy because the items are indexed, but as far as I know, numericUpDown controls are not indexed.
Instead I used 2 selectCase statements to determine the index in each updown control, then passed the indexes to a function to determine the answer.The numericUpDown controls both increment by 5, (wind from 5 to 30) (temp from -20 to 15)Just looking to see if someone has any ideas of a better way of doing this.
[Code]...
View 1 Replies
Aug 5, 2010
Whenever we need to handle events, we do it by creating a method which handles the event. Without creating methods; is there some other ways of handling events?
View 6 Replies
Mar 16, 2010
I am looking to get some information on updating my own applications. Because what I have to do at the moment is replace the files every time it changes so I would like to know what are the options available starting with the easier ones or does it involve any third party applications. For example I have noticed some applications checks the files before it starts up and then asks a user if he wants to update it
View 4 Replies
May 6, 2011
(I'm using 2010 express), which includes, i think, very basic knowledge of coding. I have made a game in vb 2008 express before and it was a basic arcade game where you move your guy from the left to the right collecting points and dodging enemies that are randomly moving in the opposite direction that you are. Now I am attempting to make a sort-of user interface similar to that of the ps3 home screen, as a windows shell replacement app..
so far i have got what I am looking for in terms of moving between the menus, however the code that I have made seems very extensive for such a thing (in my opinion)..the question I am asking is whether there are ways of shortening the amount of code used, or changing it to be more efficient..if someone is willing to help, I will post my code, or upload my project (if given instructions on how to do so)
View 5 Replies
