News

GitHub1y

This function could be useful in scenarios where traditional Eloquent relationships are not applicable, and you need to manually handle the relationship using raw SQL queries ...

$relationTable: This variable represents the name of the table that holds the related data. $relationFieldName: It specifies the field in the relation table that is ...
GitHub3y

System.ArgumentException occurs while sorting the column when column name contains a comma(,) in DataTable collection

at System.Data.DataView.System.ComponentModel.IBindingListView.ApplySort(ListSortDescriptionCollection sorts) at System.Windows.Data.BindingListCollectionView.<>c ...
Ars Technica6y

SQL comma and colon separated values in a column to split

I have a table that stores a comma separated list of key value pairs for permissions. E.g 45:902,45:61,51:203,51:208 etc. I'm trying to parse a single record row so that I get a record set of multiple ...
findnerd.com10y

How to display SQL row data as a column wise with user specific column name

Hello all, The below tutorial will help you in displaying SQL row data as a column wise with user specific column name. here, I've a table with #Temp1 name that contains the following columns Id, ...