ganti aja nama tabelnya dg nama viewnya, karena dlm sql query, kita bisa melakukan query ke sebuah view dg cara yg sama ke sebuah tabel.
atau dalam kata lain, view akan dianggap seperti layaknya sebuah tabel.
.CommandText = "select * from ViewMyData" ' View My Data
best regards
[wwn]
On 2/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Ass.Wr.Wb
Para VB mania , bagaimana cara coding connection ke View di Sql server ?
Di bawah ini sample connection yang ke Tabel , bagian mana yang saya harus rubah ...
makasih ...semua...
Set conpib = New Connection
Set rstpib = New Recordset
Set compib = New Command
rstpib.CursorLocation = adUseServer
rstpib.LockType = adLockOptimistic
rstpib.CursorType = adOpenDynamic
With conpib
.Provider = "SQLOLEDB"
.ConnectionString = "User ID=sa;Password=sql;Persist Security Info=True;Initial Catalog=DATABASEKU;Data Source=SQL"
.Open
End With
With compib
.ActiveConnection = conpib
.CommandText = "select * from MyData" ' tabel My Data
.Execute
End With
Abu Ibadurrahman Ja'far Al Jauziyah
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
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
