Jing-ta's Q&A profile

• SQL Server LIMIT'ed to TOP in TSQL???

  I have worked with TSQL quite a bit with different projects... I have recently had a slew of projects that got me to start using MySQL for the database... I know that may be sacralige here; however, it is relevant to my point. I have always had a problem in TSQL that the TOP attribute doesnt quite do what I want. I would like to pull the TOP 50 records from a data set, but I want to pull them after the initial 200 records. I have come up with several ways around this, however, none are efficient. The reason I bring up the MySQL usage is because there are two commands in MySQL to which work Postregres, Oracle, basically any PLSQL DB. LIMIT (start param, rowcount param) AND OFFSET (start param) These make page numbering very simple and effi ...Show All

• Windows Search Technologies Stopping Search from a command line?

  WDS under Vista has huge performance issues for me- even after allowing 5 days for it to index, my HD runs excessively. The worst performance hits are when I'm running anything full-screen DirectX, at which point every 10-20 sec, I'll hit a pause of 1-2 seconds. Irritating. What I'd like to be able to do is stop the service from a command line. In XP, you could do this with something like "Net Stop "Windows Search"" in a batch file. In Vista, I get "System Error 5 has occured. Access is denied." Any workaround And I mean to the command line problem, not the performance problems... Hil, Here is the information you are looking for: From an elevated command prom ...Show All

• .NET Development how to solve this connection problem

  hello... when i open my connection(sql connection ) am geting this problem... can any one tell how to solve this An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) am using sql server 2000 for my database am getting this error how to solve this.. plz help me Try forcing it to use TCP in stead of Named Pipes You can do that by adding "Network Library=dbmssocn" to your connection string. ...Show All

• Visual Basic reading from an xls file (into VB) without using Excel

  Hi everyone, I've written a program in VB which accesses data from an xls file. Right now I open excel, and then hide it (so it is invisable to the user) to read the data from the file. Then I have a close button on my program which the user can click and as the program exits, it also closes excel. I have removed the "x" from the taskbar on my program, but I still run into problems if the user uses ctrl+alt+del. I am sure this is probably the worst way to read from this file, but it does get the job done... although very buggy and error prone. I was wondering if someone could inform me of a way to read in this data in a more efficient manner. Possibly even if the user doesn't have excel installed on their computer I am no ...Show All

• .NET Development languages in HTTP and C#.net

  my application should send texts in arabic language through http protocol .. and as we know http does not support arabic language ... so I have to incode the texts into hexa ... how can I do that ... I have a source code but in VB.net can any one convert it to c#.net or can any one help me to write the incoding function .... this is the VB.net code Public Function ArabicHex( ByVal b() As Byte ) As String Dim s As String , h As String Dim i As Integer i = 0 s = "" While i <= UBound(b) h = Microsoft.VisualBasic.Right("00" & Hex(b(i)), 2) i = i + 1 h = Microsoft.VisualBasic.Right("00" & Hex(b(i)), 2) & h If h = " ...Show All

• SQL Server Timeout in copy databases

  Hello and thanks in advance for help, I have configured several jobs in the SQL Server Agent which do a copy of databases from a cluster of SQL 2005 to another SQL 2005 server. I did these from the "Copy Dabatase Wizard". When I run these it works fine with "small" databases but with the two bigger ones I get the following error after 10 minutes since execution started: Event Name: OnError Message: An exception occurred while executing a Transact-SQL statement or batch. StackTrace: at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(StringCollection sqlCommands) at Microsoft.SqlServer.Dts.Tasks ...Show All

• Visual C++ Why ATL contorl got WM_DESTROY mesage when it's loaded from a form in MDI App?

  I have an ATL activeX control, and I want to put that control into a child form in my C# MDI App. When I click "show child" menu, my child form should show up correctly. But my ATL control receives WM_DESTROY when it's loaded, and this is only happend in C# MDI enviroment. I trid to load it from MFC MDI app, it's fine. In my WM_DESTROY message handling, I want to do some final clean up,and I don't want it to be done when it is just loaded. Thanks for any help! I am using Visual Studio.Net 2003, and here is my code: ATL: created from "Visual C++ Projects--> ATL --> ATL Project" and the control typ is just a "Standard control". LRESULT CMyAtlControl::OnDestroy(UINT /*uMsg*/ , WPARAM / ...Show All

