SearchClient.cs

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

namespace FINAL
{
    public partial class SearchClients : Form
    {
        public SearchClients()
        {
            InitializeComponent();
        }
        public static SqlConnection CreateConnection()
        {
            SqlConnection con = CreateConnection();
            con.ConnectionString = @"Data Source=HRISI-PC;Initial Catalog=VP_CREDITS_Final;Integrated Security=True";
            return con;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            comboBox1.SelectedItem = -1;
            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                SqlConnection con = new SqlConnection(@"Data Source=HRISI-PC;Initial Catalog=VP_CREDITS_Final;Integrated Security=True");
                SqlDataAdapter sda = new SqlDataAdapter("SELECT CLIENT_ID, CLIENT_TYPE, CLIENT_EGN_BULSTAT, CLIENT_FULLNAME, EMAIL, TELEPHONE, ADDRESS, CLIENT_NOTE, MODIF_DATE FROM CLIENTS WHERE CLIENT_EGN_BULSTAT like '" + textBox1.Text + "%' ", con);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                dataGridView1.DataSource = dt;

            }
            else if (textBox2.Text != "")
            {
                SqlConnection con = new SqlConnection(@"Data Source=HRISI-PC;Initial Catalog=VP_CREDITS_Final;Integrated Security=True");
                SqlDataAdapter sda = new SqlDataAdapter("SELECT CLIENT_ID, CLIENT_TYPE, CLIENT_EGN_BULSTAT, CLIENT_FULLNAME, EMAIL, TELEPHONE, ADDRESS, CLIENT_NOTE, MODIF_DATE FROM CLIENTS WHERE CLIENT_ID like '" + textBox2.Text + "%' ", con);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                dataGridView1.DataSource = dt;
            }
            else if (textBox3.Text != "")
            {
                SqlConnection con = new SqlConnection(@"Data Source=HRISI-PC;Initial Catalog=VP_CREDITS_Final;Integrated Security=True");
                SqlDataAdapter sda = new SqlDataAdapter("SELECT CLIENT_ID, CLIENT_TYPE, CLIENT_EGN_BULSTAT, CLIENT_FULLNAME, EMAIL, TELEPHONE, ADDRESS, CLIENT_NOTE, MODIF_DATE FROM CLIENTS WHERE CLIENT_FULLNAME like '" + textBox3.Text + "%' ", con);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                dataGridView1.DataSource = dt;
            }
            else if (textBox4.Text != "")
            {
                SqlConnection con = new SqlConnection(@"Data Source=HRISI-PC;Initial Catalog=VP_CREDITS_Final;Integrated Security=True");
                SqlDataAdapter sda = new SqlDataAdapter("SELECT CLIENT_ID, CLIENT_TYPE, CLIENT_EGN_BULSTAT, CLIENT_FULLNAME, EMAIL, TELEPHONE, ADDRESS, CLIENT_NOTE, MODIF_DATE FROM CLIENTS WHERE EMAIL like '" + textBox4.Text + "%' ", con);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                dataGridView1.DataSource = dt;
            }
            else
            {
                MessageBox.Show("Моля, задайте парааметри за търсене!");
            }
        }

        private void SearchClients_Load(object sender, EventArgs e)
        {

        }
    }
}