[asemshahen5]

PHP كود :

            try
           {
               dataGridView1.Refresh();
               // البحث
               OleDbDataAdapter da = new OleDbDataAdapter("select * from issam where XDATE Between @sd And @sf AND XNAME LIKE @xg ", con);
               da.SelectCommand.Parameters.AddWithValue("@sd", dateTimePicker2.Value.ToString("dd/MM/yyyy"));
               da.SelectCommand.Parameters.AddWithValue("@sf", dateTimePicker3.Value.ToString("dd/MM/yyyy"));
               da.SelectCommand.Parameters.AddWithValue("@xg", "%"+textBox6.Text+"%");
               DataTable dt = new DataTable();
               da.Fill(dt);
               dataGridView1.DataSource = dt;
           
           }
           catch (Exception ex)
           {
               MessageBox.Show(ex.Message);
               // con.Close();
           }