HOW TO USE YOUR PHONE TOUCH SCREEN AFTER IT BREAKS

Most times when a phone falls and the touch screen breaks, it keeps working but other times it stops completely, thereby forcing the owner to get a new one. Now in some cases when the latter happens the phone screen stops working completely but sometimes you can fix the problem by holding the top edges of your touch screen without touching areas covering the phone screen. This helps fix the touch screen is connected to the phone from the top edge, so sometime if it is not too damaged holding it helps make it keep working.

FIX WINDOWS PHONE APPLICATION INSTALLATION ERROR (EG TEAMVIEWER ERROR)

Generally if an app is compatible with your windows phone it should be able to install. If an error occurs, it is due to the following:

• You have an internet connection problem;
• Windows store is not available at the moment;
• You have not installed the latest available phone update (this usually occurs on win 10 phones);
• You installed the application in the wrong storage memory (some apps can only be installed in phone storage)

I'm going to explain the last one. If you install an application that is meant for phone memory into SD card memory, it will either refuse to download or it will download and not install. If the latter happens then it creates a problem, because no matter the number of times you install the application (even if you change storage location to phone memory) it will still detect the downloaded application and refuse to install. In this case the only solution is to either scan and fix memory card or you remove the memory card entirely from phone and then download and install app to phone memory before putting the SD card back.

HOW TO PUBLISH A VISUAL C# APPLICATION WITH REPORTVIEWER

In order to publish the application containing reportviewer, you first need to add the required references, go to references and add "Microsoft.Reportviewer.common" and "Microsoft.Reportviewer.Winforms"(or Microsoft.Reportviewer.Webforms if it is a web application) to your project. if you don't have this already in your visual studio then you search online and add it. Now when you go to setup and go to file system, you should enter your applications folder. Here when you add your primary output, reportviewer references should appear as well, but if it doesn't you can add it manually by right clicking on a blank area and going to "add" and enter "assemblies", then add it. Now go to your solution explorer and enter properties - publish - application files. Under "Publish status", ensure that all your report viewer references are set to "include" or "include auto".
Now for the last process. In order to add reportviewer to your application there are some prerequisites you must add these are "Microsoft report viewer 20** runtime" and "Microsoft System CLR Types for SQL Server" (both x64 and x86 for 64 and 32 bit respectively). And you need to add this in two places. First in your setup, right click and go to properties - prerequisites, and add it. Then next in your publish, go to prerequisites and add it as well. If you don't have these prerequisites already in your visual studio, search online and add it.
Note: All these are necessary when you are selecting the option "Download prerequisites from the same location as my application". If you want the other two options, then this process might not be necessary.

HOW TO PUBLISH A VISUAL STUDIO PROJECT WITH LOCAL DATABASE

If you are reading this, I am assuming that you've read my article on HOW TO CREATE AND ADD A NAMED LOCAL DATABASE INSTANCE IN VISUAL STUDIO 2013  . Now to add the local database file to your published application, first you need to make sure that the database.mdf file is in your project folder. Then go to solution explorer and click on "properties". go to "publish" and click on "application files" ensure that your database.mdf and database.ldf files are there. Then go to solution explorer and create a new "setup" project (unless you have an existing setup project). Right click on the setup and go to "view" then open "file system". Open the "application folders" by the right. Then right click on an empty space and select "add" then "files..." it will open a windows explorer for you to locate and add your database.mdf and database.ldf files. Then you can build your setup and publish your application.
Note: for the published application to access your database after installation by and end user. you'll need to adjust your connection string to the database a little. where it is written "attachdbfilename:" change the database path to "AttachDbFilename=|DataDirectory|\database.mdf". This will allow your published application to access the database file no matter the path it installs it to.

HOW TO CREATE AND ADD A NAMED LOCAL DATABASE INSTANCE IN VISUAL STUDIO 2013

To create a database file in your visual project, go to the "add new item" and add a service based database file, then in your solution explorer, double click on the .mdf file. The database instance opens in server explorer automatically. right click on the database instance and click on "modify connections" (before you do this make sure you close the connections first). Click on "Change..." and in the new tab select "Microsoft SQL Server". when the former tab reopens type "(LocalDB)\v11.0" as your server name. click on the radio button "attach a database file". Select browse, and browse to the database.mdf file which you created (It is located in your project folder by default). After selecting the file, give the project a logical name of your choice (do not use punctuations because this might affect its backup if you want to put a backup code). click ok.
To get the connection string for your database instance, go back to "modify connections", click on "advanced", copy the connection string which will appear at the bottom of the new window.