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.
simpel search form. that redirect to a search result page.
View 4 RepliesIt is about ASP.NET MVC3. I have a page with at the top some search criteria and at the bottom the resulting data. The user can type some criteria and use a submit button to retieve data. In my controller, I have an ActionResult function for managing these criteria and return to the same page with a ViewModel class filled.
The problem: the user can click on a line in the resulting table for viewing a detail page. On the detail page, he can navigate to an edit page for editing data. On this page (edit data) I would like to able the user to go back to the search result page (in fact: navigate back two times). What is the best way to proceed? If I "simply" use an ActionLink (without posting data) to my search result page, it will simply display an empty result page with empty search criteria. Maybe I need to keep my search criteria in a session variable? I don't like this kind of thing...
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
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 RepliesAs a newbie coming from a Java background with tag libraries I wonder if there is a simple possibility to render areas depending on backend values.For example if I have search form I do not want to render the table for the search results as long as the user hasn't pressed the search button. Of course I can iterate over the model containing an empty list but this does not allow to suppress rendering the whole table.Using web forms I would just control the visibility of the affected tag(s) in the code behind file but how do I do this with ASP.NET MVC?Can I use a partital view for a case like this? But I think I would have the same problem. How can I determine if a partial view is rendered (e.g. the whole result table with header)?
View 7 Repliesi want to use the weather web service that provided for free from webservicex so i have added the service to my ASP.net web site [URL] in the code behind i have defined an object of this service and this object require the country and city name to get the result back i gave the
city name :amman
country : jordan
but i dont know how can i get back the result? is there any function i forgeted?
I have been at this for hours and am pretty stuck. I am using MVC2 with VS2010 Beta 2.
Here is my javascript from the view:
[Code]....
Here is my controller code:
[Code]....
I can set a breakpoint in the GetMember method and it does receive the Member_ID parameter correctly. It also correctly returns a member object from my repository (dpR). The function in $.getJSON call that is supposed to receive this result does nothing however. There are no exceptions or javascript errors. It is just silently dying.
I can i create a search capability to search profile table?
View 2 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 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 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 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 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 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.