TBurrowsNZ's Q&A profile

• SQL Server Query Analyzer in SQL 2005

  I believe that Query Analyzer no longer exists in SQL 2005 and when I go to run saved Stored Procedure or any Transact SQL scripts I need to connect to a database every time a run one of my scripts. Is there a way to save my login so I don't have to login every time and also execute my scripts from the same window I found a solution in another post: Thanks to Erland Sommarskog for his post on my suggestion ...Show All

• Visual Basic Listbox update problem - easy one, i guess

  This should be an easy problem, i bet there is someone who can help me. I'm a begginer, so thanks in advance! I'm working in VB 2005 Express. The problem is: in one form there is a listbox with a MS Access database source, and in the other form si a datagridview throug which users change that particular data. Datagridview control works and updates perfectly, but how can I update (or refresh ) listbox in the first form after the changes have b ...Show All

• SQL Server How to aggregate a column that was itself an aggregate

  I have a column that has an expression with a runningvalue in it, a "Carrying Cost" for each month. I need to create another column that aggregates the monthly Cost. I can't to do a Runningvalue on the Runingvalue. I can't even do a Sum on the Runningvalue. Below is a message:   The value expression for the textbox 'textbox13' contains an aggregate function (or RunningValue or RowNumber functions) in the ...Show All

• Windows Forms Control placement when Inheriting forms BUG??

  Ok I found something really mind blowing. If you build a form and put some basic controls (basically building a template) and then compile it to a DLL. You then reference it in your project and use it as a template (you inherit the form&nb ...Show All

• Windows Forms Preventing Serialization of Control

  Hi all, I have the following problem: For a docking framework I have a manager which derives from Component and is visible in design-time. When the user adds a control via its collection I need internally to create 4 Docks that should be concealed&n ...Show All

• Visual Studio Express Editions Passing values to a function and returning value

  Still learning passing values. Could someone check my code so far and see if I am heading in the right direction I am getting value not declared errors and I see it, but not quite sure on where to declare them. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim A, B, D As Integer A = 1 B = 2 D = 5 AddThem() MsgBox( "Sum is " & ...Show All

• .NET Development White space below a nested table

  I'm sure this has been asked an answered, however, I am finding difficult to remove the white space that appears below a nested table.  In otherwords, I would like the table to fill the entire cell (<td>) however, it seems to leave a line, below the nested table in the cell.  Is there a tag or setting that will illiminate this behavior For all of you having this problem, as i did, simply m ...Show All

• Software Development for Windows Vista WWF and Business User

  Hi,     I would like to have clarifications on the usage of WWF in a business environment. Lets take a scenario in a company XYZ. The company XYZ can have multiple internal processes. for example ... 1. Leave application processing 2. Sales Order Processing 3. Purchase Request processing Consider that we have one .net application managing these processes. And all these processes involve human approvals. How should the business use ...Show All

• Visual C++ Pointer in C# to C++ unsigned char array

  Hi, I have a C++ class for accessing images from a DirectShow-compatible camera. For this I get a pixelbuffer that is actually a one-dimensional array of characters. I need access to this from C#, and I would like to avoid copying memory, since I need to update the camera image live, and this should be performed very fast. This is my C++ method in my Managed C++ application: ----------------------------------------------------------- ...Show All

• Visual Basic Problems with ODBC32.dll - cant get a handle for a connection

  Hi folks,  I am trying to get - for example - a list of available Data Sources on my PC.  I had it working when I was using the SQLAllocEnv function followed by SQLDataSources but as I researched further, everything that I read says I should be using SQLAllocHandle, which was introduced with ODBC version 3, instead of SQLAllocEnv.  I'm pretty sure I have ODBC 3.5 or so.  When I do use SQLAllocHandle function - I seem to ...Show All

• Windows Forms Exception Error

  Why would the following line: Dim dlResult As DataLayerResult = m_DataLayer.Login(txtUserName.Text, txtPassword.Text) give me an exception error System.NullReferenceException - Object reference not set to an instance of an object when I'm sure I am passing a user name and passwo ...Show All

• Visual Studio Tools for Office vbScript with .NET

  With Visual Studio 2005 and Framework 2.0 you discontinued the Microsoft.Vsa namespace. How do I execute vbScript in your latest framework without having to return back to your COM MSScriptControl (C:\WINDOWS\System32\msscript.ocx) I had been using the with Visual Studio 6.0 and then upgraded to VS 2005. I am using msscript.ocx in C++ and what used to work under 6.0 now does not. Calling Run on the control for a ...Show All

• Visual Basic Copying data between Access databases using VB2005 Express

  I am trying to copy rows of data between tables that have the same structure but using AutoNumbers for the PrimaryKey.  If I try and use the command dataset.Tables("table").rows.add(newrow)  I get the exception that the rows is in another table.  When I used ImportRow instead of Rows,Add it worked. I had previously set newrow(0) = 0 to avoid duplication errors in the AutoNumbering knowing Access automatically updates the Aut ...Show All

• Visual Studio xp64 hangs random during and after vs2005 installed

  my poor machine stopped without any response, keyboard and mouse not responsed. The CPU temprature is below 40'c and I have tested memory with MemTest tool. The CPU runns well on full load for for half an hour before I installed vs2005, and the temperature reached 42'c only. I haved updated BIOS flash to newest version. the cpu is amd64. Daemon tools x64 and Norton antivirus x64 is installed. The system also hang while system startin ...Show All

• SQL Server Any good workarounds for renaming columns?

  I have copied a long dataflow from one package to another (I wish I could reuse it without copying & pasting it, and thereupon being required to maintain two copies). Now I have to change the source to another table. Sadly for me, the columns on this one were renamed in the data source, so they all are lost in the copy & paste. (This one had been designed before we found out that field renames inside of other components are a nightmare ...Show All