How To Establish A Connection To Database Using C# Application?

Question

Im using Visual Studio 2008 . and wants to connect to database. My Application (in C#) is to develop a form acts like Image Viewer and to perform insert an image and delete an image , Also To Display the images In Database

I think you should spend some time [here](http://www.connectionstrings.com/) — V4Vendetta, Jul 06 '11 at 05:37

score 3 · Answer 1 · answered Jul 06 '11 at 05:41

3

Refer this walkthrough:

http://msdn.microsoft.com/en-us/library/tzedkwye%28v=VS.80%29.aspx

answered Jul 06 '11 at 05:41

Mamta D

6,310
3
27
41

score 0 · Accepted Answer · answered Jul 06 '11 at 05:42

Assuming that your DBMS is Sql server. You could do for example

SqlConnection conn = new SqlConnection("connString here");//conn string here
conn.Open();//if using SqlDataReader
SqlCommand cmd = new SqlCommand("your query", conn);///your command object
....
.....

In order to insert the image to the database, there are mainly two options, either to save the image path in the database or save the image itself in database as BLOB.

How To Establish A Connection To Database Using C# Application?

2 Answers2