David M. Kean - MSFT's Q&A profile

• SQL Server Display selected multivalue parameters

  I would like to display the selections made for a parameter in a multi select dropdown. If i do as following for a textbox..doesnt work. =Parameters!STORELOCATION.Label.ToString I would like the labels to be displayed as below. Report is for the following stores: abc, xyz Pls help! ...Show All

• Visual Studio VSS: % in filename

  I have added to a VSS project, a file which contains a % char in the filename.  For example: "Is_Old_New_65%Line.vi".  When I try to Check-out the same file, VSS complains with the error: "Is_Old_New_65%Line.vi is not a valid SourceSafe syntax".  Looks like VSS is treating the % as a control character, and rejects the filename.  Since VSS was able to ADD the file with the % character, it should also be able to Check-out/Check-in the same file. Has anyone else run into the same problem   Any work-arounds, besides deleting the old version, and Re-ADDing the new version, which defeats the concept of version control. Thanks. I was not able to add files using A "$&qu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The documentation needs seperation between PC and XBox 360

  I'm trying really hard to enjoy XNA. It seems like a clean break from native programming. I enjoy the innovation that MS gave, but maybe its just their docs that are just annoying right now. I read the docs and when I try to follow something on the Windows development side, it goes right into the XBox code and doesn't give me the source code I need for Windows. I thought I was reading a Windows section too, or sometimes hoping that I am. I wish Microsoft could seperate the differences because right now its just "oh and while you're doing reading about what relates to Windows development here, take a look at the XBox code below." All I can say right now is the documentation needs some seperating. I'm do PC development and I have n ...Show All

• SQL Server Class not registered

  Hi, when i am trying to open a table from Microsoft Visua Studio 2005 I got the following error Class Not Registered.Loking for object with classID:...... how resolve this Hi, What is the class ID that it complains about. This seems more like a Visual Studio setup/installation issue than a SQL Server Data Access issue. Thanks Waseem ...Show All

• Visual Studio Express Editions How I can check with vb6 is some dll in windows registry ?

  How can I check in VB, is some dll registered. It helps me little but... one more question.. if I register dll like that regsvr32.exe c:\mydll\Card.dll what is the parameters value in this Function => GetRegKey(" "," "," "," ") ...Show All

• SQL Server My "On Update" Trigger reacts also "on delete"

  In SQL Server 2005 Express I created a trigger which should edit a value in another table when a special tupel column has been updated. The funny thing is, that it also fires on delete...of course not what I wanted. what did I do wrong Thanks in advance! ALTER TRIGGER dbo.update_history_users ON dbo.[user] AFTER UPDATE AS IF UPDATE ([name]) BEGIN DECLARE @old_value nvarchar ( MAX ), @new_value nvarchar ( MAX ); SELECT @old_value = name FROM DELETED ; SELECT @new_value = name FROM INSERTED ; UPDATE dbo.history SET user_name = @new_value WHERE user_name = @old_value; END How did you identify that this trigger was also fired for del ...Show All

• SQL Server What does a Filter do in Report Model

  In a Model designer when you select and Entity you have list of Attributes on the right side. There you have the option to add new "Folder", "Source Field", "Expression", "Role" and " Filter ". Can anyone explain in a bit detail what this filter can be used for. Can it be used to filter data from underlying entity (I am not looking for SecurityFilter) I am working on Microsoft SQL Server 2005 - 9.00.3027.00 Thanks, Rahul That's a little unfortunate. I was hoping to find a way to filter data from entity. Not based on security but say based on date. Is there a way filter data in a model ...Show All

• .NET Development is is possible to request trigger in webservice

  i need to create an webservice course training project,if user register for course,the available seats in another table should decrase in value and check whether avilable seats become zero each time user registering,what is the method for this column value updation laja, triggers belongs to the dbms so it is the same if you're inserting the data from a web service, console application or directly in the table... pls show us the code you're using for the insertion in the ws... maybe we find something there. Rgds Rodrigo ...Show All

