shuyangtu's Q&A profile

• SQL Server Creating a 3.1 SDF from MDB

  I am trying to populate a new SDF database to be deployed with my CF application, and am totally bummed to find out I have to manually code my own custom app just to import the data from the existing desktop DB with ado.net code. I don't want to write code so that I can write code! Custom apps to support the development of custom apps! Jordan I wrote a commercial application for this (you can try it for free for 30 days, though). You can download it from my company's website (look for Data Port Wizard). ...Show All

• Visual C++ Editing Array of string values from CSV file

  I'm new at this so please bear with me. I have a CSV file that contains about 500 rows and 50 columns. I need to keep all the rows but only keep columns 1,2,3,4,6,7. I've opened the CSV and stored each row as a single element in a one-dimensional array. What I need to do now is search through those array elements and remove everything except column 1,2,3,4,6,7. Am I approaching this problem correctly If so, how do I proceed I'm stuck. I adapted your sample code somewhat. This should get you further. using namespace System; using namespace System::IO; using namespace System::Collections; using namespace System::Collections::Generic; int main() {     StreamReader^ reader = gcnew Strea ...Show All

• SQL Server Recordset destination used in a FOREACH?

  Hi all, Can a Recordset destination be used as source for a ForEach loop. Correct me if i'm wrong but the Recordset is stored in a variable of type Object So what stops my ForEach loop from itterating Regards, Pieter Thanks for the reply. After my post i tried a test project and it worked 100%. I then tried again in my actual project and no luck. Since then I rebuilt my entire work project around the test project and it is still working....go figure ...Show All

• SQL Server Performance problem: 2000 vs. 2005

  I copied a 2000 database onto 2005 on another box. Running the exact same SELECT query, with 7 tables joined, is running in less than 2 minutes on 2000 and almost 3 hours on 2005. The 2005 box is "bigger and better". I've compared the sp_configure output. There are differences in max worker threads, cost threshold for parallelism, and priority boost. I don't think any one of these is significant. I checked the server properties and the database properties and, again, I did not see what I would consider any significant differences. The 2005 instance has 4GB memory, as opposed to 2GB, but not using that much. In fact, the Total Server Memory (KB) for the instance indicates around 1,230,000 for some reason. We need to reso ...Show All

• Visual Basic After further research on this topic....

  I don't need much, just the ability to send a one line msg on an event. The applet buys/sells stocks or options and that part works fine. Now I would like the applet to report the action to an IRC channel. The applet probably doesn't even need to have the connection persist because the computer is already connected to the IRC server and channel through mIRC. I can't even find any coding samples for this, so any suggestions would be appreciated. Indi Rather than having your app attach to mIRC you'd probably be better off taking an IRC client like this one and using it to send your message. ...Show All

• Visual Basic How do i use ASCII code to display characters?

  Hi! I want to use ASCII to display characters I.E the letter "T" has the ASCII codes: HEX = 54 DEC = 84 OCT = 124 . So i wonder how i can use this information to display the character T in a string. Like get T in a message box. Thnx Hi You can use the chr function in the Microsoft.VisualBasic namespace and pass the decimal value to retrieve the string "T": MessageBox.Show(Chr(84)) HTH ...Show All

• SQL Server PredictCaseLikelihood

  I'm working with the cluster analysis algorithm (EM) in SQL 2005. I have tried to find documentation on the function PredictCaseLikelihood without luck. Is there any reference on how this function is defined Is there a option for querying the data mining model directly to get this result (within analysis services itself and not using add-in for excel) (just to make sure, what i want is to detect anomalies from a set of data without training the model, following the assumption that these anomalies are occur in very small amounts relatively). Thanks, EYaL ...Show All

• .NET Development IDumpable and IBindable

  Hi all, Can someone tell me what namespaces contain IDumpable and IBindable interfaces I can't seem to find either one in the .NET framework documentation. Thanks in advance IDumpable looks like a BizTalk interface (namespace Microsoft.BizTalk.ParsingEngine): http://msdn.microsoft.com/library/default.asp url=/library/en-us/sdkmref_bts/html/T_Microsoft_BizTalk_ParsingEngine_IDumpable.asp IBindable doesn't appear to come from Microsoft. Thanks. ...Show All

• Smart Device Development connecting data with MS Active Sync, howto?

  is there any way to connect a database (desktop) from PPC2003 to a desktop with Active Sync 4.1 I can't do it with this code: imports system.data.sqlclient Public Function GetConnectionString() Dim connectionstring As String = "Data Source=desktop;Initial Catalog=table-name;Integrated Security=True" Return connectionstring End Function Private Sub click() Dim connection As New SqlConnection(GetConnectionString) connection.Open() Dim queryString As String = _ "SELECT Layer FROM dbo.MasterLayer" Dim adapter As SqlDataAdapter = New SqlDataAdapter( _ queryString, connection) Dim mstmap As New dataset Dim mst As DataRow ...Show All

