Recent content by JasonNevin

OK. points taken. Thanks.

I agree with all your points but still somehow it seems inefficient. Is it in any way inefficient i.e is it detrimental to the performance of the database? Is it even possible to build this model using standard SQL server methodlogy?

I have a similar problem where I have three tables (tbl_user, tbl_site and tbl_service_centre) each of which has a unique set of fields but also a common set of address fields. Surely the correct way to implement this model would be to have a single address table (tbl_address) with a...

It varies. On some forms there is just one, on others 15.

I have been having a problem getting my required field validators working. When I click on my 'submit' button it posts back and runs the on_click vb .net event but doesn't seem to validate the page. What is even more spooky is that when I remove the on_click events from my code so that the...

ca8msm Excuse my ignorance but am I not using relative positioning?

I am trying to use a repeater to print a multiple form and map data to the form. The form itself is stored as a gif and I'm trying to map to sections on the graphic so that my database fields print in boxes, etc. I have managed to achieve this as far as viewing the data on the screen but when I...

Excellent. Opened a new window as I required. Only problem was that the redirect I performed after running DownloadFile is not being executed so my users still have to use the back button. Is my method correct? code: DownloadFile(strPDFFile)...

I have a VB.NET web form that creates a PDF report based on some database results. The form uses response.redirect to display the file it creates. What this means of course is that the user has to use the back button in their browser to return to the page from where they triggered the report...

jbenson001 I already have that column. It contains the duplicate values I've spoken about. I could use it to lookup after the postback but it means two DB reads. ca8msm's method only requires one DB read. Thanks.

Yeah that'd work. Good man.

Sorry, I should have explained a bit more. I'm readling the values from a database table so hard-coding anything is not really an option.

Good morning I've just found out that the value field in a DropDownList must be unique. In which case does anybody know of a way of dealing with duplicate values? I want to be able to select from a long list which automatically assigns my selection a score. i.e...

How do I setup a dropdownlist control on a web form that allows both selection of values and free text? I.e My customers can either select a value from the list or type in the value they want (similar to the limittolist property for combo boxes in Access). Thanks.

I have a VB module with a sub that I'm using to handle errors. I want it redirect to a standard error page.