brian_tsim's Q&A profile

• SQL Server how to set default value for datetime column in sql mobile?

  I try to set a default value (getdate()) for a datetime culomn in sql mobile, but got error when i insert record: there was a syntax error in the date format. [expression = getdate()] may be I can only set a exict date I can repro the failure you are seeing. On Searching BOL for sql mobile, It says the following about the default definitions for columns. DEFAULT Definitions A column can have only one DEFAULT definition. This can contain constant values or constant functions. You should post this to the SQL Server Everywhere/Mobile/CE Edition Technical Discussion forum. ...Show All

• Windows Forms I want to give appropriate value to the mouse movement with c#

  I want to give appropriate value to the mouse movement with c# ====================================================== int m=0; if(mouse movement == up) m=1; if(mouse movement == right) m=2; if(mouse movement == left) m=3; if(mouse movement == down) m=4; ====================================================== Just like the algorithm above, I want to make a program that gives appropriate label. And I would like if it can work out of the form(frame); I linked an example of that in c++ (and it works with keyboard) http://blog.naver.com/cianism/90013728694 I wish it could work with keboard in c# I'm a newbie in c#. I will really appreciate if you guys help me making this program. First, thank you for replying. I th ...Show All

• Visual C# System Time

  Hi all, I am using C# in windows form ( VS 2005 ). I would like to know how do i add system time into the windows form. Your help will be appreciate. Thanks! =)) DateTime.Now    there are methods like .ToShortDateString  and . ToShortTimeString and . ToString ...Show All

• Visual C++ MFC8

  hi i am programming with vc++ express and i have MFC4 and i am looking to upgrad to MFC8 .is that possible and how Search for WTL (Windows Template Library). It is a free download - I think on sourceforge. You should find a bit of documentation and samples on there too. Some guys at ww.codeproject.com have also some samples, tutorials or enhencements. -- SvenC ...Show All

• Visual Studio Express Editions How to convert the windows Ritch Text box control to web rich text box

  I am using Windows Applications. Here I added System.Windows.Forms.RichTextBox control. This Control is working fine. My requireMent is When i click the button the system want to read the content of the Windows RichTextBox control and should to be produce equivalent html code. Please help me how to do it. I am struggling how to achive it. Also I want to known any Predefined controls is there for this porpose. I am using Visual studio 2005 with c#. Advance thanks Hi even if it's for VB.NET you may visit the following page and get some useful info about the topic http://www.codeproject.com/vb/net/RTFToHTML.asp hope that helps by the way I have tried to convert the original V ...Show All

• Software Development for Windows Vista Vastly decreased multiuser Jet DB Performance under Vista

  Testing our VB6-based database application under Vista (Business Pro, Release version, Clean install on fresh partition), all seems largely well with one very noticeable exception: Multiuser Jet 4.0 database access is vastly decreased (often involving several minute waits for simple queries that generally run in one or two seconds); on the other hand, single user access seems quite comparable to its former speed, as does general file system/file server performance. Is this a known issue with Jet 4.0 under Vista Can anyone suggest any potential workarounds or know of any factors which might be responsible for the performance hit -Pete More fishing... Is there a performance problem when only doing simpl ...Show All

• .NET Development A Read-only dataset

  I have a singleton class which contain a DataSet. And also provide a property which return the dataset. How can i return a readonly dataset so that the object that is asking for it wont modify the data and the structure of the dataset Thanks, GoDaddy wrote: I have a singleton class which contain a DataSet. And also provide a property which return the dataset. How can i return a readonly dataset so that the object that is asking for it wont modify the data and the structure of the dataset Thanks, Hey GoDaddy, By default a dataset is read/write. You have the opportunity to present read-only user controls...ie Read-only datagrid view. But if you are wanting to retunr a read-only porti ...Show All

