Suggest technology tutorial and book

Question

1.00/5 (2 votes)

See more:

I am very new to C#.net Database Programming for Windows Application. I try to write code but I am totally confused because there are many technologies like Entity Framework, SQL Server, SQL LocalDB. I could not able to use my old programming knowledge.

So friend please suggest me which technology I have to use and any good step by step tutorial of book for that.

Here I describe my Application needs:

Windows Form Application with Database
I need to deploy application without SQL Server (earlier I used Access for this type of project)
In my database there are many tables like Customer Master, Daily Transection, Vehicle Master, etc.
I like to bind many DropDownList box with table data with filter.
I like to change DropDownList box data according to other DropDownList which is also bind with table.

What I have tried:

At present I tried with C#.net Windows Form Application with Service-Based Database (LocalDB).
I can able to bind some DropDownList but it is so confusing because of new DataTable, DataView, RowFilter etc.

Posted 3-Mar-17 2:33am

AjayBaroda

Updated 3-Mar-17 7:16am

Add a Solution

2 solutions

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-03-03T05:48:00

Solution 1

You can find some suggestions on this post - tutorials for Windows Forms[^]

Posted 3-Mar-17 5:48am

CHill60

RickZeeland · Answer 2 · 2017-03-03T07:16:00

I had a bad experience with localDB too, couldn't get it working.
If you can manage without a real database, and don't have lot's of data, you could use XML to store your data.
My database of choice at the moment is PostgreSQL in combination with NpgSql in C#, it is not as bloated as SQL Server, runs on different platforms, and there is even a portable version.
An alternative might be SQLite, here is a tutorial: Windows 10 Development SQLite Database[^]