Knowledge Share

Knowledge is NOT Power IMPLEMENTATION of knowledge is Power!!!
 
HomePortalGalleryCalendarFAQRegisterUsergroupsLog in

Share | 
 

 To Modify An existing Record in DataBase

View previous topic View next topic Go down 
AuthorMessage
Admin
Admin


Posts : 141
Points : 407
Reputation : 0
Join date : 2007-12-29
Location : Chennai

PostSubject: To Modify An existing Record in DataBase   Mon Feb 08, 2010 11:15 am

To Modify An existing Record in DataBase

Dim mcmd As OleDbCommand
mcmd = New OleDbCommand("update notice set notice='" & ta.Value & "' where noticeno='" & tb1.text & "'", Application("con"))
Dim r As Integer
r = mcmd.ExecuteNonQuery

To Delete An existing Record in DataBase

Dim dcmd As OleDbCommand
dcmd = New OleDbCommand("delete from notice where noticeno='" & dl2.SelectedItem.ToString & "'", Application("con"))
Dim r As Integer
r = dcmd.ExecuteNonQuery
Back to top Go down
http://knowledgeshare.forumotion.com
 
To Modify An existing Record in DataBase
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» selenium with database testing
» How can i store all the commandsused by rc in a database??
» Pass multiple test data record to run test suite recursively
» how to check the existing value in the textbox using selenium webdriver.
» Gang Tag Database

Permissions in this forum:You cannot reply to topics in this forum
Knowledge Share :: .Net-
Jump to: