Private Sub txtusername_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtusername.TextChanged username = txtusername.Text connect.Open() ds.Clear() da = New OleDb.OleDbDataAdapter("SELECT * FROM tbluser", connect) da.Fill(ds, "tbluser") Dim dv As New DataView(ds.Tables("tbluser")) dv.RowFilter = "username= '" & username & "'" DataGridView1.DataSource = dv connect.Close() End Sub
if(con.state==ConnectionState.Closed) { con.open(); } if(con.state==ConnectionState.Open) { con.Close(); }
DataAdapter
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)