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.....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
asmita patilPosted Feb 4, 2015, 1:36 AM
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
Abhijit PatilPosted Feb 4, 2015, 12:52 AM
can you elobrate your question please .then we understand what exazactly you want .then we provide correct solution.
hope you understand