Need help with saving data in C# program

Question

0.00/5 (No votes)

See more:

I am working on a program that ideally would take user input from a text box (windows form application) and the code would identify an object and assign members to it (example: "the jacket is black" and the code would identify the object as jacket and give it an attribute of black). The code to identify the object and its attribute I can handle, but I have very little experience with storing data in a database or however the most efficient way would be to store this would be.

Also I would need to be able to have the code check if there is a "jacket" object already created and if not create the object as well as its attributes and if there is, it would simply add the attributes to the already existing class.

Thanks for any and all help.

Posted 6-Mar-12 18:37pm

BboyTech

Add a Solution

Comments

Rahul Rajat Singh 7-Mar-12 0:46am

What exactly you want to store? I mean you want to store user input string somewhere or you want to store the jacket data itself?

BboyTech 7-Mar-12 13:51pm

The way I was thinking of approaching it was to have the jacket object actually be the name of a data table that could contain attributes like black, waterproof, etc...
being able to store the user input string would be nice to have in the program, but I want to tackle this issue which is more vital and not bite off more than I can chew.

Here's a more elaborate example (without going into the code of it):

user input: the jacket is black
//code to identify that the object is jacket and its "attribute" is black

//code to see if there is a data table named jacket in the database already
//if yes then checks to see if black is already a member of the data table
//if no then adds black as member of jacket
//if yes then doesn't re-add black and exits the loop that's running
//if no, creates the data table "jacket" with member "black" and exits loop

I am sorry if I switched between terms like member and attribute, I don't always write with perfect coding terminology.

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)

walterhevedeich · Accepted Answer · 2012-03-06T18:42:00

Solution 1

Since you have little experience on the database part, you might want to start by learning ADO.Net[^].

Posted 6-Mar-12 18:42pm

walterhevedeich

Comments

Sergey Alexandrovich Kryukov 7-Mar-12 1:24am

Basically, your idea is good; and I voted 5.
However, I'm not 100% agree that it will provide sufficient help. ADO.NET manuals usually assume some prerequisites, such as understanding of OOP, and, essentially, some understanding of databases and relational model ideas.

So, I added my answer with some references, but that also might be not enough. Some people do not move on their own but require some cultural environment and guidance from others.
--SA

BboyTech 7-Mar-12 13:27pm

Thanks walter, that's much appreciated point in the right direction.

Sergey Alexandrovich Kryukov · Accepted Answer · 2012-03-06T19:20:00

In addition to what walterhevedeich advised, I would suggest you learn about the ideas of databases.

http://en.wikipedia.org/wiki/Database[^],
http://en.wikipedia.org/wiki/Database_management_system[^],
http://en.wikipedia.org/wiki/Binary_relation[^],
http://en.wikipedia.org/wiki/Relational_algebra[^],
http://en.wikipedia.org/wiki/Relational_model[^],
http://en.wikipedia.org/wiki/Relational_database[^],
http://en.wikipedia.org/wiki/Relational_database_management_system[^].

Maybe the encyclopedia cannot replace education, and you really need some pretty basic education, not just some concrete technical knowledge. At least these encyclopedia can show you the scope of required education. Also, it needs some practice of analyzing of real-life concepts and mapping them onto relational model.

Also, understanding of ADO.NET requires good understanding of OOP.
Only based on that, or in parallel with that, you can learn ADO.NET and get to using it practically.

Good luck,

—SA