ASP.NET

SeMartens14-Apr-09 22:11

SeMartens

14-Apr-09 22:11

Work with timeouts. As every user has its own session, you can catch the session-timeout-event. When this event fires you know that the user didn't take an action during the last xx minutes. Deactivate the user in your database according to this event.

Regards
Sebastian

P.S.: A handler for this event can be found in Global.asax.

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Karthick_gc14-Apr-09 22:15

Karthick_gc

14-Apr-09 22:15

Cant understand. Can u explain briefly?

Christian Graus14-Apr-09 22:19

14-Apr-09 22:19

It means you're probably not clever enough to be attempting this task. Which part of the clear explanation you were given used terms you're not able to comprehend ?

There is a better way, but it's also more complex, so there's probably no sense in trying to explain it.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

gridview validation not working within upadate panel

SeMartens14-Apr-09 22:58

SeMartens

14-Apr-09 22:58

Do the following:

1) Open the Global.asax-file of your ASP.NET project
2) Go to the method void Session_End(object sender, EventArgs e) ...
3) Call the method you are using to deactivate the user (if he clicks at the logout-button) within session_end

@Christian Graus: I'm interested in the better way to do this you mentioned. How does it work?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

z-index Problem

Niungareamit14-Apr-09 21:45

Niungareamit

14-Apr-09 21:45

Hi,
I am using an Update Panel. inside the Update Panel I vahe 5 DropDown List control

for this Update panel i am using an UpdateProgress control of AJAX. In UpdateProgress control I have used div tag with z-index property.
I want that when I run the application and choose any items from any DropDownList, an UpdateProgree should overlap the entire UpdatePanel.

But i am not getting an output.

So, If u have a solution for this, please Help me............

Abhishek Rana14-Apr-09 21:37

Abhishek Rana

14-Apr-09 21:37

hi,
I am devloping a web application in which i am using gridview with its template field and apply update panel on it. but what happen the validation on gridview is not working properly.and when i remove the update panel its working correctly.
I m unable to find why its happen can any on ehelp me for the same.

About the multiple instances of same form

Abhishek Rana14-Apr-09 21:31

Abhishek Rana

14-Apr-09 21:31

hi ,
I am devloping a web application in which i have an menu from which diffrent pages can be open now what i want is to restrict the user to open the same page from the menu more than once.so how do i restrict.

Thanks in advance for your help.

Re: About the multiple instances of same form

Christian Graus14-Apr-09 22:13

Re: About the multiple instances of same form

14-Apr-09 22:13

If the pages are popups, then you can do this using javascript. keep a reference to each open window and focus on it if someone tries to open it when it is already open.

Abhishek Rana14-Apr-09 22:22

Abhishek Rana

14-Apr-09 22:22

Thanks for replaying

But these pages are not popups these are the master form ,
whats the requirement is that when once the form is open and user agian tries to open it it should not do any thing.

Re: About the multiple instances of same form

binarymax15-Apr-09 4:52

binarymax

15-Apr-09 4:52

Keep a list of the open pages in a Session object. For each event that would open a page (clicking a link, clicking a button, etc), check the target page versus the session list and see if it exists. Open the page for the user based on that.

how to change the filter expresion at runtime ?

md_azy14-Apr-09 20:32

md_azy

14-Apr-09 20:32

Hi,

<asp:SqlDataSource ID="grid_source" runat="server" ConnectionString="Data Source=db;Initial Catalog=faq;User ID=sa;Password=mercury"
ProviderName="System.Data.SqlClient"
SelectCommand="SELECT [c_empcode], [c_name], [c_designation], [c_department], [c_emailid], [c_reportingPerson], [c_passwd], [n_status] FROM [Employee_Mst] where n_deleted =0"
OnSelecting="grid_source_Selecting"

FilterExpression="c_name like '{0}%' and c_department like '{1}%' " >

<FilterParameters>
<asp:ControlParameter Name="c_name" ControlID="txtname" PropertyName="Text" />
<asp:ControlParameter Name="c_department" ControlID="txtdepart" PropertyName="Text" />
</FilterParameters>

</asp:SqlDataSource>

