Click here to Skip to main content
16,018,353 members

Comments by arnoldxx (Top 19 by date)

arnoldxx 17-Apr-14 2:28am View    
thanks my friend.. you help me a lot.. :D
arnoldxx 14-Mar-14 8:25am View    
Thx bro.. Its work :D
arnoldxx 19-Jun-13 5:53am View    
can u gime an example bro.. sorry i m still new in this progress.. might need some help from you guys.. thanks..
arnoldxx 18-Jun-13 6:57am View    
ty for the feedback..
i have follow the step that u show it to me by changing the if val = 0 to if val = "0"
but it still won't work to me..
arnoldxx 13-Apr-13 21:12pm View    
Deleted
thx bro.. i just found out a new method..
but i m now facing another problem..
i want to update my data.. but the problem is..
it update all of the data without refer to its row..

here is the sample of code.

cm.CommandText = "update Table1 SET address='" & TextBox1.Text & "', pcode='" & TextBox2.Text & "', state='" & TextBox3.Text & "', email='" & TextBox4.Text & "', nationality='" & TextBox5.Text & "', hp='" & TextBox6.Text & "', fax='" & TextBox7.Text & "';"
cm.Connection = cn
cm.ExecuteNonQuery()
cm.Dispose()

and another problem is delete..
is there any method for me to delete just only a specific data.. but not the whole row of data on data base..
cause i try this method
cm.CommandText = "DELETE * FROM Table1 WHERE address ='" & TextBox1.Text & "';"
it delete all of my database..
:(
sorry i m actually still a newbie in database..
but i have try my very best to make research on google.. :(