In sql2005 or Sql2008, is there any possibility to find since last month, what r the manipution have done in sql (i.e insert ,update,delete, creation in database makuse of any log file). That i need to track this manually.
View 8 RepliesMy intention is to give the user a flexible user control on a master page that does the following:
When navigating, a child page will pass the URL (with querystring) and PageTitle to the user control. The user control will take those two parameters and insert them as a "breadcrumb" object at first index of a List<breadcrumb> collection
This part works fine through the use of a Repeater with a LinkButton contained in an ItemTemplate. The user sees each of the pages he has been visiting in descending order, the provided benefit is a quick way to re-open records they have recently modified or created.
The part I'm having trouble handling is what happens when the user clicks the LinkButton, which is that the child page adds a new reference to the URL at the beginning of the List<> collection and I cannot seem to control the behavior of removing the LinkButton before it gets re-created. What I've tried doing is:
List<>.RemoveAt(RepeaterCommandEventArgs.Item.ItemIndex);
Repeater1.Controls.Clear();
Repeater1.DataSource = List<>;
Repeater1.DataBind();
While that should work, my CreateBreadCrumb(string url, string title) function gets called by the child page before the UserControl detects the Repeater1_ItemCommand event, so in effect it appears that the wrong ItemIndex is being used for removal.
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
In my upcoming project, I need to track GPS device attached to vehicles. Is there any way this is possible through PHP or ASP.Net
View 2 RepliesHow to track downloads with ASP.NET?
I want to find how many users completed the file download?
Also How can make restrict user from specific IP?
for example if a user download [URL] the track will work automatically.
I need on my website to track for a particular page who has visited the page and actually click on it.
Is there a way to know that information as much as complete as possible ?
is it possible to track the URL in browsre. i want to change my DB fild if the part of the URL is samen as i want .
View 4 RepliesThis issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 RepliesI want to monitor the activities of all the folders present at "C:Inetpubftprootsan".User can work on any type of files and not only text files.Since we have given 1GB space (lets say) to each user, so user can do anything to utilize this space.
Now I want to monitor the activites that the user will do in his folder like creating new file, deleting an existing file or editing a file.I want to monitor user's activities because i have to keep track of the space given to the user so tht i can restrict the user to use 1GB space only and not more than that.
is there any class that i can use other than FileSystemWatcher as it works only in console applications and not in webapplications?
I'm trying to write an application that allows a visitor to use our service for 7 days. After 7 days, they will no longer be able to use it unless they sign up. What's the best way and the most accurate way to track it without collecting their credit card information? I'm trying to use the following code to track visiotr's ip. But I'm not sure if people are able to change their ip address or using a proxy server that will go through.
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]
How to track the exception in application. means let say there is enterprise project, If we deliver the project to end user (forget for a while any tester is there/ or in my side who can track this exception). and while navigating or doing any operation , a custom error page occurs, which is define by developer from his web.config file.
then how user will let know to developer that he get something exception while doing particular operation ? How developer can tack this exception without having any kind of debugging. Let say user not allow to deploy again. developer want to track this exception on deployed application. What he must to do. I know we can put try..Catch but need to now particulars..
I've added this in my web.config:
<customErrors mode="RemoteOnly" defaultRedirect="~/Site/Statics/Eroare.aspx">
<error statusCode="404" redirect="~/Site/Index.aspx" />
</customErrors>
Well, in Page_Load method on Eroare.aspx page i try to print to my internal logs the error which caused this redirect but Server.GetLastError() is null...
Do you know why? Or any other solution to get the exception?
I want to put an unique image (1x1) on an e-mail marketing (not spam) of my client. Just like [URL], I'd like to use it to know how many people have actually read the e-mail. I guess I'll have to check how many times this unique image has been accessed, but I can't figure out how to do it.
Is there a way to check how many times an image file was accessed using ASP.NET/C#?
I am populating a table based on a javascript function.I want to limit the data entered to 2, afterwhich I hide the table.Is there a way to track how many hits the javascript code gets hit?
[code]...
I am trying to track the client IP, with this code
vb.net Code : Dim Ip_TcpIp As StringIp_TcpIp = Request.UserHostAddress()
But it is resulting me
::1
I want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I m trying to save files like pdf, word, excel etc... into sql express, but m getting this error in my web page:An attempt to attach an auto-named database for file C:Usersmalek.safaDocuments est vbSavingFileInDBSavingFileInDBApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
m not getting errors inside my code, just this one appearing on the web page.
I have built my intranet using MS Visual Web Developer Express 2008. There are several secured areas and my manager asked me to find out if tracking the traffic is possible. Things that I would need to track include:
Which unique user ID's logged in and when? How many times did the same user login? Last login What info was accessed? What page(s) had the most hits? Would I need a database for tracking purposes? Would this info be available with a "dashboard" interface?
I am redirecting from A.aspx to C.aspx and B.aspx to C.aspx.In C.aspx i have a button "Back Page". I am implementing as below.If there is a better way pls let me know.
In A.aspx and B.aspx before redirecting to C.aspx,saving the LastPageURL in session
Dim lastPage as string = Request.UrlReferrer.AbsolutePath
Dim sArray() as string = lastPage.split("/")
lastPage = sArray(Array.Length-1)
Session("LastURL") = lastpage
On click of Button "Back Page" in C.aspx
Response.Redirect(Session("LastURL"),True)
I am recording time taken by a page to be displayed to user, for which I am recording execution end time in page_PreRender. But if the page contains huge amount of data, then it is taking few more seconds after PreRender event. I also tried with Page_Unload, still the same.
View 5 RepliesI'm curious, anyone know the mechanism a checkbox control uses to remember that its checked or not checked after a postback?If I add them manually to a page via html as in <input type="checkbox"/> I have to use javascript and hiddenfields to keep things checked after a postback and I would have to have an onclick="dosomething()" inside the tags.Viewing the html source code for a page with a .NET checkbox control, there is nothing like that there.
I was writing a custom control and rendered my own checkboxes when I came across this problem. After the postback, the control would reload the checkboxes from viewstate and forget the user had clicked anything. As I couldn't use hiddenfields to track the changes (they got reset from viewstate too), I ended up using .NET checkboxes as childcontrols instead but this experience got me thinking.
I want to save each request to the website. In general I want to include the following information: User IP, The web site url, user-if-exist, date-time. Response time, response success-failed status. Is it reasonable to collect the 1 and 2 in the same action? (like same HttpModule)? Do you know about any existing structure that I can follow that track every request/response-status to the website? The data need to be logged to sql server.
View 3 Repliesi want to know that from which pages my current page has been called in ASP.net As for example I want the track of page named "hero.aspx" and it has been called from "Zero.aspx" and "Zero.aspx" has been called from "one.aspx" So i want output as whole page called hierarchy.How can i get this in asp.net
View 3 Repliesusing vs2008, asp.net, c# .net3.5 In this control;s ActiveTabChanged event, the ActiveTabIndex property stays 0 no matter which of the 3 tabs I select. Why is that? I want to keep track of which tab the user has selected and store this in the seesion variable so when refresh or bookmark by the user is would done properly. I was advised to possibly do this by saving the ActTab instead of the ActiveTabIndex. The problem then is how do I set the ActiveTab of the Tabcontainer, I mean how do I cast the Seesion variable so I can assign it like tabScien.ActiveTab = (castType)(Session["SavedActiveTab"]);