I have some sql say select * from (Select 'JOB'[deadlineSource],yadda yadda) A union select * from (select 'TEST'[deadlineSource],yadda yadda) B which works just fine in sql Management studio. I prep my sql command SqlConnection connection = new SqlConnection(connectionString); connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandTimeout = 6000; command.CommandText = sqlTxt; SqlDataReader reader = command.ExecuteReader(); at which point an exception gets thrown. Is there some issue with trying to do unions selects with sqlDataReader? The exception is something an "Invalid object name 'Test' which kind of tells me that it doesn't like the column [deadlineSource] i'm using.

We have been upgrading our development IDE's to VStudio 2010. We generate reports for sql server currently using vstudio 2005. Is there a way for newer VStudio's to deploy the reports so sql server 2005 can understand them, so far we don't seem to see how.

Thanks I seem to have gotten that one to work the way i want!

I'm trying to learn how to communicate between applications and evaluation of the various projects i've come across have helped, but i still have one area i'm not having luck with. Lets say i have a tcpclient connected and it sends a message to server, servers listener accepts it adds the client object to a list and can respond to requests from the client. The connection stays active and my client gui app can press button repeating the process. Now on sever side gui app lets say i want to initiate a message to the client. I try to utilize the same client object and send some data, but client does not get the message until the connection ends, ie a disconnect. Anyone have any code examples or links to some that would demonstrate this process?

With msoft dumping Netmeeting, what tools are fellow developers using to replace this. We use it on regular basis to host meetings among the team in conjunction with conference lines. Demoing applications and sharing desktop are necessary features we need. Dale

