Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lookup13

    Search with drop down box

    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...
  2. lookup13

    Search with drop down box

    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...
  3. lookup13

    Search with drop down box

    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...
  4. lookup13

    This is a simple one ....

    Thank you,I knew it was simple...
  5. lookup13

    This is a simple one ....

    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...
  6. lookup13

    Search with drop down box

    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 ?
  7. lookup13

    Search with drop down box

    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...
  8. lookup13

    Expression Web and SQL server

    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
  9. lookup13

    Expression Web and SQL server

    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 '%' +...
  10. lookup13

    Expression Web and SQL server

    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 ..
  11. lookup13

    Expression Web and SQL server

    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?...
  12. lookup13

    Expression Web and SQL server

    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 + '%'
  13. lookup13

    Expression Web and SQL server

    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 ?
  14. lookup13

    Expression Web and SQL server

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

    Expression Web and SQL server

    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 ?
  16. lookup13

    Expression Web and SQL server

    No luck with trim code ..
  17. lookup13

    Expression Web and SQL server

    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">...
  18. lookup13

    Expression Web and SQL server

    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 ?
  19. lookup13

    Expression Web and SQL server

    Ok update , varchar(50)
  20. lookup13

    Expression Web and SQL server

    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 ...

Part and Inventory Search

Back
Top