KitGreen's Q&A profile

• Visual FoxPro Arrange the "character string" numbers in order

  I use the character string for number input. What Syntax should I use to sort out the “character-string” numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546 12A 5 443546 555AB 555AB Thank you.   MillBear wrote: Is there any ways to sort the datas in the report designer You mean at runtime Just prepare the data before you run the Report Form ... Have this data sorted by either a SQL ORDER BY clause, or ...Show All

• SQL Server How to use reporting services with data mining ?

  Hi , How can I use reporting services to get reports out of analysis Services Database I found following on one site, but I tried to look for Analysis services database on the server I am deploying the model , but I am not able to find it. 'To use Reporting Services with data mining, you simply create a Reporting Services project with the BI Dev Studio and specify an Analysis Services database as your data source. Depending on the contents of the database, you will be presented with either an OLAP or Data Mining query builder as in Figure 3.23. You can always switch between the two modes by clicking the Switch ' thanks, Vikas Hi Shuvro, I did everything you specified. But when I go to query builder window ...Show All

• .NET Development Asp Impersonate with vbscript

  Hello, Sorry if this isnt the correct forum for this, but i couldn't find the proper one. I want to impersonate the user that is connected to my asp or aspx page. The problem is that i cannot find what to do to impersonate. In another words, i don't know what to do to impersonate a user. I checked several sites and i could understand what was there, always mentioning wmi winnt:// and stuff like that. I assume that the  session already has the user (even so how can i check it) Thank you in advanced I hope this link helps you http://support.microsoft.com/kb/306158/ regards, Ramkumar ...Show All

• Visual Basic Typed dataset nullvalue

  I am using a typed dataset created with the VS 2005 designer with nullvalue set to Nothing. this gives the following designer code for the field memo: <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ Public Property memo() As String Get If Me.IsmemoNull Then Return Nothing Else Return CType(Me(Me.tablePaypalIPN.memoColumn),String) End If End Get Set Me(Me.tablePaypalIPN.memoColumn) = value End Set End Property I want to test for a dbnull and so do this: TestString = IIf(Datarow.IsmemoNull, "", Datarow.memo.TrimEnd) Debugging the last expression, both the Truepart and the Falsepart are evaluated and, in the property, the lines If Me.IsmemoNull Then, Return Nothing, ...Show All

• SQL Server Predicting player win over a period of time

  I would like to create a simple regression equation to predict player win on their next trip. I have tried to create the model using a linear regression tree based on two players (as a test). The result gives me a single node (expected) with only a coefficient instead of a regression equation. I can do this math by hand to get a regression equation and predicted value for the next trip for each player. The dataset I used for a simple test is..... Trip # Player Win 1 1001 1,250 1 1002 50 2 1001 1,450 2 1002 75 3 1001 1,600 3 1002 100 4 1001 2,000 4 1002 175 I also tried to predict next trip worth u ...Show All

