With windows and sql server accounts, I can access the logged in user with functions like: user_name() or suser_sname().Can I access the user that is logged into asp.net in the same way?
View 1 RepliesI 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 RepliesI have the asp.net with authentication set to forms. After deploying new version on server it started to display a UsernName Password dialog box (like in windows authentication) on the login.aspx page.
When user click "cancel" the login.aspx page displays normally and user could log in and continue his work normally.
I don`t know how to get rid of that dialog box? Anonymous login on IIS is enabled, and the anonymous IIS user has access to that file - login.aspx
Would something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
View 1 Replieshow can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 RepliesI have looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it.was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go.
Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking!
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
View 2 RepliesI have a web service that runs a query (from C#) to get a dataset from sql server. I get the following time out error. Googling on this error says, you can set the timeout on command object. But I am not using command object to set the timeout. This is the code I am using to get the dataset.
code:
[code]....
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 RepliesI want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 Replieswe can not add .mdf file to the project in vs2008 and sql server2008 when i am adding .mdf file its displaying an error message so it is not possible to add
View 2 RepliesWhen i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
How to update username of current logged username?
View 10 Replieswhy when i'm loging in the loginName turns in to the name of my server and not the name of the username ... ? give some tutorials or articles about loginview.
View 2 Repliesi am trying to upload file to a server (72.16.10.156),
my code is in below,
my web application works succeffully when i run it from my code, ofcourse i log on to that server (172.16.10.156) with username and password, before running the web application.
but when i pulish my program an error is occured and that is because of user name and password, ofcourse it is right , because i did not set username and password in my code.
[Code]....
how can I do it?
View 1 RepliesI need to ask this question.I registered websitespark program and I have some tools.I have Server 2008, VS 2008 etc.I want to install Server 2008 and VS 2008 but I never use them together before. What are the advantages and disadvantages and also performance? We are developing web and win applications.
View 1 RepliesI am using SQL server triggers to do the database auditing for my website. My problem is that I cannot pass the username who manipulate data into the Audit table. The username saved into Audit table is always the SQL server user name which is part of my connection string. Is there any better way to handle this?
View 6 RepliesI am developing a website in ASP.NET with SQL SERVER as backend.
I want to find the best(FASTEST) way by which I can find if USERNAME exists or not.
My application is taking a bit of time finding that out. Do I need to look into my TABLE structure,indexes.
Is there any replacement for the query
Select username from usermaster where username=@Username
In C# I need to connect to a database. How do I find out the username and password to use for that database? I know that sometimes the "sa" username can be used. I don't know how to find the password though. I am working on a contract and no DBA, and the developer left for a different job.
View 1 RepliesI have a table setup in the database for users who are basically going to create a classified listing. How can I setup a diagram that would easily create a table relationship with the Users table, so that it automatically inserts the users username when they submit a new ad? If so, how? I've tried adding a UserName row to my table and creating a relationship with the Users table "UserName" row, but it wasn't accepting the relationship when I tried to save the diagram...apparently because the UserName row in the Users table isn't a primary key?
Also, one this is setup, what's the best way to provide the user a way to see a list of their ads and have the ability to edit them?
I have an ASP.NET VB website in which I am using the Membership functionality to authenticate users. I am doing this through the Login control on the HTML page. I have working that it will authenticate the user and then opens a welcome screen in which I have a button they can push to open a Reports.aspx page. On that page I have a dropdown box that is being populated from a datasource connection query to my SQL Server database table. It is a hard coded query but want it to query the table off the username text value that the user provided on the login (i.e. select <something> from inventory where username = <username>). I have not behind code but only HTML at this point. Here it is ...
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Login.aspx.vb" Inherits="Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] .....
Here is the Reports form that has the dropdown on it:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Report.aspx.vb" Inherits="Report" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] .....
This 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 RepliesAs Iwas trying to install SQL Server 2008 I got the message that, SQL Server 2008 requires VS 2008 SP1. Am using Visual Studio 2008 what do i haveto do here. I cant be able to dowload due to my bandwidth problems.
View 3 Replies