On Fri, 15 Jul 2005 10:13:31 +0700
"Dedy" <[EMAIL PROTECTED]> wrote:
> bung rival kalo pada event keyup bagaimana ya contoh di
>MsFlexgrid
>
> Private Sub txtCari_KeyUp(KeyCode As Integer, Shift As
>Integer)
> ......?
> End Sub
>
> kalo pake Adodc kan coding seperti ini..
>
> Private Sub txtCari_KeyUp(KeyCode As Integer, Shift As
>Integer)
> Adodc1.RecordSource = "select * from namaTabel where
>Field like '" & txtCari.Text & "%'"
> Adodc1.Refresh
> End Sub
>
> thanx
=My Reply=
Hmm...tambahan dikit, kalo butuh kecepatan boleh pake
method filter dari adodcnya.Jadi, dari record yg sudah di
select dari database sebelumnya, tinggal filter data yg
diinginkan, itu lebih cepat dibandingkan menselect ulang
dari database. ^^
codingnya kira2 seperti ini:
> Private Sub txtCari_KeyUp(KeyCode As Integer, Shift As
>Integer)
> Adodc1.RecordSset.Filter = "NamaField like '" & txtCari.Text & "%'"
> End Sub
BTW, koq bikinnya di event KeyUp? Bukannya bisa di event
Change?
Oh io, utk menghilangkan filter, isi saja .filter dgn
string kosong.
--
^_^ The Doctor ^_^
-----------------------
{M-4=>Magnificent Four}
========================================================================================
Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah Jawa
Timur.
Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN
(467826)
========================================================================================
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
