programerinfonet
چهارشنبه 29 شهریور 1391, 12:00 عصر
DataSet ds = new DataSet();
OleDbCommand com = new OleDbCommand();
if (cmsearch.SelectedIndex == 1)
{
com.CommandText = "select * from contact where( id LIKE '" + txsearch.Text + "')";
}
else
if (cmsearch.SelectedIndex == 2)
{
com.CommandText = "select * from contact where( groupname LIKE '" + txsearch.Text + "')";
}
OleDbDataAdapter da = new OleDbDataAdapter(com);
da.Fill(ds);
dgv.DataSource = ds.Tables[0];
dgv.Refresh();
OleDbCommand com = new OleDbCommand();
if (cmsearch.SelectedIndex == 1)
{
com.CommandText = "select * from contact where( id LIKE '" + txsearch.Text + "')";
}
else
if (cmsearch.SelectedIndex == 2)
{
com.CommandText = "select * from contact where( groupname LIKE '" + txsearch.Text + "')";
}
OleDbDataAdapter da = new OleDbDataAdapter(com);
da.Fill(ds);
dgv.DataSource = ds.Tables[0];
dgv.Refresh();