"WenYuan Wang [MSFT]" wrote:

> Hi Dave,
>
> Could you please past some code snippet in newsgroup? I'm not sure how did
> you get the DbDataReader and which provider are you using. I have test with
> SQLDataReader on my side. However, SQLDataReadder.GetName() method will
> return column name, even though there is no row returned by
> SQLCommand.execute() method. Would you please provide some detailed
> information.
> Below is my test code:
>
> SqlConnection sc = new SqlConnection();
> sc.ConnectionString = @"Data Source=sha-dng-wywang;Initial
> Catalog=AdventureWorks;Integrated Security=True";
> SqlCommand scd = new SqlCommand();
> scd.CommandText = "select * from DataBaseLog where databaselogid=100000";
> scd.Connection = sc;
> sc.Open();
> SqlDataReader sdr=scd.ExecuteReader();
> string columnName=sdr.GetName(0);
> sc.Close();
> Console.WriteLine(columnName);
>
> Have a great day.
> Sincerely,
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
>
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>