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 am trying to develop a page where I am trying to search a database (MyQSL) and display the data in a table format. Some of the database entries, like category, is stored as integer values, but I want to display the category name in the search result (not the corresponding integer value). I have also another issue, every time I change the dropdown list values (which are having "auto postback" enabled) the <EmptyDataTemplate> is returned. At this moment I am using GridView. But I am ready to change this to any other method, like repeater or whatever...
View 2 Repliessimpel search form. that redirect to a search result page.
View 4 RepliesHas 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 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 have page A.aspx where I show some result in listview. When I click On Some data on listview I go to page B.aspx. Now the problem is when I click on back in page B.aspx it comes to A.aspx with out previous listview result. Ack requirement is when I come to page A.aspx result of listview has to be there. How do i do that?
View 2 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?
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 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 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?
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 have to give the user the option to upload his own aspx and aspx.cs files on to the server, adjust the hyperlink to point to a page which would do the following display the aspx and aspx.cs files code onto the page without actually rendering the code the browser should not understand anything, and while reading the files to display them the method be such that nothing is processed on the server regarding the code within the files to prevent from unnecessary problems many user would try to cause.
i have tried many ways of displaying it but it ends up on displaying the actual comments instead of the code. how to achieve the above. note main concentration is on asp.net and c# using vs08, so j script and ready-made tools be avoided if feasible
Basically 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 RepliesI'm developing a search page that will display the results in a gridview. The codebehind (in VB.NET) uses a SQL command to fill the gridview.
The gridview does have paging and sorting enabled. Once the search button is clicked the initial results are displayed, if the user clicks on a sorted column or wants to advance a page the gridview disappears. Enable Sorting And Paging Callbacks is set to True. Enable ViewState is also set to True.
Am searching a database with three text fields so that i can display the records in a Gridview.
At least one text filed must be filled, then the other two are optional., and one field of the record has PDF file names saved in it,how do i search and display in Gridview on the same page,, and put a link in the Gridview that links to the corresponding file on server?
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 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 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 Replies