Search results for query: *

further to thread183-1532457 i have multiple stored procedures. the code for each is in a separate t-sql script file. a change of server has changed the way that dates are handled...

i'm moving from oracle to sql server. in oracle i'm used to using modular scripts, including the text of one script in another. e.g. <script name=script1> create table xxtest as ( field1 char(10) not null ); </script> <script name=script2> @script1 </script> running script2 would then...

please forgive my dumbness, but what's the difference between create unique index index_name on table_name ...; and alter table table_name add constraint index_name unique ...; mr s. <;)

i'd like to be able to have an arbitrary number of sequences against a single table. i realise that general algorithm questions like this aren't really what this forum is about, but i thought someone might have come across this problem before, or could find or have found a solution...

two classes: public class ClassA { private string boing = "boing"; public string boing { get { return boing; }; } public class ClassB : ClassA { private string boing = "BOING"; } class TestClass { void Main() { Debug.Print(new ClassA().Boing); Debug.Print(new ClassB().Boing); } }...

class a derives from class b. if i have an instance of class b, is there a quick way to construct an instance of class a, without hard-coding all the attributes? public class B { public B() { } // properties galore private string p1; public string P1 { get; set; } //... } public class A ...

i have a control derived from UserControl. one of the rocket scientists at microsoft decided that the Text property on a UserControl wasn't needed in the designer and would never be serialised, and so turned it off. i've turned it back on again, and changing the value in the properties page...

trying to set the value of a ComboBox programmatically. the list contains custom classes with the DisplayMember and ValueMember properties set correctly. unfortunately, SelectedValue is always null. is there something i'm missing? public class ValuePair { // these are properties really...

how can i let the parent process of a thead created using a delegate that the thread has finished? i have a set of web services which, on startup, must be compiled by the server. this takes 20-odd seconds to do, and i'd like this to be done by a splash screen which gives some feedback to the...

what would you say is a good way of showing the user that the data on a form is read-only? i'd rather not use Enabled=False, since this sets controls to be grey on grey, which can be very hard to read. ReadOnly=True would be useful, but this is only a property of a TextBox. i've tried...

i have a web service which marshalls arrays of custom data objects. you can't pass complex list types across a web service (and rightly so) so the web service unpacks these into simple arrays on the server side. what i'd like to do is create calls on the client side which wrap these simple...

i'd like to save a form as a report from code. currently i use: DoCmd.RunCommand(AcCommand.acCmdSaveAsReport) but this prompts the user for the name of the new report. is there another way to create a report from a form without doing it object by object? if not, is there a way to tell...

i use reflection in my code to run forms, getting the class names to create at runtime from data held in a database. this works pretty well, if not instantly, but my problem comes when the invoked form throws an error. i'm using the following code: string className = valueFromData; Form form...

i have a wrapper which provides access to a web service. i'd like to provide a lookup facility on the wrapper so that the developer can write code like this: string code = arbitraryValue; Wrapper wrapper = new Wrapper(); if ( wrapper.Code.Exists(code) ) { txtField1.Text =...

the title says it all. i have a web service whose code should be shared between solutions. i've decided arbitrarily that these solutions should compile to a single DLL, so single project. is there a way to set the default namespace on the code generated by visual studio for a web service to...

if this looks like cross-posting i apologise, i realise the other post is in the wrong foum and i've asked for it to be deleted. i'm using Access 2003 to create an Access 2000 database which will be used on both 2000 and 2003. the database contains ten reports. i'd like to have a "print"...

could someone point me at a resource that tells me how to set an XML file to have multiple record formats so that these and the relationship between them can be read by SSRS? i have two problems. 1. i need to pass the parameters used to create the dataset as part of the dataset. there may be...

i'm using office components via COM. i call Application.Quit() at the end of processing, but the application (Access, Word, or Excel) is left running. how can i shut it down? how can i check to see that it's really gone? many thanks, mr s. <;)

Access 2003 (11.6566.8036) SP2. i'm writing an app that builds forms-based questionnaires from data. i'd like the format to be in rows of controls, with a column of labels on the left and a corresponding column of data entry controls on the right. i've got to the point where i can add the...

i'm creating a document in Word from C#. the first forty or so paragraphs are written very quickly, less than a second for all of them, but after that it slows right down to about four seconds per paragraph, and gets slower as more are added. any ideas on how to speed things up a bit? object...