kevzn's Q&A profile

• SQL Server Thoughts on asynchronous Operations with SLQ Ce

  I noticed that the current SLQCe driver does not offer support for the APM(Asynchronous Programming Model). Are there any plans to do this in the future In light of the lack of APM functionality doe anyone have any ideas or thoughts on how async operations could be done, or if they are even needed in the context of applications that use SQL Ce Any operation becomes asynchronous if you do it on the thread (code not verified): Thread worker = new Thread(new ThreadStart( WorkerProc)); worker.Start(); ... // Execution continues… void WorkerProc() { ... // Do whatever here and fire event as soon as you're done if needed. } Whatever it’s needed or not – it depends on your application. ...Show All

• SQL Server How to create a connection to Access Database

  Hi guys, I want to create a report from Access Database. Can anybody tell me how to connect and create a data source from Access data source. A step by step guide is preferable. I am more concerned on the connection string. Thanks. There are two standard data providers that may be used to connect to Access databases:The JET 4.0 .NET OLE DB provider and Access ODBC driver. The former is newer and generally more efficient than the latter. In the "Connection Properties" dialog, 1) pick "OLE DB" under "Data Source" 2) pick "Microsoft JET 4.0 OLE DB Provider" 3) enter the full path of Access file under "Server or File Name" 4) the conne ...Show All

• Visual Studio Team System Compiler Warnings - Can I indicate I want the build to fail?

  Is there a way to indicate that I wish the team build to fail if any compiler warnings are encountered I tried this and I got the build error: vbc(0,0): error BC2014: the value 'true' is invalid for option 'warnaserror' My TFSBuild.rsp file looks like this: # This is a response file for MSBuild # Add custom MSBuild command line options in this file /p:WarningsAsErrors=true Am I doing something wrong here ...Show All

• .NET Development Newbie likes to use a RingBuffer from two threads...

  Hello, My SerialPort receives data which should be handled by my Application without any data loss no matter how busy my Application can be with other tasks. My SerialPort should write received data into a (Ring)Buffer and my Application should read data from this (Ring)Buffer. I am looking for some clear example what mechanism to use and how exactly it is to be implemented. As far as I know with the Lock mechanism only a buffer can be locked but in my Application also the read/write indexes should be locked somehow. All tips are welcome, regards, Henk If you are using .net version 2 then you'd better use the new System.IO.Ports namespace. The objects do al the things you ...Show All

• Visual Studio 2008 (Pre-release) Question about concurrency and sessions

  Hello. I've been trying to understand the interdependencies between: SessionMode, InstanceContextMode, ConcurrencyMode and the used binding. I’ve done a systematic test where I issue two concurrent asynchronous calls over the same channel, and observed the following: With SessionMode=NotAllowed the calls are processed concurrently, independently of the InstanceContextMode (PerCall or PerSession), of the ConcurrencyMode and of the binding (NetTcpBinding throws an exception). This is ok because every call is handled by a different instance. With SessionMode=Required and InstanceContextMode=PerSession and ConcurrencyMode=Single, the calls are processed sequentially. This is ok because the instance is always ...Show All

• Visual Basic Saving in Debug mode

  I have created a basic form that is linked to an access database. Everything is working properly except when I add a new entry in debug mode. I can add an entry and save it with an "add" and a "save" button, but once I stop debugging, the entry dissapears. I want to be able to update and save the original database in the debug mode and nothing I do seems to work. See if this thread helps you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=427451&SiteID=1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Sprite Effects

  Hi: Are there any tutorials regarding applying any effects to sprites or textures For example I want to apply 'motion blur' based on the sprites velocity vector. Do I need to write some kind of custom shader or does the XNA framework have this included Any help greatly appreciated! Regards: John So there are two different approaches: Write a pixel shader. Manually draw the sprite multiple times with varying opacity. How does number two affect performance, surely it will slow my drawing down 10x fold if I draw 10 instances I am very new to C# game programming, can anbody point me in the direction of how to apply a custom shader to a 2D Texture when drawing using SpriteBatch Regards: John ...Show All

