Hi Pradipta, Should be that designated folder is a password protected and is disabled from 'Anonymous Access'. Deepak Kumar Vasudevan http://deepak.portland.co.uk/

Thats great,That is what i was looking for Thanx a lot

I apologize for the brevity of my response -- you can achieve concurrency control using transactions in ADO.NET with the SqlTransaction class (see MSDN[^] for more details). However, the following two examples might be more specific to the issue you are attempting to resolve: MSDN Data Concurrency[^] Data Concurrency Exception Handling[^]

What I would consider is this: if possible, create a component shared by the windows application and the web application that returns the expected results in the same form to both apps. For example, you could create a component that returns a recordset/dataset based on values stored in public properties, or perhaps, stores information in a database and returns a value indicating success or failure. The alternative is awkward and a bit kludgey -- you could install the windows application on the server and have your web application impersonate a user account that has permission to execute the application, then use something like the Windows Scripting Host or Winbatch to launch the app and "animate" the correct sequence of events to start the application, produce the correct series of mouse clicks and keystrokes to complete the desired action. I think that performance could be an issue: it is probably not possible to have the app sitting there waiting for activity, so each new user request, in effect, starts a new instance of the app on the server, which, depending on the number of users, could kill your server.

Simply call the same stored proc again in the code: like this: CREATE PROCEDURE MyProc AS . . --your code here . . exec MyProc . . GO the nesting limit is 32 levels (this time i'm sure..got it from MSDN) you can test for the nesting level using :@@NESTLEVEL like : select @@NESTLEVEL AS 'Outer Level'

thanx CBoland Its great and working as per my expectation. Thanx a lot Pradipta

pradipta wrote: N'c:\mssql7\data\pubs.mdf' Are you using SQL Server 7? I can explain how I do it with 2000, but I assume it would be similar process. Open Enterprise Manager. Expand the tree until you find your database server instance. Expand that. Right-click on Databases, select All Tasks -> Attach Database. Browse [...] for your database file. As for the error you are receiving, I don't know what the problem might be. Was the file detached from the original database, or just copied? That may cause problems potentially. But I'm no DBA, so I can't say for sure. Good luck Without nipples, breasts would be pointless.

What do you mean? Do you want to stop windows users from changing the date/time? The system time originates from the system clock which any user can change from windows/dos ect. If you have Win2k or NT4 there may be a way for you to stop them from accessing these options by restricting thier accounts although i'm not sure how. As for locking the date/time from your app. surely if you dont include code that sets the date time which is accessable to the user, then they won't be able to do so. I think you need to clarify what you are trying to do. Regards Wayne Phipps

pradipta wrote: the query u have written only to retrive those DOB which will lie within this week.But DOB means only the month and day will be same whatever may be the year... Sorry about that. Who knows where my mind has be drifting. :-O Try the following: SELECT t.myName, cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime) FROM DOB AS t WHERE datediff(d, cast(cast(Month(getdate()) as varchar(2)) + '/' + cast(Day(getdate())as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime), cast(cast(Month(t.DOB)as varchar(2)) + '/' + cast(Day(t.DOB)as varchar(2)) + '/' + cast(Year(getdate())as varchar(4)) as datetime)) Between 0 and 6 Let me know for sure that this works properly. Jeremy Oldham

Thanx a lot Thats what i was needed

Hi, Why so many textboxes??? Isn't it a bit hard to with for the end user??? If you open your controlbox window you can find a wrapper for control array's Go to your customize Toolbox window. Then select the tab ".NET Framework Components" Find the component "TextBoxArray" that's the compatibility component for the control array. but why not redesign your application to use less textboxes or assign the same eventhandler to one event and check on the "sender" variable. greets, Poolbeer Speak Out! Use the Source, Luke! (Dr. GUI .NET #5)