9 Replies - 14312 Views - Last Post: 25 October 2010 - 12:06 PM Rate Topic: -----

#1 Dev1462   User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 145
  • Joined: 20-May 10

Getting started with Databases

Posted 23 October 2010 - 09:31 PM

Well Google is confusing the hell out of me. I was wondering where could i go to start learning about implementing data bases into my application. I wanted to build a Gradebook App that adds student and has columns for tests, quizzes and projects. Its going to be something to 1UP my professor's assignment so i can get some extra points :D

Is This A Good Question/Topic? 0
  • +

Replies To: Getting started with Databases

#2 tlhIn`toq   User is offline

  • Xamarin Cert. Dev.
  • member icon

Reputation: 6535
  • View blog
  • Posts: 14,450
  • Joined: 02-June 10

Re: Getting started with Databases

Posted 23 October 2010 - 10:06 PM

Build a Program Now! in Visual C# by Microsoft Press, ISBN 0-7356-2542-5
is a terrific book that has you build a Windows Forms application, a WPF app, a database application, your own web browser.
Was This Post Helpful? 0
  • +
  • -

#3 Nakor   User is offline

  • Professional Lurker
  • member icon

Reputation: 448
  • View blog
  • Posts: 1,504
  • Joined: 28-April 09

Re: Getting started with Databases

Posted 23 October 2010 - 10:41 PM

what database are you going to be using? SQL Server, MySQL, PostgreSQL, SQLITE or something else? Or do you already have the database created and just need help figuring out how to connect to it?
Was This Post Helpful? 0
  • +
  • -

#4 [email protected]   User is offline

  • D.I.C Addict
  • member icon

Reputation: 1003
  • View blog
  • Posts: 975
  • Joined: 30-September 10

Re: Getting started with Databases

Posted 24 October 2010 - 02:23 AM

Hello there,

I find that this book is very good for getting you started with databases in c#. Here is a link to the book I am talking about:

http://www.amazon.co...e/dp/0782141838

It makes it very easy and simple to learn how to integrate databases into c# applications. It's a very good starting point!

This post has been edited by [email protected]: 24 October 2010 - 02:24 AM

Was This Post Helpful? 0
  • +
  • -

#5 JackOfAllTrades   User is offline

  • Saucy!
  • member icon

Reputation: 6247
  • View blog
  • Posts: 24,014
  • Joined: 23-August 08

Re: Getting started with Databases

Posted 24 October 2010 - 06:06 AM

Have you looked through the C# Tutorials here also? For example, this one, or this one.
Was This Post Helpful? 0
  • +
  • -

#6 cmatija   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 10-October 10

Re: Getting started with Databases

Posted 25 October 2010 - 10:32 AM

OMG All of you tell him this and that book is good; look at this tutorial and look at that
and NONE of you tell him some basics...

OK so here they come:

1. I would suggest to use SQL Server DB(database) and i would also suggest to download the free
Microsoft® SQL Server® 2008 Express with Tools because it has IntelliSence and more options for edditing SQL Server DBs.

2. The basic form of info is grouped by tables. Tables are sets of values with names.
In a table the is a row and a column(you know what that means)
Columns are the names of values ex. CreditLimit; Date ...
Rows define specifig sets of values with a name.

There are keys. Keys are a mean to differentiate 2 tables.
There is a primary key which every table must have and on which foreign keys are added.
There is a foreign key which defins a link beetween 2 tables [ foreign key(FK) links on primary key(PK) ]

3. The language used in this prog is T-SQL (Transcend - Server Query Language) its basicly the same as SQL but it has been edited my Microsoft(the only change is some syntax differences).

The basic keywords are : - SELECT (returns the rows with the specifications you wrote)
- INSERT (adds a row with the specifications you write)
- DELETE (deletes a row with the specifications you wrote)
- UPDATE (updates a row with the specifications you wrote with the new specifications)

The common sign used with all these is the * which basicly means ALL.
Some other keywords are BEETWEEN(which defigns a value beetween 2 other ones)
WITH ( one of the most important;you write the specs of the row here)
INNER JOIN ( defigns that there is a link beetween 2 tables)
ON ( defigns the link)

