How do I create textbox dynamically and insert value into database on C# windows form application

Question

1.00/5 (1 vote)

See more:

I am currently working on a C# windows form project that would be used to calculate personal income tax for employee, i am having issue with my client weird requirement of creating allowances dynamically on the form, companies have different policies concerning which allowance would be given to thier employee, i have tried to captured the popular allowances in the application, and also provided a textbox for other allowances, so could enter the sum value of other allowances that is not included in the application form since the application is not going to be used for only one company, the issue now is: my client does not want the others allowances texbox that i included on the form, he wants to be able to click on somthing on the form and that should open where he can type in any other allowances that was not included on the form fields, i have tried the approach of putting a label for allowance name and allowance amount on the form, but this didn't seem to work since enteries could only be done once for each employee very month and thier allowances could up to ten sometimes depending on the company. I dont know whether any of our senior colleadgues here had done anything similar to this, i will appreciate if they could share thier knowledge with me. Thanks

What I have tried:

I have tried the approach of putting a label for allowance name and allowance amount on the form, but this didn't seem to work since enteries could only be done once for each employee very month and thier allowances could up to ten sometimes depending on the company.

Posted 5-Apr-17 19:33pm

Uwakpeter

Updated 6-Apr-17 1:12am

Add a Solution

Comments

Prifti Constantine 6-Apr-17 2:50am

One Solution would be to create a string builder with the appropriate string that would create the markup in the client and then return that string so that it would be created upon demand. If you would like, i could provide some examples, but i am not sure if thats what youre asking . Best regards!

Uwakpeter 6-Apr-17 4:57am

this is windows from application, not sure of markup, also, if i use string builder to create the markup that will allow users to enter multiple allowances for a particular employee at once, how will i save them to database and display same in different report columns on the report? seeing i will be saving into only two fields (Allowance name, and Allowance Amount) I will appreciate some examples as you said , thanks.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2017-04-06T01:12:00

It sounds like your "client" wants a pop-up Dialog (modal) for the Allowances.

I would suggest displaying the list of allowances per individual employee in a listbox on the form - make it scrollable so that it doesn't matter how many there are. You could also consider using a ComboBox to enter any allowances that aren't "standard" - but you might run into problems with the Revenue if you go too far away from standard terms.
Reference: Drop-down Lists & Combo Boxes (Windows)[^]

If you do use a modal dialog then you might find this article useful (there are further article links in the article itself)
Transferring information between two forms, Part 1: Parent to Child[^]

Finally on the UI side of things it would be better to use a Button than a label to trigger the dialog.

As to the database side of things, do NOT, I really mean DO NOT store these allowances as a single string. It is a real pain to manage them, a real pain to use them and eventually you will run out of column space to store them. It is the WORST possible design you could choose. (Have you guessed I really don't like the idea? :-) )
A better solution is to have a linking table...e.g.

SQL

Table Employee (EmpId, FirstName, LastName, etc)
Table Allowances (AllowId, Description, etc)

A table like this can link allowances to specific employees:

SQL

Create table AllowEmpl
(
    EmpId int,   -- Foreign Key to Employee table
    AllowId int  -- Foreign Key to Allowances table
)

By using this construction you can have unlimited allowances per employee, they are easily inserted, searched for, deleted and you won't have to change the database schema when more Allowances are added.