• Visual Studio 2008 (Pre-release) ListViewItem w/Context Menu

  I hope this isnt a dumb question, but I'm hoping someone can help me understand the expected behavior of right-click in a ListView. Here is the problem: If you have a context menu on a ListView in Multiple or Extended selection mode a right click to bring up the context menu will toggle the selection. I have mocked up a small repro using the ListViewCheckBox example in the SDK. I've inlcuded the modified XAML and the unchanged codebehind. All I did was add a contextmenu to the listviewitem. How to repro: 1. Select Multiple items 2. Right click on a selected item to bring up the context menu. This action will toggle the selection to unselected. The item is no longer viewable in your collection. Based on my observations the WP ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Function pointers and calli opcode

  Hi, Is the 'calli' IL opcode supported by the Xbox360 .NET framework (for calling managed function pointers) Will I be able to get a pointer for a managed function (with 'ldftn') and call it using 'calli' you cant not use opcode , but here is a sample of getting a datastructure in the datastructure you can have a void to call other things here is a sample verry fast access to a class in memory     [StructLayout(LayoutKind.Sequential, Size=64, Pack=1,CharSet=CharSet.Ansi)] public class MyDataStructure { [ MarshalAs( UnmanagedType.ByValArray, SizeConst=40 )] public byte[] name; public byte eyeColor; public byte hairColor; public Int16 age; // Two byte integer public I ...Show All

• SQL Server ForEach Loop Container Question

  Hi Currently the ForEach Loop container is set to loop over the entire collection of records in my table, but I only need to loop thru the records where the status = x. How is that possible Can I use expressions to set the enumerator to do something like this. Basiclly the collection values are used for further processing, and I would like to avoid looping thru records which have been processed already, which means they already have a status set to y. Please let me know. Thanks. MA Hi: How are you populating the collection From a db table Whicn enumerator are you using in the ForEach loop ADO Enumerator utilizing ADB Object Source Variable which is in my case a User variable called FullResultSet. The enum mode is R ...Show All

• Visual C# Unicode Byte to string

  I need to print some greek characters like αβδ from my C# program. By using Hex Editor, I know their HEX (or byte) value is CEB1, CEB2 and CEB3. So now, how should I construct the data and print it from my C# program I can't do this anyway. String temp = "" + 0xCEB1 + 0xCEB2 + 0xCEB3; It printed out as some numeric value. Ps. I don't want to hardcode the αβδ characters into my source code. What can I do Please help me. Urgent. I will grade you. Promise. Thanks Hi MVP, Thanks for your answer. I am getting closer to the answer I wanted. Other than the puzzle you have solved for me above, I also found another mistake I made in my printer class. Below is the original code: ...Show All

• SQL Server Finding deatail Deadlock info IN SQl Server 2005 Standard Edtion

  We are using SQL Server 2005 with SP2.Originally, we seemed to be having a lot of unnecessary lock escalation occurring to the page and table level. I would like to track down all storedprocedure/queries or function that are being casue of deadlock in sql server 2005 with all deadlock input like transactionID ,command ran,loginID etc.But we have to need to find these information on SQL Server 2005 standard edtion. Is there any tool,command or something like this which track down these information blindly in sql server 2005 without effecting system performance seriously. Ahamd Drshen Use SQL Server Profiler with DeadLock Graph Event. Or use stored procedures sp_create_trace and sp_trace_setevent for collecting profile ...Show All

• Windows Live Developer Forums Handling large number of PushPins

  I need to create a large number (>1000) of pushpins onto the map, but noticed that performance slowed down considerably. Are there any methods to improve the performance Thanxs. One example is to use clustering as shown on this link: http://www.viavirtualearth.com/vve/Articles/Clustering.ashx The link above depends on whether or not your retrieving from a database.  If your not retrieving from some kind of customized datasource and just making like 1000+ find calls and have to get those 1000+ pins displayed then your bound to take a huge performance hit without some kind of re-organization of which pins are being displayed. ...Show All

• Visual Studio Team System XSD Schema Designer in a VS Database Project

  I have a Visual Studio Database project (SQL Server 2005) that contains a script to create an XML SCHEMA COLLECTION. Fine so far. However, this XML schema is to be used in application code too and so I wanted to create an XSD file and use it for both the application AND the DB script (i.e. I dont want the schema defined in two places). I changed my script to use my new XSD file instead of a string literal and that works fine too. However, my problems started when I decided to keep the XSD file in the DB project together with the script. Firstly, when I right-click the XSD file, I don't get the usual "View Code" option and secondly, when I double click the file, the designer opens and contains an error message:- The XM ...Show All

• Visual Studio Team System If I want to install TFS and Visual studio.net 2005 Team Suite what is the order to do it?

  I want to do it on the same computer. Is it neccessary to install virtual server Can I do SQL Server 2005 Enterprise and my own db on the default instance Do I need to do development on a virtualised os or can do on the Windows Server 2003 whis TFS So do I need a).to install TFS on the real Window Server 2003 and then install Team suite on a Virtual OS (like WS 2003 or WinXP) or b).to install TFS on the Virtual OS (like WS 2003 or WinXP) and then install Team suite on the same OS or c)to install TFS on the real Window Server 2003 and then install Team suite on the same server. I do want to try on all the hats(Project Manager, Architect, Developer and Tester) on the same PC. So what is th ...Show All