I'm creating a webpage with serveral web controls to set search parameters for querying an SQL table. My plan is to use a TableAdapter to hold the query. If the user decides not to use one, several, or any of the web controls to filter their search, I want the SELECT to execute without complaining that it doesn't have parameter values. Should my SQL query look like
[Code]....
I have a GridView bound to an DataSource query with parameters tied to form controls.What is the standard / best-practices way to handle optional query parameters?
View 3 RepliesI've already implemented URL routing in my app but there are cases where I may or may not get a paramter. In particular, I'm trying to come up with a good way to handle multi-language support. For example, if my regular URL is /SomeCategory/Friendly-Topic-URL, I want to have an optional language selector at the end but I'd like to be optional. So, if I get /SomeCategory/Friendly-Topic-URL/es, that should bring up the topic in Spanish but if get nothing, that should bring up English.
View 6 RepliesI have a data grid with a lot of information on it - to easily filter the data, I would like to be able to pass parameters to it. My problem is that I do not want the parameters to be required. So if I just put 1 or 2 of them in the query string, I would like for it to return all of the data related to those two parameters.I am using a data grid & stored procedures:My Stored Procedure looks like this:
[Code]...
I have a TableAdapter that consists of an SQL SELECT query.
Need to create an "if" statement that checks to see if the query returned any records.
Tried "HasRows" but Visual Studio 2010 says: Error 2 'Maine_Innkeeper_Site_2010.App_Code.DataAccessLayer.MaineInnsDataset.membersDataTable' does not contain a definition for 'HasRows' and no extension method 'HasRows' accepting a first argument of type 'Maine_Innkeeper_Site_2010.App_Code.DataAccessLayer.MaineInnsDataset.membersDataTable'
could be found (are you missing a using directive or an assembly reference?) E:Ed dataclientsMaine InnkeepersMIA website 2010Maine Innkeeper Site 2010lodging-search-output.aspx.cs 49 83 Maine Innkeeper Site 2010
What's the proper way to check if HasRows is wrong?
[Code]....
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].....
I am trying to show a Gridview that lists information in a database based on a query. The query takes a parameter of a string, how do you define what this parameter is. An example of the screen I am stuck at is:http://static.asp.net/asp.net/images/dataaccess/07fig08cs.pngAn example of the code i want to use is:parameter for my object data source select query = OBDS_Query_ParameterOBDS_Query_Parameter = str;
Sorry Im not sure how to explain it...For instance if I have a query that GetAllProducts(String userName); How do i pass or define what userName is when using the data gridview. I am using an Object DataSource and linking the data Gridview to that. I can do this without the object data source and strictly melodramatically like this:
quartz_SongsTableAdapter songsAdapter = new quartz_SongsTableAdapter();
CurrentRole = "admin";
GridView1.DataSource = songsAdapter.GetSongForClient(CurrentRole);
GridView1.DataBind();
I have an asp.net site which includes a "search" page that queries an SQL table, then redirects the user to a "results" page where the results of the query are displayed. The parameters for the query are assembled into a string which is the SELECT statement. I've been asked to add additional functionality that requires a secondary search which takes place on the "results" page. How can I pass the parameters from the "search" page to the "results" page so that I can access those parameters in the code behind? Here's the first page code behind (I inherited most of this from another developer):
[Code]....
And the second page--it would be on line 51 that I would need to insert the parameters from the search above:
[Code]....
What is the best way to handle following situation? A dropdown(for master table) is optional in a particular form. But, In database table the field is constrained with foreign key. If user don't select from dropdown then It creates problem because of foreign key. One solution is to create default option in master table and use it in case of blank selection. but in dropdown, we need to handle this to show on top. Is it perfect solution?
View 1 RepliesI have an MVC action on my abstract BaseControlller like this (and this action is common across all inheriting controllers):
//
// GET: /controller/RenderForm/{formType}
[Authorize(Roles = "Administrators")]
public ActionResult RenderForm(FormType formType, BaseContentObject contentObject)
[code]...
I want to create a method with optional parameters in my wcf service. I am doing it like this
[Code]....
When I try to use it in my client application and try to pass the values only for first two parameters it gives me an error that"Argument not sepecified for parameter Status"
I am creating a DataSet to attach to a report (*.rdlc). In the DataSet is a TableAdapter that has the GetData(@start, @end) function. Can someone please explain how I get values in to @start and @end? I have searched and seen that it might have something to do with overriding the Fill function in the DataSet code behind file. Please let me know.
View 1 RepliesI have a controller method that is called with many different combinations of URL's. To overcome issue i am using optional parameters.here is my controller method signature...public ActionResult localMembersSearch(string Gender, string calling, [Optional]string Region, [Optional]string County, [Optional]string Town, [Optional]string queryvalues)the first two parameters are not optional but always expect
View 1 RepliesI want to add optional parameters in my routing table.For example I would like the users to browse a product catalog like this:http://www.domain.com/browse/by-category/electronics/1,2,3 etc
routes.MapPageRoute(
"ProductsBrowse",
"browse/{BrowseBy}/{Category}",
"~/Pages/Products/Browse.aspx"
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 RepliesI'm using the iis7 URL Rewrite module and it's working fine, except for two things. Being new to this, I might be missing something obvious.
1) My URL gets converted from www.mysite.com/search.aspx?fName=John&sName=Smith to www.mysite.com/John/Smith. This works fine, but if I add a trailing / , a few images on the site disappear, wheras a few don't. (They're all in the same location). However, the search results are fine.
2) Is it possible to make cerain querystrings optional? Server side, this is implemented (i.e. if nothing is entered, then assume a default value). But how would this work with the URL rewrite module? e.g. www.mysite.com/John would search for John and use a default value for the sName parameter.
I have the following JSON class I am intending to use to perform management calls on my database asynchronously:
<script type="text/javascript">
var CalendarManager = {
defaultOptions: {
staffcode: 0, // required
date: 0, // required
[Code]....
Basically, my question is: how do I specify optional parameters to a WebMethod when providing JSON data?
I know I can reduce the parameters down to just the required values, and then use HttpContext.Request.Params to read the values of optional paramaters, but I would have thought the way I have tried here should have worked.
EDIT
The XMLHttpRequest.responseText value for the error is:
Invalid JSON primitive: staffcode.
This is throwing me even more off the scent of the problem :(
I am currently making a website on asp.net and i am creating methods using TableAdapter. I am connected to MySql using an ODBC connection. The select * from department will work perfectly for me but when trying to use parameters i am given an error message on the wizard. select * from department where name = @name gives me the error: Error in where clause near '@' unable to parse query text. also tried select * from department where name = ?: this gives me the error: No mapping exists from dbTypeObject to a known Odbc type.
View 3 RepliesI get a 404 error when I navigate to the following URL using the route below:
http://localhost:53999/properties/
However, all the following are correctly routed to the List action in my controller:
http://localhost:53999/properties/usa/new-york/manhattan/12
http://localhost:53999/properties/usa/new-york/manhattan
http://localhost:53999/properties/usa/new-york
http://localhost:53999/properties/usa [Code]....
In PropertiesController.cs: [Code]....
It looks like it should just go to the default controller/action,
In my stored procedure I have declared some parameters as NULL values(Optional Parameters).
In my C#.NET code I didn't use the parameters to pass values to Stored Procedure's NULL
Parameters. So I am getting Exception.
I don't want to pass parameters from my code.Because I have declared 30 parameters in my
Stored Procedure as NULL values.
Is there any other way to execute Stored Procedure from Front End without passing values to
Optional Parameters in SQL stored procedure?
I have a quite baffling problem. I've created a Table adapter with 3 queries. 1. GetMemberData() - Return ALL rows. 2. SearchMembersLastName(@q) - Return specified columns from rows that have a column starting with a specified letter. 3. GetMemberDataById(@id)
- Return all rows matching a specified ID.
The Problem is that SearchMembersLastName(@q) is returning ALL coloumns instead of just the ones I want. Here's the query that's in the Table Adapter:
[Code]....
The problem is that it is acting like:
[Code]....
Here's the code that's calling it:
[Code]....
I just can't figure out why this is happening, any help will be greatly appreciated.
I have a webpage that displays the results of a query on a table. The resulting list is sorted by town:
New York
Hyatt Regency Waldorf Astoria
Paris
Hotel du Louvre Hotel Le Meurice
I've been asked to add to this list another sublist of nearby hotels. The intended result is:
New York
Hyatt Regency Waldorf Astoria nearby hotels:
hotel 1 hotel 2
Paris
Hotel du Louvre Hotel Le Meurice nearby hotels:
hotel 3 hotel 4
I've got a TableAdapter set up in VS2010 so that I can query the table for nearby hotels with "@town" as the parameter. So at the end of each list of hotels in a town, I need to display the results of this query.
If the query turns up no records (no nearby hotels), I don't want to display anything. If it turns up 1 or more records, I want to display the list of nearby hotels.
I am trying to set up a conditional "if" statement that checks to see if any records returned but am getting an error when I try to build:
Error 3 'Maine_Innkeeper_Site_2010.App_Code.DataAccessLayer.MaineInnsDatasetTableAdapters.membersTableAdapter.GetNearbyProperties(string)' is a 'method', which is not valid in the given context E:Ed dataclientsMaine InnkeepersMIA website 2010Maine Innkeeper Site 2010lodging-search-output.aspx.cs 49 49 Maine Innkeeper Site 2010 [Code]....
I am creating a TableAdapter using corresponding wizard, with a GetDataByID() query. The select statement is like this:select * from books where ID = ?Thus books are filtered by ID. But in case a null is passed as a parameter, I want to select all records rather than none. Could you please tell me how I can do it?
View 4 RepliesI'm pretty new to C# and ASP.NET, so bear with me on this one. I'm setting up a page that receives query strings from the url. It then passes these strings to another method (in another class, actually), which goes on to do lots of things depending on the value of the query string.
The general structure looks something like this, where DoSomething() is actually part of another class that will be used by lots of different pages:
pretected void Page_Load (object sender, EventArgs e)
{
DoSomething (Request.QueryString["name"]);
}
public void DoSomething (string UrlVariable)
{
// if UrlVariable isn't set, initialize it to some value
// do stuff with UrlVariable
}
Here's what I'm wondering:
If the query string "name" isn't defined in the url, what does Request.QueryString return? an empty string? null? If it returns null, what happens if I try to pass null to a method that is expecting a string? Does the whole program fall apart, or can I check for null inside the DoSomething() method (after receiving the null string)?
The "name" is optional, so if the user doesn't set it, I'd like to detect that and initialize it to some default value. If possible, though, I'd like to put any validation inside DoSomething(), instead of doing the check on every page that requests the string.
I have a form that searches for images in a database. I have several DropDownLists with various search criteria e.g. Genus, Photographer, State, Project.I'd like the user to be able to filter using any combination of these. For example they might pick a specific photographer and a specific genus but choose not filter by project or state.I'd like to find a good, clean, elegent way to do this.Here is an example of the code I have now, it has only two possible criteria. It works but I have a feeling there are better ways to do this....
[Code]....