Tuesday, 1 November 2016

SearchBox Text Changed Event

private void txt_Search_TextChanged(object sender, EventArgs e)
        {
            dgv_search.Rows.Clear();
            string aq = "SELECT [Name],[Description],[Date] FROM [City] where Name like '%" + txt_Search.Text + "%'";
            DataTable dt = qc.DataReaderTable(aq);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dgv_search.Rows.Add();
                dgv_search.Rows[i].Cells[0].Value = Convert.ToString(dt.Rows[i]["Name"]);
                dgv_search.Rows[i].Cells[1].Value = Convert.ToString(dt.Rows[i]["Description"]);
                dgv_search.Rows[i].Cells[2].Value = Convert.ToDateTime(dt.Rows[i]["Date"]);
            }
        }

No comments:

Post a Comment