chionhhm's Q&A profile

• SQL Server Ignore first X rows in Excel Data Source

  Hi all, Is it possible to ignore the first x rows of the Excel file in an Excel Data Source component Seb. Not sure if the Excel Data Source has that capability built-in; but you could store that X value in a variable; then somehow add a column to the data flow that represents the  'rownumber' of every row in your data set (if this column is not in your excel file you could use a  Row Count & Derived Column to make it up). The use a conditional split to 'ignore' alll rows where rownumber<= X Not sure how neat this solution is; but it may work.   Rafael Salas ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. VerifyCanDraw throwing a NullReferenceException

  Hello, Occassionally a function called VerifyCanDraw is throwing a NullReferenceException from within DrawIndexedPrimitives - so I'm not getting any information about what's going wrong. The arguments look fine, and I've stepped through the program and found that the vertex and index buffers passed in look fine. The DirectX Debug runtime on highest output level isn't printing anything out of the ordinary. The problem itself is very capricious - for some deterministic applications using my library, it may or may not get thrown even if there are no changes to the code. For one other I can get it to occur or not occur consistently by constructing or not constructing an object from another library (FarSeer, specifically) that is never referenc ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectInput (MDX 1.1) GameComponent for download

  I posted this in the other forum here : ...Show All

• Visual Studio 2008 (Pre-release) TabControl Two level

  Hello all I have a TabControl with two levels, meaning some of the TabHeaders are in level one and some in level 2. The bottom level is closest to the content area. This is a default behavior. Now the default behavior also cause the upper level to switch places with the bottom level whenever an upper level tab header is selected. Tab 4 | Tab5 Tab1 | Tab 2 | Tab3* Tab 3 selected and when clicking on Tab 5 we get this: Tab1 | Tab 2 | Tab3 Tab 4 | Tab5* What I want is the upper level to stay upper and lower to stay lower, meaning each level keeps its initial state, like that: Tab 4 | Tab5* Tab1 | Tab 2 | Tab3 Is this possible Itzik here is the code from sdk for custom panel sa ...Show All

• SQL Server Series Grouping in SSRS Charts

  I am having some difficulty in getting series grouping in SSRS charts right. I have a result set which has item id, status of the item, status date The statuses are Purchased and Returned . I want to be able to show a chart where count of Purchased Items are in green and count of Returned Items  are inn Red grouped by week (dates grouped into weeks) and my Y-Axis shows the count of items. I have my series group expression set as: =Fields!Status.Value I have my values expression set as: =Count(Fields!Status.Value) The difficult part for me how would I group these statutes by week date. Any help is greatly appreciated. Thanks in advance, spj   I got this wor ...Show All

• Visual C# Whats wrong with my properties

  I want to assign my properties to values in my database using the sqldatareader...what am i doing wrong...the compiler tells me that my properties are read only...take a look please! private bool _IsNew = false ; private int _CustomerId = -1; private string _CustomerCode = ""; private string _Class = ""; private string _LoadType = ""; private string _VehicleType = ""; private string _TermNumber = ""; private int _Status; private string _Commodity = ""; private string _Name= ""; private string _Address = ""; private string _City = ""; private string _ZipCode = ""; p ...Show All

• Windows Forms Getting error "You do not have privileges to run this application"

  I have a Windows Forms application I wrote last year in VS .NET 2003, which I've upgraded to VS .NET 2005 today. It includes Crystal Reports 11 Release 2, and I've made a setup for it. I've just tested it by installing it on a new PC, and I'm getting an error that says simply, "You do not have privileges to run this application". I've searched for this error using both Live.com and Google, and really haven't found anything useful (both search engines yield just one website that lists this error message - interestingly enough it is not the same website). I am hard pressed to figure out why the network administrator account, which is what I used to install the app and test running it with, does not have privileges in order to run i ...Show All

• Visual Studio 2008 (Pre-release) Access a control in datatemplate of a ListBox does raise SelectionChanged Event?

  In the datatemplate of a ListBox, I place a TextBox and a Button. When I click the Button, or focus into the TextBox, the selected Item of the ListBox does not change at all. The only way to change the selected item is to click the item itself. So how can I change the selected item when I access the controls in datatemplate this would work < Style x:Key = " st1 " TargetType = " {x:Type ListBoxItem} " > < Setter Property = " Template " > < Setter.Value > < ControlTemplate TargetType = " {x:Type ListBoxItem} " > < Border Name = " Border " Padding = " 2 " > < StackPanel Orientation = " Horizontal " ...Show All

