Re: Windows Authentication - ASP.NET Discussion Boards

Help with using SqlCacheDependency programmatically?

Member 43208318-Apr-10 0:58

Member 4320831

8-Apr-10 0:58

Hi,

I have a web page that uses the AJAX framework. Basically you choose something in a dropdown and click a button and the page is partially refreshed to show a gridview(which is inside an UpdatePanel with the trigger as the button). You choose a different option and click Go, the gridview is updated accordingly.

Now, I want to use sqlcachedependency in codebehind (since I'm not using SQLDatasource and doing it all programmatically). In my code, I have the code to populate the dropdown in Page_Load and in the Gridview_Load, I create my SQLCommand object. I found the following code and seems pretty simple:

SqlCacheDependency dependency = new SqlCacheDependency(comm);
int expire = 3;
DateTime exp = DateTime.Now.AddMinutes(expire);
Response.Cache.SetCacheability(HttpCacheability.Public);
Response.Cache.SetExpires(exp);
Response.Cache.SetValidUntilExpires(true);
Response.AddCacheDependency(dependency);

But the question is, where do I put the code to ensure the DB isn't queried and data is actually retrieved from Cache??? Should I put it before or after my SQLDataAdapter.Fill in Gridview_Load? Or is it somewhere else?

Thanks in advance Smile | :)

Re: Help with using SqlCacheDependency programmatically?

Not Active8-Apr-10 1:32

Not Active

8-Apr-10 1:32

Have a look here, http://msdn.microsoft.com/en-us/library/9dz445ks(VS.80).aspx[^]

I know the language. I've read a book. - _Madmatt

check session timeout

alfhv7-Apr-10 22:45

alfhv

7-Apr-10 22:45

Hi guys,
I want to check in my application the expiration of session in order to demand the user to reconnect.. or just lock the current page.
I'm using the code in example Prevent Session Timeout in ASP.NET[^] wich work great.
At the end of session I show an Ajax modalPopup asking for reconection..but.... from my pages I can open popup windows to continue edit data.
Then, the problem is:
I have a main page with javascript code running decrementing the session time, when I open a popup window the session timeout restart but the javascript in main page continue counting the old timeout.. So, I get main page locked when I'm using popup windows.. and when session is stil active.

I need a way to restart the javascript in main page, or better, to really check if session is valid from javascript code in the main page before to lock the page.

any hint ??

thanks a lot

Re: check session timeout

Dinesh Mani7-Apr-10 23:40

Dinesh Mani

7-Apr-10 23:40

I'm not sure if you thought about this but, can't you just reset counter on the parent page before you open the pop-up? You are anyway going to open the pop-up using java script or by using target property on a link.

You can alternately use the window.opener.document property from javascript function on the pop-up to access the parent window.

Links for the latter -
Passing of value from child to parent window[^]

Accessing parent window from child window or vice versa using JavaScript – options explored[^]

HTH!

Re: check session timeout

alfhv7-Apr-10 23:45

alfhv

7-Apr-10 23:45

Yes, sure, I can do it, but I'm looking for some other solution to keep independient popup windows from parent.
I have a lot of popup windows to implement it.. so I would like to do it once in the parent.

Thanks anyway.

Windows Authentication

Paul Unsworth7-Apr-10 22:39

Paul Unsworth

7-Apr-10 22:39

Hi Guys

I'm a bit of a newb to the joys of ASP.NET, and I have a bit of a problem...

I'm trying to use windows authentication with my app as it's intended for intranet.

I have the following in my main web.config:

<authentication mode="Windows"/>
	<authorization>
	<allow users="*"/>
	<deny users="?"/>
</authorization>

And I have the following in the config file of a directory that I only want certain users to see:

<configuration>
    <appSettings/>
    <connectionStrings/>
    <system.web>		
	<authorization>
		<allow users="unswortp"/>
		<allow users="HO\unswortp"/>			
	</authorization>
    </system.web>
</configuration>

My problem is the restrictions on the folder will not allow me to get into that folder when deployed to the IIS server, although it works fine on my development machine. I cant help but think that the Windows Credentials it is using are not on the local machine, but on the server, so once deployed to the server, I have no chance.

Am I doing something wrong? or is this just the way the windows authentication works in ASP.NET Apps?

Is there something else I need to set up?

Also, how would I pluck the Windows Username of the end user programatically?

oooo, the Jedi's will feel this one....

Re: Windows Authentication

Dinesh Mani7-Apr-10 23:27

Dinesh Mani

7-Apr-10 23:27

Check your Directory Security tab in the website property in IIS. May be IIS is configured to allow anonymous access while your application is denying access to anonymous users.

Check the below links for details on how to use Windows authentication with ASP.NET and how it works.

How To: Use Windows Authentication in ASP.NET 2.0[^]

Recipe: Enabling Windows Authentication within an Intranet ASP.NET Web application [^] This is 4m Scott Guthrie's blog.

Explained: Windows Authentication in ASP.NET 2.0[^]

HTH!

Re: Windows Authentication

Paul Unsworth9-Apr-10 0:15

Paul Unsworth

9-Apr-10 0:15

Thank you.

oooo, the Jedi's will feel this one....

Shape File Reader

