Re: Logout Problem in forms authentication - ASP.NET Discussion Boards

First Prev Next

Re: How to pass parameters to a stored procedure using 'in' keyword [modified]

Spunky Coder13-Mar-09 1:35

Spunky Coder

13-Mar-09 1:35

You can do as the following...

CREATE PROCEDURE [dbo].[Procedure]
@GroupId as varchar(500) = ''
AS
BEGIN
SET NOCOUNT ON;

DECLARE @query as nvarchar(500)

set @query = 'select VideoTitle from Item where ItemId in(select ItemId from GroupLink 
where GroupId in (' + @GroupId +'))'

exec SP_EXECUTESQL @query

END

Now execute the procedure as exec Procedure (2,3,4)

I used to do like the above whenever I have to retrieve the values based on a list...Don't know if it has any performance issues...

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

modified on Friday, March 13, 2009 8:28 AM

Datetime?

Karthick_gc13-Mar-09 0:04

Karthick_gc

13-Mar-09 0:04

Hi, I am using SQL in my project. I want to fetch only time alone. I know to fetch Date. How to fetch time? Can any one tell?

Re: Datetime?

Spunky Coder13-Mar-09 0:35

Spunky Coder

13-Mar-09 0:35

Use DatePart function for e.g. SELECT DATEPART(hour, '2007-06-01 10:00:01') gives you the value 10. as it queried for hour.

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Re: Datetime?

Karthick_gc13-Mar-09 0:43

Karthick_gc

13-Mar-09 0:43

S. Is it possible to fetch the full time?

Re: Datetime?

Spunky Coder13-Mar-09 1:07

Spunky Coder

13-Mar-09 1:07

Hmmm...You must have used Google by this time Smile | :)

any way follow the link Get Time[^]

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Re: Datetime?

Ashfield13-Mar-09 2:21

Ashfield

13-Mar-09 2:21

See my reply to your CROSS POST, which, by the way, is a bad thing.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Logout Problem in forms authentication

SreejithAchutan12-Mar-09 22:35

SreejithAchutan

12-Mar-09 22:35

Hi Friends,

i have used aspnet authentication to logging into my site.When i click logout and i click back button,i can see the last page.How can i logout properly.I used FormsAuthentication.Signout() to logout.What is the problem of dont properly logout fro site.

Re: Logout Problem in forms authentication

kumar_k50812-Mar-09 22:55

kumar_k508

12-Mar-09 22:55

Hi,
After clicking the logout button,the all the cookies will be cleared... and when you click on back button it shows only UI and links...

if you want you can test it by clicking any link (button/link),you will not get any user information and automatically it will redirects to your redirected page..

if not like that,you have to clear all the cookies and abonden all the session variables

S Kumar

Re: Logout Problem in forms authentication

SreejithAchutan12-Mar-09 23:22

SreejithAchutan

12-Mar-09 23:22

How can i clear all cookies when we click on logout.

Re: Logout Problem in forms authentication

kumar_k50812-Mar-09 23:31

kumar_k508

12-Mar-09 23:31

Hi,

'clears formsauthentication cookies
Response.Cookies.Remove(FormsAuthentication.FormsCookieName)

'clears all sessions variables of application
Session.RemoveAll()
Session.Abandon()

S Kumar

Re: Logout Problem in forms authentication

SreejithAchutan12-Mar-09 23:40

SreejithAchutan

12-Mar-09 23:40

Hi Friend,

I Given the code but it willnot cleared the cookie and i can took all datas,it willnot ask again to login.

Re: Logout Problem in forms authentication

kumar_k50812-Mar-09 23:46

kumar_k508

12-Mar-09 23:46

HI,

Are you redirecting from that page to some other page (generally login page) whenever page losses cookie value...?

S Kumar

Re: Logout Problem in forms authentication

SreejithAchutan12-Mar-09 23:52

SreejithAchutan

12-Mar-09 23:52

Hi,

Actually i put a login control in masterpage enabled page and i put menu in masterpage.in the menu i put a menuitem logout and in the menu item click event i given formsauthentication.signout and the above given code.and i retdirect the page to home page where the login control, is situated.This is the flow of login and logout.After logout i checked username is null or not in another menuitem page.but i can easily access the page because the username still exists.What is the problem.

