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