How to display data in a table using C# Windows Form?

Question

1.00/5 (1 vote)

See more:

Hi.

I would like to display data from my database in a table. I have not yet tried anything. Can anyone send me links where I can solve this. I had read many articles yet I could not find any solution. Please help me. Thanks in advance :)

Here is what I need to display:

Months|TotalFeeToPaid|AmountPaid| Balance |
---------------------------------------------
May | 15,000.00 | 5,000.00 |10,000.00 |
---------------------------------------------
June |10,000.00 | editable |AutoCompute|

->at the amountpaid, user can input the amount then the system will auto compute it to get the balance remaining. Please help me :)

Posted 17-Jan-15 15:50pm

DarkDreamer08

Updated 17-Jan-15 16:22pm

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Jan-15 22:00pm

Web app or windows app? What have you tried and where is the issue?

DarkDreamer08 17-Jan-15 22:03pm

i have not yet fried anything. I am still looking to any articles that could help me here :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Jan-15 22:18pm

Web or windows?

[no name] 17-Jan-15 22:22pm

"C# Windows Form" is "Windows" and it is obvious.
You shouldn't answer question if you don't know a subject.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Jan-15 22:26pm

That was edited just now. It was not there previously and I am not answering, I am asking questions in comment.

Answer box is below. When you are not sure about the question, you should ask the OP about it by commenting. That is what I am doing here.

DarkDreamer08 18-Jan-15 2:10am

Hey Dash, i updated my question. Sorry if I was late to update the question. But thanks for reminding me to clarify my question. Anyway, I have a scenario above. I want to do it in a table not in a datagridview. can you help me :)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Jan-15 2:54am

So, when you type 1, it should autocomplete to 4999 !!!

DarkDreamer08 18-Jan-15 4:51am

No, when you type to the AmountPaid column which is editable, let say for example 1000, the Balance will be now 9000. Meaning, the TotalFeeToPaid is the remaining balance that the customer will pay. AmountPaid is deducted to the TotalFeeToPaid Column and that will be the Balance :) Hope you get it :) if it is not possible to a table then, I think it could be in a datagridview, right?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Jan-15 5:27am

Yes, you have to use datagridview and do that. You just need to write the code inside the correct event.

BillWoodruff 18-Jan-15 3:49am

Keep in mind that a DataTable in C# .NET is a data-structure that has no visual representation. Typically a DataTable is hooked-up to a visual UI, like a ListView, or DataGridView, by binding.

If you just want to display your structured data in a UI, that's one thing, if you want to display and allow a user to edit the data, and then save the edited data back to your database or datatable ... that is another scenario.

DarkDreamer08 18-Jan-15 4:48am

Oh, i thought that I could post like that kind of questions which were both related. anyway, thank you for your statement about that.

BillWoodruff 18-Jan-15 5:06am

There's nothing wrong with your question as it is ! I'm just trying to get you to clarify exactly what you want, and be aware of how most people will understand the description you give now. It often takes some back-and-forth here to get the problem in "focus" :)

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)

Emiliarge · Answer 1 · 2015-01-17T16:19:00

Solution 2

Why not google properly?
https://www.google.ru/?q=c%23+read+ms+access+database+codeproject

C# / VB.NET / C++ CLI: Create, read and write MS Access (mdb, accdb), MySQL, SQL Server, SQL Server Compact and SQLite databases[^]

MS Access (*.mdb) + C#: SELECT, INSERT, DELETE and UPDATE Queries[^]

SQL Server + C#: SELECT, INSERT, DELETE and UPDATE Queries and Stored Procedures[^]

Posted 17-Jan-15 16:19pm

Emiliarge

Updated 17-Jan-15 16:20pm

v2

Comments

DarkDreamer08 18-Jan-15 2:08am

i updated my question above,. can you help me. I am using SQL server as my database :) hope you will.

[no name] 18-Jan-15 5:13am

There are as much as 3 links in my answer here. All those links are links to my (!) CodeProject articles about DBs. 2 links are about sql server. What more do you want?
Get used to read articles and explore the demo source code in them!!! No one will write the answer for you personally, when there is an article in internet!!!