Pass Membership Logged In Username As Parameter To SQL Server Datasource Query
Jul 23, 2012
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] .....
View 1 Replies
Similar Messages:
Feb 14, 2011
I tried to develop a dynamic pivot query with following code to avoid hard coding. I can got the 'Q1, Q2, Q3, Q4' dynamically and assigned to @(@quarter. But it cannot be passed to the pivot query.
[Code]....
View 7 Replies
Jun 3, 2010
I'm using Visual Studio 2008 Query Builder and am trying to pass a value to a parameter that uses the IN OPERATOR.Here is my sql from qb:
SELECT COURSE_TITLE, INSTR_NAME, ADMIN_UNIT
FROM vwHRIC_EC_ContractSummary
WHERE (ADMIN_UNIT IN (@ADMIN_UNIT))
The trouble I am having is that if the parameter @ADMIN_UNIT contains more than one value such as (8X, CV) that the query doesn't return any data. If I run the same query with only one value such as (8X) it works fine.I have tried different formats like (8X, CV), ('8X', 'CV'), (8X; CV) but none have worked.I ran this same query in SQL Server Management Studio and and it returns data no problem but can't get it to work in Query Builder for my aspx application.Does anyone have any experience with this problem and how did you correct it?
View 3 Replies
Jul 16, 2010
[Code]....
returns the error: The parameter 'username' must not be empty.Parameter name: usernameI want to check if a user is logged. If not logged in redirect to loginerror.aspx.
View 9 Replies
Jul 13, 2010
I have a standard Login form
<asp:Login ID="lgnExcel" DestinationPageUrl="login/data.aspx" OnAuthenticate="Login1_Authenticate" runat="server">
Is it possible to attach the Username as a query string with the DestinationPageUrl or reference the value in the code behind. I've tried lgnExcel.UserName.ToString()
View 2 Replies
Mar 12, 2010
How to update username of current logged username?
View 10 Replies
Apr 14, 2010
We are using a asp.net page to submit data to server. what we do is we will pass as parameter in url Query string) and in page load we take that values and submitting to database I have these following doubt
1, What is the default event happening while we call a ASP.NET page is it a POST or GET? We tried to call this url from a mobile application, it is not happening , we are not getting any error also in the mobile application.
2, IF we are calling the url to submit data from mobile applications which one we have to use (GET or POST)
3, IF we are calling this url from an application running in PC to submit which one we have to use ?
View 3 Replies
Feb 28, 2010
SELECT DISTINCT TblSections.SectionID, TblSections.Description
FROM TblSections INNER JOIN
UMG.Users ON TblSections.SectionID = UMG.Users.SectionID
WHERE (TblSections.Description IS NOT NULL) AND (dbo.Users.LoginName = [@Session(UserName)])
ORDER BY TblSections.Description
I have problem in using Session name in the above BOLD WHERE clause.
View 5 Replies
Jul 29, 2010
I 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 Replies
Apr 22, 2010
I am getting return some data through stored procedure in a asp.net 3.5. Below is the method.
public DataSet GetDataSet(string strConnection,string strSPName, string param1)
{
DataSet ds = dataAccessLayer.getDataSet(strConnection, strSPName);
return ds;
}
In some cases, I have to pass 3-4 parameter. How can we do pass optional parameter here....
View 3 Replies
Mar 31, 2010
I just like to know how to pass a parameter to the datasource of my dllItemCodeFooter and dllItemCodeEdit Drowndownlist which calls my getItemCodeList(decimal categoryID) method in the code behind. The value of the parameter will be seletectedValue of the first dropdownlist(ddlCategoryFooter or ddlCategoryEdit).I know it could be done in code behind, but i prefer to bind my datasource in asp page. I want to achieve something like this
DataSource='<%# getItemCodeList(ddlCategoryEdit.Seletected)%>'
Below is the code for my Gridview
[Code]....
View 1 Replies
Sep 23, 2010
I'm trying to pass default value to a sql parameter which is
[Code]....
View 1 Replies
Feb 17, 2010
how can i pass a session variable in a C# web form to a stored procedure..?
View 1 Replies
Jan 6, 2010
I am creating a TableAdapter using corresponding wizard, with a GetDataByID() query. The select statement is like this:select * from books where ID = ?Thus books are filtered by ID. But in case a null is passed as a parameter, I want to select all records rather than none. Could you please tell me how I can do it?
View 4 Replies
Mar 31, 2010
I have 2 dropdownlist(ddlCategoryFooter and ddlItemCodeFooter)inside my gridview. I want to set ddlItemCodeFooter 's datasource to my getItemList(decimal categoryID) method. The selecteditem of ddlCategoryFooter will serve as the paramter which will be passed to my getItemList Method. Basically,ddlItemCodeFooter is dependent on ddlCategoryFooter's selectedItem.
I know it can be done in code behind approach but i prefer to place it in my asp page.
This i what i want to acheive:
DataSource ='<%# getItemList(Convert.ToDecimcal(ddlCategoryFooter.seletectItem))%>'/>
Source code for my Gridview:
[Code]....
View 8 Replies
Jun 30, 2010
I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page.
For this purpose I defined a public property in user control but how do I pass it with object datasource ?
I am calling from parent page like
myusercontrol.parameter=querystring["id"];
How to bind object datasource with my parameter ?
View 4 Replies
Dec 31, 2010
i am passing the serverside control as parameter, but it throws OBJECT ERROR.
View 5 Replies
Jan 14, 2011
I have a server control that performs some logic. I'd love to provide a default implementation of this logic in the code of the control, but allow a developer to pass an alternate implementation of this logic in as a delegate, if they wish.
So...
<prefix:MyControl FooLogicMethod="MyUtilityClass.MyFooLogicMethod" runat="server"/>
If they don't specify this, I'll use my default method. If they do specify it, I'll use the method they passed in.
Can I do this as a delegate, or do I need to reflect it?
View 1 Replies
Sep 21, 2010
I having problem in display the username after a user logged in.This is my master page which has label which named Label1 on top right, i want to display the username on there after logged in.
View 4 Replies
Jan 26, 2010
This may be elementary user control stuff, but I can't get it to work.
How can I pass the Membership.GetUser.UserName variable (or any variable) through a user control parameter at load time?
[Code]....
The only thing that I was able to do was to create the User Control object in the code behind and then add it to the page. Although that works, it doesn't seem like the correct way to program.
View 1 Replies
Jan 31, 2011
I have one more question. How can I use a column in the stored prcedure and pass it to a parameter in the code above?
Can we access a column like that?
View 23 Replies
Dec 2, 2010
I was not able to find the post. I am building an MVC app and on the master page I want to display the user that is logged into the workstation. This is just an internal app so we were just going to use
AD authentication. I am not sure how ISS will be configured on the anonymous or impersionate part so I did this line of code in the master page
<%=Environment.GetEnvironmentVariable("USERNAME") %>
Is this proper and the best way or should I look for a better way. I know this is generic but just curious.
View 2 Replies
Jun 11, 2013
How can I assign logged in windows username as a parameter to sqldatasource in ASP.net web forms.
View 1 Replies
Jul 8, 2010
SQL query so that if i pass date that is not between startdate and EndDate then it should return the previous row schedularID.
For Example:if i pass 19/06/2010 i should get SchedularID 1
if i pass 09/07/2010 i should get SchedularID 3
and so on....
SchedularID
ContestantA
ContestantB
StartDate
EndDate
1
3
4
10/06/2010
18/06/2010
2
1
2
20/06/2010
28/06/2010
3
5
6
01/07/2010
08/07/2010
4
7
8
10/07/2010
18/07/2010
View 9 Replies
Nov 21, 2010
I have a stored procedure that is close to working. It takes the values of a details view puts them into the respective table 'entity' then should also put the @@identity into 'entloan' and should put the LoanID which is in the query string of the page the detials view is loaded on, into the LoanID field of entLoan as well. Everything works except for getting the querystring value to pass to a insert variable on my stored procedure.
Stored Procedure
[Code]....
I do not have a LoanID Insert parameter set as it is not in entity table:
[Code]....
I have been playing around with different code in the backend but always get errors:
[Code]....
View 2 Replies
