Hauk's Q&A profile

• SQL Server Convert Int Data into a multi-field string

  Trying to get a multi field grouping to print. Client + Req Number + Status Client and status are nvarchar fields Req Number is an int. Keep getting # Error for this field on the report. on the report. It works in Access - should it be this difficult Thanks! Terry I found this also worked, Cast (ReqID as Char(5)) As Creq in the query and I was able to use the value. Your code looks both easier and better. Will give a try. I regard this as solved. Thanks! Terry ...Show All

• SQL Server Sum issue on table footers

  I am having a big issue trying to resolve this problem. Hope to layout it out well enough to understand. I have a dataset like this. Name Sales$ Quota Month ----------------------------------------------- John Doe 10 10 1/1/2006 John Doe 20 10 1/1/2006 John Doe 15 10 1/1/2006 John Doe 18 10 1/1/2006 ----------------------------------------------- Jane Doe 12 5 1/1/2006 Jane Doe 6 5 1/1/2006 ----------------------------------------------- Jack Black 18 15 1/1/2006 Jack Black 22 15 1/1/2006 Jack Black 14 15 1/1/2006 ----------------------------------------------- The issue I am having is quota is truely only the one value, not a sum of the ...Show All

• Windows Forms How to set the transparent color for an Animated GIF?

  Hello, The animated gif in my application represents the process and asks the user to wait while the thread is completing its task, however the problem is when I try to set the transparent color of the animated gif with a code similar to this: waitImage.MakeTransparent(System.Drawing. Color .White); The transparent color works as expected, but the problem is, the Animated GIF become static and loses its motion. I am hosting the Aimated GIF in a Picture box and the application is written in Windows.Forms and .Net 2.0 Do you know why this happen Thanks in advance. private void OnLoad( object sender, EventArgs e) { waitImage = ResourceHelper .GetImage( "wait" ...Show All

• Windows Forms Magic with Installations (Am I re-inventing the wheel)

  Hello, it appears that this is the catch all forum for ClickOnce, Setup & Deployment and the Bootstrapper. see Chris Smith's last signoff note at http://blogs.msdn.com/chrsmith/archive/2006/03/10/Bootstrapper-SDK-R1.aspx Anyway, this is what I need to be able to do for MAJOR insurance carriers deployement of our application but everything I try I keep dead-ending. First can't use ClickOnce because of the per-user limitation... 1. Launch Install -OR- Bootstrapper a. Test RAM, OS, DiskCost b. Summarize to end user what is and isn't passing for launch conditions 2. Go no Go bassed on 1a. a. Summarize prerequisites to be installed. In our case .NET and SQL Express (and their prerequisites) ...Show All

• .NET Development Crate Image

  Hi there. I would like to ask how can I create an RGB image from a matrix of the following form: 1 2 3........... n 1 rgb rgb rgb.......... rgb 2 rgb rgb rgb.......... rgb 3 rgb rgb rgb.......... rgb ..................................... m rgb rgb rgb.......... rgb where rgb are the red, green, blue values of each pixel.. What is more usefull for me to save the rgb values in three different matices or using structs I would really appreciate any help of you. Thank you in advance. NM You already have a struct to store an RGB color: System.Drawing.Color. You could represent an image in a 2-dimensional array: Color rgb[,] = new Color[m, n]; Note that .NET arrays are indexed starting at ...Show All

• SQL Server Log Shipping Error 4323

  Hi all, Scenario : MS Windows 2003 SP1 - MS SQL Server 2000 EE SP4 Log Shipping My secondary server was restoring backup logs successfully, but suddenly i got the following error: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4323: [Microsoft][ODBC SQL Server Driver][SQL Server]The database is marked suspect. Transaction logs cannot be restored. Use RESTORE DATABASE to recover the database. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally. How can I fix this situation without re create the maintenance plan We had the same issue some time ago, this was related to a new file being created in a filegroup on the source. Don't know if this applies to your ...Show All

• SQL Server Flat File with Nested Data

  I am looking to import data into SQL Server 2005 using SSIS. I want to take data that is contained in a flat file and place it into the various appropriate tables in my system. The flat file contains nested data. For example... Bob,Smith,555-5555,123~3.33|245~1.99,Active So I want to build a package that brings in the records as follows Client Table: First Name, Last Name, Phone, and Status (Bob, Smith, 555-5555, Active) Order Table: OrderID, Amount (ID 123 @ $3.33 and another row ID 245 @ $1.99). If possible I would also like to tie the orders to the client record that was inserted. My first question is if SSIS supports nested fields as in my example. Can it break a file by commas, then within a field by other delimiters I ...Show All

• Visual Studio 2008 (Pre-release) Sql everwhere and WPF

  Has anyone sucessfully used the sqlce results set as the data sourse for a control on a wpf window or page do you know where I can find a c# example of this Thanks We solved the problem in this thread ...Show All

• SQL Server sql services

  hello Every one, I work for mcafee and we have alot to do with data bases and their manipulation. I need to learn to work my way around the query analyzer and manager. Any good docs or web sites about thank you all Ali Katouzian alcat1975@hotmail .com I believe you will be creating scripts to run as batch jobs to be a part of your solutions delivery. You need to know how to create TSQL scripts and use osql to execute them in batch files. ...Show All

• SharePoint Products and Technologies Workflow and Form Library?

  It appears I cannot create a workflow (using Sharepoint Designer 2007) in a form library. I have success with document libraries. Can anyone verify this ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed C# performance loss.

  I caught some people quoting managed performance loss at only 2% (over unmanaged). I am just curious how accurate that assessment is. Last time I was looking into it, DX programmers were quoting 90% of managed performance as a BEST case scenario. (usually much lower) If the margin has grown so low, is there any large scale games developed using C# This is an ever returning question. I am a real C# fan simply because it is easy to use :) A language like C# does not make you worry about pointers etc which enables you to focus on great software designs. In the end having a good design might be most important especially in the context of a game which tend to become exponentially complex as they grow in si ...Show All

• Visual Studio Team System Response time Vs Connections

  Hi, I am doing load testing on web application. I have executed the test with 100 users with Connection pool size was 50. Average response time was 27 seconds and I got the errors for average connection time out counter. I have increased the connection pool size from 50 to 100. When I have executed the load test second time I did not get errors for average connection time out counter. But response time was 60 seconds which is almost double than first time (27 seconds) Why response time varies when connection pool size increases. Is it right that increasing connection pool size when we get the errors for average connection time out counter In forum I have seen some messages connection per user is better ...Show All

• Software Development for Windows Vista problem with execution context and accessing activity data at runtime of a workflow

  Hi, I have a problem on execution of a state workflow, maybe someone can help me: My state workflow contains 2 custom state activities which initializes some data objects when a state is executed. If I run the workflow, state 1 correctly executes and sets it's data object, which is exposed by a dependency property. The data object only is available at runtime not at design time. After state 1 has completed the workflow is persisted and unloaded. Now I send a continue event to the workflow, which causes the runtime to reload the workflow and executing state 2. In the Execute method of state 2 I try to access the data object of state 1, which was set on it's Execute method, but this object is null. To access this object I use ...Show All

• SQL Server How to update my program with a database

  I need help to decide how to proceed. I have written a program using vb 2005 express that will create menu items after the user presses a particular button. So if the user picks a mountain dew then inside the reciept window(list box) the user will see 1 MT DEW $1.00 also as the user selects more items the price is calculated and displayed also. This part of the program works fine. After using the program for a while I realized that I will need to update prices and be able to add and subtract items from the menu that customers order from. The way I accompolish this now is to go back into my code and rewrite alot of code. From reading the forums I think that a database would be a good solution because what I have gathered so far is t ...Show All

• Visual Studio Express Editions Error loading file in VB 2005 Express forms designer

  I'm getting the error "unable to load Interop.NCDControl" which is associated with a third party control placed on one of my forms. Since this error won't allow the form to load, how do I remove the control. I have removed all references to this control in the code section and the program runs correctly. I need to change the form to address some other issues. Hi Windy Well we're going to do something we are told we shouldn't In the solution explorer, select your form At the top of the solution Explorer is a Show All Files Icon - Depress it You should see a file called form1designer.vb double click on it and you'll see it in the editor...... CAREFULLY.... remove all references an ...Show All