Geeks With Blogs
Sathya Narayanan Srinivasan .NET Developer August 2010 Entries
Weird error page "page cannot be displayed" when everything is correct
I was facing a weird error page "page cannot be displayed" when everything is correct in my page which is called through ajax from another html page. But checked the page by copying the url in the browser and pasting it. even then it want working. Then finally set that aspx page as the startup page and tried executing. it worked then. Was struggling with this for an hour. What a shame, finally i have found out the reason that there was a space between http: and // it was like this : http: ......

Posted On Tuesday, August 17, 2010 10:13 AM

Convert DataRowCollection to DataRow[] (Array) in C#

Access the select method of the datatable to convert the DataRowCollection to DataRow[];

You might get an error like this:-

System.Data.DataRow.DataRow(System.Data.DataRowBuilder)' is inaccessible due to its protection level

To overcome that use the select method from the datatable

Ex :-

DataRow[] results = genericDataSet.Tables[0].Select(); 

Posted On Tuesday, August 17, 2010 9:57 AM

Concatenate row data from SQL using For XML instead of coalesce
This was the question from Pinal Dave's blog and i have answered the same. Thought this might be useful for my friends too and posting the same here. Hi, I’ve following problem, which I’ve not been able to do successfully. Your help will be appreciated. Table has following 2 columns DocNum DocEntry 1 234 2 324 2 746 3 876 3 764 4 100 4 387 Expected result is as follow 1 234 2 324, 746 3 876, 764 4 100, 387 Thanks Rahul Jain on August 16, 2010 at 12:22 pm | ReplySathya Narayanan Your comment is awaiting ......

Posted On Monday, August 16, 2010 12:28 PM

Copyright © sathya | Powered by: