Nak Select Dari Database

[Zamri Tumidi 0]

samekom rakan2,nk mitak tlong skit saper yg expert....cam ner nak select data dari database yer......aku guna asp.net 2003...tlong yer

[napsa 0]

samekom rakan2,nk mitak tlong skit saper yg expert....cam ner nak select data dari database yer......aku guna asp.net 2003...tlong yer

Hi,

hang kenalah ada connection string kat web.config file.

Macam ini di web.config kat appsetting tag, codelah macam ini,

<add key="AnyUniquekey" value="data source=(local)\databaseInstance;initial catalog=DatabaseName;integrated security = SSPI; persist security info=True;packet size=4096"/>

lepas tu, buat klas untuk guna that "AnyUniquekey". Lepas tu, barulah boleh guna select statement.

[Zamri Tumidi 0]

yg connection string tu aku da wat dah bro....cume skng ni select statement tak leh wat....ada tak coding nak wat select statement tue?

[Rapla 0]

Select statement mcmnih ke? :-

SELECT * FROM namadatabase where id = 0 and name = "contoh"

[ron 0]

Select statement mcmnih ke? :-

SELECT * FROM namadatabase where id = 0 and name = "contoh"

Salah tu, camni

SELECT * FROM NamaTable WHERE Id = 0 AND Name = 'contoh'

[Zamri Tumidi 0]

tengkiu bro...aku cube coding tue....nanti pehal aku infom blik

[coisox 0]

Akhirnya, setelah berhari-hari aku Google, berjaya gak aku implement SQL with variable. Thank you ron.

Yg aku heran, apasal banyak sangat version cara nak SQL kat Google? Pehtu bukan semua sesuai. Actually, kalau pakai database MS Access vs. jenis lain, SQL dia lain ke?

Nie yg aku dah buat mengikut kata Google tapi tak jadi:

FYI, aku pakai VB.net 2008, ADO.net, MS Access

Dim myVar as string = "testing"

Cubaan 1:

dataAdapter = New OleDb.OleDbDataAdapter("SELECT * From table1 WHERE jenis = '@myVar' ", cnADONetConnection)

Cubaan 2 dan seterusnya:

WHERE jenis = '"myVar"'

WHERE jenis = '%"myVar"%'

WHERE (jenis = " & myVar & ")

WHERE jenis LIKE 'myVar%'

Dan macam2 lagi version yg aku dah confuse dan tak ingat mana yg pernah try mana yg blum

Oh, ada satu lagi soalan, ada ke statement yg membolehkan kita select from table1 di mana field tertentu punya value yang takde kat table2 punya senarai?

"SELECT * From table1 WHERE jenis NOT AVAILABLE IN table2.jenis "

[sworn 0]

"SELECT * From table1 WHERE jenis NOT AVAILABLE IN table2.jenis "

=

"SELECT * From table1 WHERE (jenis NOT IN (SELECT jenis From table2))

[coisox 0]

oooo boleh main campur camtu je ke... ok thank you.