SQL Server :: Want To Capture The Region/Location Information ?
Dec 31, 2010
I have a requirement for my client (100000/1 Lakh users) for a Asset Tracker portal (Laptops/Desktops) where in I have a show the Asset (Laptop/Desktop was with whom and currently with whom) history (Trace Infromation) on a Report. There might be a n no of users who have used the same laptop.
From the beginning till the end of the life cycle of an asset, the trace of asset owner needs to be captured thoughout.We need to show the asset history report in a single row of data.e.g: Laptop was with A then with B and then with C and Currently with C. Not alone user history we also need to capture the Region/Location information of the asset and certain other things too.
how to implement this since there are lot of assets which needs to be registered in the portal.I am using SQL 2005.
View 14 Replies
Similar Messages:
Sep 30, 2013
Just to avoid misuse of website i have to make it specific for certain region. Like people could view menu across the world and only the people of mumbai can order online. I want a submit button that would be visible to only mumbai people.
View 1 Replies
Oct 21, 2010
I'm working in a website that is going to work like a landing point, providing a specialized service for many other websites. Users log-in to different sites and those sites have links to my website.
Now, I want to create my website using asp .net, and also I want to be able to use SSO (Single Sign-On) so the users doesn't have to authenticate again when they land on my site.
The problem is that most of the websites that are going to use the services of my site are in php, when users login on these sites, all the authentication process is handled and also a lot of data is fetched into the Session variable; what I want to do is to be able to capture all the data in the session variable coming from the php page, in my asp site.
So far, the only thing I've been able to do in the asp is, ask for a parameter in the url and using that parameter query the database to get all the data that was already in the session in php.
View 3 Replies
Feb 12, 2011
Similar region in C#, is there stuff available for MS SQL?
View 1 Replies
Mar 28, 2011
Have an Windows Forms application that captures sql_informessage event that update a progress bar. How can I do the same on on ASP.NET application,
View 1 Replies
Mar 26, 2016
URL....This link shows a demo that let user to put origin and destination then get direction. I want to know how to add a option which is let user to use their current location as origin location (Location from).
View 1 Replies
Apr 7, 2010
I have a table in my database, in which a certain field holds the locations of text or doc files (the files are of a transcript for a chat session).
In the Gridview right now i able to show the link locations. But i want to have Hyperlink or Button in the links location in the Transcript Location fields.And on the click of which the txt or doc file opens up in notepad or microsoft word.
View 2 Replies
May 7, 2015
Following is my code when user enters hospital name and city, he will be navigated to this page to show location on map. Now I want to get user current location and draw the route between current location and destination. Is there any way to integrate to geocoding and geolocation?
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style>
html, body, #map-canvas
[Code] ....
View 1 Replies
Jan 17, 2010
I'm using an asp:TextBox as the wmd-input. As the user clicks the submit button I wan't to capture the markdown at server side as the Text property of my asp:TextBox control. However, instead of the expected markdown, my TextBox at server-side contains the HTML formatted version of the markdown: <h1>testing</h1>
How do I get the pure markdown? PS: At client side I see markdown on the asp:TextBox. It's not clear for me when it's getting converted to HTML before post-back.
View 1 Replies
Aug 4, 2010
I just want to know how to capture an image using asp.net server side.
My code runs smoothly and captures the image when I'm running it in localhost, but when if I published or deployed it in our web server then access it tru its url, it doesn't work or i can't capture the image.
Here's my code:
[Code]....
View 1 Replies
Apr 6, 2010
In web.config, we can set to allow user upload file up to 2GB for .NET 2.0.
View 1 Replies
May 29, 2010
I was reading about "Change Data Capture" functionality in SQL Server 2008. It sounds awesome. My implementation of it would be in a website environment where ASP.NET pages use SQLDatasources to do inserts, updates and deletes. When enabling "Change Data Capture" can you store additional information supplied from the website like a UserID, SessionID, UserRole etc so you can identify who did the insert, update or delete? [URL]
View 1 Replies
Jul 12, 2010
In one of our sprocs, we have a validation and it returns an error as: RAISERROR('this is the error message', 18, 1) When I call it in the business logic layer, how do I obtain this error message and pass it through the web service?
[Code]....
As you can see, it supposes to return a Users type, but how would I capture that error message in sproc and pass it all the way to UI?
View 2 Replies
Sep 8, 2010
i would like to do a project that enable to capture photo from webcam, and record audio from microphone store to database. but the photo and audio store in folder and the database only store the filename. later i set the path and its play back the audio and show the photo.
View 2 Replies
Mar 15, 2010
What is #region, and what does it do?
View 2 Replies
Jun 30, 2010
I am using ASP.Net 4.0/Visual Studio 2010. However, I think it would be the same if it was ASP.Net/VB.Net 3.5. I am inserting three form filed values into a database table. I have placed a LoginName Control on the page and the login name is properly displaying. I am using forms Authentication and it is set up properly in the web config file. I simply want to insert the logged in username value into the database table so I can track who created the records. I am happy to be able to insert the UnserName or the UserID value. I assume both of the values are derived out of the aspnet_Users table. Being able to insert either one would be fine but I believe UserID would be better because it will always be unique.
View 8 Replies
Nov 18, 2012
After filling all the required information in any registration form, I want to capture the Date of submitting the form in Sql Server 2005 how to achieve this using Asp.net C#?
My insert query is:
con.Open();
SqlCommand command = new SqlCommand("insert into data (UserID,Name,Email,Country,Date,Multiselect,Gender,Pincode)values('" + txtuserid.Text + "','" + txtname.Text + "','" + txtemail.Text + "','" + ddlcountry.SelectedItem.Text + "','" + s1 + "','" + lbmultiselect.Text + "','" + rblgender.Text + "','" + txtpincode.Text + "')", con);
command.ExecuteNonQuery();
View 1 Replies
Aug 6, 2010
Is it possible to get window.location.hash on the server-side code alone? [URL]
View 2 Replies
Aug 6, 2010
When my ASP.NET site uses documents (e.g. XML), I normally load the document as follows:
Server.MapPath("~DocumentsMyDocument.xml")
However, I would like to move the Documents folder out of the website folder so that it is now a sibling of the website folder. This will make maintaining the documents considerably easier.
However, rewriting the document load code as follows:
Server.MapPath("../../Documents/MyDocument.xml")
results in a complaint from ASP.NET that it cannot 'exit above the top directory'.
how I can relatively specify the location of a folder outside the website folder? I really don't want to specify absolute paths for the obvious deployment reasons.
View 4 Replies
Oct 26, 2010
CDC or Change data capture is a new feature in SQL Server 2008, which is an ability to record changes to table data into another table without writing triggers or some other mechanism, Change data capture records the changes like insert, update, and delete to a table in SQL server.I have sql 2005 and I have created triggers and tables CDC to capture the data. everything functions good and the data is being updated in the _CDC tables. all i need to do now is to generate the updated data as a report (excel/html)- what should I do ......?i need to show only the updated columns when user selects the date periods ( Range between dates ) and the person name - i need to display any updated info about that person during that period. So this updated columns about this person should be displayed in excel formatted column wise.
View 2 Replies
Oct 5, 2010
In my asp.net wep application i would like to move the folders from the server to a network location so that the server doesnt get filled up.
i was able to move the files within the same drive but not to other network locations .
View 11 Replies
Mar 25, 2011
When running the ASP.NET Development Server, everything is working fine. However, when I deploy my asp.net application to the production server (IIS 7.0 integrated mode, fresh install), my location tags in my web.config file are being ignored.
Case in point: I'm using forms authentication, and when the user arrives at my login.aspx page, the external css & js files are not being loaded...even though I have specified that those files should be available to all users (auth'd or not). However, once the user is logged in, the files do in fact load.
<authentication mode="Forms">
<forms loginUrl="~/Account/Login.aspx" timeout="2880" />
</authentication>
<authorization>
<deny users="?" /> <!-- Restrict anonymouse user access -->
</authorization>
And the exception to my css file...
<location path="Styles/xtools.css">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>
I've verified that the path to the css file is accurate.
--EDIT Forgot to mention, I have tried creating a web.config file in the targetted folder as well...still not working.
View 1 Replies
Nov 9, 2010
Can anybody tell me the description about
"#region PageLoad"
which i absorbed in a code given to me....
View 3 Replies
May 1, 2010
I'm working on an asp.net mvc application. Each user have his own time zone.Right now, I'm using "TimeZoneInfo.GetSystemTimeZones" to generate a drop down list in order for the user to select a timezone and this is what I store in my db
They are like that:
Morocco Standard Time (00:00:00)
UTC (00:00:00)
GMT Standard Time (00:00:00)
...
I know that php use a different timezone set, they are "region timezone", for example:
Europe/Paris
Europe/London
...
My question is: is there a way to play with the region timezone (like php) in an .NET application? The only way I can think of is to bind each php region timezone to the .net timezone.Also, the "TimeZoneInfo.GetSystemTimeZones" list all of the timezone on the machine. Is the list different between windows server, windows vista, windows xp?
View 3 Replies
Nov 24, 2010
Does anyone know how this is possible? I can retrieve the file, but I cannot figure out or find anywhere online how to prompt the user where he/she wants to download the file to.
View 2 Replies