Has a stored procedure in the database to retrieve data
[Code]....
i store dataset in session to use it in resultsearch page Then in the resultsearch page I added a gridviewIn the event Abaj LodI added the code below
[Code]....
but this code is not working any one can modify and correct this code
i am working with search page .. when i click the search button it will show some result like google.. when i click url it will show some personal information. But my problem is i will store data in line line by format. like our forms . but it will display only one single line as page width.. how can i store data in database like that and how can i get that data like to display what i am putting in textbox like this forms
View 3 RepliesI have atable for video files contains the following fieldsIDTitleDescriptionImageViewsUserCategoryI have a text box in the currency ofthe burden of private research is showing results in another page I called it asearch resultFirst of all, has a store of the research processso
[Code]....
'd Like to getthe results in the Grid viewAnd the results are imageany onecan tell me how to make my photo show and control of size in order to become like YouTube
I'm about to create a masterpage that contains a search field, the result from the search should be placed inside a contentplaceholder, but how do I build that? I added the search form to the masterpage (not inside a contentplaceholder), and then I added the eventhandler for the button that trigger the search. Now lest say I want to display the result in the contentplaceholder, how would I do that?
View 4 RepliesI want make a search by which want find data and display in gridview.
View 1 RepliesI'm a complete novice in .NET. I am trying to implement a multi textbox / dropdowns / checkboxes search for a website using vb.net. How do I pass the values of my form fields to my griedview and display the search result on the same page?
I've written a stored procedure and specified it as data source for my gridview and defined parameter source as my CONTROLS (textboxes, checkboxes n dropdowns) on the form. What I want is when a user fills out one or multiple fields on the form, how do I display data in the gridview on the click of SEARCH button? Also is it necessary to write a codebehind for my search button or we can achieve the desired result in some other way?
simpel search form. that redirect to a search result page.
View 4 RepliesBasically I want to have a page do a search on first name(textbox), last name(textbox), gender(dropdown). and return a grid result back. it's so easy in web forms. how do i do in mvc? So far I have: Controller
[Code]....
View: Search.aspx
[Code]....
I didn't modify the route. When I put in [URL], it says resource not found.
Does anyone know how to do this? My boss wants to have an indexed sql server return a set of hits based on their weight in the db.
View 1 Replies I have one left side panel which containg one search box and treeview, when user type any search text than i have to dropdown the list of matching item below textbox,according to search text user can able to find text on dropdown, when user select particular text and click on same on treeview that text would be automated selected and on right side panel data will pupulate automatically according to selected item.same like
[URL]
I am new to visual studio .net c#. I was able to use Jdeveloper to create a search result page - search criteia on top with a "search" button, a result set table or form at the bottom of the page.
View 1 RepliesI have an ASP .NET web application. I'm fairly new to .Net but a longtime SQL and Java programmer. I have a requirement to implement a search feature as it is currently implemented in the legacy application. There is a pageable grid of data displayed and a search box. You type your search criteria and the grid pages to the first match. A "next match" button pages to the next item etc. This way the user sees where their search item falls in the hierarchy of the data. I have seen examples where the search criteria filters the data, limiting the data results.
View 1 RepliesI've been implementing MS Search Server 2010 and so far its really good. Im doing the search queries via their web service, but due to the inconsistent results, im thinking about caching the result instead.
The site is a small intranet (500 employees), so it shouldnt be any problems, but im curious what approach you would take if it was a bigger site.
I've googled abit, but havent really come over anything specific. So, a few questions:
What other approaches are there? And why are they better?
How much does it cost to store a dataview of 400-500 rows? What sizes are feasible?
Other points you should take into consideration.
how i can parse Google search result into title, desc and urls?
View 1 Repliesi develope the search engine project
how to bold search key word in description of result
I have a table in SQL Server with structure:
Students
(
StudentId bigint,
FullName nvarchar(100),
DegreeId smallint,
Articel nvarchar(max)
)
i have created a full text index and enabled it for "students" table.
in my asp.net page ,users type words and i call a stored proc filter students using these words.
Create Procedure GetStudents(@Article nvarchar(200)=typed words)
AS
BEGIN
SET NOCOUNT ON
SELECT StudentId,FullName,DegreeId,Article
FROM Students
WHERE WHERE FREETEXT(Article,'''+ @Article+''')
END
The search works fine ,now i need to highlight(yellow background)the "articles" of returned stuents in my asp.net page(by jquery,or asp.net).
i have a requirement in which the user can search for other user he enters three char of the name clicks on the search button and a new window is opened and he can see all the search results in a gridview he can select one of them and this closes the new window and the details are populated on the previous page.
View 6 RepliesI wanted to a window to pop up when the user clicks on an image. In the pop window, i want to display a text box to search and a button to submit the search. Also on the same pop up, i want to use a radiobutton list to give the option of choosing to search by first name or last name.on searching, i want to display a list of employee names matching the search and give a radio button next to each of them to select the record. On selection, the user will click an OK button below the records. On clicking OK, the pop up window should close and the employee id of the employee selected should be visible in the text box next to the image.Does anyone have an idea of how to do this, because i am not too sure that i have explained it properly.
View 5 RepliesI have a Quick search box for a real estate website, which will search from the SQL server. I have two Radio buttons , and two dropdownlists. I want to display the result in a new page using the chosen criteria, I found this article but it's in VB, I want the code in C#. What i understad that i put this code for the search button:
[Code]....
What next?
Let's say I have a gridview with some columns like, title, name, funding agency. Here's an example of what I want to do:
I want to display all the records in the gridview to start. There would be a dropdownlist that lets the user select whether to search by title, name, funding agency and a text box that lets them type in what they want to search for (and a button to start the search). After searching, the gridview would only display the records that matched the criteria.i already know how to connect datasets to the gridview, but i am using mysql database and writing code in vb.how to accomplish this task
I am new at this VB/Microsoft Visual Web Developer 2010 Express thing. I am amaze that I even got this far and thatI manages to make this search page work. Below is the code and picture for this search page. It's working. However I want to transfer the result/the gridview onto a second page Result.aspx. But I tries all kind of thing and it just doesn't seem to want to cooperate with me. If anyone can give me some hint/some sample codes on how I might be able to transfer controlfrom one page onto another. I just have to learn it from a class extra credit project. Also in the picture above I am using a direct connection to an Access database not the ObjectDataSource. I was just playing around with it to see which is better. But I ended up going with direct connection to Access database.
<%@ Page Language="VB" ClassName="SenderClass" EnableSessionState="True" %>
<head>
<script runat="server">
Sub closeSite(ByVal sender As Object, ByVal e As EventArgs)
Response.Write(" <script language='javascript'> { window.close(); }")
End Sub
Sub Page_Transfer(ByVal sender As Object, ByVal e As EventArgs)
'Storing in Context
Session("SearchBox") = SearchBox.Text
Session("ListBox") = ListBox1.Text
Session("DropDownList") = DropDownList.DataTextFormatString
'Context.Items("DropDownList") = DropDownList.Text
'Server.Transfer("SearchResult.aspx")
End Sub
Sub Page_Transfer2(ByVal sender As Object, ByVal e As EventArgs)
Dim field1 As String = ("SearchBox")
Dim field2 As String = ("ListBox")
Dim field3 As String = ("DropDownList")
'Dim TestString As String = ("SELECT * FROM [Books] WHERE (([Title] = ?) AND ([Category] = ?))")
End Sub
Sub Test(ByVal sender As Object, ByVal e As EventArgs)
AccessDataSource1.SelectCommand = "SELECT * FROM BOOKS WHERE "
If DropDownList.SelectedIndex = 0 Then
AccessDataSource1.SelectCommand += String.Format(" ((Category = @Category OR 'Computer' ")
AccessDataSource1.SelectCommand += String.Format(" OR 'Literature & Fiction' OR 'Reference'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Romance' OR 'Science'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Home Design' OR 'Accounting & Finance'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Horror' OR 'Refernce'))")
Else
AccessDataSource1.SelectCommand += String.Format("(( Category = @Category ))")
End If
For Each Item As ListItem In ListBox1.Items
If Item.Selected = 0 Then
AccessDataSource1.SelectCommand += String.Format(" AND ((Title Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR [Author(s)] Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Publisher Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR ISBN Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Price Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Category Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Year Like @Search + '%' ))", Item.Text)
End If
If Item.Selected = 1 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Title Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 2 Then
AccessDataSource1.SelectCommand += String.Format(" AND ([Author(s)] Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 3 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Publisher Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 4 Then
AccessDataSource1.SelectCommand += String.Format(" AND (ISBN Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 5 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Price Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 6 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Category Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 7 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Year Like @Search + '%' )", Item.Text)
End If
Next
Dim KeywordCom As String = AccessDataSource1.SelectCommand.ToString
Context.Items("Test") = KeywordCom.ToString
Server.Transfer("Result.aspx")
End Sub
</script>
</head>
<html>
<body>
<a href="Default.aspx">Home</a>
<a href="About.aspx">About.aspx</a><a href="SearchResult.aspx">SearchResult.aspx</a>
<form id="form1" runat="server">
<h3>
Search for:
<asp:TextBox ID="SearchBox" runat="server" Width="219px" />
<asp:Button ID="Button1" Text="Search" Width="146px" AccessKey="S"
runat="server" Enabled="True" Onclick="Test" height="26px"
style="position: relative"/>
</h3>
<h3>
Search In:<asp:ListBox ID="ListBox1" runat="server" style="margin-left: 6px"
Width="221px">
<asp:ListItem>Keyword Anywhere</asp:ListItem>
<asp:ListItem>Title</asp:ListItem>
<asp:ListItem>Author(s)</asp:ListItem>
<asp:ListItem>Publisher</asp:ListItem>
<asp:ListItem>ISBN</asp:ListItem>
<asp:ListItem>Price</asp:ListItem>
<asp:ListItem>Category</asp:ListItem>
<asp:ListItem>Year</asp:ListItem>
</asp:ListBox>
</h3>
<h3>
Category:
<asp:DropDownList ID="DropDownList" runat="server" Height="16px" Width="162px">
<asp:ListItem>All Categories</asp:ListItem>
<asp:ListItem>Computer</asp:ListItem>
<asp:ListItem>Literature & Fiction</asp:ListItem>
<asp:ListItem>Reference</asp:ListItem>
<asp:ListItem>Romance</asp:ListItem>
<asp:ListItem>Science</asp:ListItem>
<asp:ListItem>Home Design</asp:ListItem>
<asp:ListItem>Accounting & Finance</asp:ListItem>
<asp:ListItem>Horror</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button3" runat="server" Text="Exit Store" Width="146px"
height="26px" />
</h3>
<p>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="AccessDataSource1" >
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="ISBN" HeaderText="ISBN" SortExpression="ISBN" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="Author(s)" HeaderText="Author(s)"
SortExpression="Author(s)" />
<asp:BoundField DataField="Publisher" HeaderText="Publisher"
SortExpression="Publisher" />
<asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
<asp:BoundField DataField="Category" HeaderText="Category"
SortExpression="Category" />
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select"
ShowHeader="True" Text="Select" runat="server" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/Books.accdb" >
<SelectParameters>
<asp:ControlParameter Name="Category" ControlID="DropDownList" PropertyName="SelectedValue" />
<asp:ControlParameter Name="Search" ControlID="SearchBox" PropertyName="Text" />
<asp:ControlParameter Name="InColumn" ControlID="ListBox1" PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
</p>
<p>
</p>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</form>
</body>
</html>
I would like a site that offers the users the possibility to search over 2 datasources but as i tried to indicate in the subject title the searches are one after another where the result of search 1 is used as a parameter for searching the second datasource. The order of the search would depend for what you search (ideally). Some "fields" or "data" of course appear in both datasources.
To get more specific: datasource 1 contains chemical structures and the associated "id" for this structure + additonal properties. You can search for chemical structures here. (chemically intelligent system). datasource 2 contains documents which are indexed (full text) and have metadata fields one of them beeing above id. No chemical search possible.
The idea is now that i perform a search by chemical structure on datasource 1. As as a result I get a list of id's. These id's are then past into datasource 2 as parameter + also all additionaly parameters entered. There are API's available to perform above searches on the 2 datasources. Is this a reasonable approach? Would it be better to create somekind of a simple datawarehouse, eg a table with all numbers linked to all documents they appear in? (would't know how to achievie this actually since it's the 2 datasoruces are not the same rdbms).
I have Database called mygroup , and I have three tables:
* Cataloges table .. columns (CatalogeId
int, CatalogeName
nvarchar)
* Brand table .. columns (BrandId
int, BrandName
nvarchar)
* Products table, it is consists of these columns :
ProductId int
ProductNO nvarchar
CatalogeId int
BrandId int
MainSpecification nvarchar
DetailsSpecification ntext
Image imageand I want to desgin form for products, and this form contain these ToolBox
* DropDownList for CatalogeId
* DropDownList for BrandId
* DataList Control for displaying the Result Search
* Button
When the user visit Product Page for Example (productpage.aspx), then he see the two DropDownList , then choose one of Cataloge Name (Laptop , Printer, ....) , and choose one of the Brand Name (Sony, Toshiba, ....) , then Click the Button, and get the Result Search in Paging DataList
i have a textbox with button search.
i would like to search database of input text from textbox and give result out in one view.
I am stored date in "smalldatetime" datatype as in databse.How can i particular textbox entered date(dd-mm-yyyy) used to fetch the row information from databse and shown in a gridview.
View 1 Replies