Re: [Programmer-VB]Click datagrid

Mon, 29 May 2006 18:39:07 -0700

saya coba bantu ya.
gimana memunculkan data di textbox yg di click di datagrid
Private Sub DataGrid1_Click()
      Text1.text =  DataGrid.Text
End Sub
 
gimana cara mensortir data yg ada di databse berdasarkan row cursor di datagrid
rs.Open "select * from barang where kodebarang = '"&  DataGrid1.text &"' ", cn, adOpenKeyset, adLockOptimistic
untuk lebih jelasnya mending mas googling aja dengan keyword : datagrid,vb
 
 
Semoga membantu
 
Salam,
Padu Arsana iW
 

Hasan Fajar <[EMAIL PROTECTED]> wrote:
maaf saya ingin nanya, gimana memunculkan data di textbox yg di click di datagrid dimana data yg ada di datagridnya di dapat dari database.
permasalahannya gimana cara mensortir data yg ada di databse berdasarkan row cursor di datagrid.
 
ini contoh program yg saya buat :
Private Sub DataGrid1_Click()
dim posisicursor as integer 
posisiscursor = DataGrid1.Row
DataGrid1.ShowWhatsThis
koneksi
rs.Open "select * from barang", cn, adOpenKeyset, adLockOptimistic
If rs.EOF Then
    MsgBox "Data not found", vbInformation, App.Title
Else
    DataGrid1.ShowWhatsThis
    posisicursor = DataGrid1.Row
    Text1 = rs("kodebarang")
    Text2 = rs("namabarang")
    Text3 = rs("jenisbarang")
    Text5 = rs("total")
    Text4.Enabled = True
    Command1.Enabled = True
    Text4.SetFocus
End If
DataGrid1.ReBind
End Sub
 
mohon pencerahan dari teman2.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

Ring'em or ping'em. Make PC-to-phone calls as low as 1ยข/min with Yahoo! Messenger with Voice.

Wahana Programmer Groups Links

<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
    http://wahanaprogrammer.net

<*> Untuk menghubungi owner milis ini, kirim email ke:
    [EMAIL PROTECTED]

<*> Konsultasi pemrogramman bisa chat disini:
    Yahoo! Messenger: wahanaprogrammer



SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



Kirim email ke