Problem Solved. It turns out the ACT doesn't like it when there is a VPN connection running in the background. The problem was that I had a VPN connection, once I terminated the VPN connection ACT was able to record fine.

I think the error message is quite clear. The ExcelData is not a valid object that can be used in the query statement. For example, I want to read data from the 'Sheet1' sheet in the .xls file. The command text looks something like this: string command = "SELECT * FROM [Sheet1$]"; Remember to use the $ after the object you make a reference.

Syntax is: [ServerName].[DatabaseName].[Owner].[TableName].[FieldName] So in your Stored Proc your request might look like: SELECT myField FROM myServer.myDatabase.dbo.myTable WHERE myField = 'some value' ServerName can be an ip address, or if it is on the same server - just a different database - you can omit ServerName altogether. Owner is usually 'dbo' -- otherwise substitute the table's owner

Actually I'm looking for a way other than Crystal Report, because I can't use Crystal Reports for other reasons. So, is there any other way to acomplish that. Thanks

You're welcome! I assume you have access to Query Analyzer, yes? You could spend a fun couple of hours just poking around in 1) the master.dbo tables, where lots of useful information is stored; 2) INFORMATION_SCHEMA views, which Microsoft recommends whenever possible; 3) the other databases like msdb, where job and replication info is stored etc. etc. Also look up system functions and sp_ stored procedures in books online. After all that, you'll have the beginnings of the beginnings of a good working knowledge of SQL Server. And get your boss to spring for the Microsoft Press books on SQL Server; they're really good. Regards, Jeff Varszegi EEEP!  An Extensible Expression Evaluation Package

Paul Wilson has a great article all about ViewState: http://aspalliance.com/articleViewer.aspx?aId=135 Marcie http://www.codeproject.com

Yup, This helped me. Thanks Paul!

Thank you for your reply

I believe you can update specific cells of a DataGrid on the client side. I really don't know how though, because I've never needed to do it (yet!). I remember coming across an example somewhere, but I can't recall where! Sorry! Marc Latest AAL Article My blog Join my forum!

Personally, I like the User Control approach in this context. If your wizard had five steps, then you could use five user controls on your form, setting the Visible property of the four not in use on any given step to false. I've also done this sort of thing using your second approach - but in this case I use asp:Panel controls to represent each step - its a lot simpler to tell set the Visible property for a panel to false than to hide each of the individual controls within it.

I didn't really understand right. Questions: 1. These 37 Tables do they all have the same Fields or what is different between them. 2. Do you store different Projects in different Tables? 3. Just show me the first 4 Fields of two Tables that I can understand. 4. What is the relation between the Tables? Database Design is more difficult than many people think. A good structure may help the developers. Please tell me more. Stefan

DotNet WebDev Newbe wrote: 1- When does each of these methods gets called, I understand that they are suppose to be called in the case of session ending and application ending, but what I’m looking for is in what case they actually get called: session time is over, what else. I am not sure but I guess that the Session_End would be called when the session times out. You can do a simple test on your machine, override the Session_Start and Session_End events, and write a line containing current date/time into some text file. You can also play with session timeout, set it to, say, 3 minutes and see if the Session_End is called after 3 minutes of inactivity. You can set the session timeout in the web.config file of your web application, e.g. <configuration> <system.web> <sessionState mode="InProc" cookieless="false" timeout="90" /> </system.web> </configuration> DotNet WebDev Newbe wrote: 2- My problem is I expected them to be called once you close the browser (since the application and session are ending) but they didn’t, I also set breakpoint at them and never got to them Well, I guess that application is not ending when the session is ending. The Application object is shared among sessions, so you cannot expect the application to be started and ended along with sessions. DotNet WebDev Newbe wrote: 3- The BIG Question is I’m trying to get the FormAuthentication.SignOutcalled if the user closes the browser window he is working on so that the authentication cookie gets deleted You don't need to do this - FormsAuthentication uses either a persistent or non-persistent cookie. If you are using FormsAuthentication.SetAuthCookie to generate authentication cookie, the second parameter is bool createPersistentCookie. If this parameter is false, non-persistent cookie is created and this cookie is discarded when the browser is closed. DotNet WebDev Newbe wrote: 4- Is there a similar event handler to handle the closing of the browser window I am not sure if it is possible to detect such event on the server side, but it is possible on the client side using JavaScript, using the onUnload event. Rado

Wow, tons of good questions, I will answer what I can. :) 1 - Does each user access a separate area of the file server, or is it common for all users? If it is common for all users, You can give the ASPnet account the essential rights on the file server. All your aspx pages operate in the ASPnet user's context. Also, you can change the machine.config file to run using any Windows account, but the password is stored in clear text in the file. If it is different for each user, you should probably look into Impersonation. You can programatically change the account that the code is executing with. See ASP.Net Impersonation on MSDN. It is not very difficult, only a dozen or so lines of code. 2 - Why not use Windows authentication instead of forms authentication? No need for a login page. Set up the site in IIS for Windows authentication and let IIS do the work. This won't work securely for all browsers though. 3 - See above answers. Side - ASPX pages run under the ASPnet user's context unless you have edited machine.config to use a different account. HTML/ASP pages run in the context of the IIS anonymous user (if that is what is assigned in the IIS console). Using Impersonation you can get the ASPX pages to use the user account assigned by IIS. Dave

Rocky Moore wrote: The later makes the process faster and is the perferred method for transferring to a page on the same server. Just want to add: 1. Server.Transfer doesn't seem to work between virtual directories on the same server. For example, you cannot transfer to a page on a different virtual directory, even if it is located on the same website. 2. You cannot use Server.Transfer with non .NET pages (.asp pages, for example). Click here to see my articles and software tools

Thank you very much for your response

Strings have to enclosed in quotation marks in an sql query. For example, you cannot do SELECT * FROM table WHERE text = whatever you must enclose whatever in single quotes SELECT * FROM table WHERE text = 'whatever' Now if you are building your own string in a variable, you need to explicitly enclose them in single quotes.

DotNet WebDev Newbe wrote: So there is no way to do it directly from ASP or ASP.net Not from ASP, and I've never done ASP.NET, but I don't think there is a way without using 3rd party software. Ryan Being little and getting pushed around by big guys all my life I guess I compensate by pushing electrons and holes around. What a bully I am, but I do enjoy making subatomic particles hop at my bidding - Roger Wright (2nd April 2003, The Lounge) Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late - John Nichol "Point Of Impact"