EntityDataSource Replace * With % Wildcard On Queries?
Jan 8, 2011
I have an application that uses EntityDataSource in many places. In the EDS, I manually build the Where clause based on user input from TextBox'es.
I would like the user to be able to enter "*" (asterisks) instead of "%" when querying data.
Is there an easy as using Entity SQL or the EDS itself to do a search/replace? I know I could actually change the TextBox after the data is entered, but when the user sees his text was changed from an * to a % I don't think he will understand.
I have tried using the T-SQL Replace command and doing something like this:
I need to replace <span> entries in a string to legacy html code because it's going to be used in a report for Crystal Reports. <b> works with Crystal, but the<span>'s do not.
Here's the string which I'm trying to replace: <span style="font-weight: bold">%THIS CAN BE ANY TEXT%</span>. I want to replace it to
My students are working on an ASP.net VB application for a Web Programming competition and we are having problems with a page where we want an URL string to return all values from our database.
Here is the page:
[URL]
If you use the jobs by category menu on the left side, if you select a job category (ie retail) it will pull up all the jobs from that category. By using a query in the URL like this:
[URL]
What we need is the URL that would show all jobs regardless of the category. I'm not sure how to do this with asp.net VB. I'm sure it's probably not all that hard, we just don't know the syntax to make it happen.
If you cannot turn on wildcard mapping for IIS (shared hosting) or can't be bothered (lazyness) can you still use ASP.Net routing if your routes end in one of the "known" asp.net extensions...like ending all routes with .ashx, .aspx etc?
From Chris Cavenagh's blog, could his examples of:
[code]...
I'm presuming so as his last route is Default.aspx, but he hasn't included any route data with that...Is there a better way? Provided this works, it looks like the best as if the application is moved or wildcard mapping can be turned on, only the routes need to change...
I'm working in a shared hosting environment, so my access to IIS is limited, but I need to know if I even need full access to IIS to use extension-less URLs the way I'm using them.
Basically I'm just calling a RewritePath() in the Application_BeginRequestion() method in the Global.asax.cs file... something like this:
Here is an interesting problem... I have configured wildcard domains on my production site and will be using it as a customer identifier. This allows me to display the right banner/css/logos for each customer simply be pulling out the wildcard prefix (eg. CompanyABC.website.com will be displayed the logos and branding related to CompanyABC).
But how do I test this on my local Visual Studio 2010 installation? In production the site loads COMPANY.website.com etc., but locally I can only use the flat http://localhost address.
I have a table in the db with one column containing a URL like http://site.com/users/*/profile.I am given a URL (like http://site.com/users/234/profile) and want to select all the rows in the db that match the url (in this case * is a wildcard).
I was thinking of using Regex to do this, by replacing the * with regex for any character. But am unsure as to what the SQL or LINQ code should be for the selection.
I had a look through some of the older questions, but I can't find anything.I have a Wildcard HttpHandler on my web app which is processing the url and working out if it can do anything with itIf it can't, then the StaticFile Handler should pick it up and just serve it as a static file (like an html file).The problem is, it's going through the Wildcard handler, then seemingly not going to the StaticFileHander. Is there something I need to do to the Wildcard handler, or in the web config?This is my web.config:
I'm trying to use a RegularexpressionValidator to match an IP address (with possible wildcards) for an IP filtering system.I'm using the following Regex:
"([0-9]{1,3}\.|\*\.){3}([0-9]{1,3}|\*){1}"
Which works fine when running it in LINQPad with Regex.Matches, but doesn't seem to work when I'm using the validator.Does anyone have a suggestion as to either a better Regex or why it would work in test but not in situ?
[ServiceContract] public interface IRest { [OperationContract] [WebGet(UriTemplate = "/test")] int Test(); }
With the following web.config:
[code]....
EDIT: You can all reproduce this by creating a new WCF Service in VS2008 (new Project > WCF Service Application). Browse to the dummy method ('GetData')... you will notice it returns 400... that's fine because it shows it's still forwarding to WCF. However, if you enable wildcard mapping in IIS6 you will now get a 404, meaning WCF is no longer intercepting the request.
and rename all columns with some prefix, rather than having to name columns individually? Or better yet, when doing a join and getting all columns from both tables, how do you identify them uniquely in the VB where some columns have the same name?
I have a requirement to add specific functionality to an asp.net mvc2 web site to provide addtional SEO capability, as follows:
The incoming URL is plain text, perhaps a containing a sentence as follows
"http://somesite.com/welcome-to-our-web-site" or "http://somesite.com/cool things/check-out-this-awesome-video"
In the MVC pipeline, I would like to take this URL, strip off the website name, look up the remaining portion in a database table and call an appropriate controller/view based on the content of the data in the table. All controllers will simply take a single parameter bieng the unique id from the lookup table. A different controller may be used depnding on different urls, but this must be derieved from the database.
If the url cannot be resolved a 404 error needs to be provided, if the url is found but obsolete then a 302 redirect needs to be provided.Where the url is resolved it must be retained in the browser address bar.
I have had a look at the routing model, and custom routing and can't quite work out how to do it using these, as the controller would not be predefined, based on a simple route. I am also unsure of what to do to provide 404, 302 back to the headers also.Perhpas I need a custom httpmodule or similar but going there went beyond my understanding.
I have a user specified URL that has a wildcard in it, e.g. http://site.com/project/*/accountIn this case * could be anything, a number, a character or anything else. I want to get regex that would find a match for that. The location of the wildcard * changes and could be http://site.com/user/*/title or http://site.com/user/*/*/*/delete (just as an example, depends on the site ... so all possibilities should be supported) Then comparing that with the current URL to see if it is a match.
I have a simple ASP.NET (Web Form) application. I created a separate project for my DAL. In the DAL, I have created an entity called Sites.
Now, I want to bind that to a form using an EntityDataSource control but it isn't visible. What am I doing wrong?
I made sure to reference the DAL.dll in the web project and include it in the code behind for the form. It's been a while since I've been in ASP.Net :-)
What my code does is that the EntityDataSource has a Where Parameter tied to the first DropDownList and it populates the second DropDownList, but when the first DDL changes, the EntityDataSource doesn't change the values of the second DDL. Worth mentioning this is inside a ModalPopupExtender which is inside an UpdatePanel. Maybe there is a way in just putting all the data in the second DropDownList and filter it depending on the value of the first one... or something like that... so there's no need of refreshing the data.
I'm utterly new to APS.NET and in particular the MVC model...! I have a Telerik RadGrid control that I'm using. Until now (following NerdDinner) I was having the Model passed back to the view and this provided access to the various properties I wanted.
.. lets me loop around the Model object and extract Customer data. This RadGrid control, however, needs me to use an EntityDataSource (hooked up via the designer). Does this have implications for maintaing the MVC pattern? I'm a little confused about how the EntityDataSource works in relation to my Model.EDIT: I do know there is an MVC version of the RadGrid but we also need the RadScheduler and a few others.. besides that, I'd still like to know the impact.
I have a GridView with DataSource an EntityDataSource web control.
I would like filter Data using EntityDataSource, filter show apply for the Current Logged-In User, this value should be taken using MS Memebership Provider ( Membership.GetUser(); ).
Now I cannot inf any Parameter in EntityDataSource that would allow me to dot that (in Where/Automatically generate a Where expression using provided parameter ).
I have a table in SQL fro "Categories" and I need populate a TreeView in my Asp.net page.
My question are:
1 - How can i populate the TreeView? 2 - How can i use the TreeView to modify the hierarchy of my Categories?
NOTE: I use "hierarchyid" SQL Columns!
CREATE TABLE dbo.CmsCategories ( CategoryId int NOT NULL IDENTITY (0,1) -- Seed = 0 and Increment= 1 CONSTRAINT PK_CmsCategories_CategoryId PRIMARY KEY, Title nvarchar(40) NOT NULL, MetaDescription nvarchar(160) NOT NULL, MetaKeyword nvarchar(128) NOT NULL, Summary nvarchar(256) NOT NULL, IsPublished bit NOT NULL CONSTRAINT DF_CmsCategories_IsPublished DEFAULT 1, CategoryNode hierarchyid NOT NULL, CategoryNodeLevel AS CategoryNode.GetLevel() );
