Ugh, sounds awful. It would do in a pinch but I am not there yet. :)

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Thanks for the feedback. I am looking for some extra money and would hate to go get work at some random place for x number of hours a week when I have skills that I can put to use that compliment what I already do day to day.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Thanks, I will check these out.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Thanks, I will check these out.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Is there a place where a programmer can find side programming jobs? I thought that is what sologig.com used to be but it doesnt appear to be that way now.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

That's a joke right? How in the world is that possible?

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

There's an idea. I don't post much on here anymore so is it strange that you provided the quote in my signature?

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

That's what I figured. I already wrote my own and we were just evaluating whether there are systems that are already out there that can be configured to do what we want. I didn't have high hopes. :) To answer the other 2 questions, I already wrote my own so don't have a problem with that.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I work for a company where I have rolled our own DES and it has been a successful system for many years. Now we are evaluating whether to build new, retrofit, or purchase something. I am trying to review software but am only finding stuff intended to provide mechanisms to enter fairly simple data, small amounts of data, or surveys. Do you all know of companies that offer software that is truly customizable and intended to allow for hundreds/thousands of complex data edits? I just need help finding the companies that offer those types of systems instead of these data entry creation systems that are intended to allow for name and phone number type entry.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

It was your reply that I found earlier, :). Thanks for confirming.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I just found a message from 2004 that said there is no option for opening a file and adding text to the beginning. I want to validate whether that is still true or not. What I want to do is add some data to the beginning of a file without reading and writing the entire file. The files are large text files, a lot of the time they are gigabytes in size so it is inefficient and most of the time not possible to read it into memory and manipulate the data. Is there an option through a FileStream or some other type of I/O class that will open a file allow me to point to the beginning and write text as an "insert" type of operation and save the file? An example of what I am trying to do is below. Start Middle End Open file and add to the beginning New Text Start Middle End

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I have a program that uses SqlBulkCopy to insert data into a staging table for processing. 5 different computers run the same .NET and database code and only one or a couple occasionally will receive the following error: "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM." The exact same data will import correctly for other users as well as myself. There are only valid dates in the fields and I verified that their local database tables match the column order I am expecting. The only thing I can think of is that a memory issue is coming into play here and the data is corrupting internally before import. Is there something else I can look at? I dont understand why the same code has different results.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I have conversion code already, I was just hoping to find a more complete codebase to use rather than re-inventing the wheel.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Does VB.NET have any hidden understanding of units of measure? Meaning, if I had a value 12 oz and wanted to quickly decide if it is greater than or less than 500 mL, is there something out there that already can do that in VB? I know that I can give a weight to each UOM and do the comparisons but am hoping there might already be something in the vast framework of code. I couldnt find anything by searching the net for VB but did find stuff for F#. I dont believe I can program with F# though, or at least it isnt available as a project template.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I am working on that path now. I tried simply setting the DataSource = Nothing for the columns, datagridview, and cells within the combobox columns. Apparently that isnt working good enough because the dispose is forcing the grid to go through and remove bindings which is raising events which is slowing down the dispose.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

The DataTables that I am disposing of are instantiated at the class level for specific data. It is not the DataSet bound DataTables that I am disposing of, it is those individual datatables. Didnt I have a discussion with you a few years ago where you said to dispose of anything that implements IDisposable?

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I have a form that displays a list of records in a DataGridView. The recordset in question is about 9,000 records. I know that is a lot but is required by the application. The problem I am experiencing is the form closing. I call the dispose methods of some class level variables which slows the close down quite a bit. I have seen it take anywhere from 10 seconds to 2+ minutes. This is a hinderence to the users of the application. I have written some Debug.Writeline() statements with timestamps to see how long each dispose call is taking. The slowdown is on my unfiltered datatables which are bound to the DGV combobox columns. A filtered version is bound to each individual cell that is edited but after the edit the original unfiltered datatable is bound to the cell again. The unfiltered tables only contain 20 or so records but are taking 8+ seconds minimum to clear and dispose compared to the milliseconds it is taking all of the other tables. Here is my current iteration of the close (please note that the original call was only to dispose of the _Utilities object, I have added the other calls to try tracking down the issue):

