Edit Question - KnowledgeHub

Title Body

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

Tags (comma-separated) Cancel