SqlConnection

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

namespace Challenge
{
    public partial class Klienti : Form
    {
        public Klienti()
        {
            InitializeComponent();
        }
        public static SqlConnection CreateConnection()
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = @"Data Source=PETIOFI-PC;Initial Catalog=Team2DB;Integrated Security=True";
            return con;
        }
        private void button4_Click(object sender, EventArgs e)
        {

            SqlConnection con = CreateConnection();
            using (con)
            {
                SqlCommand myCommand = new SqlCommand("StoredProcedure1", con);
                myCommand.CommandType = CommandType.StoredProcedure;
                myCommand.CommandText = "StoredProcedure1";

                SqlParameter ZastrID = new SqlParameter("@INS_COMPANY_ID", SqlDbType.Int);
                ZastrID.Value = dgViewSearchClients.CurrentRow.Cells[0].Value;
                myCommand.Parameters.Add(ZastrID);

                SqlParameter Name = new SqlParameter("@INS_COMPANY_NAME", SqlDbType.NVarChar);
                Name.Value = dgViewSearchClients.CurrentRow.Cells[1].Value;
                myCommand.Parameters.Add(Name);

                SqlParameter Bulstat = new SqlParameter("@INS_COMPANY_BULSTAT", SqlDbType.NVarChar);
                Bulstat.Value = dgViewSearchClients.CurrentRow.Cells[2].Value;
                myCommand.Parameters.Add(Bulstat);

                try
                {
                    con.Open();
                    myCommand.ExecuteNonQuery();
                    MessageBox.Show("Успешно свързване!");
                }
                catch (SqlException se)
                {
                    MessageBox.Show(se.ToString());
                }
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {

        }
        //dobavi
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = CreateConnection();
            using (con)
            {
                //while (i() == false)
                {
                    return;
                }
                try
                {
                    SqlCommand cmd = con.CreateCommand();
                    cmd.CommandText = "EXECUTE spInsertNewCompany @INS_COMPANY_ID, @INS_COMPANY_NAME, @INS_COMPANY_BULSTAT, @INS_COMPANY_ADDR, @INS_COMPANY_CONTACT, @INS_COMPANY_TEL";
                    cmd.Parameters.Add("@CLIENT_TYPE", SqlDbType.Int).Value = cmBoxClientsType.Text;
                    cmd.Parameters.Add("@CLIENT_EGN_BULSTAT", SqlDbType.NVarChar, 100).Value = txtBoxClientsClientID.Text;
                    cmd.Parameters.Add("@ADRESS_TEXT", SqlDbType.NVarChar, 400).Value = txtBoxClientsAdres.Text;
                    cmd.Parameters.Add("@INS_COMPANY_CONTACT", SqlDbType.NVarChar, 400).Value = txtBoxClientsClientName.Text;
                    cmd.Parameters.Add("@TELEPHONE", SqlDbType.NVarChar, 100).Value = txtBoxClientsCity.Text;
                    cmd.Parameters.Add("@EMAIL", SqlDbType.NVarChar, 100).Value = txtBoxClientsEmail.Text;
                    con.Open();
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Добавена е нова застрахователна компания.");
                }
                catch (SqlException)
                {
                    MessageBox.Show("Вече има застраховател с такъв код или наименование!");
                }
                finally
                {
                    con.Close();
                }
            }
        }
    }
}