- Messages
- 1,097
- Reaction score
- 0
- Points
- 26
baka database ang inopen mo. my vb.net kaba mga 2010 para ma convert xa kung lower version ginamit?
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
baka database ang inopen mo. my vb.net kaba mga 2010 para ma convert xa kung lower version ginamit?
Mga sir,tanung lng,pwde po ba kyung makagawa ng application sa smrtph0ne using vb.net?tnx
Mga sir patulong naman. .
panu po gamitin ang Catch ex as Exception sa Try?
salamat po. .
try
'code here
catch ex as exception 'research on other exceptions(eg. sqlexception etc.)
'option to show message or not
msgbox(ex.message)
end try
magandang hapon mga masters in programming...
newbie lang ako sa thread...instructor ako sa isang college
vb6 kasi ang napag-aralan ko nong college, this coming sem nabigay saking subject is computer programming 6, vb.net yun at ang software na gamit ay vs2008.
baka meron po kayong link na pede ma-download e-book tungkol dito...mejo nangangapa ako sa vb2008 at self study tlga...pionagaaralan ko is pag-connect sa database, access or mysql.
Sir polens slamat po,.
sir tanung lng po aq ulit panu po iupdate ung naedit n narecord?.
un nlang po kxe kulang sa gnagwa q eh..thankz po in advance.
UPDATE TABLE SET COL1=@value1,COL2=@value2 . . . . WHERE COL0=@Value0
magandang hapon mga masters in programming...
newbie lang ako sa thread...instructor ako sa isang college
vb6 kasi ang napag-aralan ko nong college, this coming sem nabigay saking subject is computer programming 6, vb.net yun at ang software na gamit ay vs2008.
baka meron po kayong link na pede ma-download e-book tungkol dito...mejo nangangapa ako sa vb2008 at self study tlga...pionagaaralan ko is pag-connect sa database, access or mysql.
.sir polens ung po bng syntax eh ganito: UPDATE [database table name] SET [database field name] = [@value'pero diko alam f anu to] WHERE [database field name] = [@value'diko nan alam f anu to]
patulong naman owh.
dim sqlString as string
sqlString="UPDATE TABLE SET Col1=@val1,col2=@val2. . . WHERE Col0=@val0"
dim com as new SqlCommand
com.commandtext=sqlString
'dito na ipapass ung value
com.parameters.addwithvalue("@val1",textbox1.text)
com.parameters.addwithvalue("@val2",textbox2.text)
com.parameters.addwithvalue("@val0",textbox0.text)
UPDATE TABLE SET PRODUCT=@prdct ,QTY=@qty WHERE ID=@id
.sir polens salamat po.hehe.ngwa q na po,sir wat if iche2ck q naman qng mei duplicate entry?halimbwa magme2sage aq ng Record already exist..
SELECT COUNT(*) FROM TABLE WHERE dupItem=@dupItem
dim x as integer=com.executeScalar
if x > 0 then
'message duplicate
end if
Mg Master,
Patulong po sana sa SQL.
SELECT * FROM TABLE1, TABLE2
Pwd pa explain po?
Parang inner join po ba ito?
ang inner join ay kung may "Matching" Columns or Fields... karaniwang merong PRIMARY KEY at sa isang TABLE ay may FOREIGN KEY... Basta ang keyword eh "Matching Fields"
sa binigay mong example kinuha mo lng lahat ng rows ng dalawang tables na walang related field...