I 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?
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.
In my application when I click on one of my button in the page it is giving error like this..
Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.IO.DirectoryNotFoundException:
Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
There is No folder ("EnterTrailorVideos") in my project. But it is showing like this .
This the code:
string path = Page.MapPath("../../User/VideoOut/"+sFile);
FileUplvideo.PostedFile.SaveAs(path);
Session["oldfile"] = path;
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 RepliesCould 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
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
One of the test case requirement is to run the same query ie URL for N number of times. Consider a google search that will have a text box and a Search button. I want to search a string such as "Test API" for N number of times. I can't do this test manually because i have to refresh the browser or hitting the button for so many number of times. I know, we will be getting the same results but that will change the page ranking. Is there any script available to automate this test case in C# or any language?
View 1 Replieshow to find and replace substring in select query
DATA RELEASE FORM $LSB$DRF$RSB$
I am getting frustrated with this problem, I dont know what i did, but now I cannot execute any stored procedured when I could last time.When I use my asp.net application to run the query, it finds the stored procedure but when I execute it is sql management studio it says it cannot find the stored procedure even though it is there.I tried to execute other procedures and the samething happens. Even when I try a simple query it says it cannot find the tableI could execute the query if i placed Use [databasename] in front, but even with this, I cannot execute stored procedures.
View 12 Repliesquery to find the 5th highest salary from an employee table?
View 2 RepliesI'm developing my own forum, and now I've come to the task of replacing text with smileys (such as colon and left parethesis to a smiling ball). this works well with the Replace function, such as
dim smile as string = "<img alt=""smiling"" src= ... "
txt = txt.Replace(":)", smile)
myLabel.Text = txt
However, I'm worried about speed, because this approach means running Replace on every message a bunch of times (each for each emoticon, quote amrking etc). Is there a smarter way to do this, or is this the reason why forums are, in eneral, so slow?
I have a download page with a linkbutton that users use to download files. The event handler of the linkbutton sets up the Response type for the user to see the download dialog and chose to save it. I need to find out accurately how many times the file has been downloaded. If I increment a counter in the link button's event handler, I'd assume it wouldn't be accurate as the user may chose to click on Cancel in the download dialog.
Where exactly do I need to hook this counter incrementing logic?
I'm a newbie here. I have created a custom control that requests a set of data from a user. However, I want to be able to have a variable number (dictated by the user) of these data sets entered on each page. How can I create and refer to a variable number of instances of a user control on a single page? It's hard to explain in words, but I'm basically looking for some way to do what amounts to the following:
[code].....
Is there a straightforward way of doing this? I haven't been able to find a clear answer via Google, which brought me to this group.
Is there a way to inherently/manually log the number of times a specific file is accessed in an ASP site. For instance, I've got a few .mp3 files I have on my server and I would like to know how many times each file has been visited.
What's the best way to track this?
I want to be able to use a gridview in asp.net 2.0 that is bound to a datasource. That's no problem. The first column in the gridview is a manufacturer part number. This data is going to be a link. When the user hovers over the link I want to have a tooltip immediately show up in the form of a bubble or balloon tooltip. The tooltip widow should point to another page that loads the detail information from the database for that part number.
View 1 RepliesI have an issue trying to connect to a mapped drive from an asp.net application.I tested my code on the development machine and it was successful.
[Code]....
"z" is a mapped network drive. My web servier is a virtual server Windows 2003 R2.When I try to create the dirctory on z drive I got the following error.Could not find a part of the path 'z:uploadsuser1-timenowIF I change the path from "z" to local drive like "c" it works fine.I tried to use Impersonate true to one user account ("let's call webuser which has full access to that z drive") and I still get the same error.
I have been learning ASP.NET my self and is about to dive into the nitty gritty by creating a club website for a club.
It will be basically pretty simple. It will have around 4-6 pages consisting of:
1. Homepage/News
2. Gallery
3. About
4. Contact
5. Calendar for events
My question is should I use MVC to develop such website? As I am totally a noob in MVC development, but if it is better then I would need to learn MVC first, otherwise I'll just do it the standard way.What should I use for the calendar of events?
In a website, if I have a class:
[code]....
How many times the query will be compiled? Every time the page loads...? Once in the application...?
I'm trying to create an XmlReader class instance to read an xml file. However I pass it a url for the xml file but it isn't resolved. what do I have to do to get the proper url?
[Code]....
I have an asp.net c# web forms application that uses a file upload control to load documents to a specific folder. The location to upload the file is ~Assignmentsassignment_docs.
The error code is:Could not find a part of the path 'E:webmeAssignmentsassignment_docsfilename.xlsx'.The following is the code behind:
protected void btn_fuc_assnmt_doc_Click(object sender, EventArgs e)
{
int i = 0;
string filename = fuc_assnmt_doc.FileName;
if (fuc_assnmt_doc.HasFile)
{
while (System.IO.File.Exists(Server.MapPath("~/Assignments/assignment_docs/") + filename))
[code]...
This works just as expected in dev on my localhost, but I get the error when I try it on my Winhost server.Is there an issue with the code or possibly with my IIS settings?
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]....
Error : Could not find a part of the path 'C:Images2.jpg'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:Images2.jpg'.
Source Error:
Line 86: pdfDoc.Open();
Line 87:
Line 88: htmlparser.Parse(sr); Line 89:
Line 90: pdfDoc.Close();
I have a direstory Created by Name of Webimage... Now i enter a directory name in textbox.. The directory should be created inside Webimage and data should be stored in that folder. But its not working
Could not find a part of the path 'C:UsersArjunDownloadsCompressedWebsiteWebimagesasasaRaspiBoard.png'.
string directoryname = TextBox1.Text.ToString().Trim();
HttpFileCollection hfc = Request.Files;
for (int i = 0; i < hfc.Count; i++) {
HttpPostedFile hpf = hfc[i];
string filename = Path.GetFileName(hpf.FileName);
[Code] ....
I convert my webpage to pdf i got this error
Server Error in '/POD/POMLNT' Application.
--------------------------------------------------------------------------------
Could not find a part of the path 'c:windowssystem32inetsrvPOMLNTImagesPhotos333827.jpg'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'c:windowssystem32inetsrvPOMLNTImagesPhotos333827.jpg'.
Source Error:
Line 270: PdfWriter.GetInstance(pdfDoc, Response.OutputStream)
Line 271: pdfDoc.Open()
Line 272: htmlparser.Parse(sr)
Line 273: pdfDoc.Close()
Line 274: Response.Write(pdfDoc)
Source File: D:websitesDevelopmentalPODPOMLNTPOMLNTonepage.aspx.vb Line: 272
How to create two primary key in a table using sql query and manually?
View 3 Replies