StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10753431
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-05-25T11:14:44.027
FavoriteCount
0
LastActivityDate
2012-05-25T11:14:44.027
LastEditDate
LastEditorUserId
0
OwnerUserId
1414680
ParentId
10752295
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Just been in the middle of doing this myself, one thing I would suggest is using SQL Compact Edition makes the process a lot easier, but if it's too late in the process at the moment then stick with the current database, However I do not know if the below method works with an MDF file. How are you deploying the application on the client machine? does the users machine have sql installed? The first thing you need to do is go to the properties of your MDF and ensure copy to output directory is set to copy if newer and build action is set to content. If you're using a setup project to install the application then you need to make sure in project, application properties, publish, application files that you're mdf is in the list and is set to Data File auto, required and include. and right click on the "Application Folder" in the installers file system, then add, project output, file contents Finally change the connection string in your code so that it reads <pre><code>using ( SqlCeConnection sqlCon = new SqlCeConnection( @"Data Source=|DataDirectory|\App.sdf;Persist Security Info=False;" ) </code></pre> or if you're not using compact Edition <pre><code>using ( SqlConnection sqlCon = new SqlConnection( @"Data Source=|DataDirectory|\App.mdf;Persist Security Info=False;" ) </code></pre> ^using "DataDirectory" means that you don't care where the user puts the application, you will always get the right file before you run and change your database to compact, it doesnt support a lot of things a proper sql database will. After all this, you may still encounter errors with permissions and because its quite long winded I might have missed out a step so just comment if you need more? EDIT If the user does not have either sql server or sql Compact, your easiest solution would be to require them to install SQL CE or there is a way of using DLLs that do the same thing but I couldn't get that to work the link for that is here <a href="http://msdn.microsoft.com/en-us/library/aa983326.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/aa983326.aspx</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPackaging a C# application with a database
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAlex
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.