How to split a single column values to multiple column values?

USE LEFT FUNCTION WITH CHARINDEX

Could not find a row that matches the given keys in the original values stored in ViewState.

Add DataKeyNames="PrimaryKey1,PrimaryKey2,PrimaryKey3,....." to formview, gridview and/or listview

How to get sql server bak file logical name

RESTORE FILELISTONLY 
FROM  DISK = N'path to bak file' 
WITH  FILE = 1 
GO

Use WITH MOVE to identify a valid location for the file.

USE [master]
GO
RESTORE DATABASE [DBName] 
FROM  DISK = N'Path to BAK File' 
WITH  FILE = 1,  
MOVE N'Logical File Name' TO N'New Path to mdf file',  
MOVE N'Logical File Log Name' TO N'New Path to log file',  
NOUNLOAD,  REPLACE,  STATS = 1
GO

To get logical file list

RESTORE FILELISTONLY 
FROM  DISK = N'path to bak file' 
WITH  FILE = 1 
GO

crystal report for visual studio 2015 / dot net framework 4.6

just copy existing framework folder in aspnet_client\system_web folder and the rename it to 4_81 or whatever version you have installed and your are done
To Check your version click here
http://w3dproblems.dcense.com/2015/09/what-net-version-are-you-running-20-45.html