Rapla 0 Report post Posted January 11, 2006 Assalamualaikum....Nak tanya sikit....macamana nak tolak value dalam TextBox dgn Value kat dalam Database....kiranye....tak pakai Stored Procedure....tapi buat dalam coding VB.Net....boleh tolong tunjukkan tak? Quote Share this post Link to post Share on other sites
Rads78 0 Report post Posted January 11, 2006 nih contoh jerk Dim strSQL as string strSQL = "Update certaintable set certainfield= sum(certainfield - " & CINT(textbox1.Text) & " where anotherfield='" & txtValue.text & "'" 'then ngko execute strSQL ngko tuh slamat Quote Share this post Link to post Share on other sites
Rapla 0 Report post Posted January 11, 2006 Aku guan Access sebagai Database.. Dalam Database aku ada satu colum nama dia Availability. Availability ni plk ada 4 row...camner aku nak select row mana yg aku nak tolak. and kat strSQL tue takyah specify table name ke?Pastu kena buat OleDbDataAdapter utuk tue ke or guna yg existing? Quote Share this post Link to post Share on other sites