HKEC's Q&A profile

• SQL Server How ChunkData is Serialized?

  Hello, everyone! I wanna ask a question. You know that SQL Server 2005 Reporting Services creates a ReportServer database in the database engine and there is a table called dbo.ChunkData. I once saw in a webpage that the [Content] field of dbo.ChunkData is not encrypted but serialized. I wanna know how it is serialized and how I should deserialize it in C#. Looking forward to your reply. Thanks! ...Show All

• SQL Server Data Access Application Block for SQLClient

  I download the DAAB CF version. However, most of them use SQLCEClient to connect to the database. Is there any DAAB that use SQLClient One workaround that I made is I replaced all SQLCEClient objects with the SQLClient objects. I only test one method "ExecuteDataset" and it works so far. However, my question is "does my workaround a good solution " Thanks, Hendra You might want to explore the new Mobile Client Software Factory. I believe it has data access blocks for both SQL CE/Mobile and SqlClient contained in the framework. http://msdn.microsoft.com/mobility/default.aspx pull=/library/en-us/dnpag2/html/mcsflp.asp Darren ...Show All

• SQL Server Predicate Vs Residual Predicate

  hi , what is the definition and difference between predicate and residual predicate. give me some examples..Basically the columns used in where clause are called as predicates. Am i right. I hope Craig Freedman's   Blog may help full for you http://blogs.msdn.com/craigfr/archive/2006/07/07/652668.aspx ...Show All

• Visual Studio Team System Some users cannot acces version control

  Hi! We have a problem with some users not being able to access version controlled files. They can see all projects and they can work with Work Items and run reports. They can also see the folder structure in the Source Control Explorer but when they right-click on a folder they get a menu with the only text being "No commands availiable". Has anyone seen this or has any idea what the cause can be We are running TFS with SP1. Some of the users have upgraded to SP1 for VS2005 and some have not. The problem seems to exist regardless of client version of VS2005. I have of course checked that the users in questions belong to the group Contributors or Project Administrator and should have permissions to change (or at least see) the sou ...Show All

• .NET Development Unload an assembly

  Hi, In my project, I use the code below to load an assembly, and by using that loaded assembly, I create a form and show it to user. I load assemblies with that method, because it don't lock dll file and I can change this dll with new one when needed. When I copy dll and its dependent dll's to working directory, Dll file loaded with that memory stream method, copy without any error. But its referenced dll's could not copy and an error message shown "...Its using by another process". We can say that, when you load an assembly with Assembly.Load(byte[]) method, its references load also, main dll doesn't lock but its refrences lock. Is there any way to load an assembly without dll and its references locked Best Re ...Show All

