b6s's Q&A profile

• Visual C++ VC++ Certifications

  hi all, can anyone tell me the certifications in vc++ All available microsoft certifications are listed here: http://www.microsoft.com/learning/mcp/certifications.mspx , find one that most suitable for your case. you can also visite here to get an overview of microsoft certifications: http://www.microsoft.com/learning/mcp/default.mspx thanks ...Show All

• .NET Development Extended Properties on SqlCommand and SqlParameter

  Why is there no extended property collection property on SqlCommand and SqlParameter as there is on DataTable, DataColumn etc. And, as both SqlCommand and SqlParameter are sealed there is no easy way to attach them. Have to implement seperate keyed collections to keep track of each parameter's extended props. Bit of pain. Why didn't MS put the property collections on these objects The database supports extended props on these type of objects so why omit the property collection on the client side NET 3.0 maybe what extended properties are you referring to unlikely in .NET 3.0 since nothing has changed in the "core" functionality of .NET 2.0, but just add ons like Indigo/Avalon/WPF ...Show All

• SQL Server Monitoring SQL Server activies from an outside environment

  Hi, I don't know if this is the right place to post this kind of question (moderators, please move it to the right place if it's not here). I want to know how can I monitor some operations that are executed on a SQL Server database. Operations like: INSERT, DELETE, UPDATE, transactions, and so on (I know that I can do this using triggers, but doing this way I'll have to fill a table with the information from the triggers and stay loading the table data all the time. I want a way to monitor using other resources, in realtime). My idea is to build a program to monitor these activities (C# to be more exactly). How can I do this Thanks SMO is a set of object libraries that allow you to manage SQL Server. What I think you're l ...Show All

• Visual C# File.Move with Large files

  I have an application that watches a directory and transfers files when any arrive. I have files anywhere from 1 MB to 6 GB. The problem I am having is that when the files tend to be larger(100MB or more) the move seems to leave the file in the source directory an just copy it. Has anyone seen this problem before or know why this would be happening The method works properly with files over 100MB however if anyone has a lock on the file then the move will fail silently. If you are using FSW to watch for the file then it is possible that FSW still has a lock on the file. When working with files and FSW it is important to remember that a single file can raise multiple events when it is created or written. For large files this is definit ...Show All

• SQL Server Multi-value parameters returning 'ALL' or an itemized list

  I work in the Data Warehouse where like in most large companies we run very long and complex SQL with lots of data in parameters are datasets. Due to the nature of our SQL I need our multi-valued parameters to return (something along the lines of...) ‘ALL’ if all values are chosen or an itemized list (as it already does) only if not all values were selected. The SQL would look like this... where ‘ALL’ in (@PARAMATER_NAME) or table.field in (@PARAMETER_NAME) I can not seem to find anything about this online, which I would assume is a very common issue. Can anyone help me with functionality I am well aware of that as I mentioned above. ...Show All

• Visual Basic How do we use Application.doevents in window services

  Hi I have created an window application which has Application.doevents Now I am converting the application to Window services.. I find that Application.doevents is not a valid window service command. I need a similar command as that of application.doevents. You need to use the Threading Namespace... The DoEvents method simply yeilded the process so putting the currect thread to sleep would have the same effect...try System . Threading . Thread . Sleep (2000) That line stops the processing of the current thread for 2 seconds ...Show All

• Software Development for Windows Vista Win32 API for Event Logging

  I am writting code for the descriotion of windows event log record recently. This is the first time i use "MessageFile" and "ParameterFile" to FormatMessage. I can retrieve basic message text from "MessageFile" and use the formatmessage API to format it. But i can not find the example about how to format the message which has the insertion string with the form of %%1 %%2 ...n from "ParameterFile". Anybody knows how to do it Thanks ...Show All

• Visual Studio Express Editions please help me

  i want work project finger print useing vb how,where start you need to explain ALOT more than that. what exactly do you want to do from what I understand you want a finger print reader app correct it requires access to your finger print reader device. you also require to interact with it via SDK or some dll API calls. ...Show All

• Software Development for Windows Vista CorrelationManager.ActivityId changes when in a method under Workflow

  I am having an issue with the CorrelationManager.ActivityId changing on me when I am running inside of Workflow. I understand that the CorrelationManager utilizes the CallContext to store its state, but I can't figure out why the ActivityId is a different guid when running under Workflow. In fact, the ActivityID is set to the WorkflowInstanceId. Within my workflow method I can do a CallContext.LogicalGetData("System.Diagnostics.Trace.CorrelationManagerSlot").Peek and get out the stack in the same position I expect but if I do a CallContext.GetData("E2ETrace.ActivityID").ToString or (Trace.CorrelationManager.ActivityID same thing) I get the WorkflowInstanceId. This is causing me much difficulty when trying to log a ...Show All

• .NET Development Maximum UPD message size - WSAEMSGSIZE

  I am using multicast (i.e. UDP) to distribute very high volume market data around a network. For my particular architecture, it turns out that larger packet sizes are more efficient (yes, I know this is not usually the case). However, when I dial up the packet size, I start running into WSAEMSGSIZE errors (socket error code 10040). I am unable to find any documentation on how to determine what is the allowed packet size. It would be useful to know this in advance rather than trying to tweak the numbers until my app breaks. Can anyone provide any guidance on determining what value will trigger WSAEMSGSIZE and whether it can be configured directly. I've tried SET_SENDBUF and SET_RECVBUF, but these didn't seem to work very well. I think there ...Show All

• .NET Development Using XmlDataDocument with DataSet

  Hi people. I'm new to C# and .NET and I'm trying to write an application to store passwd. In the program I used XmlDataDocment to create passwd tables and everthing's fine. But when i try to save XmlDataDocument, I have limited options. I can't write the content to a file, because I want them to be encryted in file. If I had used DataSet , I could pass the content to memorystream and save it by encrypting. I could not see any possible opportunity to do this with XmlDataDocument. Or is there a way Or the best solution for this (if possible), Can I pass the Xml data from XmlDataDocument to DataSet without using files Thanks in Advance.. Thanks for the reply. I tried to use the XmlDataD ...Show All

• SQL Server [Help]I encounter an error when using RDA

  Hi All, When my customers sync the data using RDA, they got this error message, I don't know how to avoid it. ( I am using window mobile 5, Palm Treo 700wx, C# 2005, Sql server 2005(remote server) and Sql CE 3.0): The OLE DB data type information in the SQL Mobile columns does not matchthe information in the SQL server columns for the RDA table (Client type=3,server type =20, Table naame =MyTable) it's very urgent, could anyone help me out Thanks. James Those are data type values from OLE DB: DBTYPE_I4 = 3 (Int32) DBTYPE_I8 = 20 (Int64) This means you are mapping an Int32 to an Int64. ...Show All

• SQL Server SRS Performance Problem

  I have a performance problem with Reporting Services that I can't seem to get around. I have a stored proc based report that takes about 20 minutes to run. Even executing just the stored proc on the Data tab within Visual Studio takes 20 minutes. When I run the same stored proc that the report is based on in SQL Management Studio, the proc takes about 25 seconds to complete and returns 1 row (with minimal data). When I view the stored proc running from Management Studio vs. Report Server in Profiler I can see that the same exact command is being executed with the same parameter values. The only difference is that Management Studio runs a SQL Batch while Report Server is making an RPC call. I am lost as to why there is such a big d ...Show All

• Visual Basic Retrieve User AD GUID

  I am creating several VB.net apps that store and retrieve records to and from SQL 2005. With some of this data I need to track who created/edited the data. I know how to retrieve the users login name, but I need a more unique ID since over time someone else might get the same login name with user accounts created and deleted over time. Is there a simple property simular to system.enviroment.username that will expose the users GUID or do I need to use a control like Directory Searcher you maybe talking about the SID. You can get the SID of an account using WMI add a reference to System.Management and import the namespaces, System.Management and System.Management.Instrumentation. Then try this: Dim se ...Show All

• Visual C++ How i can create ZIP archives in C++?

  Hello! How i can create ZIP archive files in C++ Baybe some library help me with this or MSVS already have function for work with ZIP files I know library "zlib" but this library can`t compress folder only files. Please help me with this problem, Thanks! Hi NLebron, The .NET 2.0 API does support Stream compression with the System.IO.Compression class, but it doesn't allow you to compress entire folders - this is left to the programmer. In addition, there are some problems with the Compression algorithm that it uses which result in less than optimal compression ratios. For the time being, it's probably best to use a 3rd party library. Check out SharpZipLib . ...Show All