Thanks Sledge. I did all the above before returning to the thread and after doing a whole lot of background work on Postgres Databases etc. Stored procedure definitely helped and then indexing did as well. I am in the process of looking at using a refcurs as well. But the proof will be in the pudding on Sunday when I have to run the billing for the month of May. Just over 2 million records now and it takes around 2, 3 or 4 minutes to complete everything, calculations included and creating PDF output reports. Excellence is doing ordinary things extraordinarily well.

I bound the SelectedSong to a textBox and it works now. Not the cleanest way of doing things but it works. Thanks Excellence is doing ordinary things extraordinarily well.

Thanks Alan. That resolved my issue. Greatly appreciated. Excellence is doing ordinary things extraordinarily well.

If it's only 50 records you should parse and read the entire file into a List<Record>, where a Record is a data holding class which is populated in a similar way to your code here, at the start. Working with a proper domain object with properties is much better than working with a string format the whole time. To read all the records you do something like List<Record> GetRecords(string s){ List<Record> r = new List<Record>(); ReadHeader(s.Substring(0, HEADER_LENGTH)); s = s.Substring(HEADER_LENGTH); while(s.Length > 0){ string recordstr = s.Substring(0, RECORD_LENGTH); s = s.Substring(RECORD_LENGTH); Record rec = new Record(); rec.CO_ID = recordstr.Substring(0, 5); //= 5 // etc r.Add(rec); } return r; } ed: HEADER_LENGTH = 463 and RECORD_LENGTH = 276.

OIC

My dear friend, I havent told you to copy and paste all the APIs in C#. You can you these APIs in C# only the syntax is different. Regards,

Kwagga wrote: Any advice would be greatly apreciated. Write a parser which reads the file and creates a data structure (presuming that the file is reasonably sized.) Your data struct is represented by the following pseudo code class RecordA { // Fields from record ... } class RecordB { // Fields from record ... } class Data { RecordA RecordA List RecordBList } After you have populated Data above then you pass it to something else.

Try opening this file in MS Word. It locks the file when you open it. Then when you open file, test your application. Don't forget to rate answer, that helped you. It will allow other people find their answers faster.

CLUE: UPDATE mytable SET field1=@F1,field2=@F2 WHERE field3=@F3 cmd.AddWithValue("@F1", "111"); cmd.AddWithValue("@F2", "222"); ... Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Kwagga wrote: Access DB which is not that friendly with stored procedures No one said anything about stored procedures. :confused: Aren't you using parameters within Crystal?

Hi Mycroft. Sorry for taking this long to reply. I have actualy set the DateColumn in the DB to a string column and I am passing a string. I have now tried numerous things and it just won't work. I have now decided to abandon the save changes from the datagrid and just to delete the row and the users can retype. I know it is not the best thing to do but if I can't et it working then I am stuck with doing that. Excellence is doing ordinary things extraordinarily well.

:laugh: Antoine de Saint-Exupery: Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.

Hi, you are not supposed to touch a Control from a thread that did not create the Control. While your code is using several InvokeRequired/Invoke patterns, it is also not using them in several locations, see: 1. if (this.WindowState == FormWindowState.Minimized) is probably OK, but not documented to be OK 2. infile = txtboxSelectFile.Text; is probably not OK (not documented, I guess it is not OK for Controls that allow text editing) 3. outfile = saveFileDialog1.FileName; is most likely not OK, file dialogs are known to be critical (e.g. you need STAThread for them) IMO you should fix all of the above. :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.

Aye, I got it. Below is what I have done. FinalHash = homingTotal + OverFlow + ContraHash; string hashfinal = Convert.ToString(FinalHash); int length = hashfinal.Length; int remove = length - 12; outhash = hashfinal.Substring(remove, 12); finalhashtotal = Convert.ToInt64(outhash); Excellence is doing ordinary things extraordinarily well.

I did that in my reply. I mentioned exactly what I did wrong and rectified it. Excellence is doing ordinary things extraordinarily well.

They would both be running all the time, they're Services. In my case, I had the report runner insert a record to a database table telling the emailer what to do. On the next cycle, the emailer reads the record, sends the required emails, and (on success) deletes the record (on failure, the record gets marked as failed).

Luc Pattyn wrote: You're just stupid then? Yeah, I recon I probably am just stupid but could be slightly smarter than you!!!!........... :laugh: Luc Pattyn wrote: No, with decent code it does not. If you knew the decent code I am sure you would have suggested it, but you just as clueless as I am. I will resolve this and share my findings. Harsh statements like the above is appreciated but if a matter is not resolved then I recon it is uncalled for. Thanks for the help mate. Excellence is doing ordinary things extraordinarily well.

Hi Mate. I get the jist of this but it seems that the code you have given above puts me in an infinate loop. TO answer your questions: musefan wrote: Are they one per line in the file? or is there more than one on each line? File 1 contains +- 1000 lines with two ID's on each line, the first ID is the one to matched to file2 and the second ID is trhe one to be written to the output file along with the remainder of the data on the matching line of file2. Hope this makes sense. Almost like doing a match in Microsoft Access and then output a combination of the data from the two files. Excellence is doing ordinary things extraordinarily well.

Yeah, this could end up being a right mess then..... :(( .....I have read somewhere that if I use the earliest version and develop on that then I could use earlybinding. I guess though that it would depend if they use the same methods hey? :(( :(( :(( The Nearest Bridge is looking pretty good from my office window right now!!!! Excellence is doing ordinary things extraordinarily well.

All COM classes have registry entries (this is what the COM Library uses to activate objects). Searching the registry is pretty simple. As I recall, Microsoft applications have thousands of registry keys and values. I would guess enumerating, HKEY_LOCAL_MACHINE\SOFTWARE subkeys for Microsoft subkey, and then specific subkeys for Office 12, and eventually, you're looking for a Current Version subkey and value. Also, you might try searching here: Object Library Reference for Microsoft Office 12[^]