kjsl2k97-Apr-10 22:14

kjsl2k9

7-Apr-10 22:14

Hi,

I am using the Sharp Map to Show the Map.I want to display the information of a particular point on mouse click how can this be done.Is there any utility which is avaialable

Thanks.

conversion

Kissy167-Apr-10 21:14

Kissy16

7-Apr-10 21:14

Hai all,
I have a doubt.
I have both .net 1.X and 2.0 applications and both the versions of VS were installed in my machine.
If i migrate my vs 2003 app to vs2005,and before that i have taken backup of that vs2003 app.
Here i am doubting that if i convert it into 2005,can i open that backup application again in 2003??
Hope u got my doubt and please respond to my question.
Thanks in advance.

kissy

Re: conversion

R. Giskard Reventlov7-Apr-10 21:24

R. Giskard Reventlov

7-Apr-10 21:24

Yes, you should be able to do so.

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: conversion

Kissy167-Apr-10 22:06

Kissy16

7-Apr-10 22:06

thanks for the reply,my doubt is clear.
I am trying now,definitely i have to be very care before conversion.

kissy

Re: conversion

Dinesh Mani7-Apr-10 21:39

Dinesh Mani

7-Apr-10 21:39

as long as the backup is not converted or you do not swap solution files between backup and converted files then you should be able to open the sln in VS 2003.

BTW, most VS2003 apps get converted to 2005 without errors, so don't worry. Also, VS ask you if you want to save a backup before converting the solution, you can use that back up as well.

Re: conversion

Kissy167-Apr-10 22:04

Kissy16

7-Apr-10 22:04

thanks for the reply,my doubt is clear.I shd be careful while conversion by giving correct path.

kissy

dll resource and w3wp.exe memory leak

swjam7-Apr-10 20:56

swjam

7-Apr-10 20:56

say a web application uses a dll assembly as a resource and the dll has memory leak. this shows up as memory leak in w3wp.exe right? since all resources are loaded by the application pool which comes alive as a w3wp.exe?

many thanks.

----------------------------------------------------------
Lorem ipsum dolor sit amet.

gridview paging problem

developerit7-Apr-10 20:36

developerit

7-Apr-10 20:36

hi iam using asp.net2.0 with c#

In the gridview 1st column is checkbox,in my gridview iam using paging , iam dispalying data at page load,

when user selects the check box that records are stored in database.
but when i selects the checkbox at 1st page then it is
storing all the records but when i selects the 1st page records as well as 2nd page records
then it is storing only second page records .

iwant to store all the records what ever user has selects the checkbox.

can you give me example which helps me.

Re: gridview paging problem

Arun Jacob7-Apr-10 20:45

Arun Jacob

7-Apr-10 20:45

Which event you are using for saving record?If you iterate through a gridview you'll get only the rendered page rows not the entire rows as expected. otherwise you need to save the DataSource in some persisting object and need to iterate through it.

Arun Jacob
http://codepronet.blogspot.com/

Re: gridview paging problem

developerit7-Apr-10 21:11

developerit

7-Apr-10 21:11

iam using button click event.

when users selcts the records from 1st page or from second page then what ever user has selected that should be save in database .but it is not happening.the only last page you have visited and selects the records that is stored not the previous records

how to solve this situation can you give example which helps me,

Re: gridview paging problem

Blikkies7-Apr-10 21:47

Blikkies

7-Apr-10 21:47

What you can do is, on the PageIndexChanging event you iterate through the grid and add all checked records to a collection, same with the second page, and when he click on submit you save the collection.

Re: gridview paging problem

developerit8-Apr-10 0:00

developerit

8-Apr-10 0:00

can you give example how we can add the records to the collection

Re: gridview paging problem

Blikkies8-Apr-10 2:52

Blikkies

8-Apr-10 2:52

can you provide your grid source?

Re: gridview paging problem

Sunil Scaria8-Apr-10 2:35

Sunil Scaria

8-Apr-10 2:35

Persist the Data either in the page view state or inside the session.Both these way will cause a severe performance issue.

Re: gridview paging problem

Tej Aj8-Apr-10 3:48

Tej Aj

8-Apr-10 3:48

check this latest post for ur issue

http://opexsolution.com/forum/viewtopic.php?f=15&t=20&p=52#p52

Database Connection in asp.net

sarang_k7-Apr-10 20:19

sarang_k

7-Apr-10 20:19

Hi all ,

I have created an asp.net application and my database is on another system.I want to connect that database to my application from that another system using the webconfig file. How can i do it ?

Thanks in advance.

Re: Database Connection in asp.net

yogesh_kumar_agarwal7-Apr-10 20:51

yogesh_kumar_agarwal

7-Apr-10 20:51

define the connection string in web.config under appsettigns tag like;

<appsettigns>
<add key="name" value"Data Source=remote pc name; uid=userid; password=sqlserverpassword;Initial Catalog=Database name"/>
</appsettigns>

</pre>

or U can use the connection string tag also. 

call the same is ur cs or vb file using configuration managaer class.

Last Visit: 31-Dec-99 18:00 Last Update: 26-Apr-24 13:03

Refresh

ᐊ Prev 1...990 991 992 993994995 996 997 998 999 Next ᐅ

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