How To Search With Parameters In MVC
Jun 13, 2010
I need to be able to provide a page for the end user where thay can search in the following :
Search work
Category
Price
AdType
Location
and so on.
Its important that the user can copy the url and then use it later(and get the same settings). Its also important to be able to save these settings on the user in the database.
So far I have created a ModelView class that contains the parameters but I am not sure that this is the right way to go? Maby I should pass all inte the URL.
View 2 Replies
Similar Messages:
Jun 15, 2010
I have a strong typed view bound to the following type :
[Code]....
As you can see it is containing both the data and the search parameters(dont know if this is a good idea?). The method looks like this :
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult List(AdList adList)
{
try
{
return View(adList);
}
catch (Exception ex)
{
throw ex;
}
}
What I need is to provide a search page where the user can set parameters and see a list of data(depending on parameters. It should be using QueryString to be able to get to a specific setup with the URL. I supose that I could set the "<form method=get.." this would generate a QueryString on submit but Im not sure that this would work in the current setup? Maby I have to place the seartch stuf in a partialView?
View 6 Replies
Oct 14, 2010
I am working on a railway web application and I have following layers:
[Code]....
I pass Domain Entity Objects from Repository to Service layer and thinking of passing View Models from Service to Presentation layer. Website would require a login and after successful login I have to present a search screen with basic search (as default option) and option for advance search. Once user fills the
search criteria I have to gather data from DB & Web Services and present the results to user. User would select a particular Rail option and would move on to other additional options page BUT they should be allowed to change their previously selected Rail option by going back to Rail search results. I have to
always hold and present user's initial search criteria (basic and advance search options selected by user on the search wizard) on every screen and need these criteria in Service and Repository layers.
What is the best way to hold these search criteria and pass them from page to page within presentation layer and across layers? Should I create a View Model class for Search Options? Or a Domain Entity Object (I don't think so)? and best way to pass it across layers and from page to page with in presentation layer.
View 1 Replies
Nov 26, 2010
I'm trying to implement a search function on an incident logging page that is working fine. Currently I am only able to search against one criteria at a time, using the following route:
View 2 Replies
Sep 19, 2010
I have recently started using SQL Server Reporting services. I currently have a problem. I am trying to achieve a search by dates in a report. I have a table with the fields RequestDate in e.g. 22-Jan-2010 or 23-Sep-2010. I have created a report in Query Designer with two parameters in it RequestDate & RequestDate2.
The Operators are for RequestDate is: Is more than or equal to The value is: 1-Jan-2010 And the Operator for RequestDate2 is: Is less than or equal to. The value is 30-Dec-2010 When i go to the SQL Statement this is produced:
SELECT
MHRA.ImportRequestID
,MHRA.UniqueID
,MHRA.CreatedBy
,MHRA.RequestDate
FROM
MHRA
WHERE
MHRA.RequestDate >= @RequestDate
AND MHRA.RequestDate <= @RequestDate2
When i go to view report i want to be able to search for dates between the dates 1 Jan 2010 and 30-Aug-2010 My query seems to pick up all or most of the results between these dates. How can i build this query so i can get specific results. For example...in the Request Date Parameter box i would put 2-feb-2010 and in Request Date 2 i would put in 5-Jun-2010 and this would return all the results between these dates.
View 1 Replies
Oct 10, 2010
I've got a gridview that I need to perform filters on. All works great until I try and add a date range..
Below is the code. Basically I have 5 dropdown lists which all filter as expected giving them the option to use each one or just the ones they need.
The problem is they want to also have the option of filtering by date i.e date range or greater than or less than or equal to etc..
As soon as I add the date parameter it stops the other filters working. I'm guessing because I have a null value in the date field (textbox) if they dont use the option??
Does anyone have a sample on how to filter by dropdown lists and dates keeping in mind they wont use all the filter options?
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<style type="text/css">
.style2
{
width: 100%;
}
.style3
{
width: 137px;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
</br>
<table>
<tr>
<td>
Person Responsible</td>
<td>
<asp:DropDownList ID="DDLPersonResponsible" runat="server"
DataSourceID="SqlDataSource2" DataTextField="AssignedTo"
DataValueField="AssignedTo" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
Location</td>
<td>
<asp:DropDownList ID="DDlLocation" runat="server" Height="22px" Width="200px"
DataSourceID="SqlDataSource3" DataTextField="location"
DataValueField="location" AppendDataBoundItems="True"
AutoPostBack="True">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_Locations" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Activity/Product/Service</td>
<td>
<asp:DropDownList ID="DDlActivity" runat="server" DataSourceID="SqlDataSource4"
DataTextField="Activity" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_Activity" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Risk Ranking</td>
<td>
<asp:DropDownList ID="DDlRiskRanking" runat="server" AppendDataBoundItems="True"
AutoPostBack="True" >
<asp:ListItem Value="%">All</asp:ListItem>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
Reference</td>
<td>
<asp:DropDownList ID="DDLReference" runat="server" DataSourceID="SqlDataSource5"
DataTextField="Reference" AppendDataBoundItems="True"
AutoPostBack="True" Height="22px" Width="200px">
<asp:ListItem Text="All" Value="%"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_SelectReference" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
</td>
</tr>
<tr>
<td>
Target Date</td>
<td style="margin-left: 40px">Greater than
<asp:TextBox ID="txtstartTargetDate" runat="server" AutoPostBack="True"></asp:TextBox> Less Than
<asp:TextBox ID="txtendTargetDate" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
</tr>
</table>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_AssignOwner" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="IssueId"
DataSourceID="SqlDataSource1" Width="803px" CellPadding="4"
ForeColor="#333333"
EmptyDataText="There are no matching records to display.">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="IssueId" HeaderText="IssueId" InsertVisible="False"
ReadOnly="True" SortExpression="IssueId" />
<asp:BoundField DataField="BriefDescription" HeaderText="BriefDescription"
SortExpression="BriefDescription" />
<asp:BoundField DataField="DateEntered" HeaderText="DateEntered"
SortExpression="DateEntered" />
<asp:BoundField DataField="EnteredBy" HeaderText="EnteredBy"
SortExpression="EnteredBy" />
<asp:BoundField DataField="Likelihood" HeaderText="Likelihood"
SortExpression="Likelihood" />
<asp:BoundField DataField="Consequence" HeaderText="Consequence"
SortExpression="Consequence" />
<asp:BoundField DataField="Location" HeaderText="Location"
SortExpression="Location" />
<asp:BoundField DataField="Activity" HeaderText="ActivityProductService"
SortExpression="Activity" />
<asp:BoundField DataField="Scope" HeaderText="Scope"
SortExpression="Scope" />
<asp:BoundField DataField="Aspect"
HeaderText="Aspect" SortExpression="Aspect" />
<asp:BoundField DataField="AspectRevised" HeaderText="AspectRevised"
SortExpression="AspectRevised" />
<asp:BoundField DataField="Impact" HeaderText="Impact"
SortExpression="Impact" />
<asp:BoundField DataField="Objective" HeaderText="Objective"
SortExpression="Objective" />
<asp:BoundField DataField="KeyAction" HeaderText="KeyAction"
SortExpression="KeyAction" />
<asp:BoundField DataField="TargetDate" HeaderText="TargetDate"
SortExpression="TargetDate" />
<asp:BoundField DataField="PersonResponsible" HeaderText="PersonResponsible"
SortExpression="PersonResponsible" />
<asp:BoundField DataField="PercentageCompleted"
HeaderText="PercentageCompleted" SortExpression="PercentageCompleted" />
<asp:BoundField DataField="Reference" HeaderText="Reference"
SortExpression="Reference" />
<asp:BoundField DataField="Comments" HeaderText="Comments"
SortExpression="Comments" />
<asp:BoundField DataField="Status" HeaderText="Status"
SortExpression="Status" />
<asp:BoundField DataField="AssignedTo" HeaderText="AssignedTo"
SortExpression="AssignedTo" />
<asp:BoundField DataField="RiskRanking" HeaderText="Risk Ranking" />
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"
SelectCommand="usp_AllIssues" SelectCommandType="StoredProcedure" FilterExpression="assignedto like '{0}' and location like '{1}' and activity like '{2}' and riskranking like '{3}' and reference like '{4}' and targetdate > '{5}'">
<FilterParameters>
<asp:ControlParameter Name="assignedto" ControlID="ddlpersonresponsible"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="location" ControlID="ddllocation"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="activity" ControlID="ddlactivity"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="riskranking" ControlID="ddlriskranking"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="Reference" ControlID="ddlreference"
PropertyName="SelectedValue" />
<asp:ControlParameter Name="startdate" ControlID="txtStartTargetDate"
PropertyName="text" />
</FilterParameters>
</asp:SqlDataSource>
</asp:Content>
View 2 Replies
Mar 29, 2010
I have three parameters to search data and populate to gridview. The parameters are textboxes and dropdowns. These are independent.
If the parameters are not matching and not fectching data from table then the gridview count is 0 therefore I am displaying a message to the user that the "data is not available".
The message I displayed to the user using the EmptyTemplate of Gridview.
I want some enhancement that if the parameters are not matched and there is not data fetch from the table then message should be more specifice like:
txtRegion and lstSection are mismatched.
or
txtRegion and txtLocation are mismatched.
View 7 Replies
Nov 3, 2010
I want to give option to user with two or three search parameters in textbox or dropdownand the result should display in CrystalViewer.
I know how to do this task with gridview but don't know how to do the same with CrystalViewer.
Moreover, can I have a weblink to download Video lecture on CrystalViewer?
View 2 Replies
May 28, 2010
I'm new with all stored procs - but I have a very basic Full Text Search going on...I created a stored proc, and linked it up to my application using Linq to SQL. If I use Linq to SQL to call the stored proc without any parameters (hard coded search string) i get results back, as soon as I add a parameter - the result set is 0 for some reason.
The funny thing is that I run Profiler and execute both queries its trying to do - and it looks identical
Here is the working parameterless query:
[Code]....
and according to Profile this is what it looks like when its called as a stored proc
[Code]....
I get 2 results as expected.
Here is the NON-working stored proc that takes in 1 string parameter
[Code]....
and here is the query that gets called when profiling
[Code]....
declare @p4 int
View 3 Replies
Feb 16, 2011
[Code]....
When I want to get the output values its okay but I also want returning a table as a result data.But Datareader has no rows.is it possible if I want a returning query result and multiple output values togather ?I wrote a test above.I can get output values as sqlparameters. But Datareader attached to a Gridview is empty.can you detect whats wrong here and it doesnt return a query result.So stored procedure is not standart or ı am doing something wrong.this doesnt raise any exception.but not returning any data.
[code]....
View 8 Replies
Jun 7, 2010
I want to define a route that have 2 optional parameters in the middle of the URL the start an end parameters are digits
[Code].....
View 1 Replies
Dec 10, 2010
Since ASP.NET MVC3 RC2 I encounter a bug when posting values to a controller method of which one of the parameter is a nullable int. Steps to reproduce:
I've created a test method
[code]....
In MVC3 RC1 this was working without any problems with the nullable int
Update:
I don't seem to have the problem with a newly created MVC3 website. What could I have in my project that influence model binding to nullable int's? And why would there be a difference between RC1 and RC2?
View 10 Replies
May 12, 2010
I am using jquery ajax method on my aspx page,which will invoke the webmethod in the code behind.Currently the webmethod takes a couple of parameters like firstname,lastname,address etc which I am passing from jquery ajax method using
data:JSON.stringify({fname:firstname,lname:lastname,city:city})
now my requirement has been changed such that,the number and type of parameters that are going to be passed is not fixed for ex.parameter combination can be something like fname,city or fname,city or city,lname or fname,lname,city or something else.So the webmethod should be such that it should accept any number parameters.I thought of using arrays to do so, as described here.
But I do not understand how can I identify which and how many parameters have been passedto the webmethod to insert/update the data to the DB.
View 4 Replies
Jan 27, 2010
I want a word search i doing the search like this , but it is giving character wherever there is in the string,if i give two character like ok it is searching for a full string where ever Ok is there select * from table1 where textfield like '%word%' this query would match word but also wordabc how can i make it aware of delimitions
View 3 Replies
Oct 5, 2010
I am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
[code]....
View 5 Replies
Apr 19, 2010
how to Add Search Control for Detailsview for search page... simple solution required.?
and is it possible to give field names to each page numbering?
View 3 Replies
Nov 26, 2010
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 Replies
Jan 18, 2010
As 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 Replies
Dec 2, 2013
I made a usercontrol consisting of an AJAX tab control, a textbox, and a gridview. The gridview is pulling data from a SQL database. When the gridview is outside of the tab control and I begin to enter text into the textbox, quicksearch begins to filter the information in the gridview. When i put the gridview and textbox inside an AJAX tab control quicksearch does not work. How do i need to structure the textbox and the gridview on an ajax update panel to get it to work?
View 1 Replies
Mar 29, 2010
I am using SQL Server 2008 and Full Text search.
Its working fine for PDF / doc files but not working for .JPG files.
Basically i have some document scanned and stored it in varbinnary datatype in DB.
I am able to search for .doc /.xml /.pdf files .. but not able to search .jpg.
also i am not getting ".jgp" extension in result of following query
SELECT document_type, version, manufacturer
FROM sys.fulltext_document_types order by document_type
View 1 Replies
May 28, 2010
i have some text boxs in a page and in the same page there will be a table 'grid' like for holding the search result.When the user start editing and of the textbox above, the search must start by sending all textboxs values to the server 'ajax', and get back with the results to fill the below grid.
Notes:This grid should support paging, sorting by clicking on headers and it will contains some controls beside the results such as checkboxs for boolean values and links for opening details in another page.
I know many ways to do this some of them are:1- updatepanel around all of these controls and thats it "fast dirty solution"
2- send the search criteria using ajax request using JQuery post function for example and get back the JSON result, and using a template will draw the grid "clean but will take time to finish and will be harder to edit later".
3- ....My question is:What do you think will be the best choice to implement this scenario? because i face this scenario too much, and want to know which implementation will be better regarding performance, optimization, and time to finish.
View 3 Replies
Apr 15, 2010
I can i create a search capability to search profile table?
View 2 Replies
Feb 22, 2010
I have Visual Studio 2005 and 2008 installed on my machine. When I bring up the Find and Replace box in 2008 in any project the 'Look at these file types:' option is blank however in 2005 it keeps defaulting to the file type of RemoveFile. If I don't remember to clear it then it causes my search to fail. Does any one know how do I reset this value or remove this default option so the file type is not set and it looks at every file type when I search for a word.
View 1 Replies
Jan 19, 2011
I have a database filled with information about a bunch of different articles. I'm trying to add a search mechanisim to the site where you would type in what you are looking for, and it would search through the articles finding the most appropriate article. In my database I have a bunch of different fields that will help find the best article. For example, for each article, there is a title, description, category, a bunch of tags, Number of page views, number of votes, and the sum of all the vote scores. All this informaiton i believe can be used to gather the most relevent article based on the persons search terms. The problem is I don't know what to do with this information. What I would like to do is have a scoring system where the highest score is the first result and the lowest score is the last result. Where the first result is the most relevent.
So for example: The user types in "Korean War" it looks through all the articles, and gives all the articles with "Korean War" in the title + 1, all the tags with "Korean" or "War" + .1, then adds the number of views/1000, and then adds the average vote/4. (I just made that scoring system up on the spot, I would need to do some testing of course). Then it would sort the articles based upon the score it recieved. Is there anyway to do this with a select statement where I can run all of the calculations and then sort them with an "ORDER BY" command? Or would i have to have the server side code do the calculations store them in an array, and then sort them in the array? Or is there a better way of doing this that I might not know of (which is certainly possible).
View 3 Replies
Dec 5, 2010
I want to know how can I build a simple search engine which search from specific websites, for example it should search codeplex and msdn only and show the result on my page?
View 1 Replies