I have a MQ-SQL 2005 stored procedure that returns a dataset that is fine except I would like to change the rows to the columns and the columns into the rows. Is there an easy command to do this, or is pivot the only option (which is not easy)? Thanks,

Leo T. Smith Program/Analyst Supervisor

OK, I am not sure how you mean to do this. I am used to using AJAX calls to make things work, but I don't know how that differs from this kind of a call. How would I setup callbacks and addressing the webservice for the required function? You wouldn't happen to know an article or two that would explain this with code examples would you? Thanks,

Leo T. Smith Program/Analyst Supervisor

Hello, Question: Is it possible to use a web service as a proxy to a different web service on another web server? Due to desired web service running outside of the zone and possibly having to go through a firewall (launching web server accesses two networks with one being in the DMZ). If this is possible, is there any articles in MSDN that can assist in setting up the intermediate service to send a request to the primary service? Thanks,

Leo T. Smith Program/Analyst Supervisor

I have a small problem. I need to convert some rows into columns. Look at the following information. Original Table: Ind Sub String 0 1 22 0 2 21 0 3 5.6 0 4 John Rogers 1 1 12 1 2 76 1 3 99.3 1 4 Sarah Peters Converted to: Ind val1 val2 val3 val4 0 22 21 5.6 John Rogers 1 12 76 99.3 Sarah Peters This is similar to a pivot, except that I am not count, averaging, counting, or any other agregating methods. Is there a simple query that will convert this or is this going to be a cursor issue?

Leo T. Smith Program/Analyst Supervisor

Thanks for the information. I really was hoping this would not be the case. So then the next questions will to be; Is there a way via stored procedure to: A. Command for turning on and off constrants? B. Command to turn off and on auto increment, or would truncating reset increments to 0? C. Is there a command that will allow for copying data between one DB server and DB another in SQL 2005? D. Is any of this easier in CLR functions? Thanks,

Leo T. Smith Program/Analyst Supervisor

SImple replication question. I am running MS-SQL 2005 on a couple of machines. How can I copy the data from one machine to another. The target machine has some of the data, but I would like to update the dataset with want is on another machine. Simple summary: Replicate the data from production to debug without using backup and restore. There are some tables on the debug machine that are in process of being worked on that have yet to be added to the production, so all I want is productions data to be copied. There are auto incremented keys that need to remain the same. Thanks,

Leo T. Smith Program/Analyst Supervisor

Hello, I am trying to other user controls within a single control. A couple of them reside in another assembly (AjaxToolkit), and one resides within the assembly I am trying to create. How do you link to these other control to utilize in a composite control. They are all created with the $create method. ANy ideas or documentation would be appreciated. Thanks,

Leo T. Smith Program/Analyst Supervisor

I would like to know how to capture the current position of the cursor within a textbox, and then if necessary how to place within the text area to change the text insertion point. Thanks,

Leo T. Smith Program/Analyst Supervisor

Actually I ready keep the sensitive information on server only, but there comes a time when knowing when an element has changed a value could be useful. I find the reasons more compelling as I use AJAX and client side scripting. An example would be for an extender control that needs to do some action when the control that it has extended (i.e. text input) has had its value changed is used to set other internal things within the control. If there was a trigger that fired when this happened, you would not force a programmer to use your behavior to set things up when the value changed. I know that under the current paradign this is not a common occurance, but in the future it could become a greater problem in making more user friendly applications. Just my thoughts. Thanks for your time,

Leo T. Smith Program/Analyst Supervisor

Thanks for your answer. It was what I expected, but I want to know how in a world of security, there is not a way to see when your values have changed by someone other than the user. Thanks,

Leo T. Smith Program/Analyst Supervisor

Does anyone know of an event that fires when a value is set on an element from within JavaScript? Example: $get('id1').value = $get('id2').value (copy values between input controls). Is there an event that will fire on control 'id1' when it is modified this way? Thanks,

Leo T. Smith Program/Analyst Supervisor

I noticed that several places you can use "~" to start a path for the application root. This does not seem to work for CSS files or for JavaScript files. Is there an inline way to ensure that the path in the browser starts at the root? It seems that there has to be a way for the ~ to be converted to a server name at least on the server then appended to the front of the relative path in the browser. Thanks,

Leo T. Smith Program/Analyst Supervisor

I am looking for anyone familiar with using the tabs control from the MS AjaxControlToolkit. The question is simply, how do I load web pages into the tab panels? The only option I see is "ContentTemplate" for the TabPanel and it doesn't seem to allow for linking in outside material (unless it is a user control). The reason I need this ability is that I am creating panels that may use separte master pages to define their layouts. Outside of IFrames, is there another means of loading other pages into the pages? Thanks,

Leo T. Smith Program/Analyst Supervisor

