Search results for query: *

Hi I have to implement some business logic that switches at 07:00 New Zealand time. This is the case regardless of there the logic is being run, ie NY, London etc. I cannot find any TimeZone classes, and it looks like Microsoft have taken a decision not to support this kind of thing anyway...

Hi A database I am working with has a UDT which is defined as not nullable. However, I am able to set variables of this type to be null, as well as assign null to table columns of this type. This seems like strange behaviour to me. Can anybody tell me what setting a UDT to be not nullable...

The subject kind of says it all really ... Is there a limit on the number of columns you can return in a query? If so, what is it? Thanks!

Hi I have a table that can contain numerous records with the same transaction id, each of which can be set to one of a number of statuses. I would like a query that will only select me transaction ids where they are all set to a specified status. For example, for this table (run this in Query...

Hi I have developed an ASP.NET application which runs on an intranet, and uses Active Directory roles for Windows Integrated security. I have up until this point been using a single SQL Server account to access the database, which is stored in the web.config file along with its password...

Hi I would like to use a Multi Line TextBox, but I only want it to display scrollbars when they are required (ie when the text doesn't fit into the box). Is this possible? I am think I already know the answer, but figured it is worth asking the question!

Hi I have a number of orphan connections when I run sp_who. How do I kill these?

Hi I have been having a recurring problem with the connection pool, getting message like USERNAME: etc: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached...

Hi I am working on an ASP.NET application which uses Windows Integrated security. When the session expires, I would like to display a message to the user explaining what has happened, and then redirect them to their start page. Can anybody tell me how I may do this? Regards

Hi I have an interesting problem that is driving me mad! I have a user control, which contains a button. This button fires an event which runs in the code behind. However, when I load the control, the first time I press the button, it posts back (and goes into the Page_Load method), but...

Hi I have a webpage which consists of a number of user controls, some buttons, and a Validation Summary. There are numerous validation controls within the controls, and also one on the main page. The idea is that errors will be shown in the one Validation Summary on the main page. This has...

I am developing a custom control to output an expandable list, with each expandable element being able to contain a different control(s). I wish to be able to insert a User Control into this. I have used the LoadControl method to load the control into my page where the custom control is...

Hi Does anybody know of a good tool that I can buy to allow me to generate PDF files programatically? It must have a C# API, and be fairly easy to get up and running with. I have already found one (http://www.cete.com/Products/GeneratorForNET/), which looks quite good in the evaluation, but...

Hi I have typed DataSet containing a number of related DataTables. For example, suppose I have Table1 and Table2 Table1 has columns ColA, ColB, ColC and Table2 has columns ColZ, ColA Table1 primary key is ColA Table2 primary key is ColZ/ColA I want to get all rows from Table1, where Table2...

Hi My application reads in a number of PDF files as byte streams. I would like to be able to merge these into a single PDF file and display it to the user. Can anybody recommend how I might do this? Thanks

Can anybody recommend a good State Machine to use with a C# .NET project?

Hi I need to have a resizable Label control, so that it can be dynamically populated. However, I am finding that it always fixes position of the left edge of the Label. I would like it to fix the right edge instead, and expand it leftwards. Is there any straightforward way of doing this...

Hi I am trying to pass a Custom Exception over a Remoting Interface, and catch it on the client side. However, instead of getting my custom exception, I am instead getting a SerializationException which appears to contain my custom exception. Is there anything I can do to be able to catch the...

Hi I wish to have a UserProfile class for the client of an appication I am working on. As there will be only one UserProfile per client, I would like to implement this as a Singleton. I would also like to be able to initialise the UserProfile at creation (parameters such as Username, Role...

Hi I am writing a trigger to write updated in a table to a History table. On the history table, there is a HistorySequence number for each instance of a record from the original table. In the trigger, I need to get the largest HistorySequence already entered, and update. Then I can insert...