#1 (permalink)  
Old
New Member
 
Join Date: Sep 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
update table

hi friends
I am trying to search a table with last and first name and update table after changes .I can retrieve rows and display in datagridview,
I would like to know how do I update table after changes, i would appreciate any help
Code:
  Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
        ds.Tables("table1").DefaultView.RowFilter = "FName_ LIKE '*" & TextBox1.Text & "*' OR  LName_ LIKE '*" & TextBox1.Text & "*'"
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        If Me.data IsNot Nothing Then
            Dim builder As New OleDbCommandBuilder(Me.adapter)
            Me.adapter.Update(Me.data)
        End If
    End Sub
Reply With Quote
Reply

Bookmarks

Tags
edit table, sql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I update multiple records in a table at once?? davestar057 PHP 9 09-11-09 07:44 PM
MYSQL database countll Database 2 06-19-07 04:20 PM
Update multiple rows outside loop - need help ElvansX PHP 1 12-03-06 01:55 AM
Newbie MySQL fccolon PHP 2 03-16-04 10:54 AM
Looking for a update table script thebugz Script Requests 1 12-07-03 06:32 PM


All times are GMT -5. The time now is 06:59 AM.
vBulletin® Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.