This is the first time I've used SQL and this is probably a stupid question but I've done some research and I don't think I'm finding what I'm looking for.

What I want is a way to make a private SQL database that will be used within my C# program. I've already made a database within SQL Server Express and I've connected that to Visual Studio 2010.

```
SqlCommand DBAccess = new SqlCommand();
DBAccess.Connection = new SqlConnection(
    "Data Source = localhost;" +
    "Initial Catalog = My_Database;" +
    "Trusted_Connection = True");

```

* Can I make the Data Source embedded into my program and will be compiled along with the rest of the solution?

Some extra background on the program;

It's a program that needs to search through 6 tables within the database and output the contents of a `DataRow` when search string matches a particular field.

EG.

```
Field 1     Field 2
quick       AA
brown       AA
fox         AB
jumps       AB
over        AA
the         AB
lazy        AB
dog         AA

```

Search\_String = AB

Outputs;

```
fox
jumps
the
lazy

```

Any help will be much appreciated!!!!!

Thanks