Cemana ndak buat table kat database dr VB.NET?

[sager 0]

Assalamm....saya ndak bukak table baru dlm database menggunakan VB.NET dan ODBC.tetapi buat masa ni code dia x work.So, sy mintak panduan dan nasihat drpd user yg berpengalaman semua utk menambah baik code saya ini.Saya tertannya kenapa x nampak table baru dalam database postgresql?


Imports System
Imports System.Data
Imports System.Data.Odbc



Public Class Form1

Dim thisConnection As New OdbcConnection _
("dsn=MyOdbc")
Dim nonqueryCommand As OdbcCommand = thisConnection.CreateCommand()

Public sConnection As String = "DSN=PostgreSQL30;UID=tele;PWD=tiny;"
Public cnDB As New Odbc.OdbcConnection(sConnection)

Public dsDB As New DataSet
Public adDB As New Odbc.OdbcDataAdapter


Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles Button1.Click
nonqueryCommand.CommandText = "CREATE TABLE mytable " & _
"(MyName VARCHAR (30), MyNumber INTEGER)"
'Console.WriteLine("Executing {0}", _
' nonqueryCommand.CommandText)
'Console.WriteLine("Number of rows affected : {0}", _
' nonqueryCommand.ExecuteNonQuery())
Try
cnDB.Open()
'adDB.SelectCommand = New Odbc.OdbcCommand(" CREATE TABLE sensor_result_test ")

MsgBox("Connect to Database", MsgBoxStyle.Information, "Success")
cnDB.Close()
Catch ex As Exception
MsgBox("Connection to database Failed", MsgBoxStyle.Critical, "Action Failed")
End Try


End Sub

End Class



fail dia.

http://rapidshare.com/files/268975860/BuiltNewtables1.rar.html


sekian terima kasih.

[DevGuy_1 0]

oo. ok
apasal guna odbc.odbc ni kira dah 2nd layer dah
cuba guna .net provider utk postgresql. cuba masuk sini and dload http://npgsql.projects.postgresql.org/

ok saya dah tgk and tgh ubah sikit
tapi saya guna .net data provider.
kasi email nanti aku send balik kat ko.
ok

[sager 0]

ezalampunk at gmail.com.tq. abang.sy ada try gak npgsql tp xjd.huhu....

[DevGuy_1 0]

ok aku dah send dah
cuba ko try tgk and run
ok adiosaaa

[DevGuy_1 0]

tipu aaa email tak leh pun reject apadaaa
betul ker email ni [email protected]

[sager 0]

[email protected] betul beb.atau antar je kat eza17 at yahoo.com.tq.

[sager 0]

x reti ndak guna npgsql nih.sy ndak guna dlm vb.net jer.minta tunjuk ajar... thanks

[DevGuy_1 0]

aku dah buatkan dahh
email mana satu nii
ko nyerr asyik bound back jerrr

[DevGuy_1 0]

lg satu apasal la ko guna postgreesql
guna sql server sudahh express edition jerrr

[sager 0]

mana2 email pun boleh incik.hmmm.... antar aja ke eza17 at yahoo.com.Erk, saya ndak try postgresql aja incik.