علی فتحی
شنبه 03 اسفند 1392, 23:25 عصر
سلام من برای جستجو در ئیتاگرید این کدو نوشتم ولی بازدن کل دیتاگرید خالی میشه .
public void serch()
{
OleDbConnection scn = new OleDbConnection();
OleDbCommand scm = new OleDbCommand();
OleDbDataAdapter sda = new OleDbDataAdapter();;
DataSet ds = new DataSet();
scn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DATA.ACCDB;";
sda.SelectCommand = new OleDbCommand();
sda.SelectCommand.Connection = scn;
sda.SelectCommand.CommandText = "select * from Table2 where family LIKE " + textBoxX11.Text + "";
sda.Fill(ds, "Table2");
dataGridViewX1.DataSource = ds;
public void serch()
{
OleDbConnection scn = new OleDbConnection();
OleDbCommand scm = new OleDbCommand();
OleDbDataAdapter sda = new OleDbDataAdapter();;
DataSet ds = new DataSet();
scn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DATA.ACCDB;";
sda.SelectCommand = new OleDbCommand();
sda.SelectCommand.Connection = scn;
sda.SelectCommand.CommandText = "select * from Table2 where family LIKE " + textBoxX11.Text + "";
sda.Fill(ds, "Table2");
dataGridViewX1.DataSource = ds;