Click here to Skip to main content
15,921,905 members
Please Sign up or sign in to vote.
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
Updated 3-Mar-17 7:16am

You can find some suggestions on this post - tutorials for Windows Forms[^]
 
Share this answer
 
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[^]
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900