Search results for query: *

Hey Joe , I just could not find any examples or tutorial.So I set it up like a Search page using a droplist box with a button (ASP.Net) SELECT * FROM Parts WHERE MFG is not null Link the Search button to the results page On the results page I setup a gridview SELECT * FROM [Parts] WHERE...

Joe - yes and no. Web development yes and SQl 1)In one view I pull a data list of MFG out Parts Table That work fine, now the tricky part,I want make all Mfg hyperlink to all product listed to them in gridview. So I am pulling from database then giving a option to select a brand and pull up all...

Hi all, I am working on a parts page - To show MFG using SQL I can list all the Mfg Two option: 1) I would to creat a dropdown box with all MFG in it and the click search to go to all parts made by the MFG 2) I have all the Mfg list already pulled up , how can I hyperlink or link it back...

Thank you,I knew it was simple...

I want to make list of all the Mfg from my parts table, but the problem is how do I get one listing for each item? For ex part table mfg partnumber etc apple 123456 apple 134567 apple 145624 bike 123465 car 123468 select * [parts] order by [mfg]asc apple apple apple bike car...

Ok maybe its a combo box,take brand names in column A and you can search with drop down box to each item Drop down you select Apple the the grid shows all Apple products Sound Possible ?

I am working on a web page in search box , I came along a website that has a search feature lookup parts or has a dropdown box with MFG names in it.You select Apples and it brings up all apple products.I like that feature. I have search working , but cant get the drop down box to work. See...

Yes and No ,Simple is best , when time is in short supply with a budget.Creating your own code would have less issues on certain apps, but on this simple Query , this will do. On my search I want all data that is related to BC BC154,BC155 an 123BC45,xcv12BC Thanks again

Update the code Markros provide worked : select * from Parts where Part_Number like '%' + @Part_Number + '%' I forgot to pick form view : ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:ConnectionStringparts %>" SelectCommand="SELECT * FROM [Parts] WHERE ([Part_number] Like '%' +...

Expression Web you use SQLDatasource and you can chose grid, page or form view.It lock the SQL server in and you can chose what you want to do..show all data or some columns ..

What do you suggest for a search Box ? The simple does work,I know it something still simple.It just a setting that we are missing?...

Tried Code on web page and stated @part_num was already delcared ?... Declare @Part_Num varchar(50) set @Part_Num = 'BC' select * from Parts where [Part_Number] LIKE @Part_Num + '%'

In SQL Server ,Declare @Part_Num varchar(50) set @Part_Num = 'BC' select * from Parts where [Part_Number] LIKE @Part_Num + '%' Works , bring up all the BC part numbers What do we set Declare for a saerch box ?

Link is not working (http://=/)You may want to check Setting SQLDataSource parameter from the code-behind

I didnt set the value of @part_number,I know if you try the code on SQl Server it ask for a Scaler Variable for @part_num ?

No luck with trim code ..

Here the code : <asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowPaging="True"> <Columns> <asp:boundfield DataField="Cat_Id" HeaderText="Cat_Id" ReadOnly="True" InsertVisible="False" SortExpression="Cat_Id">...

I not using a stored procedure for the search.The string doesnt error out , so I know it something small. Trim , how would I do that ?

Ok update , varchar(50)

Same results , Blank Results page More Info in the search Box enter BC, I would like it to pull up all part numbers with BC154,BC155,BC15 Etc. I know were close ...