mas andreas makasih yah....!!!!!!!!!!!!!!!


----- Original Message ----
From: andreas sulistiyo <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, February 6, 2007 4:11:29 PM
Subject: Re: [indoprog-vb] sort data dari VB

sql command, yang penting dah connect database, jadi gini sql commandnya:
'----------- --------- -
'disini buat connection db....
dim cmd as ADODB.Command
dim nama as string
nama =Trim(combo1. Text)
cmd.CommandText = "select * from datasiswa order by " & nama
cmd.execute 
'----------- --------- --
klo mo Decending

cmd.CommandText = "select * from datasiswa order by " & nama & " DESC"


by Andreas Sulistiyo



<fahrul_1983@ yahoo.com> wrote:
motanya donk ....

saya punya data base dengan access
saya ingin mensort data yang digunakan pada combobox berdasarkan abjad 

contoh 
adi 
budi 
cinta
deden

gmana caranya yah.....?

terimakasih

____________ _________ _________ _________ _________ _________ _
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers. yahoo.com

[Non-text portions of this message have been removed]

------------ --------- --------- ---
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.

[Non-text portions of this message have been removed]





 
____________________________________________________________________________________
Looking for earth-friendly autos? 
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
http://autos.yahoo.com/green_center/

[Non-text portions of this message have been removed]

Kirim email ke