Connecting To Database in C# (WebApplication)

[Noah]

If he's using C# then there's a much higher probability of him using MSSQL and not MySQL...

Habit I guess, it's what I use.
Web -> MySQL
Desktop -> SQLite

 

[Bighit]

http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

 

[zippy]

Unfortunately, if you can't follow those tutorials that are listed when you google "connecting to a database with C#", then you are wasting your time with this course.

 

[Cool E]

after i connect the database, how do i compare the data so that IF the user enters a product number it will display the price from the database?

C# for Dummies

 

[Bar0n]

my web form has the following items:

TextBox1 = to enter Product Code.
TextBox2 = to enter Name.
Button1 = to process the transaction.
label1.Text = to display the output.

Kill it with fire.

 

[Bar0n]

Oh, and just write a stored procedure in MSSQL, and pass the product code as parameter from C# to MSSQL.

 

[jeanres]

Sounds like homework

 

[Bona Botse]

Unfortunately, if you can't follow those tutorials that are listed when you google "connecting to a database with C#", then you are wasting your time with this course.

I hate discouraging people but OP is showing symptoms of all the dropouts from my 1st year class.

 

[CamiKaze]

Well, I didnt have any IT course at my school and I am a programmer today.

Anyway, its extremely trivial. Follow the links from the previous posts.

Best follow this:

http://www.csharp-station.com/tutorial.aspx

It should put you ahead of your class, and you will pick c# up pretty quick.

Word of advice before starting a project, as a beginner, always do a logical flow type of thing on paper before starting to code, don't jump into the coding. Make use of Chapin diagrams or any other form of pseudocode.

 

[Bar0n]

I hate discouraging people but OP is showing symptoms of all the dropouts from my 1st year class.

Or a Help Vampire.

http://slash7.com/2006/12/22/vampires/

 

[Bar0n]

I hate discouraging people but OP is showing symptoms of all the dropouts from my 1st year class.

Or a Help Vampire.

http://slash7.com/2006/12/22/vampires/

 

[stevenv]

no, i don't know how to do databases. im First Year university, they said must use school knowledge, but i never do IT in school.

Maybe by "school" they meant what you've learnt so far in university. Not that I'm advocating it but you can even get away with implementing the requirement without very much database knowledge at all. Programming requires a certain degree of logical thinking, an analytical mind and the ability to independently solve problems. If you're unable to solve such a trivial problem by looking for the solution in the numerous online resources available to you, I would start reconsidering whether you're taking the right career path. Sorry to be harsh but that's my opinion.