• SQL Server The task Transfer SQL Server Objects Task cannot run on this edition of Integration Services. It requires higher level edition.

  Error code: 0xc0012024 Using "Integration Services Project" template in Business Intelligence Studio. Using platforms Visual Studio 2005 along with SQL Server 2005. Getting the error while trying to execute package after loading it programmaticaly. I've just one task "Transfer SQL Server Objects Task" on my Integration Services package. But when I try to execute it from VS 2005 project programmaticaly, it gives the above mentioned error. The commands I use: Package pkg = new Package(); pkg = a.LoadPackage(@"C:\Documents and Settings\abc\My Documents\Visual Studio 2005Projects\lSSIS\SSIS\Package.dtsx", null, true); DTSExecResult dResult = pkg.Execute(); The the error comes like: error: ...Show All

• Visual Studio ReportViewer not finding assembly in webapp Bin folder

  We are experiencing a major problem while trying to call custom code from our report in a web app. The following message describes our problem: " Unfortunately, because of a bug, copying custom assemblies to the webapp bin folder will not work. We are [microsoft is] hoping to fix this in a service pack. Until then you have to deploy custom assemblies to the GAC. " (Rajeev Karunakaran - nov 2005) But, we are not allowed to add our assembly to the GAC. This means we can not use the custom code at the moment. Is there a known workaround this report viewer bug Or maybe some hotfix Thanks in advance, Erwin Molendyk Port your code to VB.NET ( if not already so ) and put it in the &quo ...Show All

• .NET Development Resource files and satellite assemblies ...

  Hi I'm attempting to deploy a solution where a resource file of strings can be modified at runtime. From what I gather from the documentation I need to provide a satellite assembly (which has the string resource file) alongside the main assembly. The main assembly has the string resource file embedded within it so it can act as the default. It appears from the info I have that when I deploy the satellite assembly with a different set of string values these can be used by the application instead of those embedded within. Unfortunately when testing this it does not appear to work. Key aspects of the solution is as follows: In the main assembly I have defined <Assembly: NeutralResourcesLanguageAttribute( "en" , Ultima ...Show All

• Visual Basic printing a hard copy

  So i have an app that has text boxes, labels, and comboboxes. the program populates a database. What i need to do now is Print a hard copy of the data (from a command button on the form) and send an email to someone (through Outlook).. Can anyone point me in the right direction on how to do this Thanks. Ian. the print dialog class, as it states in the documentation, Lets the user choose which sections of a document to print and what printer to print it to. This is your call, would be good user interaction for the user to select what printer they wish to print to for example the printdocument class is the main class that does the print processing job, you have to code in the printpage event, on what ...Show All

• SQL Server Please give me your suggestions on Report Query - Very Urgent

  I need to disaplay number of Active Agencies on monthwise in one of my report. I have tbl_Agency table with ActiveDate and ActiveFlag. ActiveDate column contains always first Activation Date. If any chances in the agencies(update/delete) the same record will move to tbl_AgencyHistory table. "If an agency is inactivated in September 10th, inactivated all of October, and then reactivated November 10th - the agency would be counted in September, not in October and counted in November" ActiveDate column has always first activation date, I could not meet this requirement. This is very urgent issue, Could you please help me on this. Thanks, Malar Thanks Mugambo, ...Show All

• Visual Studio Team System Is Microsoft.Cci.dll redistributable?

  I'm writing a standards-checking program which primarily parses C# source code (using the NRefactory library from SharpDevelop), and I sometimes need to relate the information in the source code to the compiled code in the resulting assembly. I'm currently using regular-old reflection to do this, but I've been poking around with the Microsoft.Cci dll from FxCop 1.35, and it's really nice. I'd like to use it in my app, and I was just wondering whether I'm actually allowed to do that. The license at http://www.gotdotnet.com/team/fxcop/Misc/eula.htm  specifically says the component parts may not be separated for use by more than one user.  I would say no, you can't redistribute. ...Show All

• SQL Server Package variables

  Couldn't quite find the answer I was looking for via a forum search. I have 9 packages that are currently called by a master package - all child packages take a datetim e variable from the master package which is subsequently used in the child processes. The question I have is that if I run the master package manually from Visual Studio I can set the master package variable manually to a date of my choosing and run it, which works fine. However we will be wishing to automate the package execution at some point and want to know the best way to run the package(s) on an automated basis and have the data variable supplied to the master package. What would be the best way to do this Presently we have a variable called MasterPackage ...Show All