Sql a vyjimka – .NET – Fórum – Programujte.com

Ahoj sem se zkousel pripojit k databzi kde sem dal nejakou vyjimku, kde mam potom umistit finaly pro uzavreni spojeni

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;



namespace ConsoleApplication1

{

    class Program

    {

        static void Main(string[] args)

        {





            string source = @"Data Source = .\SQLEXPRESS;AttachDbFilename = |DataDirectory|\Database1.mdf;Integrated Security = True;User Instance = True";

            string select = "SELECT Prace,Jmeno FROM tblKontakty";

            

            SqlConnection sql = new SqlConnection(source);

            try

            {



                sql.Open();

            }

            catch (SqlException e)

            {

                Console.WriteLine(e.Message);

            }

            finally

            {

                sql.Close();

            }

            SqlCommand cmd = new SqlCommand(select, sql);

            SqlDataReader reader = null;

          

            try

            {



                reader = cmd.ExecuteReader();

            }

            catch (SqlException e)

            {

                Console.WriteLine(e.Message);

            }

            while (reader.Read())

            {

                Console.WriteLine("Prace: {0} Jmeno: {1}",reader[0],reader[1]);



            }

          

        }

    }

}

supr.. jen ted nevim jestli se chlubis ci o co se snazis...

To KIIV : ne bohužel se nechlubim jen se ptam kde mam umistit ten blok finaly ktery sem už tam omylem nechal aby se v pripade vyjimky uzavrel tu databazi protoze kdyz je to na tom miste kde tedkom tak se to uzavře i kdyžse vyjimka nevyvola

technicky vzato bys mohl cely kod pro praci s databazi dat do try...
a ve finally uvolnit zabrane zdroje .. tedy pokud neselze uz "SqlConnection sql = new SqlConnection(source);", ktery mas ted mimo

ale abych te nenapinal:

Listing 7.8: Try-Finally Syntax



            try

            {

                //Even if a goto statement were here

                //control gets transferred to the statement identified in

                //goto statement only after executing the finally block.

            }



            finally

            {

                // This block of code will always get executed

                // whether an exception occurs or not

                // Any cleanup code goes here,

                // especially to release any system resources

                // such as file handles and network connections

            }

V podstatě si to měl dobře, jen to vlož do jednoho try bloku, něco jako:

try

{

	sql.Open();



	cmd = new SqlCommand(select, sql);



	reader = cmd.ExecuteReader();



	// ... atd.

}

catch (SqlException e)

{

	Console.WriteLine(e.Message);

}

finally

{

	sql.Close();

}

To liborb : diky vsem