Joe Webb's Q&A profile

• Visual Basic Send a variable to a function

  This goes along with another post I have. Again, I've only been programming in VBA for about a week, so my 's may sound a little elementary. I am reading in a 3 character string and want to send it to a function. The function is going to check for validity of the string by comparing it to a list in an Excel spreadsheet.  But, it the function is going to be run multiple times throught my Sub with different data each time.  So, I ...Show All

• Windows Forms Windows controls in IE with linked sub-controls

  Hi all, I'm able to create a control and run it from a web page with the <object /> tag. What doesn't work is if I create the control with reference to other controls (third party or made by me). How do I have to reference the o ...Show All

• Visual C# Putting .NET 2.0 in installer

  Hello Everyone, VS 2005 came out and I made my application in that, never realised I need a 2.0 Framework Installed on every machine...that is 25 MB over head but have no choice... How can I check if 2.0 is installed, which will be the case on 99% machines, until Vista gets released and everyone Updates..... How can i include 2.0 in the installation of my program and do a simultaneous check.... I'm using innosetup, free Installer.... ...Show All

• SQL Server What accounts for this performance difference?

  As mentioned in a previous thread, I've got a single Transaction Scope style transaction surrounding a number of DDL style changes. This usually takes ~1.5 hours to complete. What I noticed is the same sort of query starts to take longer the closer to the end it is. I.e. Create Table after the first 1 min takes 150ms, after an 1 hr it takes 2 secs. Is this a problem with SQL Transaction handling or DTC To prove the point I set my root transactio ...Show All

• Visual Studio Team System How do we implement MSF Agile successfully in our organisation?

  Dear MSF- and TFS-gurus To save your time I’ll state my questions first: Questions: Where do we start learning MSF Agile And how do we implement this process successfully in our organisation It might be helpful for us to have external help. Do you have knowledge of any true experts on MSF Agile residing in Europe or maybe even Denmark/Scandinavia I have a feeling that most consultants here either hav ...Show All

• .NET Development Automatically adding user to a role asp.net 2.0

  Hi I have a website where people are invited to create a login to view some free stuff. They can then optionally pay to view a page that contains lots of training videos. I have created "Basic User" and "Paid User" roles. The videos page load event checks to make sure the user is in the "Paid User" role. If they are not they get redirected. I can add the users to the "Paid User" role manually using the ...Show All

• .NET Development Add datacolumn to the datatable at a specified index

  Hello, I have a dataset that gets its data from an olap server database. the columns I get is Description, 2002, 2003. however I have my criteria for selection as 2001, thru 2003. the database restricts the columns that have all 0's in it. hence i have the missing 2001. This is for faster processing time. Now I am trying to add the columns 2001(in between description and 2002) with all 0's in its rows. I see that there is Table.columns.Add, but ...Show All

• Visual Studio Express Editions VC# Exit Sub Equivalent

  In VB if I want to exit out of a procedure I call "Exit Sub". What is the equivalent of doing so in VC# in a class library project in a procedure Thanks, Ryan Ryan, Similar to VB.NET, C# uses return, for example: VB Sub Equivalent: public void WriteLine( string value) {      if (value == null || value.Length == 0)       &n ...Show All

• Visual Studio 2008 (Pre-release) Create Message from a Typed Message

  Am I missing something Is it not possible to create a Message from a Typed Message w/o subclassing Message Message message = Message.CreateMessage([MessageVersion], MyTypedMessageObject, [XmlFormatter]); Thanks, Dave Nice. Thanks Mike. Is there a reason why you guys have decided not to expose another overload for Message.CreateMessage() that takes a TypedMessage Thanks, Dave ...Show All

• SQL Server Returning Value from Dynamic query

  I want to get the count of rows in the table which match the status. I am writing dynamic query for it.. Create Procedure Dyn_Get_CountByStatus ( @TableName varchar(200), @Status int ) as Begin Declare @strQuery varchar(500) Declare @count int set @strQuery = 'select count(*) from '+@TableName + 'where status=' + @Status set @count =exec(@strQuery) return @count End GO This query is not working. ...Show All

• SQL Server How to exclude read-only connections from DTC transactions?

  Hi I'm importing from an Access db into SQL 2005 using SSIS, and I want to execute the package inside a transaction so that I can rollback the import if I get an error.  However, it seems the Access connection doesn't support DTC as I get the following error: [Connection manager "MyConnection"] Error: The connection does not support enlisting in distributed transaction. The error goes away if I set the data flow task's TransactionOption t ...Show All

• SQL Server How to run an exe in the SSIS scripting task

  Hi, Can anyone help me how to run an exe file in the scripting task. I was trying the below code but it's giving an error. Set wshShell = WScript.CreateObject ("WSCript.shell") wshshell.run "c:\Test\ABC.exe", 6, True set wshshell = nothing   Thanks, rkn   Here's one way.  You may want to check out the MSDN for any security risks, etc.  Dim procID As Integer proc ...Show All

• Windows Forms Relative paths

  Is there a winforms equivalent of ASP.NET's Server.Mappath  I have an access database (MDB/MDE) file being deployed with my application and I need to make sure the application points to the right location in case the user deploys to a folder other&n ...Show All

• Smart Device Development Unable to play WMV on WMP10 on PocketPC

  I'm not sure if this is right place to ask this question, apologies if I'm out of line. I'm trying to play a video file (encoded as Windows Media Player 9 Screen) on a Pocket PC running Windows Media Player 10 Mobile on Windows Mobile 2003 SE (it's a Dell Axim X50v). I get the sound but no picture, so I'm guessing I'm missing the WMP9 Screen codec. Does anyone know how I can fix this Thanks in advance. I did not ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with ComputeBoundingSphere

  I'm trying to use the Geometry.ComputeBoundingSphere method to get the radius of the bounding sphere of a simple mesh. The code is as follows: using (VertexBuffer buffer = this.mesh.VertexBuffer) { GraphicsStream graphicsBuffer = buffer.Lock(0, 0, LockFlags.None); Vector3 center; boundingSphere = Geometry.ComputeBoundingSphere(graphicsBuffer, this.mesh.NumberVertices, this.mesh.VertexFormat, out ...Show All