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 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?
i am using the following code for a retrieving a image stored in access database
View 12 RepliesI want to retrieve a single column from a table in a database(ms access) and then the value retrieved has to be converted to a string!!
View 4 Replies -7vf- I write a program by c# to check and retrieve data from database
The problrm:I have one table(1), I want to make update for that table(1) that is by compare the one column in table(2) with the right side from one column in table(1), so if there is any similarity it will retrieve the data and if there is no match just it will make the record empty(null) "the data type of retrieving columns: number 'double'", but the problems is:
I try to retrieve 11 columns, 7 of them are empty .the program run with out error ,but it will retrieve some records with full data 11 columns, but some of records has only 5 columns have data and 7 columns are empty (these records when I run the program did not retrive any columns, it give me empty records!!)
this is the code :
while (or.Read())
{ or.GetValues(field); OdbcCommand oc2=null;
[code]....
I want to retrive all data which are empty or null and all data
How can I retrieve current user ip address in asp.net c# from my local LAN in my web page?
In my case I want for example : I have web page when I open it in any PC in my Local LAN I want to get this PC IP and PC user name to send them to  SQl Database
This code get only the Sever IP:
public string GetLocalIP() {Â
string _IP = null;Â
System.Net.IPHostEntry _IPHostEntry = Â System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName());Â
foreach (System.Net.IPAddress _IPAddress in _IPHostEntry.AddressList) {Â
if (_IPAddress.AddressFamily.ToString() == "InterNetwork") {Â
_IP = _IPAddress.ToString();Â
} }Â
return _IP;Â Â
}Â
I have a composite control, I need to get the address of page hosting it.
View 1 Repliesiv'e looking the web for some solution without any success (some of them using VB, some of them for global file and some of them are not working) i want to put some code (not in application / global file) only in one page of my site, that send to my email address exceptions details in case there is some.(c#)
View 1 RepliesI'm a bit of a newbie when it comes to AD... But what I want to achieve in the first instance is to use the AD to display the staff name and e-mail address from Active Directory, when they are logged onto the company Intranet. Using the 'login status' I can display domain/username, but would prefer the 'CN' and e-mail address to be shown instead.
I'm using C# and I've got as far as putting Using System.DirectoryServices in my references and .cs file
Staff are authenticated using "Windows" authentication rather than "forms" as they would already be logged onto a PC and should not require to log onto the Intranet again
PS Tried to search through the forums, but the examples shown seem to be to retrieve multiple users / info from AD and I hope my request is a 'simpler' fix
I am using sql server 2005 and visual stdio 2008. i have a textbox in my page as txtEmailId. i want to compare this value in database with email_id column[it is a primary key] to avoid inconsistence in database on a button click with out using custom validator
View 3 RepliesWhen attempting to place controls in different content areas using Masterpages and trying to use a compare validator, I get the error: Unable to find control id 'txtStartDate' referenced by the 'ControlToCompare' property of 'cvlDate'. I have also attempted to set it within the c# code behind in page load: cvlDate.ControlToCompare = txtStartDate.ID and by using findControl there must be an easy way to achieve this?
<asp:Content ID="Content4" ContentPlaceHolderID="leftForm" Runat="Server">
<asp:Label ID="lblStartTimeEnter" runat="server" Text="Start Time:" Width="100px"/>
<asp:TextBox ID="txtStartTime"runat="server" MaxLength="50" Width="250"/>
</asp:content>
<asp:Content ID="Content4" ContentPlaceHolderID="rightForm" Runat="Server">
<asp:label ID="lblEndDateEnter" CssClass="formMargin labelInput" runat="server" Text="End Date:" Width="100px"/>
<asp:TextBox ID="txtEndDate" CssClass="formMargin" runat="server" MaxLength="20" Width="250" ClientIDMode="Static"/>
<asp:CompareValidator ID="cvlDate" runat="server" ControlToValidate="txtEndDate" ControlToCompare="txtStartDate" Operator="GreaterThan" Type="Date" ErrorMessage="Start Date must be before End Date" > *</asp:CompareValidator>
</asp:content>
this is my url
[URL]
how can i access to id parameter on this url
i am using this code
[Code]....
but it didn't work.
My asp.net web app is hosted on this URL on my local machine:
http://localhost:45433/
I want to access the same application from a different computer on the network. I tried replacing the localhost with my IP but it did not work.
UPDATE 1:
Now, I am getting this error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I have created a login form through VS 2008 using C#. There are 5 different aspx pages in my application.
1)Default.aspx: It contains only a hyperlink to direct the user to login.aspx page.
2)Login.aspx: This page has texbox for Username and Password, sign in button, textbox for displaying error and hyperlink (Create an Account) if the user does not created an account yet.
Here is Login.aspx code:
[Code]....
Now, I want to do following with my application.
If the user already has an account, he can put his username and password and click on the sign in button. If the username is existed in databse, application should compare the user input with database and if both are matched then the application should redirect the user to "welcome.aspx". If username does not exist it should show that Username does not exist.
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I do have another PC on the intranet and am not able to access the website using my internal IP address.
View 1 RepliesI have an application where in the User Authentication is from the AD useing Directory services.
If i type in the address of a valid page from the application into the Address Bar, it throws me to the Login Page.
However if i am logged in and i type in the address of a valid webpage, the application takes me to the page. Is there any way that this can be restricted.
If i type in the URL into the address bar the application should throw me to the Home page of the application.
i want to compare my database value with my new updated value. what should i do ? e.g : on page load i am excuting one procedure which bring 10 columns and fill it against the 10 fields using for loop on the page. then i am changing value of two columns. ok. when i press update button then there is one more procedure which updates all the new and old columns into database. Its working fine. just i want to know that, should i update only two columns(which are modified) insted of updating all 10 columns ? Is there any csharp code that brings my page load columns into array and then compare it with new ones and updates only those columns which are mismatch with array. i am not sure but there is some way to do this.
View 4 RepliesI have a web form that displays the results from a table. How can I compare the table between dates and display the differences of the table?
e.g. today 790 items, and two days ago there were 745 items and this is what is the difference;
xxx
yyy
ggg
hhh
aaa
etc.
In one online application, like online exam, If two users are on same IP address series then I need to generate questions that are completely different.
I am having no idea what approach should I follow.
how can i store youtube or any other video URL or link in database and retrive from database
and what control i use in this in C sharp
I am using compare validator to compare date... But Its not working ...I have used calendar extender...with date format as "dd/MM/yyyy"...
View 3 RepliesI created a website and i restrired the website such a way that i can be acessed from a IP i configured.I did this as shown in below steps which i got from:
http://support.microsoft.com/kb/324274
Under IP Address and Domain Name Restrictions, click Edit.
Do one of the following:To deny access, click Granted Access, and then click Add. In the Deny Access On dialog box that appears, specify the option that you want, and then click OK.The computer, group of computers, or domain that you specified is added to the list.
To grant access, click Denied Access, and then click Add. In the Grant Access On dialog box that appears, select the option that you want, and then click OK.
The computer, group of computers, or domain that you selected is added to the list. Click OK.
But its not working . I am able to browse from other machine which have a different ohter IP. Do i have to configure somewhere else ?
I am trying to provision some users to update their email address in active directory (AD). I'm trying to achieve it using MembershipUser class. But getting 'general access denied error'. Here's my code:
string userName = "sathish";
System.Web.Security.MembershipUser userDetails = System.Web.Security.Membership.GetUser(userName);
if (userDetails != null)
{
userDetails.Email = "sathish@xyzee.com";
So as the title suggested, I'm currently trying to compare the hashed answer in my database against the answer typed in the textfield by the user in the form.
I thought of hashing the answer in the textfield typed by the user first, and after that compare this newly hashed answer to the one in the database (which is already hashed). But when I typed in the SAME answer (before hashing) and hashed it to get the hashed value, by right the 2 hashes (in web form and database) should match? Somehow, it didn't. And I can't seem to get security answer right anymore (even though I typed the SAME security answer).
This is the code behind the button:
[Code]....
I tried in another way too, but still the same thing.
[Code]....