How to Search record from the Sql Server Database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 392,075 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,068 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

Thread Tools Display Modes

Views: 5136 | Replies: 5 | Solved

•

Join Date: Sep 2006

Posts: 17

Reputation: Dhruv Shah is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

Dhruv Shah Dhruv Shah is offline

Offline

Newbie Poster

How to Search record from the Sql Server Database

Sep 16th, 2006

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

•

Join Date: Feb 2003

Location: Canada

Posts: 786

Reputation: Paladine has a spectacular aura about

Rep Power: 9

Solved Threads: 26

Paladine

Offline

Master Poster

Re: How to Search record from the Sql Server Database

Sep 17th, 2006

•

Originally Posted by Dhruv Shah

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

pseudo_code:

Help with Code Tags

(Toggle Plain Text)

Dim strSQL as String

strSQL = "SELECT Field1, Field2 FROM tbltemp WHERE Field1 = '" & TextBox1.Text & "'"

Hope this helps.

Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code

•

Join Date: Sep 2006

Posts: 17

Reputation: Dhruv Shah is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

Dhruv Shah Dhruv Shah is offline

Offline

Newbie Poster

Re: How to Search record from the Sql Server Database

Sep 17th, 2006

•

Originally Posted by Paladine

pseudo_code:
Help with Code Tags

(Toggle Plain Text)
Dim strSQL as String
 
strSQL = "SELECT Field1, Field2 FROM tbltemp WHERE Field1 = '" & TextBox1.Text & "'"
 
Dim strSQL as String strSQL = "SELECT Field1, Field2 FROM tbltemp WHERE Field1 = '" & TextBox1.Text & "'"
Hope this helps.

thanks sir
this help me out. but when i m printing the record it also shows me textbox and command button. So sir now how do i remove this from print out.

•

Join Date: Oct 2006

Posts: 8

Reputation: Blah Blah is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

Blah Blah

Offline

Newbie Poster

Re: How to Search record from the Sql Server Database

Oct 2nd, 2006

•

Originally Posted by Dhruv Shah

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

TRY THIS WITH ASP.NET USING VB.NET:

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()
Catch ex As Exception
txtmsg.Text = ex.ToString
OleDbConnection1.Close()
End Try
End Sub

THIS WILL SEARCH THE TEXT AND ONLY CHECKING THE FIRST LETTER OF THE GIVEN TEXT:

LIKE IF U WRITE "J" YHEN UT WILL SEARCH EVERY TEXT STARTING WITH THE LETTER J......

I HOPE THIS WILL HELP:cheesy:

•

Join Date: Nov 2005

Location: Mostar

Posts: 88

Reputation: ManicCW is an unknown quantity at this point

Rep Power: 3

Solved Threads: 10

ManicCW

Offline

Junior Poster in Training

Re: How to Search record from the Sql Server Database

Oct 3rd, 2006

When passing query use parameters:

•

cmd.CommandText = "SELECT ID, Title, Job FROM Jobs WHERE Title=@Title"
cmd.Parameters.Add("@Title", SqlDataType.NVarChar).Value = Me.txtTitle.Text.Trim

To hide some element while print:
http://www.daniweb.com/techtalkforums/thread54946.html

Last edited by ManicCW : Oct 3rd, 2006 at 2:07 am.

http://www.manicsite.com

•

Join Date: Apr 2007

Posts: 3

Reputation: june_bunga is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

june_bunga june_bunga is offline

Offline

Newbie Poster

Re: How to Search record from the Sql Server Database

Apr 4th, 2007

•

Originally Posted by Blah Blah

TRY THIS WITH ASP.NET USING VB.NET:

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()
Catch ex As Exception
txtmsg.Text = ex.ToString
OleDbConnection1.Close()
End Try
End Sub

THIS WILL SEARCH THE TEXT AND ONLY CHECKING THE FIRST LETTER OF THE GIVEN TEXT:

LIKE IF U WRITE "J" YHEN UT WILL SEARCH EVERY TEXT STARTING WITH THE LETTER J......

I HOPE THIS WILL HELP:cheesy:

i try using this sample code to my application.but if you dont mind, can you state the namesapece of DATA declarations for connection n data type to match with this code.

tq