I have recently moved to VS 2008 to code with but am having an issue. The "asp:..." tags won't list in intellisense and give me the following error: EXAMPLE:Validation (): Element 'scriptmanager' is not supported The funny thing is that the code compiles and runs without any errors, even with the green underline under the tag name. I have loaded VS90sp1-KB945140-ENU to get the use of SilverLight into some testing. What could be wrong or missing from the web.config file that is causing intellisense and the apsx file to lose the ability to see these and user control tags. This problem didn't exist until I ran through this upgrade. Thanks for your assistance,

Leo T. Smith Program/Analyst Supervisor

I have a question on what is the best method for database connections from a web page to an MS-SQL database (2005 currently)? Let me explain what this is coming from. I am cureently trying to define a standard practice of setting up our web apps from a web server point of view. I don't want Windows Authentication due to multiple browsers hitting and no guarentee that network user names and passwords would be encrypted (I know in the past netscape would pass the user names as clear text, I don't know if this has changed). So I wanted to use a domain name for the anonymous account (easy to port accounts between servers, since nothing has to be duplicated). Now comes the catch to the plan. When I try to setup the SQL connection string I run into several problems. I will list the two wethods I have tried and the problems assoicated with them. 1. <add name="CommonConnectString" connectionString="Data Source=Davinci;Initial Catalog=CommonTable;Persist Security Info=True;User ID=Local_DBO;Password=Ac90_&0w" providerName="System.Data.SqlClient"/> Problem I have with this method is setup and replication of database. When the tables are replicated between servers, I have to delete the user account and recreate it for the new database (the old SID's don't work on the new machine). 2. <add name="CommonConnectString" connectionString="Trusted_Connection=Yes;APP=Microsoft Data Access Components;SERVER=DAVINCI;DATABASE=Common;UID=domain\webdbo;" providerName="System.Data.SqlClient"/> This method works fine from a windows application, but won't work from a web application unless windows authenication is turned on (Account has been added to database with proper access rights). Replication should work, though I can't get this string to work, since the SID's are not on the server or the database. Any assistance in helping me find a way to setup the servers to allow for replication without having to go back and delete and recreate users and account would be greatly appreciated (articles on the subject would assist in not having to get into a lengthy discussion, or assistance on the problem or limitations of the second connection string are probably going to be the easiest to deal with). Thanks for any help,

Leo T. Smith Program/Analyst Supervisor

Thanks both of you. The trace assisted in finding out that the was no error, since as Jeff suspected, I had added a string (although technically I inserted a string value and not a ECDTreeNode). I was unable to find this error only because I almost never insert a value. I had looked at all my Nodes.Add() calls before I posted. The trace let me know the type was wrong and Jeff's "you are probably adding a string" instead of a ECDTreeNode made me stop and look for something out of the ordinary. Thanks,

Leo T. Smith Program/Analyst Supervisor

Nodes is a collection ECDTreeNodes.

Leo T. Smith Program/Analyst Supervisor

Hello, I am having problems with a tree control in a windows form application. Sometime yesterday a typecast that I was using wuit functioning and I can't figure out where the problem started. I have a class that is an extents the System.Windows.Forms.TreeNode class. It adds fine to the TreeControl, but when I go back and try to read the object and cast it as the new class it throws the following exception. What could have happened to make this start failing? I am including the adding and the locating a node. The adding program sometimes throws a duplicate value, which is tested by the FindChildNode before adding it. The FindChildNode is the biggest problem right now and is throwing the following Exception (Bolded line is throwing the error). Message="Unable to cast object of type 'System.Windows.Forms.TreeNode' to type 'InternalApp.ECDTreeNode'." public class ECDTreeNode : System.Windows.Forms.TreeNode { . . . public ECDTreeNode FindChildNode(string cText) { ECDTreeNode ret = null; for (int i = 0; i < Nodes.Count; i++) { **ECDTreeNode tn = (ECDTreeNode)Nodes[i];** if (cText.Trim().ToLower().CompareTo(tn.Text.Trim().ToLower()) == 0) { ret = tn; break; } } return ret; } } public void AddSorted(ECDTreeNode tn) { bool bFound = false; try { for (int i = 0; i < Nodes.Count; i++) { if (tn.Text.CompareTo(Nodes[i].Text) < 0) { Nodes.Insert(i, tn.Text.Trim()); bFound = true; break; } } if (!bFound) Nodes.Add(tn); } catch (Exception e) { MessageBox.Show(e.Message, "Exception Error", MessageBoxButtons.Ok, MessageBoxIcon.Error); } } } Thanks for any help,

Leo T. Smith Program/Analyst Supervisor

I would like to know how I can set a new value into the triggers inserted recordset. Example: All dates on or before 1/1/1900 are to be set to null. Then a date in the fourth column comes in as 1/1/1900 in the inserted column. I can find out that the value needs to be set, but how can I change it to null before it is actually set in the database? Thanks,

Leo T. Smith Program/Analyst Supervisor

I have recently inherited a large set of databases, and have noticed that several of the dbo users have no login names associated with them. This limits several things (like assigning a database owner). Is there a way to set this value through a query, or do I have to recreate the database and import the data? Thanks,

Leo T. Smith Program/Analyst Supervisor