Hello, this is Vikash Gohil. I have a windows service that takes data from the database and does some processing on that data. I have also added licencing functionality to the service so that people using it will require to register with us. Initially the service would run in trial period and would expire after 30 days. Now I want the below functionality. I want to add a User Interface in the Service which will popup when user clicks on SysTray icon of my service. This UI would allow user to Register service using a Licence file on trial period expiration. And also when registeration form is open, i want the service to pause as i am using sleep command in my service, which will lock the UI if service is running. Can someone provide me some idea how to do it. Any help would be greatly appreciated. Thanks in advance. Awaiting a reply soon.

Hello, Brij. I was also thinking of using registry but is it possible to read registry values from a web page. Bcoz i think this will create security issues. Can you guide me in this direction with some info. If it is possible to read/write registry from web page, can u provide some link to do this. Thanks in advance, awaiting a reply soon. Again thanks for the reply.

Hello, This is Vikash Gohil. I have developed a web Application and Now I want to add functionality of evaluation period in my web app, so that I can give my application as Demo to customers. Can anyone please suggest me some functionality for this or some guidelines how to achieve this. Any information would be greatly appreciated. Thanks in Advance, Awaiting a reply soon.

Hello, Dalek. Thanks for Reply. I will surely try using Sleep. Thanks.

Hello, Estys. Thanks for your reply. I thought of using Sleep. But many posts on the net suggest that using Sleep is a bad practice. So is there any risks or disadvantages in using Sleep. Please reply if you know anything about this. Thanks Again.

Hello, this is Vikash Gohil. I have Created a Windows Service which does the following when service is started : Connects SQL Server 2000 Database. Starts a Threads. Thread executes a while loop In the while loop, Current system time is taken using : format(now,"HH:mm") A Query is made to a Table in Database to look for records as below. "Select From Where ='" & format(now,"HH:mm") & "'" if any record exists, then a particular procedure gets executed. The above code continues to run in a while loop 24/7 The problem I am facing is, the service takes aroung 98% CPU Usage. The Database Table contains only 20 to 25 records. I want to know why this thing is happening. Is it bcoz of the while loop. If yes, then what to use instead of while loop? I Can't change the Service functionality as it is a client requirement. Please can anyone guide me in this matter. Any help would be greatly appreciated. Thanks in Advance, awaiting a reply soon.

Hello, MyCroft. Thanks for the reply. Are the files/folder read only? When I put the same files in the folder where system database files are present, i.e. Master, Model, etc., and then manually attach these files using Sql express Management studio, then there is no problem. The problem of Read-Only occurs only when data files are present in some other folder. Does your app have permissions on the folder? During Installation of the software, we have set the permissions as Everyone, so I don't think that is the problem. Also we have been using this with MSDE the same way and there are no problems. Have you set up the user correctly? We Use default 'sa' user for making connections. Also the ConnectionString is absolutely proper as it works fine with MSDE.

Hello, This is Vikash Gohil. I have a Software which is using MSDE Database (SQL2000). When the Software is run for the first time, it checks for the database name and if not found attaches the MDF and LDF files that are present in the "\Data" folder. I don't face any problem in this setup. Now I want to move from MSDE (SQl2000) to SQLExpress (SQL2005). I Created the MDF and LDF Files, Installed SQLExpress and My Software. After this I Copied the MDF and LDF Files in "\Data" Folder. The problem is, when I start the Software the database files are attached, but it shows below message: "Failed To Update Database "", the Database is Read-Only." And the software does not start. I want to know why this happens? I do not face such problems in MSDE. I have Searched for this on net and found that the SqlExpress should have rights for the folder where MDF and LDF Files Exists. But I don't know how to Set rights for my "Application Path\Data" Folder. I am totally new to SQL 2005. Please someone can help me in this matter. Any help would be greatly appreciated. Awaiting a reply, Thanks in Advance.

Thanks daveauld for the reply. The post was really helpful. Thanks Again

Hello, this is Vikash Gohil. I have a windows Service that runs a thread on starting and the thread uses a while loop. Now I want to Use Sleep function in my windows Service. I want to know is it really OK or is there any kind of risk involved in making a windows service sleep. the sleep time i want to use is around 55 to 58 seconds. Please could anyone give me some guidelines on this topic. Awaiting a reply soon. Thanks in Advance.

Hello, This is Vikash Gohil. I have a small ASP.net sample project. Now there is a default.aspx page in the project. There is also a DLL file in the Bin directory named "App_Web_Default.aspx.dll" Now in the MarkUp of the Default.aspx page, below Page directive is given. <%@ Page Language="VB" AutoEventWireUp="true" CodeFile="Default.aspx.vb" Inherits="_Default, App_Web_Default.aspx" %> I am not able to understand the "Inherits" clause. I think the App_Web_Default.aspx is the DLL name present in the Bin Directory. I want to know what it actually means. Has anyone come across or used code in this manner. Please provide me some clarification. Any help would be greatly appreciated. Thanks in Advance, Awaiting a reply soon.