• Visual Studio Express Editions Code sample in MS ebook gives lots of errors

  I've just installed VC# Express, and created a Console Application, using the code sample from page 49-50 in the "Build a program now!" ebook from MS. Everything looks like it should in the code window (I copy/pasted the code), nevertheless I get 21 errors when I press F5. Most of them look like this one: "Error 16 Invalid token '(' in class, struct, or interface member declaration" Here's the code, copied from the code window: 1 using System; 2 using System.Collections.Generic; 3 using System.Text; 4 5 namespace MyFirstConsoleApplication 6 { 7 class Program 8 { 9 static void Main( string [] args) 10 { 11 // Declaring two integer numbers variables that w ...Show All

• Visual Studio Express Editions Bug: Output window: can't change text/background colors of current error/warning line (?)

  I looked all over in the fonts and colors settings under Tools/Options (including 'output window') but found no way to change the hard to see colors of the current error/warning. It causes a great amount of inefficiency with all the required squinting and face close to the monitor positioning. Is there a way to change the hard to see colors or is this a bug/design flaw "The output window itself just handles text - the Visual C++ part of the IDE has some very fragile, heuristic based code that detects when you click on a line in the output Window and tries to guess if the line could possibly be a compiler generated diagnostic - it basically pattern matches and it is very easy to fool it - once it dete ...Show All

• Visual Studio 2008 (Pre-release) showing property of an object within contentpresenter

  hi, i want to display within my ContentPresenter (which is defined within my ControlTemplate) a property's value (MyInfo.Text) of an object (custom:MyInfo) which isn't inherited from UIElement. The ContentPresenter just displays the object's namespace of the button ("MyStyles.MyInfo") but i want to access the "Text" property of the object. So in this case, the button's content should be "Info6" < Window x:Class = " MyStyles.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " xmlns:custom = " clr-namespace:MyStyles " Title = " ReplacingSt ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Saving model to .x file

  Because XNA doesn't yet support mesh saving functionality, I'm using MDX to save a model to a .x file. This is the code I'm using:             meshTerrain = new Mesh((WIDTH - 1) * (HEIGHT - 1) * 2, WIDTH * HEIGHT, MeshFlags.Managed, CustomVertex.PositionTextured.Format, device);             meshTerrain.SetVertexBufferData(vertices, LockFlags.None);             meshTerrain.SetIndexBufferData(indices, LockFlags.None);             int[] adjac = new int[meshTerrain.NumberFaces * 3];        ...Show All

• Visual Studio Team System Unpublished changes in Project

  I'm using Project to track my work items in Foundation. I open my Project file and want to do a refresh. I click refresh and it tells me that I will lose unpublished changes and whether I want to proceed or do an update. My first question would be, is there any way for me to see what the unpublished changes are I go ahead and do the update and I notice in the status bar where it tells me that it is updating 1 of 5 items and then it shows a status of doing a refresh. When I go to close the project file, I'm prompted to publish my changes to Team Foundation before closing. I haven't changed anything so I don't understand why I'm being prompted to publish changes. That's why I would like to see what it thinks needs to be published. Tha ...Show All

• Visual Studio Team System Data Compare - Not all tables available

  Hi all, when I make a new data comparison, I don't get all the tables that I have in the source database. Can someone tell me what can I do. Thanks in advance. P.D.: Sorry for my English. Unfortunately yes. If a table does not have primary key / index, there is nothing to compare against. Thanks Victor for your feedback. ...Show All

• SQL Server Merge Replication – Bug in Business Logic Update Handler

  I have got a business logic update conflict handler working, but I have had to work round what appears to be a bug. Please can someone confirm if this is indeed a bug – and if it is a known bug My conflict handler needs to take some columns from the publisher row and some from the subscriber row in the event of conflict. I can quite happily generate a custom dataset which contains the winning row that I want – I can see that because I can step through the conflict handler with debug when a conflict occurs. However, just returning ActionOnUpdateConflict.AcceptCustomConflictData from the UpdateConflictsHandler method does not set the publisher and subscriber columns correctly. I end up with diffe ...Show All

• Visual Basic Download webpage to DB

  Hi All, I have a project where I need to download a webpage and save parts of a table to my DB. Is there an easy way to do this is vb.net I have searched google but have not found any good examples. TIA OK. I Should hvae been more clear. I need to get certian parts of the page so I need to prase the HTML and split it in to the seperate parts. Not sure if there is an easy way to seperate the parts of the HTML page or i need to write a custom script for this. Saving to the DB is no problem I know how ot do that. ...Show All

• Smart Device Development About SDIO Card Driver

  Hai, I am studying about the SDIO Card driver. From my understanding the client driver is loaded after inseting the SD Card by the Bus driver. When the Host controller Driver is loaded Actually i want to diagnosis the SD Card port before inserting the SD Card .Is there any means to find this.I am using the PXA270 processor JR Lyon wrote: That code is given to the client driver from the bus driver. The client driver gets loaded only after the host controller and bus driver have initialized the card. If you are trying to detect insertion and removal events of the SD card then going through the client driver is probably not the correct method. Instead you should catch the system event with the hex value 0x21 ...Show All

• Visual C# Class doesn't exist? (ConfigurationManager or ConfigurationErrorsException)

  I've recently installed .NET 2.0 on my work machine in the hope of making use of the System.Configuration namespace - Visual Studio 2005 (Professional) however doesn't seem to recognise that System.Configuration.Configuration or things like ConfigurationManager or ConfigurationErrorsException exists! It throws the type or namespace does not exist build exception Am i missing an update or something Nothing jumps out at me from your download pages \o/ Thanks in advance, Henri If you are developing an ASP .NET project, check that the user that acts as "impersonate" in your "web.config" file (eg.): < identity impersonate = " true " userName = " ASPNETRED " ...Show All