I am trying to pull entries from a database based on the current users IP Address. Here is what I have so far:
[Code]....
I am receiving the following error: Cannot find either column "Request" or the user-defined function or aggregate "Request.UserHostAddress.ToString", or the name is ambiguous.
Is it possible to do this? Should I try to access this information another way?
[Code]....
Well I'm not familiar with SP's yet, and I can't find a single example of what I want to do. basically I want to retrieve the town & county where the customers id are equal (note there will only ever be 1 result)
I can't figure out how to address the results to be stored within the output variables.
how i can retrieve the IP address of the host PC, and then compare that IP Address with a list of IP Address which is stored in a MS Access database to verify that the host PC is able to view the webpage. I need to do this in C# language.
View 5 RepliesI was wondering if anyone knows of a good login stored procedure that can be freely used and features login limits and so on (basically a good one) With my limited SP knowledge, I've tried to create one myself, I haven't completed it yet as I'm not sure on how to compare the last login attempt time against the current time (it's in the comments).
P.S. I had to write this in notepad.
[Code]....
I have managed to expose the MEX endpoint of my WCF service and I can access it with the address like [URL] (example) and get the WDSL. So no problem there.
However, my WCF test page shows the address wrongly by using the server's name instead of the DNS name. And if I click on the link on the test page it won't work (can't get WSDL).
The WCF test page looks like this:
MyService Service
You have created a service.
To test this service, you will need to create a client and use it to call the service.
[URL]
The WCF service is hosted in IIS6. I would like to have a test page with the correct WSDL address so users can see the WSDL quickly in the browser just by clicking on the WSDL address.
In short: How can I change the MyServerName to inter.mycompany.com on the WCF test page? Can this be specified somewhere in the Web.config?
i, How can I get the current visitors IP address?
View 3 RepliesIs it possible to find out the clients IP and possibly MAC address from non IE browsers (i.e. without using ActiveX)? If so, how?
View 1 RepliesSuppose I have a resource located in ~/Resources/R1.png This resource's relative URL will vary depending on the current address.
For instance: If I'm at www.foo.com/A/B/C/D.aspx and the www.foo.com/A is the root path including Virtual Directory, then the path relative to the current address of ~/Resources/R1.png is ../../../Resources/R1.png
How can I get this relative path?
EDIT:
I want a web path that I can use in a web page, not a server path.
I'd like to do this in the Application_Start method, so I can write a 'robots.txt' file if the site is running on a test server.
View 2 RepliesHow to retrieve the current authenticated logged in user's email address who is accessing the page.
I have managed to do it with users. How to get the current authenticated user's email address if that makes sense.
Here is my aspx code:
[Code]....
and my VB script:
[Code]....
Somebody suggested that I should run a query. If you know the user name accessing the page, surely you can take that information, insert it into a query to find out the email address of the user accessing the page. Sounds great but don't have a clue how to do it.
I want to connect Sql server which is on remote mechine by IP adress. at present i able to connect sql sever which is on local machine using followning code:
SqlConnection con =
new
SqlConnection("Data Source=HCL-LAPTOP;Initial Catalog=databasename;User id=sa;Integrated Security=True");
I have two tables, both contains same properties. The problem is the address spellings MAY vary between table 1 and table 2 but they are actualy same properties. In my sql statement it list out the property that has exactly the same spellling. How do I match the two tables addresses? I heard about fuzzy algorithm but how do I apply it here. I know it wont be perfect but it will be close (check my sql below) I use sql server 05.
Example
Table 1
- 123 greenwood hwy
- 123 halo street
Table 2
- 123 greenwood highway
- 123 halo street
SELECT table1.address,table2.street_address
FROM table1 INNER JOIN
able2 ON table1.address = table2.street_address
My Output returns only one property that has same exact address spellings
- 123 halo street | 123 halo street
How do I obtain the IP address or MAC address or some Unique ID of a device within a mobile app, either client or server side?
We are developing a web application targeting iPhone, BlackBerry and Android, generally device independent, and we are looking for ways to uniquely identify a device for added authentication purpose. Is there a way to uniquely identify a mobile device, regardless of the make and model?
Is there a way to control the Outbound IP Address a .NET program uses?
We have Servers with multiple IP Addresses hosted at Data Centers with limited Firewall rules. We would like to open Port 1433 to our SQL Server to as few individual IP Adresses as possible. But this becomes difficult when a Server has multiple IP Addresses.
So is there a way to control what Outbound IP Address a .NET program uses? ...Even better would be if there's a way to control the Outbound IP Address in the connection string.
i have task to send mail to all my clients in one click
i have no idea for that
i think for each loop will be useful ??
Actually i am developing a web application for leave,,if the employee wants to take a leave,the employee working under the senior people,if the employee 001 wants to take a leave,if the employee 001 logins in the web application,if he is working in sales dept,automatically this mail is forwarded to sales manager..like wise for all the employee..if the employee works in accounts dept,whenever the employee logins in the web application,to email address automatically change to the accounts manager..i dont no how to do this
View 1 RepliesI want to calculate the current financial year in my stored procedure and use it when generating a unique Id for the customer registring in my system.
View 2 Replieshow do I grab an email address from a web form and email to that email address with the link to a webform?
View 5 RepliesI have some email Id's in my excel sheet i want to dump them grid view and send a mail to every Email Id with their names saying
example:If the Id is ex@yahoo.com
Then it should send as Dear ex and family
I dont know even which of the tags are also used in this so can you please send me the brief code (or) Description.
assign the address list to a repeater?
[Code]....
[Code]....
1st i start from the SQL Table design, i created a table which contain
RegisterID(for eg. id=1000123), Username, pasword,
Full Name & etc
using a store procedure but i didnt include 'RegisterID' in there becuz i used
'identity' method for auto increment of RegID.
my question is that, i created a login & Welcome page (in C#).
its work properly, but now i want a way, when a user login into the website,
his RegisterID(for eg. id=1000123) will appear in Browser's Address bar
for eg. (http://www.mysite.com/welcome.aspx?id=1000123).
what command i have to give, to appear this ID.
i used Response.Redirect("newuserinfo.aspx?" + "username=" + username_txt.Text);
the username coming on the address bar, but i donno how to show RegisterID.
I have used querystrings in many webpages. When user click hyperlink then it moves to next page but there is a very long string is being displayed in the Address bar of the browser.
I just want to show like this:
[URL]
Not like this:
[URL]
I have this lastname column and address column. The address obviously is longer so it makes the gridview to increase its height which I don't want to happen. What I want is to increase the column width of the address in gridview that will suit the long text inside it. How could I do it in C#? Currently this are my codes:
C#
[Code]....
CSS
[Code]....
I have an IP address stored in an oracle database as a Varchar2 20 bytes. When in a BoundField it displays as 10.220.20.221 EST and it the BoundField value is "" or string.empty it only displays EST.
View 2 RepliesI need client ip and login user name of a system, while using my web application in ASP.Net ....
View 1 Replies