'pake logika ini aja
dim oConn as new ADODB.Connection
oConn.Open "Provider=SQLOLEDB.1;Password=;Persist Security Info=True;User
ID=saya;Initial Catalog=nama_db;Data Source=."
For iBrs = 1 To grd.Rows
For icol = 0 To grd.Cols
x = grd.TextMatrix(iBrs, icol)
s = s & x & ","
Next
'jadikan perintah sql
sql = "INSERT INTO TABLE VALUES('"
sql = sql & s
'hilangkan tanda , terakhir
sql = left(sql,len(sql)-1)
sql = sql & ")"
oconn.execute sql
Next
nb: asumsinya pake mshflexgrid ato vsflexgrid
------------------------------------------------
* Integrated Software Solution - XBasicPro
website: http://www.xbasicpro.com
________________________________
Dari: beben <[email protected]>
Kepada: [email protected]
Terkirim: Ming, 2 Mei, 2010 15:32:39
Judul: [programmer-vb] save row datagrid ke tabel
Dear Senior
adakah contoh / link
untuk
save semua row yang
tampil di sebuah datagrid atau list view ke tabel tertentu ?
trimakasih
sebelumnya
bbn
