Implementing SQL Server databases in your project!

Implementint databases in your project!

Page 1 of 1

11 Replies - 2405 Views - Last Post: 20 November 2010 - 01:56 PM Rate Topic: -----

#1 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Implementing SQL Server databases in your project!

Posted 18 November 2010 - 01:42 PM

How can i implement SQL Server databases.
I know how to create a database and to work with it with the T-SQL language.
I need some keywords that are used in C# to work with SQL Server DBs OR a reference to a tutorial or an already asked question...
To be more specific how can i read* data from DBs by using C#.
*Update, Delete, Insert...

P.S. If it helps you I want to make a program that will have an input textbox and an output textbox. In the input you enter the name of the periodic element and you get the sign in the output tb. I have made a DB that has all the periodic elements inserted and all their info also, but the question is how to accsses the DB from the prog using C#?...

Is This A Good Question/Topic? 1
  • +

Replies To: Implementing SQL Server databases in your project!

#2 JackOfAllTrades   User is offline

  • Saucy!
  • member icon

Reputation: 6260
  • View blog
  • Posts: 24,030
  • Joined: 23-August 08

Re: Implementing SQL Server databases in your project!

Posted 18 November 2010 - 01:50 PM

Did you bother to search our tutorials?
Was This Post Helpful? 2
  • +
  • -

#3 f0zz13   User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 11
  • Joined: 17-November 10

Re: Implementing SQL Server databases in your project!

Posted 18 November 2010 - 02:00 PM

I would suggest perusing the MSDN documentation for the System.Data.SQLClient available at http://msdn.microsof....sqlclient.aspx. I'd especially recommend looking specifically at the SQLConnection and SQLCommand classes.
Was This Post Helpful? 1
  • +
  • -

#4 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Re: Implementing SQL Server databases in your project!

Posted 18 November 2010 - 02:37 PM

View PostJackOfAllTrades, on 18 November 2010 - 08:50 PM, said:

Did you bother to search our tutorials?

I searched the tutorials and found SQL Basics In C#
very helpful but I was looking for some really deep and detailed resource.
[My mistake i didn't mention that in my question]

@f0zz13 TY I found this very helpful.
Was This Post Helpful? 1
  • +
  • -

#5 eclipsed4utoo   User is offline

  • Not Your Ordinary Programmer
  • member icon

Reputation: 1536
  • View blog
  • Posts: 5,972
  • Joined: 21-March 08

Re: Implementing SQL Server databases in your project!

Posted 19 November 2010 - 05:16 AM

Explain how a tutorial can be "deep and detailed"? What exactly are you looking for?
Was This Post Helpful? 0
  • +
  • -

#6 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Re: Implementing SQL Server databases in your project!

Posted 19 November 2010 - 06:07 AM

I meant something like this http://msdn.microsof....sqlclient.aspx.
Something that has pretty much all the info you will ever need...
Again @f0zz13 ty.
Was This Post Helpful? 0
  • +
  • -

#7 JackOfAllTrades   User is offline

  • Saucy!
  • member icon

Reputation: 6260
  • View blog
  • Posts: 24,030
  • Joined: 23-August 08

Re: Implementing SQL Server databases in your project!

Posted 19 November 2010 - 06:25 AM

That's called "the documentation". It's the first place to which you should always look.
Was This Post Helpful? 2
  • +
  • -

#8 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Re: Implementing SQL Server databases in your project!

Posted 20 November 2010 - 03:09 AM

Thanks for the info. I'm new to searching for the awnsears on the web.
So I didn't know about "the documentation".
Was This Post Helpful? 0
  • +
  • -

#9 JackOfAllTrades   User is offline

  • Saucy!
  • member icon

Reputation: 6260
  • View blog
  • Posts: 24,030
  • Joined: 23-August 08

Re: Implementing SQL Server databases in your project!

Posted 20 November 2010 - 06:58 AM

The two most important things to being a software developer:

1. The documentation. In your particular case, you want to start here. And then there's the Visual C# Developer Center.

2. Using Google (or another search engine) effectively. Here's a good guide to using Google.
Was This Post Helpful? 1
  • +
  • -

#10 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Re: Implementing SQL Server databases in your project!

Posted 20 November 2010 - 01:23 PM

Wow this has been REALLY helpfull... Although it was not the original topic.
Thanks for "the documentation"...
Are there any more (sub)forums(inside < / Dream.In.Code® >) about that kind of questions?(Like: "What is the default place where you would look for an awnsear to your problem"... which by the way you gave me.)

This will help me ALOT not to anoy you with these insignificant(trivial) questions.

This post has been edited by CodderMan: 20 November 2010 - 01:26 PM

Was This Post Helpful? 0
  • +
  • -

#11 Sergio Tapia   User is offline

  • D.I.C Lover
  • member icon

Reputation: 1259
  • View blog
  • Posts: 4,168
  • Joined: 27-January 10

Re: Implementing SQL Server databases in your project!

Posted 20 November 2010 - 01:32 PM

There's no such thing as a 'trivial question'. Please ask anything you want and we'll do what we can to help you. Just try to show us that you at least TRIED something before things went BOOM on your dev machine. :P
Was This Post Helpful? 0
  • +
  • -

#12 CodderMan   User is offline

  • New D.I.C Head

Reputation: 10
  • View blog
  • Posts: 48
  • Joined: 18-November 10

Re: Implementing SQL Server databases in your project!

Posted 20 November 2010 - 01:56 PM

View PostCodderMan, on 20 November 2010 - 08:23 PM, said:

Are there any more (sub)forums(inside < / Dream.In.Code® >) about that kind of questions?(Like: "What is the default place where you would look for an awnsear to your problem"... which by the way you gave me.)


Are there?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1