当前位置: 首页>>代码示例>>C#>>正文


C# SqlException.LineNumber属性代码示例

本文整理汇总了C#中System.Data.SqlClient.SqlException.LineNumber属性的典型用法代码示例。如果您正苦于以下问题:C# SqlException.LineNumber属性的具体用法?C# SqlException.LineNumber怎么用?C# SqlException.LineNumber使用的例子?那么恭喜您, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在System.Data.SqlClient.SqlException的用法示例。


在下文中一共展示了SqlException.LineNumber属性的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: Main

//引入命名空间
using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;

class Program
{
    static void Main()
    {
        string s = GetConnectionString();
        ShowSqlException(s);
        Console.ReadLine();
    }

    public static void ShowSqlException(string connectionString)
    {
        string queryString = "EXECUTE NonExistantStoredProcedure";
        StringBuilder errorMessages = new StringBuilder();
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(queryString, connection);
            try
            {
                command.Connection.Open();
                command.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                for (int i = 0; i < ex.Errors.Count; i++)
                {
                    errorMessages.Append("Index #" + i + "\n" +
                        "Message: " + ex.Errors[i].Message + "\n" +
                        "Error Number: " + ex.Errors[i].Number + "\n" +
                        "LineNumber: " + ex.Errors[i].LineNumber + "\n" +
                        "Source: " + ex.Errors[i].Source + "\n" +
                        "Procedure: " + ex.Errors[i].Procedure + "\n");
                }
                Console.WriteLine(errorMessages.ToString());
            }
        }
    }

    static private string GetConnectionString()
    {
        // To avoid storing the connection string in your code, 
        // you can retrieve it from a configuration file.
        return "Data Source=(local);Initial Catalog=AdventureWorks;"
            + "Integrated Security=SSPI";
    }
}
开发者ID:.NET开发者,项目名称:System.Data.SqlClient,代码行数:52,代码来源:SqlException.LineNumber

示例2: Main

//引入命名空间
using System;
using System.Data;
using System.Data.SqlClient;

class MainClass
{
   static void Main()
   {
         SqlConnection conn = new SqlConnection(@"data source = .\sqlexpress;integrated security = true;database = northwind");

         SqlCommand cmd = conn.CreateCommand();

         cmd.CommandType = CommandType.StoredProcedure;
         cmd.CommandText = "sp_DbException_1";

         try
         {
            conn.Open();
            cmd.ExecuteNonQuery();
         }
         catch (System.Data.SqlClient.SqlException ex)
         {
            Console.WriteLine("Source: " + ex.Source);
            Console.WriteLine("Number: "+ ex.Number.ToString());
            Console.WriteLine("Message: "+ ex.Message);
            Console.WriteLine("Class: "+ ex.Class.ToString ());
            Console.WriteLine("Procedure: "+ ex.Procedure.ToString());
            Console.WriteLine("Line Number: "+ex.LineNumber.ToString());
            Console.WriteLine("Server: "+ ex.Server.ToString());

         }
         catch (System.Exception ex)
         {
            Console.WriteLine("Source: " + ex.Source);
            Console.WriteLine("Exception Message: " + ex.Message);
         }
         finally
         {
            if (conn.State == ConnectionState.Open)
            {
               Console.WriteLine("Finally block closing the connection");
               conn.Close();
            }
         }
   }
}
开发者ID:C#程序员,项目名称:System.Data.SqlClient,代码行数:47,代码来源:SqlException.LineNumber


注:本文中的System.Data.SqlClient.SqlException.LineNumber属性示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。