• Visual Studio Express Editions Problems with basic Hello World program.

  I am using the following code.... #include "stdafx.h" #include <iostream> int _tmain(int argc, _TCHAR* argv[]) { std::cout << "Hello, world!\n"; return 0; } And I am getting the following error... Error 1 error LNK2019: unresolved external symbol "__declspec(dllimport) class std::basic_ostream<char,struct std::char_traits<char> > & __cdecl std::operator<<<char,struct std::char_traits<char> >(class std::basic_ostream<char,struct std::char_traits<char> > &,char const *)" (__imp_ $ 6DU $char_traits@D@std@@@std@@YAAAV $basic_ostream@DU $char_traits@D@std@@@0@AAV10@PBD@Z) referenced in function _wmain test4.obj I don't know why but V C++ EE ins ...Show All

• Visual Studio 2008 (Pre-release) Only one usage of each socket address (protocol/network address/port) is normally permitted

  I have declared the following 2 methods.variable _thTCPHeartBeat and objHeartBeatListene is declared as global variables.When i run this code 4 first time it works fine.but when i call the startThread method again on the button click event of another button.I get the Error " Only one usage of each socket address (protocol/network address/port) is normally permitted ".Though i am calling the thread abort method and setting the objHeartBeatListener object to nothing. The code for 2 methods is given below Private Sub StartThread() Try 'Code to Start Thread for Listening HeartBeat over TCP Port _thTCPHeartBeat = New Threading.Thread( AddressOf _ListenForTCPHeartBeat) _thTCPHeartBeat.Priority = ...Show All

• SQL Server can we use sql Reporting Services with classic ASP

  Hey, we have an application written in ASP 3.0.in that we used Crystal Reports to generate reports(directly communicating with ASP).Now we want to use Sql REporting Servicesinstead of crystal Reports.I want to know whether we can use SQl Reporting services with ASp 3.0 or not.. If we can, plz send a sample or an article related to that. my id.. grminds@yahoo.com Thanks in advance.. If you are using classic asp, you can use the Microsoft SOAP toolkit to talk to the RS web services. A few articles: http://www.upyourasp.net/articles/article.aspx aid=11 http://www.15seconds.com/issue/010725.htm http://www.15seconds.com/issue/010808.htm http://blogs.msdn.com/dotnetinterop/archive/2004/11/22/267933.aspx Download SOAP ...Show All

• Visual C++ Navigating in a CHtmlEditCtrl

  Hi, Hope this is the right place to ask this question, otherwise please redirect me. :) I wonder if it possible to navigate back and forward in a CHtmlEditCtrl. It's possible to do it in a CHtmlViewCtrl with the functions GoBack() and GoForward(), but I need to use a CHtmlEditCtrl and I can't find any functions that do this for me. Please help me out. Regards Markus I also thought it was a cleanup problem, but I couldn't figure out what I should cleanup. So I created a completly new dialog and added a ViewCtrl, but it also crashed. Am I supposed to do some special cleanup with a ViewCtrl /Markus ...Show All

• .NET Development .NET 2.0 Webbrowser control and XML

  Hi Is there any way i can make the webbrowser read the xml from a xmldocument instead of from a file I create the xmldocument from a webservice and it would be great if i didn't have to save it into a file and then load it using the Navigate method. Best regards Mads Lutzhoft I don't have a link to the stylesheet itself but Oleg Tkachenko's eXml control includes a file defaultss.xslt that will work with the web browser control. Ignore that eXml is an ASP.NET control, you just need that stylesheet included with it to solve your problem, you can then use that stylesheet and .NET's XslCompiledTransform to transform your XML to some HTML with a expandable, pretty printed representation that the web browser con ...Show All

• Visual Studio Team System Sample code for getting the global list from server?

  Can someone point me in the right direction where I can find some sample code on how to read and write to the globallists I just took the following steps to try and remove the global list entries for my deleted projects... Deleted all records from Sets where ParentID was a ConstId with the Constants.DisplayPart equal to the projects I wanted to remove the global lists entries for, Deleted all records from Sets where ConstID was a ConstId with the Constants.DisplayPart equal to the projects I wanted to remove the global lists entries for, Deleted all records from Constants where the Constants.DisplayPart equal to the projects I wanted to remove the global lists entries for, Reset IIS However doing this still did not ...Show All