Best Approach For Data Manipulation?
Jul 28, 2009
I understand that there are several ways of Inserting, Updating and Deleting records in a database such as DataAdapters, DataSets, TableAdapters, SqlCommandBuilders, Parameterized SqlCommands, StoredProcedures, etc, etc,etc. According to David Sceppa Sprocs are the most preferred. Ok, I go with him on this one (who am I to challenge him anyway?).
My question is, apart from Sprocs, which of these options is the BEST for a large commercial database application and why, taking performance into account? What are the benefits and drawbacks of each option?
View 4 Replies
ADVERTISEMENT
Aug 26, 2010
I've got a method which takes some parameters and generates some XML to be sent to an [archaic] web service.
[Code]...
View 1 Replies
Dec 24, 2009
I have a question on the best way to store model data for my app. My app will basically be drawing a bunch of elements (lines) connected to a node at each end. Im trying to decide how im going to store my node data (as well as element data). The node data im trying to store will consist of the node XYZ coordinates and some other info about the node. The element data will consist of the node numbers at each end plus additional info about the element. There a number of ways i've been thinking i can do this. They are:
1) Store my node/element data as a Dictionary object, where the key represents the node/element, and the value would be an array of the information i want to store.
2) Create a "Node" structure and an "Element" structure to store the info i want. Im a bit worried here as my model could potentially have thousands of nodes and elements.
3) Create a "Node" datatable and an "Element" datatable, and store my info in those instead. I can see some advantages in this in regards to displaying information to the user in datagridview etc. But then again i can easily pull the required data from a method i mentioned above, and generate the datatable when required.
Not quite sure what the best approach is. Either way i do it, i will be serializing whatever object i use to save the data to disk.
View 12 Replies
Nov 6, 2011
There exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
View 1 Replies
Jan 19, 2012
I have eight text boxes each can have any numerical value only consisting of the numbers 1-8 up to eight digits each. No 0's or 9's.I am using a timer to loop through the sequences of text boxes at a given rate. This is already configured.Now here's the hard part so bare with me.I need to output the first value of a text box, wait some time then output it's counter letter (below the number on the keyboard), go to the next text box and repeat. Example:
1
34
765
[code].....
View 1 Replies
Apr 26, 2010
I have been using Dick Grier's example to attempt to attempt to read data coming from a project.I first have to read 16 bytes for an RFID tag. I have that working and am able to extract the unique ID code and display it (cut out for length).The project samples voltage on an ADC and transmits 120 samples ranging from 0 to 255.I am attempting to buffer in the 120 samples, convert the scaled voltages (195 Vp or so (115% of Vnom)), and calculate Vrms.When I attempt to calculate and display the information, nothing is displayed.[code]
View 5 Replies
Jan 18, 2012
I have eight text boxes each can have any numerical value only consisting of the numbers 1-8 up to eight digits each. No 0's or 9's. I am using a timer to loop through the sequences of text boxes at a given rate. This is already configured.
Now here's the hard part so bare with me.I need to output the first value of a text box, wait some time then output it's counter letter (below the number on the keyboard), go to the next text box and repeat. Example:
[Code]...
Ultimately I'm trying bring my PC Interface project up to date by going from a parallel port to USB. This will be the "Custom Loop" function for the device.
View 8 Replies
Nov 7, 2009
I am writing a program with VB.NET, there I have to select data from one table. Then I have to update about 4 tables and insert to 2 Tables. Which approach will be ok for me? I'm thinking to use DataSet.
View 3 Replies
Jun 21, 2010
I have a process that does a lot of data manipulation and then prints a simple report directly to a printer. The overall priority is speed. Tens of thousands of records need to be scanned & processed individually so moving thru them quickly as possible is the goal.
Pseudo code
01)Scan Barcode
02)Fill DataSet from Sql Server
03)Manipulate data in dataset
04)Update data back to Sql Server
05)Print crystal report directly to printer; the dataset is the reports source
06)Clear dataset and start next record back at step one
The process if pretty complicated with a ton data manipulation and data coming from multiple sources but that part works super and in short all I am doing is scanning barcode, filling a dataset, passing it to a report and starting over. Steps 1 to 4 are averaging one tenth of a second (0.01) to complete; great. Passing it to the report to print takes several seconds which is the problem. I thought I would resolve this by passing the dataset to the report print sub - allowing the print sub to run on a background thread - and moving on to processing the next record.
Dim m_ds As MyTypedDataSet
Sub ScanBarCode
Fill DataSet
Validate & Manipulate Data
Call PrintReport
Clear Dataset
End Sub
I have been attempting to add the PrintReport sub to process on a background thread. The problem though is the main thread blows right by to the next step and clears the dataset; causing an error in the report sub. I've tried unsuccessfully just about everything I can think of; including using DataSet.Copy to local datasets (which I really don't want to keep recreating the same object over & over tens of thousands of times), as soon as the main dataset clears, all clear.
View 1 Replies
Jun 15, 2010
I'm currently learning VB.net and can confidently connect to databases and return results to comboboxes run stored procedures ect to datagrids, However I'm wanting to find an online tutorial for doing loops with data so for example
I return the following data into a dataset
Orderno Orderitem Price GUID
111 Pies 1.50 xxx-xxxxx-xxxxx-xxxxxxx
111 orangutang 2.00 xxx-xxxxx-xxxxx-xxxxxxx
ect
I want to display each element on a page in a structured format so as to make a visual representation in seperate entities (labels maybe) of the data like so:
Order number
line 1 (includes item and price in plain text on a page i guess using a label)
line 2 (same goes)
Subtotal( )
The results and formulae i can do but it's simply how to split off the data from my dataset and display elements as seperates (also how will i dynamically create the lables as obviously i'm not going to know in advance how many order item rows will return )
Obviously this is not urgent but if anyone could point me at a tutorial or even better a few lines of code that will do this for the microsoft northwind data so i can mess about with it and play.
View 3 Replies
Dec 15, 2011
OK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
View 15 Replies
Jul 18, 2009
I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.
Right now I have 43 drugs in the database and still growing.
What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.
View 3 Replies
May 18, 2012
I've two BGW with similar coding but different approach, My second BGW shows me "NOT RESPONDING" whenever i try move/click/focus to form while the BGW is running.
VB
RichTextBox2.AppendText("Some Text")
process2.ReportProgress(inc)
My.Computer.Network.DownloadFile(andpic, "pics/" & spliti(0) & nnum & ".png")
My.Computer.Network.UploadFile("pics/" & spliti(0) & nnum & ".png", "ftp://ftp.mywebsite.com/domains/mywebsite/public_html/Pics/" & spliti(0) & nnum & ".png", "users", "password")
WebBrowser1.Navigate("Mywebsite")
I've taken out number of things that i think is causing this error Are they the cause of "NOT RESPONDING" ?
View 4 Replies
Nov 12, 2010
To write a effecient Active Directory library to ease the work of technicals who are responsible to create access models into the domain controller's Active Directory. This library must allow the following:Basic operations: Add, Modify, Delete, List entries;An entry may either be an organizational unit, group or user (no further need required as of now);I thought about having a class which would represent the domain with which we want to work with.
public class Domain {
public Domain(string root) {
Root = root;
[code].....
View 1 Replies
Aug 26, 2009
I have a database with three tables:
stock
orders
order_details
Stock and Orders are self explanatory. Order_details is a lookup table, holding basically just the orderID, stockID and quantity for each item in the order. That's not very friendly for the user however, so what I want to show is a DataGridView with some elements from order_details, and some from stock, i.e.:
Part_Code, Item_Name, Description, Quantity, Price
I can create a database view for this easily enough, and bind it to a datagridview. It shows existing items in the order fine, but the problem is the view doesn't update when I add new elements to order_details in the dataset. It appears that it's bound to the main database, and so won't update until I save the record. That also has the problem that it's now much harder to update the database. A simple datagridview bound to order_details would make it easy for the user to enter quantities and for me to save the record, this one now needs a custom update statement.
In summary:
- I want to show data from two tables
- I want the datagridview editable (well, the quantity column anyway)
- I want the datagridview to update when I add entries in the dataset
What is the best/easiest way to do this? Is my current approach of a view in the database and custom update statements sensible? How can I get the datagridview to refresh whenever there's a change to the local dataset?
View 8 Replies
Jul 24, 2009
I recently started a project and needed to do some integration with LDAP via DirectoryServices. I've done this in other apps so I went into one of them to see how I did it -- why reinvent the wheel right? Well, while this wheel works, it was developed years ago and kinda smells (it's wooden, firmly attached to the previous vehicle, hard to repair and produces a potentially bumpy ride).So I thought to myself, this is the perfect time to refactor this puppy and make it more portable, reusable, reliable, easier to configure etc. Now that's fine and dandy, but then I started feeling a tad overwhelmed regarding to where to start. Should it be a separate library? How should it be configured? Should it use IoC? DI?
So my [admittedly subjective] question is this -- given a relatively small, but quite useful class like the one below, what is a good approach to refactoring it? What questions do you ask and how do you decide what to implement or not implement? Where do you draw the line regarding configuration flexibility? [Note: Please don't bash this code too much okay? It was written a long time ago and has functioned perfectly well baked into an in house application.]
Public Shared Function AuthenticateUser(ByVal id As String, ByVal password As String) As Boolean
Dim path As String = GetUserPath(id)
[code]......
View 5 Replies
Apr 11, 2010
I'm working on a system where there can be 2 level of users "Admin" or "Researcher".We have the requirement to allow the researcher to change fields for a record a record, but they want the original values to stay in the record and have an admin "accept" or "approve" the changes before the real record gets updated.Has anyone run into this scenario before? I'm trying to think of the best way to do this.
View 3 Replies
Oct 15, 2009
Trying to implement a recordset approach in VB.NET and have gotten to the point where things almost run. :)
Code:
Dim strSQL As String
Dim rsMaster As New ADODB.Recordset
strSQL = "select * " & "from tblDQ " & "order by xid, xcode, xDOS"
[Code].....
View 4 Replies
Mar 25, 2012
I'm currently working on a system that requires monthly, quarterly and annual reports. I have no problem in generating/retrieving the data, my problem is the presentation. What is the best way to do it? I need the report to be:
View 3 Replies
Jun 16, 2010
I have a wierd problem with threading in an ASP.NET application. For some reason, when I run the code in the request thread, everything works as expected. But when I run it in a separate thread, nothing happens.This is verified by calling the below handler with the three flags "on", "off" and "larma" respectively - in the two first cases everything works, but in the latter nothing happens.[code]
View 4 Replies
Mar 5, 2010
What is the optimal approach to a WithEvents Collection - VB.NET?Have you any remarks on the code bellow (skipping the Nothing verifications)?The problem is when I obtain the LinkedListNode(Of Foo) in a For Each block I can set myNode.Value = something, and here is a handlers leak...
-Could I override the FooCollection's GetEnumerator in this case?
-No. :( cause NotInheritable Class LinkedListNode(Of T)
Class Foo
[code]....
View 3 Replies
Oct 25, 2011
I was wondering about what approach to take for writing a state machine or data crunching engine.As such, it wouldn't have any UI component. Since it must be able to talk to other GUI programs, should it be hosted in a DLL? I noticed that there were some State Machine templates for VB but I have no idea how to use them. If
any one could provide some pointers to documentation sample code,
View 3 Replies
Apr 2, 2009
any other approach on finding next word in a string. What im trying solve is this.
Lets say this is the whole paragraph.
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
Hello visual basic
now i search for the word basic.if i press the button find. the first "basic must highlighted, and then if i press again the button the next "basic" is the highlighted one and so on.I already finsih that scenario. What i've done is that first im going to search all the positions of the word and then store it in a array. Then after the array populated with different location of the word that is searching. that is the time i call all the indexes of the array one by one. But i don't want my approach because imagine i have 10000 words. and i search for a word or letter. Lets say the result is 5000 match. so it needs my array to be size in 5000. what a mess in memory.
I don't want to used the FinsString or Find function of VB i want some algorithm to do this. Anyone have a easy approach..
View 5 Replies
Jun 3, 2011
How to link my app to an Access database - there seems to be a number of approaches. I can add in my database via the Data Sources tab. Fine if I want to bind controls and view/edit data. But is this the best approach for queries that return an answer that is a different shape to the original table? Alternatively I can connect to the database directly (connection string, etc) and run sql queries. What are advantages/disadvantages of each approach? In terms of flexibility, is the second approach best? Also, does the second approach require the database to be added via the Data Sources tab?
View 4 Replies
Apr 24, 2012
I'm using VB.NET but this question applies to any OO language - Java, C# etc. I've tagged the question with Java and C# but will remove if not considered appropriate. I have an entity class ClassAAA that contains a reference to ClassBBB as one of it's attributes:
Public Class ClassAAA
Private Property _blah As ClassBBB = Nothing
Private Property _somethingElse As String
Private Property _anotherthing As String
' Make it private so cannot instantiate class without supplying ClassBBB '
[Code] .....
I could make the ClassBBB reference public (or supply a public getter method) but that would expose the inner workings of ClassAAA. What I'm thinking of doing is making the ClassBBB reference Friend so that it is only visible in the assembly i.e. a data layer and is not visible to client projects. But this stills feel like I'm exposing the inner workings of the class.
View 3 Replies
Sep 8, 2010
DB/Reporting :: General approach to a db project
View 2 Replies
Jan 30, 2010
Which is the recommended approach for copying elements from one control to another? Currently I am using something like this:
For Each a As Control In control.Controls
Controls.Add(a)
Next
Should I stick to it, or should I change to use the ControlCollection.CopyTo method instead?
View 3 Replies
Feb 3, 2010
I want to know what's the right way to work with objects that belong to a category.I'm building an applications with the following layers:Base data access Data access Business logic + Factories Presentation.I want to pass only objects to the presentation layer and back.I have objects (Employees), that belong to a certain category (EmployeeCat). I was wondering if I should have just an EmployeeCatID property in my Employee class/object, or an EmployeeCat property that contains a complete category object.If I want to fill a GridView with a list of employee objects as datasource, and I used just an ID in my Employee objects, then I will have some work at the presentation level to display the category names, so I think. On the other hand, if the list of employees contains plain category objects... I'm not sure what will happen.
View 2 Replies
Jul 2, 2011
Im writing a small application that need to make up to 300 socket connections at the same time. However i'm pretty confused on how to approach this. My first theory is to have my main thread to manually fire up 300 new threads that each handle all that needs to be done. Another theory is to fire up lets say 10 threads that makes 30 async connections. My last theory is to have my mainthread work with all 300 async connections together with everything else. The question to this is what would be the most effective way to go to save resources and maintain speed.
View 1 Replies
Jan 20, 2010
I am often asked to create a very simple database front-end for friends or family, and the structure of the database (and application) is usually very similar.Right now I am always creating a class that handles all database interactions with some shared functions. For example, there's a function to run a general query and return a table, a function to save/load various items (depending on the application of course). The point is: the code is nearly always the same except for some slight variations.
View 5 Replies
