VB.NET Programming Corner!

[Asaman83687]

Oops. Na'miss look ko yung AppID sa taas. remove mo nlng yun

xSql = "UPDATE FirstSemester SET "
xSql = xSql + "Fname = '" & txtFname.Text & "', " 
xSql = xSql + "Mname = '" & txtMname.Text & "', " 
xSql = xSql + "Lname = '" & txtLname.Text & "' " 
xSql = xSql + "WHERE AppID = " & txtID.Text

 

[jake_lyson]

mga sir pahelp naman po itong code q sa update sa tingin q po kxe tama eh..

Dim xSql as String
Dim cnn As New OleDbConnection(ConnectionString)
cnn.Open

xSql = "UPDATE FirstSemester SET"
xSql = xSql + " AppID = ' " & txtID.Text & "',"
xSql = xSql + " Fname = ' " & txtFname.Text & "',"
xSql = xSql + " Mname = ' " & txtMname.Text & "',"
xSql = xSql + " Lname = ' " & txtLname.Text & " ' "
xSql = xSql + " WHERE AppID = ' " & txtID.Text & " ' "

Dim cmd as new oledbCommand(xSql,cnn)
cmd.executeNonQuery()

"SYNTAX ERROR IN UPDATE COMMAND" yan po ung error..hmmm

debug mo tapos kunin mo yung value ng xSql, copy, goto database, make new sql query, run. mas malinaw yung error dun.

pero malamang yung appid is int type. tangalan mo lang ng wrapper.
i.e.
xSql = xSql + " AppID = " & txtID.Text & ","
...
xSql = xSql + " WHERE AppID = " & txtID.Text

 

[Eye Switcher]

yahooooooo!!!!

SALAMAT PO MGA KUYA AT MGA SIR!!

Gumana na po.. Nagrecode lang po aq tsaka sinunod q po ung mga payo at suggestions ninyo . THANK YOU AGAIN!
..

 

[eidecedie17]

guys ask ko lang .. nakarelation na to.. gusto ko sana ang value ng total ko sa 2nd table is yung sum ng 3rd table total column..

 

[polens]

guys ask ko lang .. nakarelation na to.. gusto ko sana ang value ng total ko sa 2nd table is yung sum ng 3rd table total column..

kuya wag yan pakita mo ung mga table mismo or ung erd...

 

[elytista]

mga sir,

pwede po ba makahingi ng very simple add, edit, delete, save and search sa vb.net using ado.net using access po muna sana..

sana yung madali lang na coding muna para gawin kong model....

salamat ng marami.. sana may magprovide

 

[fuzzy06]

guys ask ko lang .. nakarelation na to.. gusto ko sana ang value ng total ko sa 2nd table is yung sum ng 3rd table total column..

sa query mo ibased yung pag view mo ng data, for example

select sum(*) from tblOrders where orderid = 123456

 

[ninjamovers]

Hello po pede po patulong sa paggawa ng dashbord using vb.net thanks godbless

 

[privateprivato]

@ ts pa turo naman po ng date maniputalation???

 

[eidecedie17]

sa query mo ibased yung pag view mo ng data, for example

select sum(*) from tblOrders where orderid = 123456

so iinner join ko pa siya s query?

 

[remixrock12]

pa subscribe po..

 

[hmx_ryan]

Oops. Na'miss look ko yung AppID sa taas. remove mo nlng yun

xSql = "UPDATE FirstSemester SET "
xSql = xSql + "Fname = '" & txtFname.Text & "', " 
xSql = xSql + "Mname = '" & txtMname.Text & "', " 
xSql = xSql + "Lname = '" & txtLname.Text & "' " 
xSql = xSql + "WHERE AppID = " & txtID.Text

I'd like to suggest that when connecting or joing a string, use ampersand "&" instead of plus "+"... It would increase performance...

 

[Eye Switcher]

I'd like to suggest that when connecting or joing a string, use ampersand "&" instead of plus "+"... It would increase performance...

-----------------------
ahm..thank you sir..i'll take your advise.
:thank:

 

[fuzzy06]

-----------------------
ahm..thank you sir..i'll take your advise.
:thank:

another suggestion.. use String builder instead of String because string is immutable meaning it creates lot of instance of that string if you use niether "&" or "+"

 

[anishgiri]

Sir Eric ask ko lang po regarding sending sms using pc with AT command na ang gambit ay gsm mobile as modem, pwede be maka send ng 100 sms un in one go?Thanks..

 

[Eye Switcher]

another suggestion.. use String builder instead of String because string is immutable meaning it creates lot of instance of that string if you use niether "&" or "+"

---------------
ahm.."creates lot of instance"?..sir anu po dapat ang gawin? hindi ko pa po alam kung panu gumamit or gamitin ang String builder..
pahelp naman po..

 

[3xpl0r3r]

Mga Master, panu po kya i-Query to s SQLSERVER?

may tbl_emp aq

emp_id
emp_name
emp_gender

Then
ung emp_id ay primary s tbl_emp tz foreign xa s tbl_empdetail which is need to update every time n my i-add n new employee s tbl_emp.

tbl_empdetail
empdetail_id
empdetatil_emp_id '>> nka reference to s tbl_emp
and so on...

Possible b xa s isang execute lng ng query?? vb.net kc gagamitin q s pag add.

Salamat mga bossing..

 

[polens]

Mga Master, panu po kya i-Query to s SQLSERVER?

may tbl_emp aq

emp_id
emp_name
emp_gender

Then
ung emp_id ay primary s tbl_emp tz foreign xa s tbl_empdetail which is need to update every time n my i-add n new employee s tbl_emp.

tbl_empdetail
empdetail_id
empdetatil_emp_id '>> nka reference to s tbl_emp
and so on...

Possible b xa s isang execute lng ng query?? vb.net kc gagamitin q s pag add.

Salamat mga bossing..

read ka about join aggregate function..
hindi ba itinuro yan sa database subjects niyo?

 

[3xpl0r3r]

read ka about join aggregate function..
hindi ba itinuro yan sa database subjects niyo?

tahaha
tulog yta aq nun sir.. tahah

my kinalaman b d2 ung inner, outer, left join??
pero posible ung iniisip q sir??

 

[fuzzy06]

---------------
ahm.."creates lot of instance"?..sir anu po dapat ang gawin? hindi ko pa po alam kung panu gumamit or gamitin ang String builder..
pahelp naman po..

for example

string s = "John";
s += "Dela Cruz";

sa memory mo naka instantiate yung "John" at "John Dela Cruz" so magastos sa memory

parang ganito kung titignan natin sa isang hash table

|1|John|
|2|John Dela Cruz|

kung nag String Builder ka
|1|John Dela Cruz|

lang ang nasa memory mo