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.
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".
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?
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
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 :
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.
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)
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.
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?
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]
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.
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?
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?
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.
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?
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()
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
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.
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.
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?
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
(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)
