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