Re: Logout Problem in forms authentication

kumar_k50812-Mar-09 23:56

kumar_k508

12-Mar-09 23:56

HI,

you can check the formsauthentication cookie information in the masterpage's page_load event.. if the cookies value is nothing simply redirect to login page

Re: Logout Problem in forms authentication

kumar_k50812-Mar-09 23:53

kumar_k508

12-Mar-09 23:53

Hi,

you can do like this also ...just by using javascript you can disable back button (but this is not good practice).... Wink | ;)

S Kumar

Re: Logout Problem in forms authentication

SreejithAchutan13-Mar-09 0:00

SreejithAchutan

13-Mar-09 0:00

Not when i click the back button when i click any menu link also i can easily access the datas without logged in.

Re: Logout Problem in forms authentication

kumar_k50813-Mar-09 0:02

kumar_k508

13-Mar-09 0:02

hi,

what are modifications that you are done?

S Kumar

Re: Logout Problem in forms authentication

kumar_k50813-Mar-09 0:07

kumar_k508

13-Mar-09 0:07

Hi,

just check the cookie information is either available or not in master page's page load event,if values are nothing just redirect to login page...

S Kumar

Re: Logout Problem in forms authentication

rakeshs31213-Mar-09 0:01

rakeshs312

13-Mar-09 0:01

Hi,

In your first page, paste this code in pageload

Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));
			Response.Cache.SetCacheability(HttpCacheability.NoCache);
			Response.Cache.SetNoStore();

Re: Logout Problem in forms authentication

SreejithAchutan13-Mar-09 0:11

SreejithAchutan

13-Mar-09 0:11

Sorry to say again it works wrongly.the user can access pages after paster the page in pageload of first page.

Re: Logout Problem in forms authentication

SreejithAchutan13-Mar-09 0:28

SreejithAchutan

13-Mar-09 0:28

Hi Kumar Sir,

I got it sir.Actually we have to given Formsauthentication.LoginUrl then it cleanely works.

Re: Logout Problem in forms authentication

SreejithAchutan13-Mar-09 0:28

SreejithAchutan

13-Mar-09 0:28

Thanks for your corordination sir...

export image from sql 2005 to excel

tw-de12-Mar-09 22:32

tw-de

12-Mar-09 22:32

Hi,

I want to export an image field from sql 2005 to excel. This is with vb.net.
Is there anybody who knows if this is possible? And how to do this?

T.

Re: export image from sql 2005 to excel

Christian Graus12-Mar-09 22:42

Christian Graus

12-Mar-09 22:42

How is this an asp.net question ?

Christian Graus

Driven to the arms of OSX by Vista.

Help with a Logic

Vimalsoft(Pty) Ltd12-Mar-09 20:45

Vimalsoft(Pty) Ltd

12-Mar-09 20:45

I have the Following code that runs inside loops

if (txt != array[p].ToString())
                           {
                               /*The I is representing the Rows and the J is representing the Cells
                                */
                               //These are the Cells that are Supposed to be disabled
                               cycleGrid.Rows[i].Cells[j].Style.BorderColor = System.Drawing.Color.DarkGray;
                               cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.DarkGray;
                               cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Wait;

                           }
                           else
                           {
                               cycleGrid.Rows[i].Cells[j].Style.ForeColor = System.Drawing.Color.Black;
                               cycleGrid.Rows[i].Cells[j].Style.Cursor = Infragistics.WebUI.Shared.Cursors.Auto;
                               cycleGrid.Rows[i].Cells[j].Style.Font.Bold = true;

                           }

Now as you can see am disabling cells by turing the color to be gray and by making sure that its not selectable. Now this will work perfectly if the array has a single value in the Array, but when the Value is like this

1 2 3 4 5 6 7 8 9 10 11 12 13 14 17 18 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

i need to Disable the values that does not appear in the array like the above example 15,16,19 will be missing from the list, so in the grid they should be gray and the other should be bold and black. Mybe there is something wrong here , because it only make the 35 im the list and it made it bold and it made others bold to but they are grey but bold. like this

http://www.vbforums.com/attachment.php?attachmentid=69654&stc=1&d=1236926456[^]

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 1:40

Refresh

ᐊ Prev 1...2220 2221 2222 222322242225 2226 2227 2228 2229 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.