Han Qiao's Q&A profile

• Visual C# Unmanaged to managed code

  I have funtion wich was written in C++ and has the signature like this : "DWORD XPTO(BYTE **aux)" I want to use it within C# code but the function has to be declared like: static extern xpto( aux )), I dont know how to translate it!!! Can Anyone help Thanks a lot! Barbara yes that sample there is fine Mark - I meant you had this color: DllImport     for myself, and other people, its too bright, unreadable and does hurt the eyes. :-) ...Show All

• SQL Server Upgrading to SQLServer2005

  hi, I'm using custom authorization in reporting services 2000 to restrict the users. To do this we created a dll customauthorization.dll and placed it in reportserver bin folder and performed changes in rsreportserver.config, rssrvpolicy.config, and web.config files. Now its time to upgrade our servers to SQLServer 2005. Now in SQLServer2005 what new enhancements were done with respect to security and what all extra steps should i follow to perform the upgradation with custom authorization. Please give me suggestions how to upgrade my reports to SQL2005 so that my custom authorization still works. waiting for ur valuable inputs uday Hi, The changes in Reporting Services 2005 are not that much except for the new Report Mo ...Show All

• Smart Device Development random TypeLoadException

  I am having real issues with a TypeLoadException that occurs generally randomly. I've been working on a .NETCF 2.0 app all day, debugging and generally being productive. All of a sudden, with no changes to the assemblies, I get a TypeLoadException on one of the types in one of my referenced assemblies. It's one of my own assemblies, and I checked the manifest and didn't notice anything untoward. // Metadata version: v2.0.50727 .assembly extern mscorlib { .publickeytoken = (96 9D B8 05 3D 33 22 AC ) // ....=3". .ver 2:0:0:0 } .assembly extern retargetable System.Data { .publickeytoken = (96 9D B8 05 3D 33 22 AC ) // ....=3". .ver 2:0:0:0 } .assembly extern retargetable System.Xml { .publickeytoken = (96 9D B8 05 3D 33 22 AC ) ...Show All

