Using a SQL Database in a C# app

Question

0.00/5 (No votes)

See more:

I'm looking for some links to a C# windows app that uses an SQL database, specifically, how to view/update/delete info from the form.

I'm building a C# app in Visual Studio 2008 and I want to add a database to it. I already made the tables and relations in the database, and now I want to be able to view/add/delete data from the application. I was able to bind the database to some combo boxes, but I don't know how to update them when a user selects some data from the combo box. I've been looking for some tutorials for the past few days but I keep getting info on how to build a database, which is not what I need.

I know this is a simple thing, but I'm tired of searching fruitlessly for it and would like some help. This is the last part of my project that I don't know how to do and I want to get it finished as soon as possible.

Thank you for your help!

Posted 22-Nov-09 8:20am

tehJamis

Add a Solution

3 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)

Richard MacCutchan · Answer 1 · 2009-11-22T11:16:00

Solution 1

There are many such examples here on CodeProject, use the Articles tab on the menu bar above.

Posted 22-Nov-09 11:16am

Richard MacCutchan

AspDotNetDev · Answer 2 · 2009-11-22T15:35:00

I realize it can be frustrating when you are just starting out, because you don't even know what to look for. You really should read a book, but since you've put some work into this already, I'll throw you a bone. Here are some links and keywords you'll want to look into:

How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual C# .NET
Mastering C# Database Programming
Windows Forms
Asp.Net
C#
update SQL table
SQL Server insert row
SQL Server CE
ADO.Net
LINQ
SqlConnection
SqlCommand
SqlParameter

Some of those are advanced topics (ADO and LINQ, especially the latter), but that should give you some starting points of things to look into.

tehJamis · Answer 3 · 2010-02-18T20:34:00

Solution 3

The answer I found came from the book "Pro C# 2008 and the .NET 3.5 Platform, Fourth Edition" by Andrew Troelsen. He has a lot of good C# examples, but for a "Pro" book it didn't go too deep. Good intro to C# book though.

Posted 18-Feb-10 20:34pm