GO2GUY's Q&A profile

• SQL Server Sql Server Encryption

  I'm trying to encrypt a column in my table using EncryptWithPassPhrase( @PASSPHRASE, @COLUMNDATA) My Question is, does PASSPHRASE have to be (at least ) as long as the column data Is there a problem if it is longer> I'm only storing part of the results, and it looks like the # of characters I'm storing is the length of my passphrase. Thanks, Phil My bad. I was using: Convert( varch ...Show All

• Visual Basic Shared Directory Exception

  When my application trys to access a shared directory on the intranet it throws the error:  An unhandled exception has occured in your application....Object reference not set to an instance of an object.  Here is the code that I'm using: Dim DataDir As String = txtLocation.Text         ' Add the ending character if it does not exist       & ...Show All

• Windows Forms Typed DataSet problems

  Hi, I'm having some serious problems with a Typed DataSet, it's rather hard to explain, but please do try to understand. I have an MS Access Database, all the tables and relations in that database are without errors, I checked this a a thousand times and ...Show All

• .NET Development accessing blobs via DataReader vs Datasets

  I guess I should have posted this question here instead of the general forum... we are running into a situation where blobs were created using myCommand = mContextInfo.Connection.CreateCommand() myCommand.Parameters.Add("p1", OleDbType.Binary).Value = mData myCommand.CommandText = myActionQuery numOfRecordsUpdated = myCommand.ExecuteNonQuery() the command is either a "Update" or "Create" now a datareader ...Show All

• Visual Studio Team System Again Load Test - actually Multi User test

  Hi I am not a developer therefore I am trying to get everything I can, without adding lines to the code. Let's see if it is possible. :) I've read the blogs: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=122964&SiteID=1 and http://forums.microsoft.com/msdn/showpost.aspx postid=118191&siteid=1 but still there is something that I don't understand. Therefore, I restart with basic questions: Can I use thi ...Show All

• Windows Forms mask in DataGridView

  How can I check the mask when the user edit the cell. I already set the custom format in DataGridViewCellStyle using CellFormatting event. But, when I key in the value, it doesn't check the format. ( for example, maxlength... ) ( EX : 1. CellFormating&nb ...Show All

• SQL Server quick transaction inside a stored procedure question

  a transaction block inside a sproc if after one of the tran statements, I bust out of the sproc with a return statement do I have to rollback explicitly first or does the tran rollback automatically appreciate the tip After returning to another procedure the @@TRANCOUNT should be still increased by 1. You can test that by printing out the @@trancount variables in both procedure. In common, I would alw ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectSound problems

  I have installed the DirectX SDK. I found that the namespace Microsoft.DirectX.DirectSound isn't available. I assume that I need this namespace to use DirectSound in managed code. How can I fix this I see it just fine. What SDK version are you using Are you using the MDX 1.1 or 2.0 libraries What does your list of references show when you try to add DirectSound Are any DirectX assemblies in the reference list ...Show All

• Visual Studio Team System Suggestion: Extend InstantiateArgumentExceptionsCorrectly to include ArgumentException.ParamName

  Just a suggestion: Extend the InstantiateArgumentExceptionsCorrectly rule to check that the ParamName parameter is not null (ideally only in methods with more than one argument; but, I won't push my luck :-) ). Catching an ArgumentException with a null ParamName is close to useless with no specific means of ensuring the Message property has useful content. Peter, In regards to InitializeReferenceTypeStaticFieldsInline firing on th ...Show All

• Windows Forms seprate date part from datetime field

  If I bond a textbox to a date field in a database a time part is added to it how can I stop that so only date is showen in the textbox I try SQL server - access (short date) - oracle (date) fields but it seems to be&nbs ...Show All

• Visual Studio Team System Document templates in TFS

  Hi! If there is documents templates (like .dot/.xlt files), is there any way to create new documents (.doc/.xls) from these right from Team Explorer If not, then why are there .dot in the default project templates The reason why I'm asking this is that there are 2 .dot files in the MSF for Agile Project Development model included with TFS, and I expected that these could be used right of to create .doc files, but can't get it to work.. I have a ...Show All

• .NET Development Two PIA's Conflict

  Hope someone knows why it is happening: I am using two different PIA's (different versions of the same exe) to load two addins on COM application. The addin1 loads (using PIA1) and modifies a command collection on the base com App and loads perfectly fine. But when the second Addin (addin2) loads (using a different PIA- PIA2 ) it fails when I try to loop over the command collection , that was modified in addin1. It errors ...Show All

• Visual Basic VS IDE can't publish with PublishDir set

  I can't seem to use the IDE to publish my application to my website when I have PublishDir set to another location other than the default.  When finished building, it seems that it always looks for it in the default "publish\" directory, rather than what the PublishDir value is.  I had set the value to "$(OutputPath)publish\".  Is there any way to get this to work Zhila, I was able to repro ...Show All

• Visual C++ Exception when accessing an array element

  This is just weird. I'm trying to iterate through an array of structures, passed as a pointer like so: void creeaza(Digraf* d, char * filename) Where the type Digraf is defined through these structures:  typedef struct l{  int nr;  l* next;  }*LIST_AD;  typedef struct {  LIST_AD laI; //first element if internal list  LIST_AD laE; //first element of external list   ...Show All

• Windows Forms Databinding of datagrid & combo box

  Hi everyone, i have 2 qns which i need helps from you guys. 1) i have to databind a dataset to the datagrid. The dataset contain a table with 2 colums : CateogryID and CategoryName. After binding it to the datagrid, i would allow the  ...Show All