• SQL Server get the data directory

  Hi, I am searching for how getting the data directory where default mdf files are based. (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) My goal is to deploy mdf file in this folder during installation. Thanks hi, I'm little in trouble giving advieces as well as registry values are not honored as the seem.. you can query, via a NON documented extended stored procedure the Windows registry for some info.. you can see a HKLM\Microsoft\Microsoft SQL Server key.. SQL Server 2005 registers instances as MSSQL.1, MSSQL.n, and this for every engine type, like Report server, Olap engine, ... but you can get the MSSQL.x value querying the \Instance Names\SQL key as well some ...Show All

• Visual Basic Typed dataset nullvalue

  I am using a typed dataset created with the VS 2005 designer with nullvalue set to Nothing. this gives the following designer code for the field memo: <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ Public Property memo() As String Get If Me.IsmemoNull Then Return Nothing Else Return CType(Me(Me.tablePaypalIPN.memoColumn),String) End If End Get Set Me(Me.tablePaypalIPN.memoColumn) = value End Set End Property I want to test for a dbnull and so do this: TestString = IIf(Datarow.IsmemoNull, "", Datarow.memo.TrimEnd) Debugging the last expression, both the Truepart and the Falsepart are evaluated and, in the property, the lines If Me.IsmemoNull Then, Return Nothing, ...Show All

• Windows Forms Button group on toolstrip (C#)

  I would like to set up a group of buttons on a toolstrip, having functionality similar to a radio button group, i.e. checking one button will uncheck the others. I have added three buttons, and set the CheckOnClick property for each. Unchecking the other buttons is straightforward enough via each button's CheckedChanged event. However, the problem is that clicking on an already checked button will uncheck it. I would like it to remain checked. I tried changing the value in the CheckedChanged event, but this causes an infinite loop I think. I have also tried subclassing ToolStripButton and overriding OnClick. I have managed to get this working, but my solution seems overly complicated. Surely there is a way to prevent each button from ...Show All

• Microsoft ISV Community Center Forums Applying InsertBreak to a style?

  Hi, Using Word 2003 and not fluent in writing macros. I'm trying to write/string together a macro that would insert a page break in front of a style called H1 if H1 is on an even page. I've tried dozens of different pieces of code and can't get it to work. What I've tried is to find all occurences of H1 and when found, applied this: Selection.InsertBreak Type:=wdSectionBreakOddPage Unfortunately I'm not skilled enough to do this fully, and haven't been able to find any example macros that would do even something a little bit similar, so that I could modify that to my needs. Any suggestions/help you can provide will be much appreciated!!! Thanks, Laura Hi Navajo, Thank you very much ...Show All

• .NET Development Help with TripleDES and RC2 cryptography.

  I have 2 questions - 1) I get the following Exception when I try to decrypt data using TripleDES. - "An unhandled exception of type 'System.Security.Cryptography.CryptographicException' occurred in mscorlib.dll Additional information: Specified initialization vector (IV) does not match the block size for this algorithm." How do I make things right The code is as follows - /* Provides TripleDES encryption and decryption using classes in the .net Framework 1.1 */ public class TripleDES_Cryptography { public static string Encrypt(string plaintext, string key, string IV) { TripleDES des3 = new TripleDESCryptoServiceProvider(); des3.Mode = CipherMode.CBC; byte[] by_plaintext = Encoding.ASCII.Ge ...Show All

• .NET Development reflection related query

  I am facing one problem in my project. I want to find the referenced assemblies of my current assembly. I am using reflection.assembly.getreferencedassemblies() function for that. But I can't get COM converted .net dll and c++ dlls in that. why what should I do to get that dll also............... I want that dll name anyway..........please show me some way if it's not possible in .net then is it possible in c++................... Thanks in advance.................. bhavu wrote: but tell me if you came to know how dependencywalker.exe finds the references. Steve Miller is the author. Maybe he's willing to share... ...Show All

• .NET Development tableadapter update can't generat an update command

  Hi every one, I develop a program using OLEb (MS-Access2003), but there are a problem when I use (Datasource configuration wizard) to add my database which contain 3 tables only one of them has the 4 commands(insert, select , delete and update) and the other have only (select and insert) commands  and I want the update and delete Command in all table   any one can help me PLZ   Sorry, I forget to tell you that I use C# and IDE VS2005      If those tables are joined, the adatper can't do it. It can only generate commands for one table at a time, and each table needs to have a PK on it. And I hate be the bearer of bad news ...Show All