Comments by Roman Mihai

Roman Mihai 28-May-12 9:59am View

I would like to keep it as a C# Console Application for the moment, as I am just testing. After I cover all the cases I would use the data tabel aproach

Roman Mihai 28-May-12 9:45am View

A line break.
In the CSV file I will have:

LastName FirstName School
Middle Name

all on the same row and FirstName and MiddleName in the same cell. And the field containing the line break will be enclosed in double quotes.

Roman Mihai 28-May-12 9:35am View

A CSV file has some rules. If i want a field to containt a comma i must enclose it in double quote. If the CSV row is like: Field1, field2, field,3 when I open the CSV file it will have 4 fields. But if I have the CSV row like this: Field1, field2, "field,3" I will have only 3 rows the last one being Field,3. I want the same for the line break. I want to enclose the field containing the line break. The formatting of a CSV can be seen if opened with notepad. So I want my program to verify if the line break is in a quoted field (like "Field CR/LF 3"). Also see the page on the link I have provided, at the bottom of the page

Roman Mihai 24-May-12 15:54pm View

Thanks for the advices. I will certainly take notice of them from now.

Roman Mihai 24-May-12 4:01am View

I'm not looking to avoid resource consuming, as this project isn't one that will be sold. It's my college degree project and I just need to implement the things I have learnt in college for a chosen domain. The database will be quite small (I have 27 distinct jobs) and I don't think the number of employees will be more than 50-100.

Roman Mihai 23-May-12 17:54pm View

I want to code something like this in my validating event:

int minimum = "SELECT MinimumSalary FROM Jobs WHERE JobId="+combobox_jobid.selectedValue;
int maximum = "SELECT MaximumSalary FROM Jobs WHERE JobId=" + combobox_jobid.selectedValue;

and the value entered in textbox_salary should be between minimum and maximum described above.

Sorry about all my questions, I understand your solutions, but in my mind I want to clear out if the implementation thought by me is possible or not.

Thanks a lot for all the help so far.

Roman Mihai 23-May-12 15:58pm View

I have tried on the Validating event, but I need an example to retrieve the values for minimum salary and maximum salary from the table to use them for validation

Comments by Roman Mihai (Top 7 by date)