That should be enough to start you up for more references or questions e-mail me and i will be happy to answear you.


P.S. Experiment with code. Thats the way to learn onto this...

SALUTE!

ONLY Jack of all trades actually told something usefull.

Sorry about my english if i spelled something wrong...

This post has been edited by cmatija: 25 October 2010 - 10:34 AM

Was This Post Helpful? 0
  • +
  • -

#7 Curtis Rutland   User is offline

  • (╯□)╯︵ (~ .o.)~
  • member icon


Reputation: 5104
  • View blog
  • Posts: 9,283
  • Joined: 08-June 10

Re: Getting started with Databases

Posted 25 October 2010 - 10:44 AM

View Postcmatija, on 25 October 2010 - 10:32 AM, said:

OMG All of you tell him this and that book is good; look at this tutorial and look at that
and NONE of you tell him some basics...
...
ONLY Jack of all trades actually told something usefull.


That's incredibly rude. These people are sharing their experience and wisdom, same as you, except they're sharing the books they've read that helped them.

Some people learn better by buying a good book and reading it. Some learn that way more readily than a quick forum post.

It seems that you equate "immediately available" to "useful", as if these books were just pointless because it's not online.

Both have their place. You could have provided your answer without the insult.
Was This Post Helpful? 1
  • +
  • -

#8 cmatija   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 16
  • Joined: 10-October 10

Re: Getting started with Databases

Posted 25 October 2010 - 11:03 AM

I can't find the edit button for my post...
So i apoligize in this post its not the place for apolligies.
I'm sorry and you're totally right.
I was just angry at the moment I saw my mistake.

EDIT:
I know where is the edit button but its gone from my post...(idk why)
I am sorry once again for my posting and for beeing rude.

This post has been edited by cmatija: 25 October 2010 - 11:05 AM

Was This Post Helpful? 0
  • +
  • -

#9 tlhIn`toq   User is offline

  • Xamarin Cert. Dev.
  • member icon

Reputation: 6535
  • View blog
  • Posts: 14,450
  • Joined: 02-June 10

Re: Getting started with Databases

Posted 25 October 2010 - 11:08 AM

View Postcmatija, on 25 October 2010 - 09:32 AM, said:

OMG All of you tell him this and that book is good; look at this tutorial and look at that
and NONE of you tell him some basics...


cmatija: Answer 20-100 questions a day, then tell the people here that they should repeat themselves over and over and over every time a new student asks the same question the last student asked 2 days ago. Scan back through DIC. You will find the "How do I use a database?" question started at least 10 times a week. Do you really feel that volunteers should just spend 40 hours a week repeating the same 'intro do database' summary fresh each and every time? I'll tell ya what... since you feel that is the 'right' way to answer this question then you take that on as your chosen quest. From now on we'll all be watching. Every time someone new asks "How do I use a database?" we'll all be waiting to see how long you take to hand write them a complete answer.

That's the reason there are tutorials on here. So the experts can expend 20 hours writing a good explanation 1 time, rather than spend 1 hour, 20 times writing a crappy explanation with no examples, no code, no exercises. Somehow I don't think it was un-useful to point the OP at the entire section devoted to database tutorials. Frankly I don't see how your summary saying "There are 4 key words SELECT, INSERT, DELETE, UPDATE" is somehow more useful than a link to a dozen tutorials complete with code examples and exercises for a new student to follow.

Dev1462 said:

Well Google is confusing the hell out of me.

Since the OP even stated that on-line resource weren't helping and in fact making it worse by confusing him I think suggesting books was the correct next suggestion to answer his question:

Dev1462 said:

I was wondering where could i go to start learning about implementing data bases into my application.

Was This Post Helpful? 0
  • +
  • -

#10 JackOfAllTrades   User is offline

  • Saucy!
  • member icon

Reputation: 6247
  • View blog
  • Posts: 24,014
  • Joined: 23-August 08

Re: Getting started with Databases

Posted 25 October 2010 - 12:06 PM

A Change to Edit Times
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1