search form_number in datagridview through textbox

Question

i am success in searching name in datagridview using query..

but not idea for serching number in datagridview

i want to search form_number in datagridview

can any one give me that query pattern

in that LIKE operator is not working.....

Abhijit Patil · Answer

hey asmita, can you elobrate your question please .then we understand what exazactly you want .then we provide correct solution. hope you understand

asmita patil · Answer

following is my code.. private void txt_frm_filter_value_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (cmb_frm_filter_search_type.SelectedItem.Equals("Form no.")) { BindingSource bs = new BindingSource(); bs.DataSource = dgv_emp_search.DataSource; bs.Filter = dgv_emp_search.Columns[0].HeaderText + "Like " + Convert.ToInt32(txt_frm_filter_value.Text) + " "; //bs.Filter = dgv_emp_search.Columns[0].HeaderText = Convert.ToUInt64(txt_frm_filter_value.Text); // if (dgv_emp_search.Columns[0].Equals(searchValue)) //bs.Filter = dgv_emp_search.Columns[0].HeaderText.ToString() + " LIKE '%" + Convert.ToInt32(txt_frm_filter_value.Text) + "%'"; dgv_emp_search.DataSource = bs; //valueResulet = false; } else if (cmb_frm_filter_search_type.SelectedItem.Equals("First name ")) { BindingSource bs = new BindingSource(); bs.DataSource = dgv_emp_search.DataSource; bs.Filter = dgv_emp_search.Columns[1].HeaderText.ToString() + " LIKE '%" + txt_frm_filter_value.Text + "%'"; dgv_emp_search.DataSource = bs; } } } txt_frm_filter_value is the name of textbox cmb_frm_filter_search_type is name of combobox where we can select a search type like first name, last name, and form number now my problem is : in my datagridview lots of record will be come from different tables , that is employee form number wise... so i want to search directly form number in datagridview.. i cant search form number in datagridview.. my query is not set valid.... if you again not understand then ask me please.. thank you

search form_number in datagridview through textbox

Answers (2)