• SQL Server SELECT Query duplicating rows

  Hi, I have a small problem that i cant seem to get my head around regarding the results of the following SELECT query. The result set contains two rows for every Employee - one for Annual (EntitlementID = 1) and one for Long (EntitlementID = 2) Where have i gone wrong Thanks in advance. --Tables: Employee (EmployeeID, EmployeeCode) -- EmpEntitlementValue (EntitlementID, EmployeeID, Balance) -- Entitlement -- Department -- Position -- Contact (FName, LName USE Employees go SELECT EmployeeCode As 'Employee Number', FName + ' ' + LName As 'Employee Name', Department .[Name] As 'Department', Position .[Name] As 'Position', CAST(DAY(DateStarted) ...Show All

• .NET Development Kerberos delegation problem

  I have hunted through a serious number of blogs and web pages, but I just can't get delegation to work with our WCF application. To save some space, here is a link to the source code of a small test app that I am using: http://members.shaw.ca/murraypeterson/rcstest/ You can look through the source code to see the various settings I am using (NetTcpBinding, ClientCredentialType = TcpClientCredentialType.Windows, ProtectionLevel = System.Net.Security.ProtectionLevel.None, AllowedImpersonationLevel = TokenImpersonationLevel.Delegation, etc.). The scenario for testing is simple. Two machines, both members of the same domain (machine1 and machine2). Two users, both members of the domain (user1 and user2). On machine1, run the test ...Show All

• Visual Basic Writing to two files.

  Hi, my program should write a string to a file, then a number to another file, but instead it doesn't write anything to the first file, and puts the string in the second file. The files don't exist before the program is run. My .Computer.FileSystem.WriteAllText( "appdata.dat" , text, False ) My .Computer.FileSystem.WriteAllText( "apps.dat" , apps, False ) The varible 'text' is put into apps.dat and appdata.dat isn't even created. I also tried using: Dim ff As Integer = FreeFile() Microsoft.VisualBasic.FileOpen(ff, "apps.dat" , OpenMode.Output, OpenAccess.Write, OpenShare.Shared) Microsoft.VisualBasic.FilePut(ff, apps) Microsoft.VisualBasic.FileClose(ff) but that didn't work ...Show All

• Visual Basic How to create a "Hardware Profile"

  I need to create a "Hardware Profile" of the machince running my app.  Specifically i need it to gather info about hardware pieces that aren't commonly upgraded such as the hard drive then combine that into a string and hash it for privacy since i only need it for comparision reasons.  Any help on how to get manufacturers, models numbers, and serial numbers from hardware is appriciated. Thank you.   EDIT: I made a small change to the search term i was using on MSN and may have found what i need WMI, but from what i could read i dodn't undsertand how to get the details I need, anyone know of any code showing implimentation of WMI for simular use as I want EDIT2: ok i did some more digging while waiting for a respo ...Show All

• Visual Studio Express Editions how to convert textfile to mdb

  Hi, How to convert delimiter based text file to mdb. Actually I need create table structure and mdb also runtime. If any has coding like that pls send to me ASAP by thiyagu Hi, In the issue of creating an mdb file and datastructure, my approach here is to hide a blank database mdb. This would just serve as a template if i want to create a new database. I would just copy this template to whatever location I want to create a new mdb. After that, I'll connect to it through a connection object and just Issue create commands to create my tables, etc... CREATE TABLE <tablename> cheers, Paul June A. Domag ...Show All

• SQL Server can we export olap cubes from sql server 2005 analysis service to sql server 2000 analysis service?

  Dear all, Thank you very much for your kind attention. Is it possible to export olap cubes from sql server 2005 analysis service to sql server 2000 analysis service And if it is possible, then how can it be done Really need help for this and thank you very much in advance for your help. I am looking forward to hearing from you. With best regards, Yours sincerely, Helen ...Show All

• .NET Development Lossed bytes in Converting String to Bye Arrays & vice versa?

  Hi, I need to convert a byte array to string and then the same (or possibly modified) string to byte array. I did it like this. myData=Encoding.ASCII.GetBytes(buffer) where buffer is a byte array and myData is a string. Now later in application I need to convert another string to this buffer. That another string contains exactly the same text as myData contains. So I do like this buffer = Encoding.ASCII.GetBytes(anotherString) Now the length of this buffer should be same as in the first case before conversion. i mean i lost some bytes here...why is that. I tried with other options as well like Encoding.Default, Encoding.ASCII, Encoding.UTF8, .UNICODE etc...but none of them gives the same number of bytes in both cases. ...Show All

• Visual Studio Tools for Office Outlook 2007 Form Regions

  Hello Outlook 2007 has the feature of form regions that let you customize views by intorducing the concept of userform. What I had noticed is that userforms has a couple of limitations besides a nice RAD-enabled GUI. So the questions goes here as I found no useful information in this forum, nor in the usergroups. 1. Is it possible to use third party controls like Infragistics/etc inside outlook userform If yes, how it will be, If no, then what is the alternate way to come up with 2. In VS IDE, can I add a custome usercontrol into the controls collection of userform dynamically at run-time like this.userform.controls.add(...); Thanks in advance. Regards, I knew they'd be right in fro ...Show All