Patulong naman mga master d2 sa code na to..
yung pag update po ng datagrindview di ko talag makuha..
mga master patulong pls...
>>>>>
Imports System.Data.OleDb
Public Class Search
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.Close()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Texts1.Text = ""
Texts2.Text = ""
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
End Sub
Private Sub Search_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
Private Sub Texts1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Texts1.TextChanged
Dim cmd As New OleDb.OleDbCommand
If Not con.State = ConnectionState.Open Then
con.Open()
End If
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
Dim da As New OleDb.OleDbDataAdapter
da = New OleDbDataAdapter("Select * from mytable where ID like '%" & Texts1.Text & "%'", con)
da.Fill(dt)
DataGridView1.DataSource = dt.DefaultView
con.Close()
End Sub
Private Sub Button3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Me.Close()
End Sub
Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Texts1.Text = ""
Texts2.Text = ""
DataGridView1.DataSource = ""
End Sub
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'*
anyone can fix this code,, i appreciate too much*
Dim cmd As New OleDb.OleDbCommand
If Not con.State = ConnectionState.Open Then
con.Open()
End If
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
Dim da As New OleDb.OleDbDataAdapter
Dim dr As OleDbCommandBuilder
da.Update(dt)
DataGridView1.DataSource = dt.DefaultView
con.Close()
MessageBox.Show("is now updated")
End Sub
End Class