clynnekent
Forum Guru
- Joined
- Sep 3, 2015
- Posts
- 4,486
- Solutions
- 7
- Reaction
- 3,179
- Points
- 1,294
Good day po sa lahat baka may makatulong sakin dito. Pano po mag search ng data galing sa database using datagridview and textbox. May ginawa kasi akong code pero di sya na wo work.Please help naman kung ano mali sa code ko.
Code :
databaseconnection.conn()
cn.Open()
Dim i As Integer
DataGridView1.Rows.Clear()
cmd = New OleDbCommand
cmd = New OleDbCommand("Select * from tblemprecord where Employee_lname like '%" & TextBox1.Text & "%' OR Employee_empid like '%" & TextBox1.Text & "%' OR Employee_fname like '%" & TextBox1.Text & "%'", cn)
cmd.Connection = cn
Using dtr = cmd.ExecuteReader()
If dtr.HasRows Then
While dtr.Read
i += 1
DataGridView1.Rows.Add(i, dtr.Item("Employee_id").ToString, dtr.Item("Employee_fname").ToString, dtr.Item("Employee_lname").ToString, dtr.Item("Employee_mname").ToString, dtr.Item("Employee_startdate").ToString, dtr.Item("Employee_gender").ToString, dtr.Item("Employee_employmentstatus").ToString, dtr.Item("Employee_designatory").ToString, dtr.Item("Employee_department").ToString)
End While
End If
End Using
cn.Close()
Gusto ko sana pag type ko sa textbox ex: nag type ako nang "A" lahat nang nasimula sa letter A sa datagridview makikita. Ganun lang po. Nagtataka lang ako bakit di ako maka search dyan. Sa mga magagaling na IT dyan pa help naman.
clynnekent
Code :
databaseconnection.conn()
cn.Open()
Dim i As Integer
DataGridView1.Rows.Clear()
cmd = New OleDbCommand
cmd = New OleDbCommand("Select * from tblemprecord where Employee_lname like '%" & TextBox1.Text & "%' OR Employee_empid like '%" & TextBox1.Text & "%' OR Employee_fname like '%" & TextBox1.Text & "%'", cn)
cmd.Connection = cn
Using dtr = cmd.ExecuteReader()
If dtr.HasRows Then
While dtr.Read
i += 1
DataGridView1.Rows.Add(i, dtr.Item("Employee_id").ToString, dtr.Item("Employee_fname").ToString, dtr.Item("Employee_lname").ToString, dtr.Item("Employee_mname").ToString, dtr.Item("Employee_startdate").ToString, dtr.Item("Employee_gender").ToString, dtr.Item("Employee_employmentstatus").ToString, dtr.Item("Employee_designatory").ToString, dtr.Item("Employee_department").ToString)
End While
End If
End Using
cn.Close()
Gusto ko sana pag type ko sa textbox ex: nag type ako nang "A" lahat nang nasimula sa letter A sa datagridview makikita. Ganun lang po. Nagtataka lang ako bakit di ako maka search dyan. Sa mga magagaling na IT dyan pa help naman.
clynnekent