• .NET Development MSSQL or MySQL Concurrent transaction Question. Please HELP!!!

  Hi, for the 3 weeks I m on a research nightmare.  I m trying to use SQL Server 2005  and .NET 2005 VBasic and I don't know why but it is really difficult for me!!! What I m trying to do is a multiuser application were concurrent transactions will occur in a table. I ve read all about ISOLATION LEVELS etc. as much as my stomach can take about Microsoft SQL Server 2005. But in case of the following scenario I can't figure out what to do: A.USER A is taking a snapshot of table Customers. B. USER A, in Session 1 is taking a dataset of Customers tables, bringing it to the forntend (frontend will be .NET VB or C#) and editing Customers record where Customers.id=1001. Q1. Her ...Show All

• Software Development for Windows Vista Tracking and Dependency Properties

  I have recently changed one of my Custom Activity Properties into a Dependency Property so I can use DataBinding.  However, now my tracking is messed up. The same property is used in both UserTracking and ActivityDataExtract, but the actual data that is emitted to tracking is just the Type Name of the property and not the serialized object itself. Now I have also made other changed that could have caused this, but anyone know if this sounds familiar or problematic Thanks, Dave ...Show All

• Windows Forms Form wont BringToFront

  Howdy, I have a notify icon that opens a window. To open the window you can either click 'Open' in the icons context menu or just double click on the icon. The menu option is fine, but whenever I use the double click feature, the window opens but doesn't come to the front and doesn't have focus. It must be something with the second mouse click releasing focus but I have no idea how to right this. Any suggestions Both events (the menu click and the icon double click) rasie the following event: Private Sub itmOpen_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles itmOpen.Click, nfyNotify.MouseDoubleClick Me .WindowState = FormWindowState.Normal Me .ShowInTaskbar = True Me .BringToFron ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA Game Studio Professional

  In the announcement of XNA Game Studio it says that the Professional Edition "will add support for tools and services that professional game developers need to ship commercial games". My questions: What exactly would prevent me from programming a game in the Express Edition and sell it (If the answer to the question above is "nothing"): What would make me want to buy the Professional Edition Ah I see, sorry must have missed that when I read through the FAQ for the first time. So basically I only really need Professional Edition if I have a XBOX 360 Developer Kit and want to develop commercial games, correct ...Show All

• Visual FoxPro foxpro 6.01 ODBC

  I'm programing in C++ using "Visual FoxPro Tables" ODBC driver, and querying a table with around 3,000,000 records. when i'm working with my code some query takes me about 50 seconds. Today I installed visual foxpro 9.0 to compare the time with my code and when i use the query wizard i get better resualt faster then in my code. I have two question 1. when I installed foxpro 9.0 the ODBC version stayed the same. doesn't foxpro 9 have an ODBC driver 9.0 too 2. how can i get the same resualt as the foxpro apllication gives (20 second for the same query) Prefer VFPOLEDB driver. ODBC driver is not compatible with latest version (not updated since MDAC 2.5 AFAIK). 20/50 secs is som ...Show All

• SQL Server Using OPENROWSET for csv files

  I have 2 instances of SQL2005 running on the same server. I'm trying to use openRowset to get data from a csv file. This is the query. SELECT * FROM OPENROWSET ( 'MSDASQL' , 'Driver={Microsoft Text Driver (*.txt; *.csv)}' , 'SELECT * FROM \\share\file.csv' ) The query works fine on one instance, but not the other. On the other instance I get this error. OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Text Driver] System resource exceeded.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)". Any help would be greatly appreciated. ...Show All

• SQL Server Memory not being used by SQL 2005 EE 64 bit instance

  We have an I64 server with 12 GB of Ram. On this server we have an instance of SQL 2000 Enterprise with max memory set to 6 GB and AWE is turned on from SSMS. This instance seems to be running fine but is always using all the 6 GB of memory according to task manager (if I increase the max memory it will use it). We also have an instance of SQL 2005 Enterprise with max memory set to 3 GB and AWE is turned on from SSMS. I know you don't have to turn on AWE on 64 bit servers but I did just in case. I hope this is enough server info so I'll get on with the problem. The 2005 instance doesn't seem to be running very well and from the task manager I've never seen it use more then 124 MB of memory. It seems to have way too much I\O writes and betw ...Show All

• Windows Forms Filter Listbox problem

  Dear All, I'm using the following code to filter list box but there is an error. rivate Sub FilterListboxProducts( ByVal searchString As String ) lstProducts.SelectionMode = SelectionMode.MultiExtended Dim x As Integer = -1 If searchString.Length <> 0 Then Do lstProducts.Items.Clear() x = lstProducts.FindString(searchString, x) If x <> -1 Then If lstProducts.SelectedIndices.Count > 0 Then If x = lstProducts.SelectedIndices(0) Then Return End If End If lstProducts.Items.Add(x, True ) End If Loop While x <> -1 End If End Sub Private Sub cmdFind_Click( ByVal sender As Object , ByVal e As S ...Show All

• SQL Server Encrypt data in a Stored Procedure

  I am trying to insert data in a table using a stored procedure, but somehow I cannot store the values passed by the stored procedure in the table. Table has two fields FIRST_NAME, LAST_NAME with varbinary data type(I need to encrypt the data) My stored procedure is as follows. Please let me know what i am doing wrong! *************************************************************** ALTER PROCEDURE [dbo].[SP_InsertInfo] -- Add the parameters for the stored procedure here @FIRST_NAME varBINARY(100) ,@LAST_NAME varBINARY(100) AS OPEN SYMMETRIC KEY key DECRYPTION BY CERTIFICATE cert BEGIN SET NOCOUNT ON; -- Insert statements for procedure here Insert into [dbo].[INFO] (FIRST_NAME, LAST_NAME) Values ...Show All

• Windows Live Developer Forums MSAJAX 1.0 conflict with V4 API. Sys.InvalidOperationException. V3 API is fine.

  Hi Guys, Been trying to use the new V4 API in my application but I get this error when I call the LoadMap method function GetMap() { map = new VEMap( 'myMap_myMap' ); map.LoadMap( new VELatLong(53.278353017531821 , - 2.153320312500008) , 5 , 'h' ,false ); ***** Get the error here when I call LoadMap. Microsoft JScript runtime error: Sys.InvalidOperationException: Object Microsoft already exists and is not a namespace. Can anybody please help me to find the problem. V3 of the API still works fine without any problems. If I remove AJAX references from my page the error goes away. Unfortunately, I make heavy use of MS Ajax 1.0 and can't get around it. thanks, SoS ...Show All

• SQL Server VS2005 Designer runs report once, on subsequent run, VS hangs

  VS2005 Designer runs report once, on subsequent run, VS hangs. Is there a way (other than shutting down VS) to reset database connections I'd like to rule out the connection as the source of my problems. It would be nice if you could re-use the cached data instead of re-retrieving every time you make a layout change. That would go a long way to alleviating our stress. We may both want to log a bug/enhancement report on this. ...Show All

• Visual Studio 2008 (Pre-release) Visualizer for LINQ objects

  Hello, I am very impresed from LINQ framework. I am mostly work with LINQ over data structures and LINQ over DataSet which I found very very useful. The problem is I have no debug visualizer for watch the result expression tree. Thank you, Ido. ObjectDumper is not a debug visualizer, and it does not display expression trees. What comes close to an expression tree viewer is this . ...Show All