Convert Rows Into Comma Separated Values In A Column SQL Server

DECLARE @COLS    AS NVARCHAR(MAX)

SELECT @COLS = STUFF((SELECT ',' + QUOTENAME(substring(Convert(varchar,D,103),0,3))
from TempAttendRegister
where D >= @startdate
and D <= @enddate
group by D
order by D
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)') 
,1,1,'')

Check If Boolean Value Exist in a Data Table C#

bool BlnSelect = DTTable.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
    return true;
}
else
{
    return false;
}

Boolean Value Column Data Filter A Data Table Dynamically Using LINQ With C#?

bool BlnSelect = DTResult.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
DataTable _DTUpdate;
_DTUpdate = DTResult.AsEnumerable().Where(row => row.Field<bool>("SELECT") == true).CopyToDataTable();
return true;
}
else
{
return false;
}

LINQ Query on Data Table To Check If Record Exists

bool BlnSelect = DTTable.AsEnumerable().Any(row => Convert.ToBoolean(1) == row.Field<bool>("SELECT"));
if (BlnSelect)
{
    return true;
}
else
{
    return false;
}

Split Comma-Separated Values C#

string pStrCommaSeparatedList = "A,B,C,D,E,F,G,H";
string pStrResult = string.Empty;
string[] pStrCommaValues = pStrCommaSeparatedList.Split(',');
for (int i = 0; i < pStrCommaValues.Length; i++)
{
        pStrResult = pStrCommaValues[i].ToString();
}

Comma Separated String Filter Data Table C#

string pStrEmpEditValue = CmbValue.EditValue.ToString();

DataTable table = new DataTable();
table.Columns.Add("value", typeof(string));
string[] values = CmbValue.EditValue.ToString().Split(',');

for (int i = 0; i < values.Length; i++)
{
table.Rows.Add(new object[] { values[i].ToString().Trim() });
}

DataTable _Final = DTResultSave.Clone();
_Final.Rows.Clear();
foreach (DataRow item in table.Rows)
{
String author = item["value"].ToString().Trim();
//bool contains = DTResult.AsEnumerable().Any(row => author.ToString().ToUpper() == row.Field<String>("EmpCode"));
DataRow[] rowsToCopy;
rowsToCopy = DTResultSave.Select("EmpCode='" + author.ToString().ToUpper() + "'");
if (rowsToCopy.Any())
{
foreach (DataRow temp in rowsToCopy)
{
_Final.ImportRow(temp);
}
}
}

Data Set Empty Or Not Check C#

bool IsEmpty(DataSet _DataSet)
{
return !_DataSet.Tables.Cast().Any(x => x.DefaultView.Count > 0);
}