Cannot view Master Database Names on Webpage | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cannot view Master Database Names on Webpage

I have a webpage that displays the database names from the master database. The code for the stored procedure works fine in Query Analyzer. The code: select name from master.dbo.sysdatabases
order by 1 doesn’t return the database name to the ASP.NET webpage. It returns: System.Data.DataRowView Why does it do this and how can I fix it? Tx
As you said it runs fine in QA then create SP for this and then call SP through ASP.net and check. I guess there must be some bug in your code in ASP.Net
]]>