Hello, Abhijit. Thanks for the reply. I have gone through the article as suggested by you. I have a query. The article says of mapping the network printer on the Server and to do this we have to make changes in registry. I want to know how mapping of printer is done and what changes do I have to make in registry so that the Web Server has full rights for network printer. Can you please provide me guidance in this issue. Awaiting your reply. Thanks Again.

Hello, this is Vikash Gohil. I have a developed a Web Application whereby i need to print a report from my application. The printer is installed on Client PC and is shared on the network. I have installed the printer on the Web Server. The Code I use is: report.PrintOptions.PrinterName = "\\PCName\PrinterName" report.PrintToPrinter(1,false,1,1). Now the problem I am facing when given print from Web Server is as below: When I give command for Printing a Test Page, it prints properly. When I give Print command from a Word, PDF etc documents, it still prints properly. But When I give Print Command using above code from My Web Application (ie from Browser Window), it displays a error Message on the PC on which Printer is Attached. Spoolsv.exe Application Error Message : "The Instruction at "0x500a0330" referenced memory at "0x00000000". This memory could not be read. Anyone has any idea why I am getting this message when printing from my Application and not while printing normally. Do I have to Set any other permissions for the Printer on the Server, eg. permissions for IIS to Print from that printer or permissions for ASPNET user for the printer. Please Anyone could suggest me some thing in this regards. Any help would be greatly appreciated. Awaiting a reply soon. Thanks in Advance.

Hello, Chetan. Thanks for your reply. But what I want is not hiding the actual URL from the user. My actual requirement is to execute code written in page_load event on another page without redirecting to that page. Is this thing possible? Please reply.

Hello, danish. Thanks for your response. But the problem is I cannot change any code as it is not my creation, it is like a 3rd party Control so i can only use it and not change anything. But anyway thanks for the reply.

Hello, This Is Vikash Gohil. I need some guideline/help on the following issue. I have a webpage with a function written on Page_load event which takes the arguments from url using querystring and prints a single line on the page after execution of the function. Now as per my knowledge, if i need to execute that function, i need to provide the full url in the address bar of the browser along with arguments needed. Now what i want is, I dont want my webapp to redirect to that webpage but still need the function on that page, to get executed with the dynamically passed argument values. Now, in first place, is this thing possible? If yes, then can someone tell me the way to do it. if no, then can i achieve this functionality in some other way? All i want is the user must not be redirected, but still want to execute the function on another page. Awaiting a reply soon, any help would be highly appreciated. Thanks in Advance.

Hello, This is Vikash Gohil. I don't know whether this is the correct forum for my Query. My Query is I want to print barcodes in Crystal Reports and use the report in ASP.net application. Using report in ASP.net I have the Idea, but how to print Barcodes in the report. Is there any in-Built functionality in Crystal Reports for Printing Barcodes or Do I have to use any 3rd party tools. Please anyone who has done this before or can provide me some idea, would be of great help. Awaiting for a reply soon. Thanks in Advance.

I have a Web Application Where I have created an OCX Control for working with Excel Files. The OCX Control also connects to the database. Now I want to know how can I pass the connectionstring to the OCX Control from my web page when the Control is loaded. Currently I have hard coded the connection string in the control but I want a way to pass it during runtime. Can anyone please give me some idea on this topic. Any help would be greatly appreciated. Thanks in Advance.

Hello, Sandeep. Thanks for the reply. I have Used an SQL DataSource to Bind Data to the Gridview. Initially I had written the Select Command for DataSource in Page_Load event as follows: Page_Load(...) if not page.Ispostback then SDS.ConnectionString = SDS.SelectCommand = GridView.DataSourceID="SDS" GridView.DataBind end if Now the problem here is when first time the page is loaded, the grid displays properly. But when the page postback happens the gridview disappears, bcoz there is no selectcommand in the DataSource. So I have to compulsorily write the above code as below. Page_Load(...) SDS.ConnectionString = SDS.SelectCommand = GridView.DataSourceID="SDS" GridView.DataBind if not page.Ispostback then end if And what do you mean by saying Filtering Client-Side or Server-Side, could you explain a bit about both types. Thanks in Advance, awaiting a reply soon.

Hello, This is Vikash Gohil. I have a problem related to Gridview as mentioned below. I have a gridview page that displays All data from a table on page load. Now I have also provided Data Filtering options on the same page for filtering data that is displayed. Now when the user provides a filter condition, gridview only displays the filtered data. But once the user clicks on Next or Previous in the Gridview pager, the filter gets removed and the grid again displays all the data. What I want is the filter condition should remain until the user provides another condition for filtering. How can I go about doing this. Anyone can give me some idea. This would be of great help. Awaiting a reply, Thanks in Advance.