uxRecords.Clear()
uxRecordsBindingSource.DataSource = Nothing
uxRecordDataGrid.DataSource = Nothing
uxRecordDataGrid.Rows.Clear()

CType(uxRecordDataGrid.Columns("uxVersionNameGrid"), DataGridViewComboBoxColumn).DataSource = Nothing

For Each versionNameCell As DataGridViewComboBoxCell In CType(uxRecordDataGrid.Columns("uxVersionNameGrid"), DataGridViewComboBoxColumn).Items
versionNameCell.DataSource = Nothing
Next

CType(uxRecordDataGrid.Columns("uxDepartmentNameGrid"), DataGridViewComboBoxColumn).DataSource = Nothing

For Each departmentNameCell As DataGridViewComboBoxCell In CType(uxRecordDataGrid.Columns("uxDepartmentNameGrid"), DataGridViewComboBoxColumn).Items
departmentNameCell.DataSource = Nothing
Next

CType(uxRecordDataGrid.Columns("uxSizeGrid"), DataGridViewComboBoxColumn).DataSource = Nothing

For Each sizeCell As DataGridViewComboBoxCell In CType(uxRecordDataGrid.Columns("uxSizeGrid"), DataGridViewComboBoxColumn).Items
sizeCell .DataSource = Nothing
Next

_Utilities.Dispose()

The _Utilities.Dispose call disposes of each table and that is where the slowdown is. Everything up to that call occurs within the same second.

---

CleaKO

"Now, a man would ha

I have an application that has a simple user interface but quite a bit of code under the hood. The interface is a file processing form where the user chooses a file and then clicks a button to process the selection. The code disables all buttons on the form and has at it. Quite a bit of the code is reading from the file and I report how many records every 100 count and then call Application.DoEvents (I know this is bad that is why I am here). Part of this application uses BackGroundWorkers to run long SQL queries/updates where I use the .IsBusy property in a while loop and update a time elapsed message then call Application.DoEvents. I have a continuous progress bar that just runs all the time to show that something is happening but not necessarily reporting actual progress. I also have true multi-threading where I kick off threads and I have a few steps in the process where I wait for a few of those threads to complete before starting others, as part of that waiting process I call the Application.DoEvents call again. I have found many many articles online and forums where people say not to use Application.DoEvents, you should use backgroundworkers with ProgressChanged events. Well even though I implemented the Delegate step that they mention to set the value on the status bar for time elapsed, as soon as I take out the Application.DoEvents the form will report that it is not responding and if the user clicks on it they get the typical whited out form. What should I use instead to guarantee that I dont have code stepping on itself?

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

Does anyone here know of a successful way to insert a double page break into a report? I have a report that is half duplex (front and back) and half simplex (front only) that needs to be one large report by the main group. I have 3 sub groups as well. I have tried every combination that I can think of to insert a page break that will insert that blank even page and it works with the exception of the single record or 2 records that end up on the even page before it realizes that it is on the wrong page. I have shown line numbers and it seems to think that it is on the same page then breaks again to the next page. It is very strange. Please note that the the last 2 sub groups a shown throughout and are not just page header type groups so the break could happen when one of those 2 groups hits the bottom of the page.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)

I dont think much will change hardware wise from Vista to Windows 7 so I dont know if there is any reason not to go ahead and make the leap other than the fact that I will need to buy the Windows 7 OS when it comes out rather than just getting the OEM version on the machine. I will need to upgrade my laptop anyway to Windows 7 to hopefully fix the few bugs I have had issues with so far in Vista.

---

CleaKO

"Now, a man would have opened both gates, driven through and not bothered to close either gate." - Marc Clifton (The Lounge)