No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
i am developing a job site and i require to search for records from the database. i m passing value fro that parameter in textbox. so please help me thanks in advance |
|
Private Sub btnsearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsearch.Click Try txtmsg.Text = "" OleDbDataAdapter1 = New OleDbDataAdapter("select * from phbook where name like '" & ddl.SelectedItem.Text & "%'", OleDbConnection1) OleDbDataAdapter1.Fill(DataSet21, "phbook") OleDbConnection1.Open() Dim com As New OleDbCommand com.Connection = OleDbConnection1 com.CommandText = "select * from phbook" dg1.DataBind() … |