This is my sqldatasource in that i used filter expression for filtering data . if txtdepart textbox is empty means its
not filtering records according to what i entered in txtname texbox .if i am entering some datas in all two textbox's then its
showing filtered records . can anyone tell me the solution for this ?

also i need how to change the filter expresion at runtime according to these textboxes values .

Thanks in advance

Re: how to change the filter expresion at runtime ?

Christian Graus14-Apr-09 21:05

14-Apr-09 21:05

The SQLDataSource classes are not suitable for real world programming. If you're doing a professional project, you should not use them.

What you're describing seems to me to be a bug in the classes tho, what have you turned up on google, I'd expect other people would have asked the same question.

object tag problem

naveen attri14-Apr-09 20:23

naveen attri

14-Apr-09 20:23

i m using serverside object tag in my application

it is showing an error

Error 4 Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

any one can help me?

Re: object tag problem

Christian Graus14-Apr-09 21:08

14-Apr-09 21:08

Wow - you're really stupid, too.

1 - this has nothing to do with ASP.NET, it's a pure HTML question
2 - perhaps you could tell us why you think you've entered a valid GUID, and post your code, so we can explain to you why you're mistaken. The answer is, you need to enter a GUID in the correct format. That's what the error says.

Re: object tag problem

naveen attri14-Apr-09 22:42

naveen attri

14-Apr-09 22:42

i m not playing with guid anywhere
i m new to asp.net
how can i fix this error

sql problem

ptvce14-Apr-09 19:25

14-Apr-09 19:25

i write this code in my sqlserver does anybody know why it doesnt work. it has error in inner join. plz help Sigh | :sigh:

UPDATE [servername1].[WebSite].[dbo].[Table_1] INNER JOIN [servername2].[website1].[dbo].[Table_2] ON Table_1.id = Table_2.id SET Table_1.name1 = [Table_1].[name2]

Abhijit Jana14-Apr-09 19:35

Abhijit Jana

14-Apr-09 19:35

This is ASP.NET Forum , please post it in SQL Forum.

cheers,
Abhijit
CodeProject MVP

Vimalsoft(Pty) Ltd14-Apr-09 23:16

14-Apr-09 23:16

Do not Post SQL Questions here. I hope its the Last time you do this. You need to use a "from" like this

UPDATE [servername1].[WebSite].[dbo].[Table_1] 
SET Table_1.name1 = [Table_1].[name2]
FROM [servername1].[WebSite].[dbo].[Table_1]
INNER JOIN [servername2].[website1].[dbo].[Table_2]
ON Table_1.id = Table_2.id 
pre>

Check the your Statement from the Bolded and what ever follows 


Hope this Helps


Vuyiswa Maseko 

<div class="ForumSig">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
</div>

ptvce14-Apr-09 23:42

14-Apr-09 23:42

thanks for ur help, yes is it work now but if my tables be in diffrent server it has error i have problem when i have 2 server

and thats error is : Could not find server 'SPSERVER16' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Vimalsoft(Pty) Ltd14-Apr-09 23:44

14-Apr-09 23:44

Check your Permissions in the Link Servers

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

ptvce15-Apr-09 0:41

15-Apr-09 0:41

i run this:
EXEC sp_addlinkedserver
@server = 'SPSERVER16',
@srvproduct = '',
@provider = 'SQLNCLI',
@datasrc = 'SPSERVER16'
GO

and then run this:

EXEC sp_addlinkedsrvlogin spserver16, FALSE, sa, 1234
and its succses
and then run:

EXEC sp_tables_ex spserver16
GO

and it has this error:

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Vimalsoft(Pty) Ltd15-Apr-09 0:49

15-Apr-09 0:49

Why don't you add a link Server manually not from T-SQL, supplies the credentials there , and in your Code you call the name of the Link server. Doing it in T-SQl you might encounter credentials Problem

ptvce15-Apr-09 0:59

15-Apr-09 0:59

both of them is equal, when i manually create linked server i has this problem too

Vimalsoft(Pty) Ltd15-Apr-09 1:06

15-Apr-09 1:06

Talk to your DBA about the Problem , remember again not everyone can create a Link server, sometimes you might Create a link server and not have permissions to access data on the Other side. Your have a permission Issue.

ptvce15-Apr-09 1:22