Using SQL local dataBase in c#.net

Question

1.00/5 (2 votes)

See more:

Hi
How to use SQL local database to save and search images and how to write insert,update,select command for it
need example please

Posted 3-Sep-12 6:24am

mohmmad omera

Updated 3-Sep-12 6:25am

Mehdi Gholam

v2

Add a Solution

5 solutions

Solution 3

You could find many examples in google using just the keywords C# CRUD. For Image save & retrieve operation check this answer How to save and retrieve Image in Database using Asp.net[^]

Posted 3-Sep-12 15:35pm

thatraja

Solution 4

Hi,

What you are asking is a kind of project. It can be expanded to very big project but let me give you some point that you should learn.

1) Creating StoredProcedure and use it in your application.
2) Learn about File Handling in .NET Framework
3) Learn N-Tier/3-Tier Architecture (How you can separate your Business/Database logic.)
4) You can also use SQLHelper[^] class to interact with Database.
5) And ofcourse C# Concepts (Refer : C# Nutshell[^])

Best of luck
Thanks
-Amit Gajjar

Posted 3-Sep-12 16:16pm

AmitGajjar

Solution 5

I want to now how to woke with local database in C#.net

Posted 5-Sep-12 5:39am

mohmmad omera

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)

Mehdi Gholam · Accepted Answer · 2012-09-03T06:27:00

Solution 1

Use google it is a great tool.

A simple search result : http://www.daniweb.com/software-development/csharp/code/303280/sql-insertupdateselectdelete-using-c[^]

Posted 3-Sep-12 6:27am

Mehdi Gholam

Comments

mohmmad omera 3-Sep-12 12:33pm

than x
useful example

Wes Aday · Accepted Answer · 2012-09-03T06:30:00

Solution 2

This should get you started
http://w3schools.com/sql/default.asp[^]

Posted 3-Sep-12 6:30am

Wes Aday

Comments

mohmmad omera 3-Sep-12 12:38pm

than x