Hi Ishan,
Write your query with the COALESCE option. This will resolve your problem.
SELECT empid ,REPLACE(RTRIM((SELECT empLanguage + ' ' FROM TableName WHERE ( empid = Results.empid ) FOR XML PATH (''))),' ',', ') AS NameValues
FROM TableName Results
GROUP BY empid
Apply below code to bind checkbox
for(int i=0;i<lstCheckBox.Items.Count;i++)
{
for(int j=0;j<ds.Table[0].Rows.Count;j++)
{
if(lstCheckBox.Items[i].Value == ds.Table[0].Rows[j]["LanguageId"].ToString())
lstCheckBox.Items[i].Selected = true;
}
}