I'd like to change my routes so that instead of having:
/Users/Edit?UserID=1
I can do
/Users/Edit/1
How can I create a custom route to do that?
Also, can someone direct me to a good tutorial on routes? I don't wanna create a post every time I have a simple problem with routes.
I am trying to retrive the query string value and display it on the aspx page. The query string is passed from a gridview. Everything works fine except i noticed that when there is an '&' in the query string then the label on the page will display only uptil the '&' (i.e. excluding the '&'). Just so to let you know. I retrive the value of the querystring into a string variable and then assign it to the variable. I have noticed this only for '&' character but maybe there are more characters with sinmilar bahaviour that I am not aware of.if anyone has a workaround on displaying all the content from the querystring then do share.
View 4 RepliesI have the following attributes in my table
[code]....
how do I create sql query to find out the number of times participant A took part in the club activity?
Well, i know the title isn't very specific, but i couldn't find a better succint description of what i'm looking for.i want to have a default.aspx so that when a user types:
http://www.mydomain.com/randomstring
i can use the randomstring to query a table on page load. More specific:
. I will be importing batches of users to my database through a csv file.
. in that process, a random string will be generated
. i will send that url to each user by email
. when the user clicks through that link, i want my aspx(c#) to interpret that string, query a table that gives me a second url, this one with querystring, and Redirects the user to that second address
How can I pass a paramator to another page without using Session variables or passing the Querysting in the URL?
I want to create a variable on my Page Load Event............
I am thinking about using a DataSet to perform some operations but I wonder if it can be used as a regular table in a query. For example, I have the following code which updates a table named "listas_pre_titulos". Is it possible to use a DataSet instead? What I need is to build a "temporary" table on the fly and use it in a regular query and I do not know if a DataSet is an option or maybe I would need to CREATE such a temporary table.
[Code]....
does anyone have a complete example in ASP.NET VB to find move a User in Active Directory From one OU to another,
View 5 RepliesI'm working to move my simple asp.net website to a three layer architecture. Currently I have Linq queries like the one below in my code-behind files. Basically this code snippet retrieves a collection of customer data from the database and then binds it to a grid control.
I'm wondering if someone can guide me on how to rewrite this in order to move it to my newly-created data access layer. I'm thinking I will turn it into a class (e.g. GetUserBoxesByStatus()) that can be reused throughout the site.
var boxes = from p in sbm.Packages
where p.UserID == CurrentUserId && p.StatusID > 1 && p.StatusID < 3
select new { p.PackageTag, p.PackageName, p.DateReceived, p.DateShipped }; [code]....
Some of the options that I've investigated but have not had success implementing are the following:
DataTable --- returning a DataTable seems like the best solution but it also appears to require a lot of potentially unecessarry code to define a table (isn't the data source already mapped in my Linq 2 Entities dbml?)
IEneuerable --- I think I could pass an IEnumerable list between the layers but after reading many tutorials about Linq I'm still a little lost DTO --- Conceptually I think I understand what a DTO is but I am not clear on how to begin implementing this approach POCO --- Again, the concept seems logical enough but I don't know how to put this into practice
how they would tackle this using one of the above or some other solution.
I have a number of automatically generated data access classes to handle things like inserts & updates. These look like:
cmd.CommandType = CommandType.Text
cmd.CommandText = "UPDATE myTable set f1 = :f1, f2 = :f2, f3 = :f3 where id = :id"
cmd.Parameters.AddWithValue(":f1", _f1)
cmd.Parameters.AddWithValue(":f2", _f2)
cmd.Parameters.AddWithValue(":f3", _f3)
cmd.ExecuteNonQuery()
If I were to re-write the sql to do what I want, it would look something like
cmd.CommandText = "UPDATE myTable set f1 = pkg.getMyValue, f2 = :f2, f3 = :f3 where id = :id"
Is there any way to do this by setting _f1 to a "special" value, without changing the update SQL or the way the parameters are set? Only in certain cases will I need to set the value of f1 - most of the time, it will be null.
Using .net 2.0, and system.data.oracleclient against oracle 11.
i have a website that use globalization to several languages (VB Framework 4.0)
i need to get all languages exist in App_GlobalResourses directory because i don't know in future the website owner will add or remove some languages
for that i try to access in App_GlobalResources folder and i list the existing files in there now i have an array of fileInfo but i don't know how can i get some part of the file name
it return "General.resx", "General.en-US.resx", "General.fa.resx" and so one...
Could someone giving me the correct T-SQL query to update the Date part from a DateTime field?
To be more clear:
In my table i have 3 Columns, (all are DateTimes):
1. Date
2. StartingHour
3. EndingHour
This is for example one record:
2004-01-26 00:00:00.000
Is it possible to create a route, who accepts a random number of Categories/subCategories and is still able to understand /ProductID/ProductName where Product ID is an int and ProductName is a string.
[Code]....
Perhaps using a custom route handler.
in my database table there are 200 records.in description column record value is like .....
sometextLASER
sometext1LASER
sometext2LASER
i want to delete LASER from every record using sql.can enyone tell me how to do it.
I have this string: "NT-DOM-NVMTA" How can I delete the first part: "NT-DOM-NV" To have this as result: "MTA"
View 6 RepliesExample:
[URL]
I added the iis tag because I am guessing it also depends on what server technology you use?
Let's take this string has an example:
D:/firstdir/Another One/and 2/bla bla bla/media/reports/Darth_Vader_Report.pdf
I want to cut the first part of the path:
D:/firstdir/Another One/and 2/bla bla bla
And replace it with **../**, and keep the second part of the path (media/reports/Darth_Vader_Report.pdf)
If I knew the length or size of it, I could use the Replace or Substring. But since the first part of the string is dynamic, how can I do this?
Update
After StriplingWarrior question, I realized that I could have explained better.
The objective is to replace everything behind /media. The "media" directory is static, and will always be the decisive part of the path.
I need to create a web page where the user can select from a variety of categories via a dropdown list, then enter a search term into a textbox to provide a search term. The category is going to dictate which controller to use, and the search term will be a query parameter for the List action of each controller.
What I can't figure out is how to dynamically create the route based on the users selection. How do I get the values selected from the dropdownlist and textbox into Url.RouteUrl?
Why is it that a simple string inside a webpart not showing when the application is run ? Actually my requirement is to use a fusion (usually called as a function) and Visifire chart (usually called as a function from javascript) in web part which i'm not able to consume at all.
View 5 RepliesI am using ASP.NET 2.0 and C#.
I have a html table, which has 2 rows and 2 columns.
I want to create web part zones for these 2 rows and 2 columns.
For each td, i want a web part zone, so that users can move data across the table.
How to create web part zones for the td?
I m facing some problem. i m not passing Dynamic string through query string..
I m using this code
string abc = "CPCB_" + TextBox1.Text + "_" + TextBox2.Text;
Response.Write("<script>window.open('xml.aspx?Flag=3&date='+abc,target='new');</script>");
I have a table1 with first column having: usjim, uskim, uspeter, john ....
I need to insert this column into table2 excluding us if contains any ( extract substring basically)
I have tried doing this but doesn't work
[code]....
I tried to mix asp.net 4 webfrom and ASp.Net MVC 3. I add required lines in webconfig, but I've issues implementing route in global.asax
Currently I use several routes for webfroms. routs template are like below
routes.MapPageRoute("Node", _
"article/sport/{nID}/", _
"~/article/articleview.aspx")
I encounter error, when I add below lines to global.asax
routes.MapRoute( _
"Defaultss", _
"{controller}/{action}/{id}", _
New With {.controller = "Home", .action = "Index", .id = UrlParameter.Optional} _
)
I want to know how could I mix ASp.Net MVC routes with webforms routes.
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
Programmatically i am planning to move multiple files, Is it possible to move multiple files to a folder "d:MyTempFileFolder"
and create a compressed zip file of all files which are in this folder: "d:MyTempFileFolder" and then will try to download it.
using asp.net / sql server on windows 2003 server
Is It Possible to send a string consists of (,.&') in a query string ?
View 7 Replies