• Smart Device Development conect to sqlce with visual studio 2003

  have pockey pc with windows ce 3.0 i designed application to it with sqlce on visual studio 2003 when execute it on pocket it doesn't open or give error message like load exeption conection error but it execute in emulator Try posting your question to SQL specific forum - http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=152&SiteID=1 Manav ...Show All

• Visual Basic VB.NET & EMAIL

  I am trying to figure out, for a friend, how to write a VB program that will launch multiple IE's and when those IE's launch fill in the appropriate login name and password for that site. Is there any way that this can be done couldn't he set up a forwarding option from each one of the sites to forward to a central address possibly use an anonymous email forwarding service if he is worried about links between the addys ...Show All

• .NET Development The remote server returned an error: (550) File unavailable (e.g., file not found, no access).

  I have a routine that will uses the ftpWebRequest to retrive the .ListDirectorys and on the first pass is fine.. What i need to do is turn right around and ftpWebRequest again to the subDirectorys of the parents that i just got from the first ftpWebRequest.. However i am getting this error.. I have closed every connection that i know how to and it is still open some where ( are at least i think this is where my error is coming from a connection open. ) ------------Below is the code that i am using from the FtpWebRequest----- and nothing else... Can someone tell me how to close this connection please thanks erik public static List < FileDirInfo > GetFileAndDirNames( string remotePathUri) { if (remot ...Show All

• Visual C# Using a progressbar via another class

  I have written a program that splits a XML file with it's own class called SplitXML with a SplitFile(). This method has a nested do/while loop that starts at 0 and iterates until the end-of-file. My desire is to access the progress of this loop in another form which will have the progress bar. I could move the SplitFile() into this form with the progress bar, but that would invalidate the class, as I feel I am no longer performing "OOP". I access this class also in a windows service I have created, this SplitXML class appears as "Complete" Object as it is re-usable. I have had a look via Google on Delegates and possibly Multi-Threading but it seems to me that there MUST be an easy way to access the progress of this loop ...Show All

• SQL Server Move a sql 2005 express database to sql 2005 standard edition

  Hello We have developed a database with a lot of information in and we are going to move this database from a Win XP with SQL 2005 Express to a Windows 2003 server with MS Sql Standard 2005. How can we do that The easiest way is probably to backup your Express DB and restore it on your new machine with Standard edition. You could also detach the DB from your Express machine and attach it to your new machine. Both will work fine for this. Thanks, Sam Lester (MSFT) ...Show All

• SQL Server Search functionality in reporting services

  I am creating a simple report in reporting services. It contains basic fields such as first_name, last_name, ID#, location. Is there a way to create a search/find function that lets me input a field and it will find the results from any column I think I can figure out how to search by 1 single column but want the user to input one thing and search multiple fields. For further clarification...if they know the last_name, but want the id#, they can search for last name and get all the columns for the particular search....same would work for, if they know the ID#, but want the last_name, they could search for ID# and get all columns in the result. Is this possible I am not sure this is ...Show All

• Visual C++ Get active window

  Hi, Im writing an application which needs to get a handle to the active window and its content. It needs to work like the "Babylon (TM) " translator - get the active window, retrieve the text at mouse location and open its own dialog. It is not as simple as it seems ..., may be someone can give me a clue/link or a snippet. Best regards. hmmmm - getting the handle of an active window would probably result in the handle of your application, since it will be "active". I'm unsure how you would programmatically detect when the handle in question (Active window) can be notified in your application. however.... take a look at this: http://msdn.microsoft.com/library/de ...Show All

• Visual Studio Express Editions How to use CrystalReports with Visual Basic Express Edition

  hi, I would like to ask a question that is it possble to use crystal reports with visual basic 2005 express edition if so how I don't believe so. You will need VS2005 Professional to use Crystal Reports. You may be able to purchase Crystal Reports separately and get it to work with express (I doubt it though), but I think VS2005 Pro will be cheaper. ...Show All