DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Fri, 17 Aug 2007 15:07:38 +1000,    posted on: microsoft.public.dotnet.framework.adonet        back       

Thread Index
  1    Stephen Ahn no_address


SqlConnection.InfoMessage - SqlError.Class wrong value ?   
Hi,

Using VS2005, SQL Server 2005.

The SqlError.Class property always seems to be 0 when retrieving 
informational messages via the SqlConnection.InfoMessage event. Sample code 
to reproduce :

==
        private void button1_Click(object sender, EventArgs e)
        {
            string yourConnString = // your connection string here


            using (SqlConnection conn = new SqlConnection(yourConnString))
            {
                conn.Open();
                conn.InfoMessage += new 
SqlInfoMessageEventHandler(OnInfoMessage);
                string sql = "raiserror('done', 10, 127)";
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
            }

        }

        protected void OnInfoMessage(
          object sender, SqlInfoMessageEventArgs args)
        {
            foreach (SqlError err in args.Errors)
            {
                MessageBox.Show("Class  " + err.Class + ", State " + 
err.State);
            }
        }
==

The message box displays :  "Class 0, State 127".  I'm expecting to get 10 
as the value of Class. Can anyone shed any ideas into this ?

TIA,
Stephen
Date:Fri, 17 Aug 2007 15:07:38 +1000   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us