Search data in database and Filter in datagridview or table in C# (Proje...

Aslam-u-Alikuum Beautiful People

void FillDataGridView()

        {

            if (sqlCon.State == ConnectionState.Closed)

                sqlCon.Open();

            SqlDataAdapter SqlDA = new SqlDataAdapter("[dbo].[CVSsearch]", sqlCon);

            SqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;

            SqlDA.SelectCommand.Parameters.AddWithValue("@CName", textBox5.Text.Trim());

            DataTable dtbl = new DataTable();

            SqlDA.Fill(dtbl);

            dataGridView1.DataSource = dtbl;

            dataGridView1.Columns[0].Visible = false;

            sqlCon.Close();

        }

        private void button4_Click(object sender, EventArgs e)

        {

            try

            {

                FillDataGridView();

            }

            catch (Exception ex)

            {

SQL Code:

CREATE PROCEDURE [dbo].[CVSsearch]

@CName nvarchar(50)

As

select * from [dbo].[Company Name]

Where CName like @CName+'%'