Do other people run across this Visual studio Help issue(I'm using vs2008 pro all service packs) and when I accidentally hit F1 or cause anything that resembled asking for help, the DExplore.exe opens up and runs "Help Update in Progress" for the rest of the day. VStudio is frozen and you cannot kill the dexplore thread without killing vstudio too. I've tried setting help options to Not allow offline search, to no avail. I've trid opening up dexplore on its own, but even then F1 will trigger a new dexplore. I've tried removing F1 from the keyboard macros Anyone else experiencing this. It happens to me on different computers as well.

Do you find that the .net component is fast enough to perform at high baudrates, and handle other application processing of data from the serialPort?

Looking for libraries for threaded serial communication. Anyone have some links, free or relatively inexpensive.

Anyone have a solution for this problem where Vstudio launches dexplore.exe and then VStudio is completely locked up while dexplore displays the annoying help update in progress. I've changed all the options I can find to prevent dexplore from searching outside of my computer to no avail. Only thing that works is to kill process for devenv.exe (Vstudio)   and then kill process (dexplore). Trying to kill dexplore itself wont work because it continually relaunches.

Yes its port 80 The port numbers assigned are random, based on what VStudio decides to use for its virtual server. however once I publish the web app to the wwwroot directory, http://localhost/AppName should be all thats required, to the best of my knowledge.

I have developed a test website in vstudio 2008. I published the site to http://localHost/WebAndASP/ I run the Web program in IDE and it opens up browser window to http://localhost:3400/ and displays my page I can also open up a browser window manually type in the above and view the page. However I cannot do http://localhost/WebAndASP/Default.aspx IIS has Website entry named WebAndASP. It is configures with low priority. The directory security is set to Anonymous access and Integrated Windows Authentication When I right click on the Website node in IIS(5.1 btw) I get the same http 500 internal server error message. Strange that it can execute with the :3400 but not locally. I would like IIS to work without having to supply the :3400 or any of the other values Help is greatly appreciated Dale

Want to do clienside validation on a textbox control. This textbox can represent two data types depending on an associtate checkbox. So if checkbox is checked the validation should do (a) and if off do (b) In the javascript funtion below I do a getElementForID("chkBox1") However if I want this to be a global routine I don't know what the checkBox would be and preferably I'd like to pass an Integer so I could do multiple validations on this control or others. The "Sender" parameter seems to be my textbox, So question is how do I setup the ClientValidationFuntion property of the validator to pass an integer?   My custom validator is setup like this <asp:CustomValidator ID="lsdCustomVal" ControlToValidate="txtBox1" runat="server"                      ClientValidationFunction= "validateLSDControl"></asp:CustomValidator> in my external js file I have >> function validateLSDControl( sender, args) {       var expr1 = "[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]";       var expr2 = "[a-z]-[0-9][0-9][0-9]-[A-Z]/[0-9][0-9]";       var x = document.getElementById(sender.controltovalidate);       var chkbox = document.getElementById("chkBox1");       var smsg = "";       if (chkbox.checked) {             var patt1 = new RegExp(expr, "g");             smsg = "expr1 Invalid";       }       else {             var patt1 = new RegExp(nts, "g");             smsg = "expr2 Invalid";       }                   var result = false;       if (x != null) {             var s = x.value;             if (s.match(patt1))             { //                  alert("it worked");                   result = true;                              }      &nb

I have web page that I want to switch the validationExpression for control based on a checkBox. I'm trying the code in the script portion of the web page. When I submit the page and evaluate the Validation Control on the Page_Load during Postback the control has the same expression as defined in the .aspx file body, eg <asp:RegularExpressionValidator ID="EmailRegexValidator"   runat="server"    ControlToValidate="Email" ErrorMessage="Invalid Email"    ValidationExpression=".*@.{2,}\..{2,}"> ///// Does not seem to change in postback </asp:RegularExpressionValidator> Any ideas on what I need to do to make this work?       <script type="text/javascript" language="javascript">             function InitValidators()             {                   // retrieve instance of our checkbox                   var checkbox = document.getElementById('<%=enableValidatorsCheckBox.ClientID%>');                   // enable/disable all validators on page based on checkbox state                   ValidatorsEnabled(checkbox.checked);                              }             function ValidatorsEnabled(state)             {                   ValidatorEnable(document.getElementById('<%=NameRequiredFieldValidator.ClientID%>'), state);                   ValidatorEnable(document.getElementById('<%=EmailRequiredFieldValidator.ClientID%>'), state);                   ValidatorEnable(document.getElementById('<%=EmailRegexValidator.ClientID%>'), state);                   if (state)                      setValidation(".*@.{2,}\..{2,}")                   else &nbs

That is correct, I need to change ValidatorControl on a Radio click but like i said, i'm not familiar with how to do this. An example code snippet would be nice.

I have a textbox that can represent different things and need to use diffferent validator controls based on Radio buttons. As a newbie I'm not familiar with how to accomplish this. Can someone provide some much appreciated guidance.

Looking for component suites for reporting tools that other developers recommend 1 not database dependent, ie can use objects 2 Allows for dynamic creation of reports, subreports etc 3 Supports both windows and web using common report engine

I think another way to phrase this question is How about a way to override the set; method for a property In VS2008 you don't need to specify a private field for properties and can just use public int myprop {get;set;} So if I could figure out how to override that set method, maybe thats where I could add change event handler.

Not quite where I was heading, My baseclass will have no idea what properties the child class has so in pseduo code I'm wondering if something like this is possible The idea is to have a means of setting BaseClass protected void SetupHandlers() foreach property in MyProperties AttachSetChangeEvent () public BaseClass() { SetupHandlers(); }

Lets say I'm using the vs2008 convention of setting up properties and have a Base class and inherited classes. Is there a way in my base class that I can attach event handler to properties the child and base may have to determine if the set method of a property get used. Looking for something to add to base class that would setup the notification. eg static enum State (isUnchanged,isNew,isModified,isDeleted) class MyBase { public State myState; } class MyChild : MyBase { public string FirstName {get;set;} public string LastName {get;set;} }

Am trying to create a tutorial app from asp.net site which demos the Movie database utilizing MVC in asp.net. When I create my project and database, I right click on the Controllers folder (Created automatically by the project when making new project) I should see a "Add Controller" menu item. It does not show up on my pc, but does show up on another system, also using vs2008. Any ideas on what I need to do to remedy this problem? Dale