• Windows Forms Tab through Tree nodes

  Hi, How to tab through tree nodes in window forms Thanks Balamurugan (Also answered on c# general) This was harder than I thought - so I have blogged how to do this, take a peek http://blog.the-dargans.co.uk/2007/01/navigate-treeview-with-tab-key.html Ross Dargan ...Show All

• .NET Development Casting error

  I have written a class which inherits DataTable class. I need to cast from DataTable to MyDataTable.for ex: MyDataTable mytable = new MyDataTable("mytable",10); mytable = (MyDataTable)ds.Tables[0]; what is wrong with this Is not MyDataTable also a DataTable I wish I could explain the situation. Thanks in advance. You can cast MyDataTable to Table object.The derived class is having information of the base classes so we can cast up the heirarchy. But you are trying to cast down the heirarchy..since the base clsss is not having the information of derived class,it is not possible ...Show All

• .NET Development inter-process communication in .NET - weird problem

  Hi All, I'm using the approach outlined in http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpguide/html/cpconremotingexampledynamicpublication.asp , but with my own client and my own server. Everything works great for a while. My client .NET application can communicate just fine with the exposed proxy object. Then after six or seven minutes I get the following exception: Source: System.Runtime.Remoting Requested Service not found System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at MorganStanley.OmegaSuite.BusinessComponents.Base.RemoteCommunicator.InvokeRemoteAction(Object[] args) at MorganStanley.OmegaSuite.BusinessComponents.Base.DotNetServerLauncher.Invok ...Show All

• SQL Server How to Uninstall Sql Server using MSIEXEC.exe

  Hi, Is it possible to uninstall an SqlServer Instance (not Msde) using msiexec.exe. For uninstall using msiexec.exe we need product code. But in the registry i could not find any product code for an installed sql server instance Hi, It is Sql 2000. but anyhow, i can use the Registry entry key 'UninstallString' to uninstall it (IsUninst.exe). But i want to know how to find whether the Installed version is Sql Server or MSDE. (Not from the Query). I want to know by registry key. ...Show All

• Visual Studio Express Editions Very simple help needed

  I apologize for asking this but I couldn't find any help. I wanna put a button on my form that will assign a number to a frame, it needs to be uneditable by the user but editable by the computer. I need to put something like a frame in there. I've looked up and down the list in my copy of 2005 Visual Basic Express Edition but I couldn't find a frame control to put on my form, so what do I choose you may wish to look at this: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=903&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=747347&SiteID=1 there have been some powertoys developed to print a form - check it out and see if that helps. In .NET, to print, the ...Show All

• Visual Studio virtual directories

  I trying to create virtual directories in my builds. any suggestions cdoloriert Hi, What if I don't wanna use Microsoft SDC Tasks . Can I do something else instead Like my own visual c# class and then call it from my web development file to execute it. Thank you, cdoloriert ...Show All

• SQL Server Error during merge web sync

  Hello,    We have 5 subscribers trying to replicate via web synchronization. Two of the subscribers get the following message and the other three are fine. Any ideas on what the problem is or where to troubleshoot Thanks in advance. John Error on client output: The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.   I have seen typically that once is 3 times you can get successes. Other times it could fail to load the dll and hance cause the sync to fail. Can you try on a different IIS box that doesnt have anything except the virtual directory to rule out this possibility ...Show All

• Visual Studio Tools for Office Excel 2003 called from an webservice

  Hi, I am trying to use the excel 2003 as an calculation engine behind an webservice to avoid writting a lot of C# code which would be error prone (excel is a fine and well tested product). I managed to open the excel and perform the calculations I need, but when I want to close the excel process anything I do still remain open in background. I have tried everything that Andrew Whitechapel says in his book, but don't work. I am using .Net Framework 1.1 and VSTO 2003, for exection rights over the excel com I use impersonation before the call. can someone help with a solution Tahnx, Sandy Yes this is what I am doing I know the KB you are speaking about, but also MS even if they don't recom ...Show All

• .NET Development Where do I find class properties?

  SUMMARY: Where do I find the properties of classes such as IPHostEntry FOLLOWUP: Where do I find a simple description of how to use the class I.E. Set these variables, initialize with these functions, then do this. When I create a Windows project and put a TextBox in the new window, on the right side of my screen I find a properties window. This lists the variables of the TextBox. These variables contains much information that I can utilize when working with a TextBox. With the cursor on a TextBox, pressing F1 brings up the help file with a nice description of the TextBox. It begins with “Windows Forms text boxes are used to …” and proceeds to tell me what they are used for. Then I put the cursor on the phrase IP ...Show All

• .NET Development Multiplatform (32bits/64bits/CE) & Interop

  If I write a pure C# application, only using the standart public API, no interop, the same binary should work well on32 bit, 64 bits and perhaps on the compact framework as well if I link against it. Now how could I achieve the same thing if I do interop and I have a managed C++ API let say I have a managed C++ module compiled for 3 different target but with always the same interface: mycppmodule32.dll mycppmodule64.dll mycppmoduleCE.dll let say in the C# code I also do some interop internal class User32 // & CE ! { [DllImport("USER32")] public IntPtr GetHdc(IntPtr hWnd); // 4 byte IntPtr } internal class User64 // not sure it exists, but I assume.... { [DllImport("USER64")] pub ...Show All