Search results for query: *

Thanks for the notice. I will keep that in mind next time.

Thanks JohnH!! Thanks for pointing me in the right direction. I have it working now.

This is the first time I use a Parallel.ForEach loop and hoping I can get some help with it. So basically within the Parallel.ForEach loop, I'm doing unit coversions but in the example code below, I am just getting the To / From units to be concatenated which would then be used to select the...

Thanks guys! I really appreciate your input.

I ended up doing it this way. It's not the best way to implement it I'm sure but it's what I have right now. If anyone can show me a better way or the LINQ way, I'd appreciate the lesson. Thanks!! for (int row = 0; row < dt.Rows.Count; row++) { if (dt.Rows[row][0].ToString() ==...

The syntax is not correct but I'll play around with it. Thanks for giving it a shot though ConsKa! It seems like it should be a simple solution but just can't get it to work.

I have created a dynamic unit conversion Data Table, example below, and want to find specific values basically using an intersection type search. gpm_us is the reference unit, in this example, where all other units are converted based on it. For example, let's say I want the "Min" converted...

Thanks for the explanation. I really appreciate your input!

I finally figured out my mistake. In my delete statements I was not handling the case where the column's cell was null. The corrected DELETE statement is as follows: cmd.CommandText = "DELETE FROM [Temp_Tbl] WHERE (NOT [INSTRUMENT_TYPE] = '" + Instr_Type_Cbx.Text + "' OR [INSTRUMENT_TYPE] IS...

I fixed the majority of my issues with the Delete statement but I am having some weird results with one of my delete statements. In my code below, all of my DELETE statements execute as I want them to except for the last one that starts with --> if (cntrl_selection == "Instr_Type_Cbx")...

Thanks for your reply jmcilhinney. I will try your solution but I actually got my code to work sort of. The issue I was having is that I had too many continuing AND lines. I believe the limit is 23 or something like that. The code I showed in my previous post didn't show the entire code so...

I joined C# Developer today and this is my first post. Hello to all! I am creating a database with MS Access as my back-end and C# Win Form using VS 2017 as my front-end. I am having issues with deleting rows in my table using the DELETE clause. Background info: A user enters a search term...