If vb application (windows form app) is calling a store procedure and it takes 5-10 mins to SP to finish and meanwhile the application is (forced to) close,
what will happend at the SQL side?
Will the proc completely run even though the app is not running anymore?
I just learned some basics of multi threading in VB.net recently as I came across processing a large List of records and inserting them into SQL database one by one.
I have code look like this:
Private Sub btnLoadNow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadNow.Click
Dim autoLoad1 As New Thread(AddressOf AutoLoad)
autoLoad1.Start()
[CODE]...
Itemlists is a global lists i retrieved from database, everything looks fine to me but when i run this program, I found that the threads are inserting one records 9 times into the database(I have 9 threads in total), which makes me think that maybe i need to specifically assign 1/9 of a list to each thread? Is there another way to do it which doesn't require the splitting of the list, if not , how do i split it then assign?
2008 Array Processing and Sequential File Processing
View 14 RepliesIm a college student and this is my first programming class, i am having extremely diffcult time with arrays and sequential file processing. Im not asking for the whole program, just something to get me started and hints along as i progress with it. Please help me get started on my program, its due in 2 days.
Here are the requirements....
1. The program must input any number of individual�s last and first names using two separate textboxes.
2. The array of names must be sorted by the last name using a bubble sort. You must code the sort.
3. The program must be able to recall the names from the file and add to the existing list of names so that more names can be added to, sorted, and written back to the file in sorted order.
4. Sort in ascending order: A to Z
5. All names must be displayed in a listbox in sorted order when the user wishes to see them.
6. In the listbox the last and first names must be separated by a comma and a space. Example: Smith, Mary
7. The user must be able to search for a name in the array, using the binary search algorithm. You must code the search.
8. Do not use module-level variables. Instead you may choose to use Static.
9. The program must be designed using Visual Basic 2008
Is there an easy way of trapping the enter key in a textbox to process the data, instead of having a button beside it?
View 2 RepliesI have a text file that contained about 50,000 lines of data which are all the same format as below
0000710950,INFEED NAME,40,INFEED TIME,0,ENTRY,55649,MCS,[code]....
What I would like to do is read this data in as fast as possible either line by line and processing the data as I go by line. Or read the whole lot in and THEN process it, which woulkd be the fastest ? I used to do this in Excel but want to transfer it to VB and don't know really how to get started I have the following but would like to know how to get the columns into a named array and then how to itterate through array.
Dim myLines() As String = IO.File.ReadAllLines("C:SYNC_DATA�0 - LGW�5 - Archived�0 - IST Logs2008istlog20090224.txt")
I have code in an ASP.NET form that needs to, depending on user entry create messages in the database. We are speaking of potentially thousands of db entries. How do I protect against deadlocks, I mean apart from using Transactions and setting IsolationLevel to Serializable, as well as using WITH(NOLOCK) statement on my select statements since I don't mind a dirty read.
[Code]...
Let's say an application needs to persist mostly immutable data. Let's say the application's data files can grow fairly large. How would you implement a simple transaction processing so that changes are either successfully committed or rolled back?
The only requirement is to use built-in .Net libraries. (no databases, no third party libraries)
Here's my current solution. The data file will have three main sections: (1) header, (2) data, (3) index. For now, the header section simply contains an offset to the start of the index section. The data section will store mostly immutable data. The index section will contain serialized objects with enough information to access the data section.
When the application starts, it only needs to deserialize objects from index section. Anything from the data section can be fetched as needed. As the application gets ready to write changes, it makes a temporary copy of the original header and index sections. These would be small relative to the data section. New data would then be appended to the original data section. Once all data has been written, in memory objects would be serialized to the end of the file to become the new index section.
If all this goes without a hitch, the temporary file can be deleted. If something goes wrong, the temporary file can be used to restore the data file to its original state.
Will this work or is there a more elegant approach?
I have a program that tracks packages. Shipment and package entities are persisted in SQL database, and are displayed in a WPF view. Upon initial retrieval of the records, there is a noticeable pause before displaying the new shipments view, and I have not even implemented the code that counts shipments that are overdue/active yet (which will necessitate a tracking check via web service, and a lot of time).I have built this with the Ocean framework, and all appears to be doing well, except when I first started my foray into multi-threading. It broke, and it appeared to break something in Ocean... Here is what I did:
Private QueryThread As New System.Threading.Thread(AddressOf GetShipments)
Public Sub New()
' Insert code required on object creation below this point.
[code].....
At the moment, my project has a method do_job(jobid,userid)
This method take a minute or two, and then redirects to another page. This has been rewritten so that it now runs in the background and redirects to another page whilst the thread which do_job is on continues. - This works fine. In a button_click event in a default.aspx page :
Dim d as New do_job_delegate(AddressOf do_job)
d.BeginInvoke(jobid,userid, New AsyncCallback(AddressOf Callback),d)
Response.redirect("results.aspx")
[Code]....
So what i want to happen is - the longest time that do_job takes is the longest time of the longest job (30 seconds), rather than - 30 seconds x number of jobs = time it takes at the moment.
As i'm already using a delegate to detact the process from the ui, can anyone provide any advice/best practice on how i should rearrange my do_job method so that it can handle concurrent tasks to further boost the overall speed.
Is there any way of doing parallel processing in VB.net. Like running a IF-ELSE and CASE in parallel.
For example i'm incrementing a counter in a IF-ELSE statement. And for each count i need to display some thing using a case statement.
How can I keep the GUI active for my windows form application if I am processing some data in db and my process is waiting for result ?
View 2 RepliesI want to process MSXML which is generated by Visio 2010, Which Language will be helpful to work with the generated XML,
View 2 RepliesI want to run my vb.net 2003 application from command line and accepting only one parameter(argument)....... BUT it should run without GUI, only a function from my code would get run in background..
[Code]....
Does we have a good & full image processing function in vb.net? If not. what is best reference for image processing in vb.net?
View 2 RepliesI am looking for a solution to implement Credit Card processing to a POS system I have written. I have been coding VB for about 7 years but never had a need to process credit cards.
View 1 RepliesI haven't seen a related thread (yet)I have a VB windows application that uses a datagrid to display a text column and a checkbox column. Only one row in the display can have a checkbox entry = true. If a checkbox is selected, the app is to search the rows and all other checkbox entries are to be set to false.My event handler is: Private Sub dgMember_CellContentClick(ByVal sender As System.Object, ByVal e As ystem.Windows.Forms.DataGridViewCellEventArgs) Handles dgMember.CellValueChangedI first had to have this handler code check a flag and exit if true (when initializing the display) because it was called for each row during initialization.
View 1 RepliesI have a form with several buttons on it.When a button is pressed,it will execute some remoting proxy method on the server. There is some delay in the process before there is a result returned from server .Currently,I tried to disable the button in the _Click event, hoping that a 2nd, 3rd and the following clicks would not be registered.Unfortunately, those input from the mouse clicks were queued by Windows.
So once the _Click event has finished running, it will immediately get executed again due to the earlier clicking.I tried to create a form (Notice) to display some status message, hoping that clicks won't be registered on the button. Despite setting the form to maximize and on top of the caller form, the clicks still get registered.Then I thought of using .ShowDialog(). Unfortunately, it halts the processing until I close the form. So I did something more complicated by passing in the method into Notice form, so that it would execute the _Click method via an address pointer.Unfortunately, after all these coding. The buttons still get registered with the mouse clicks.So now, is there any way to overcome this clicking queue that Windows registered?
i have 10 checkboxes...i want a short way to check if checkbox1.checked=true and check box3.checked=true.... blah blah blah and so on to do codes...i was using long typeing code like:
if checkbox1.checked=true and checkbox2.checked=false and checkbox3.checked=true and checkbox4.checked=true and checkbox5.checked=true and checkbox1.checked=true.....etc then
msgbox"done"
end if
[code]....
i am using vb.net to program and process some files.I pick files from one folder process them and once i process them successfully i should store them in a different folder. when i do fi.move(destination folder) i get an error message saying "THIS FILE IS USED BY ANOTHER PROCESS" below is my code
[Code]...
I'm thinking of making use of online technology to do some validation and processing for my program but I'm unsure of its feasibility. I need to create a program whereby the client can retrieve the data/settings from website say http:[url].... .Another example would be allowing the program to run until end of December by making use of online time service to check the date so that user can't change any settings from their computer.
While discussing about retrieving the data either through html static site or webservices, another thing I'm concern is transmitting the data from client side to my side.I wonder what is the best and free way to do that? As I'm thinking of using a free smtp gmail to transmit data but I'm worried about the security issue as credentials would be stored inside the program and also firewall might block data from sending out. Another choice would be sending a POST request, but I do not have any server or is there any free server that allows user to post some small bytes of data?
Here's the content of text file:
0022005138450000425081959 091
003200513845161223180000001Doppel-Pack, WET "Warming" & "Original" 0000001499
003200513845161048400000001Handschellen-Set, "Fetish Fantasy" 0000000999
003200513845161214340000001Strap-on, "His Vibrating S(extension)" 0000003999
[code]....
I am sort of stuck on this what I want to do is when you click a button it process's a command in cmd in the background(I dont want a CMD window to appear) and then if the cmd command has finished it shows a message box like
Msgbox("Command Successful")
i does anyone have any examples of using .net to do zonal ocr form processing (I want to extract data from a scanned image based on it's location on the scan and save it), i know there are thrid parties out there for this type of thing, but I'd rather do it myself, does .net natively have the abliity to let me do this?
View 1 RepliesThe following is a program that lets users store business logic for later retrieval by other users.
I am trying to run multiple logical statements pulled from sql server database. one statement may be dependent on another one. I've been compliling the code in a wrapper and In-Memory set to True. I ran 18 logical statements in a loop and it took approx 3 seconds to run. These were simple one line statements containging math and/or If Then's.
Any other methods available out there. please no 3rd party plug-ins.
i have a piece of code that i wanna know that in how many miliseconds it would be run.
Public Sub TurnLeft(ByVal speed As Single)
Dim timer As Single
If Not IsNothing(Me._DriveActor) Then
[code].....
I have a program that opens a fixed length delimited file and process each line depending on what it starts with.
Sample Input:
101 000000000 0000000001010271255A094101National Payment Corp National Payment Corp
5200Happy Company ACH20101021-001.txt PPDDIR DEP 101105101105
[code].....
I am writing a program with a loading bar. I also have a label that says what the program is currently loading (Eg. 'Generating Numbers...', 'Determining Winners...').
It all works fine, but the label sometimes doesn't change or doesn't even appear because the program is too busy processing all the other stuff. I hope that makes sense...
Is there any way to centralize processing on the label and progress bar at times?
I am making a program which will read data from csv and pick up Username & Computer name from the csv.
Then it will run commands via telnet with those username and computer on line at a time. I have reached this goal without any problem. I wanted to paste the code here but its too much.
Basically what i now want to do is have a option for user to skip a command.
Like if csv have 3 users in it. i.e.
j.doe, comp1
t.test, comp2
u.user, comp3
Popup will come and say do you want to run the command "add user j.doe, comp1" something and you will have option to say Yes, No , Cancel.
Where yes will run the command and no will skip that user (go to next one) and cancel will end the whole process.
I know Msgbox yes,no is there but i dont know how to skip that user.
Following is the code which migh
vb
Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fileNam & "", objConn)
For i = 0 To objDataset1.Tables(0).Rows.Count - 1
[Code]....
imagine i have an image of an whole family, but then i crop just one face, to use, now i have the photo of the whole family, and the photo of a face, which is part of the big photo. what i want is an app that can scan the big image, looking for the small image, and then return if it found it, and the rectangle where the small pictures, fits, in the big picture. any ideas?
View 3 Replies
