Write down your requirements. Break them down into screens and design the navigation using HTML. Show it to your potential users and get feedback from them. This will allow you to understand what you require to do. So far, no coding is involved. Once this is done, then take ONE screen to develop. Attempt to do it on your own, use Google. If you get stuck in something technical, find out the appropriate forum and post the technical question there.
Shreekar
OK - lets do it one step at a time. Have you managed to save the uploaded image to wherever you want?
Shreekar
One idea could be do to disable all relations/checks/constraints on the report tables, execute CDC statements and then re enable relations/checks/constraints. Your execution should handle errors nicely though for this to work.
Shreekar
It does not necessarily require user name/password. All you need to know on the server is: who and when the report was sent and what does the report say. You could implement some sort of hash to filter out spam traffic at http end. If ASP/.Net is no go and you have PHP skills, you can rustle up a simple form to accept the above information on your website. *Then* you could send an email or insert into database or whatever from the webserver. You could then submit this form from your desktop application code. It does seem daunting at first for a bug reporting mechanism - but this is a much reliable approach than trying to send the email. Hope this helps.
Shreekar
A word of caution: Make sure filezilla.exe is in the PATH variable. Or You provide absolute path to the filezilla exe Or You place the bat file in the correct location with relation to how you have called the filezilla exe.
Shreekar
Multiplying by 1.0 is definitely easier on the eyes than multiple nested cast statements and produces the same output - at least in my case because there is only one operation. So thanks for that. Earlier, I had read posts alluding to this technique but I had missed the point - now I get it.
Shreekar
Just missed your post. Realised the same solution as you suggested. Thanks for the confirmation!
Shreekar
Figured it out myself, I cast the operands themselves to decimals and the product was decimal. Sorry about that - turned out to be loud thinking than a genuine question.
Shreekar
OK - I have tried the below:
declare @d decimal(10,2)
select @d = 859 * 1/5
select @d
This returns 171.00 and
declare @d decimal(10,2)
select @d = 859.00 * 1/5.00
select @d
This returns 171.80 This tells me that the 2 numbers participating in the operation have to be decimals by definition. Is there any way to work around this as I do not want to change the column types to decimals as I do not expect them to hold fraction data any time. It is only the result that may have fraction data. Any ideas?
Shreekar
Hi Database: SQL Server 2005 select 589/5 produces 117 How can I make it return 117.8? I am doing the division operation on 2 int columns and want the output in decimals. Do I have to make the columns themselves decimal? Thanks
Shreekar
I am not anyone - so I cannot help you. Shreekar
Without looking at your code but looking at your post, it is clear that the code for populating that printer drop down is written at server side. So it would NEVER show you the client's list of printers, it will show you the list of printers on the server. It is important that you understand this fundamental concept. To achieve what you need - you will have to write some client side scripting or ActiveX - though I am not sure that can be achieved since the browser may not be allowed to have access to the client's resources through script. Generally, it is the end user's responsibility (privilege?) to select the printer he wants to use. You can put out some advise for the user to select a correct printer. Hope this helps. Shreekar
Assuming that the set of menus are defined by the user type, you could build .js files with static menus per user type. Include the appropriate .js file dynamically according to the user. Alternately, include the .js files in the correct set of pages with a particular menu level. Shreekar
Have you looked at AJAX and UpdatePanel? Shreekar
I think you need to work on the database design first before you tackle the front end. Like you said - create a table with list of questions. Create another table with list of possible answers per question. This will give you Id(s) to work with for question and answer. About the dropdowns,you have to display the data in the dropdowns, so that needs to be transported to the browser. While writing back to the server, you can use the selected id(s) of the answers. This way you can use bound controls as well. Hope this helps. Shreekar
I think you have understood that it will take a long time to process. The problem if I am correct is how to make the user wait for the result? My suggestion would be to decouple the processing and the status reporting. So, the once the file is submitted by the user, 1. Save the file to disk, save the location to a queue table and tell the user that the application is processing his file. 2. On the server, write a service to read that queue table periodically and process the file. You could use fire and forget threads here. 3. The service would write some progress update to a progress table. 4. The status page shown to the user can read this progress table with the file id as the filter. You could also expose a web service to check on status of a file Shreekar
I dont see any relation between the tb object in the ITemplate.InstantiateIn method and the tb object in the upper section of your code. Would not it be better if you added the event handling code to the same block of code that creates the text box? So, just after creating the tb object (in upper section of your post), add the event handler to the tb object. Shreekar
Please share the relevant code as the sequence of events might have some bearing on the problem. Can you see the list of values in the dropdown? Shreekar
vinci007 wrote: some Desktop based Project I assume this was a typo. Provided that you have setup the data source for the comboboxes in the template (if using them), and the selected text matches the valid entries, the display should be correct. You may also need to provide the selectedvalue properties though. What is the error/problem? Shreekar
Not an answer, but a question - Why are you creating the SP in your code? Shreekar