winform and database

Hy,i wont to do winform app and the problem is database.I must put the database in aplication folder so when the aplication is instaled the database must be conected with aplication wherever is instaled and to avoid a problem if the client pc don't have instaled server or other stuff to run database.I wont to ask which database is good for this,i try to create database in visual studio 2010 but i can't get connection because my conneection string i think is not good.

I thing the soluction with |DataDirectory| is good but it don't work for me.

I try this but is not work

string spoj = @"Data Source=|DataDirectory|\baza.sdf; Persist Security Info=False;";

SqlConnection konekcija = new SqlConnection(spoj);

konekcija.Open();

string upit="select * from osoba";

SqlDataAdapter da = new SqlDataAdapter(upit, konekcija);

DataSet ds = new DataSet();

da.Fill(ds, "osoba");

dataGridView1.DataSource = ds.Tables["osoba"];

If you can advice me i be grateful.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka14y ago
Any error you are getting or any exception. Try this as connection string once

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True