Month: November 2015

Insert multiple rows into a table from another table and get identity values

November 26, 2015 Prakash

Let me explain the case first, so you will get the idea when this is required to use. In the database, there is more than one tables which store the future values and will move on specific time to standard tables. For example, Table “UserList2” contains the future values consider as temporary table. Table “UserList1” …

Remove illegal characters from file name or file path in c#

November 9, 2015 Prakash

File cannot be saved if file name has illegal characters. So how to remove the illegal characters by a single line code as below. I use LINQ Querty for that. string fileName = “prakash C/O swami.xml”; fileName = System.IO.Path.GetInvalidFileNameChars().Aggregate(fileName, (current, c) => current.Replace(c.ToString(), string.Empty)); Now the fileName is “rakash CO swami.xml”. The code removes slash …