kenny125's Q&A profile

• Visual Studio Report Slow at the Printer

  Have a couple of clients that are saying the report is quite slow at the printer. Both clients indicate that a page will print and there is a long pause until the next page starts to print on the printer. I tried a little test here in the office and found that a 200 page report grows to as much as 95 MB as it is spooling to the printer. I compared this to the old report writer we used for the same report in a previous version and the size only hit about 16 MB. Why is there such a difference in the size Has anyone one else found this situation and is there anything that can be done to resolved this Thanks in advance for any information. Jim One of the clients has provided a little more informat ...Show All

• SQL Server SSIS Optimization

  Hi There We have a package that simply reads a rows from a table and puts it into a flat file destination, this repeats through a for each loop. It is a very simple package. Problem is it takes 10 minutes to do a thousand rows. This is incradible slow, i have check indexes are fine, the table are only 1000 rows, but it seems to only read and write about 3 rows a second, this is crawling. Please how can we make tis faster, are there any obviously properties setting we should be checking We have started using SSIS alot around here, main problem is that all our packages seem very slow ! Whether they run in GUI debug or in a job in sql server (twice as fast but still slow). Anyone know some good resources on SSIS optimization Thanx ...Show All

• SQL Server Backup and recovery of SQL Server using VB.net

  Hi, I have a small application in which i'm using Sql Server as Database. my requirement is how to take the backup of the entire database or some tables from the database when there is any delete from the database. My requirement is to do from the VB.net application.Hope i delivered my question correctly. Any little help is beneficial to me. -regards GRK where i can find DatabaseCache class i downloaded and install SQLServer2005_XMO.msi but still i cant see that class, other code works fine. Thanks ...Show All

• Visual Studio 2008 (Pre-release) Can't use attached properties inside a DataTemplate

  I have the following DataTemplate defined, and I'm trying to set the "Offset" attached property that is found on my SlotItemPanel: <DataTemplate DataType="{x:Type tll:TimelineEvent}"> <StackPanel Orientation="Horizontal" HorizontalAlignment="Left" Background="BlanchedAlmond" tlc:SlotItemPanel.Offset="25" > <Rectangle Width="{Binding DatePixelRange}" Height="10" Fill="Red" Margin="10 0 10 0" RadiusX="10" RadiusY="10" /> <TextBlock Text="{Binding DateAsString}" VerticalAlignment="Center" FontStyle="Italic" FontSize="12 ...Show All

• SQL Server Copy Database Wizard Error- SQL Server Agent cannot execute the SSIS package

  I am trying to copy a database from our company's external SQL Server(production) to our local SQL Server(development). The Copy Database wizard fails on the step "Execute SQL Server Agent Job". Following is the error in the log file.. Please advise InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) When I click on Remote Connections, I get a message saying"You cannot configure surface area of clustered services by connecting to a com ...Show All

• Visual Studio Express Editions "Program Closed" notification network transmission

  I have written a Console app that will (ideally) be continuously running on a server. I need some help creating a notification of some kind that will be automatically passed over the network to a workstation if this program closes for any reason so somebody is made aware that the app needs to be restarted. I would prefer using a Message Box, but I haven't been able to figure out how to send one to another workstation (is this even possible ). Would sending the message as an email be another alternative If so, how would I go about doing this Any other thoughts on possible solutions are certainly welcome. -Bryan Bryan_THC, It seems that you are trying to create a Windows Service that can create ...Show All

• Visual Studio 2008 (Pre-release) SyncStatistics values are always 0

  Except for the start and end times, it looks like none of the values in the SyncStatistics object returned by syncAgent.Synchronize() is set. They are always 0. The various properties of the GroupProgress and TableProgress objects in the SyncProgress events are also always 0. Do I have to do anything to enable statistics Are they not implemented yet Is this a bug I made some more changes to my application (removed UpdateOriginatorID column, added a tombstone table) and now I get statistics at least for the deletes in the SyncProgress events and the SyncStatistics object. There are still no statistics for inserts and updates. ...Show All

• Visual Basic Difference between C# interfaces and VB.NET interfaces.

  I'm trying to convert a C# sample to vb.net and am running into a bit of a problem. The following C# code compiles.. public interface IView { event EventHandler Load; } public class MyView : System.Web.UI.Page, IView { } While the following VB.NET code does not. Public Interface IView Event Load As EventHandler End Interface Public Class MyView Inherits System.Web.UI.Page Implements IView End Class The error returned is: Class 'MyView' must implement 'Event Load(sender As Object, e As System.EventArgs)' for interface 'IView'. How do I fix this problem It seems like it should be simple! Not really.. Load1 is pretty ugly, don't you think If I replace Load1 with Load, I get a warning: event 'Loa ...Show All

• Visual C# CheckListBox SelectedIndexChanged Event

  Hi, I have a checklist box and I have a method that is called when the SelectedIndexChanged event fires. Is there any way to know which item in the list caused the event to fire Thanks The only way I know to do this is to maintain your own buffer of selected items, something like this: private List < int > selectedIndexBuffer = new List < int >(); private void listBox1_SelectedIndexChanged( object sender, EventArgs e) { if (listBox1.SelectedIndices.Count < selectedIndexBuffer.Count) { // Item was deselected selectedIndexBuffer.Clear(); int [] indices = new int [listBox1.SelectedIndices.Count]; listBox1.SelectedIndices.CopyTo(indices, 0); sel ...Show All

• Visual Studio Exception when running VCBuild.exe

  Hi , I'm running compiling of my solution using vcbuild.exe in the following format vcbuild /r solution.sln "Unicode Debug|win32" . The solution contains a list of C++ unmanaged project and one C# project. The crash happens when compilation of C# project starts PreBuildEvent The prebuildEvent contains reference to $ProjectDir and Environment Variables , that I believe that I think the reasons for the crash. Can you help me with with that No there is no any error message - just a regular crash pop up. It crashes on the Pre-Build Event having reference to $Project and Environment Variables I'll be happy to send the logs of VCbuild if you will say how to invoke them. ...Show All

• Visual C# Don't understand the concept of environment PATH variable

  Hi all, I am not understanding the concept of PATH variable. we are defining different path in this PATH variable. I am using one zip file and not specifying the path. See the ziputility variable in below code.. { string arguments = @" -o " + ZipFileName; string zipUtility = @"unzip.exe"; ProcessStartInfo startInfo = new ProcessStartInfo(zipUtility, arguments); startInfo.CreateNoWindow = true ; startInfo.UseShellExecute = false ; startInfo.WindowStyle = ProcessWindowStyle.Hidden; startInfo.RedirectStandardOutput = false ; startInfo.WorkingDirectory = directoryName; Process proc = Process.Start(startInfo); proc.WaitForExit(); } i am not giving the path for unz ...Show All

• Windows Forms Error Reading in Value from current row of datagrid

  i am using vb.net (.net framework 1.1) vs 2003. and the builtin datagrid i think microsoft datagrid control 6 and i am facing a problem in reading value from current row of datagrid if current row is a new row. msgbox dg1.item(dg1.currentrowindex,0) this line throws an exception there is no row at position 0 ( 0 is index of current row) i cant even read it from datatable coz it hasn't become a part of datatable yet plz give me its solution as soon as possible ...Show All

• SQL Server Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, Well if the path to the log file is a local path then that will be a path local to where the package executes. This is NOT on the server where it is stored - it is local to the app from which you are executing the package. HTH. -Jamie ...Show All

• Windows Forms ListView Selected Items

  Hi folks, if I get the selected items in a ListView with: lviItem = listViewFilters->SelectedItems->Item[0]; How can I find the actual index of lviItem I want the index so I can move the item up or down in the list. Thanks for your time, Zero ...Show All

• Visual C++ Making vcredist_x86.exe run silently

  Hi I am putting a software installer together, and one step I need to take is running this app to ensure certain dlls are present on the users system. At the moment, I am placing the exe in a temp folder, running it, then deleting it. I am using the NSIS installer scripting tool, so Exec "C:\temp\vcredist_x86.exe" is the line that does the business. Is there an argument I can pass to vcredist_x86.exe in order to make it run silently (ie without bringing up any popups about what it is doing ) Curiously, I cannot run the exe from a DOS prompt. Thanks OK, so you basically should take the command line way of installing the runtime. See the link of my previous post. -- SvenC ...Show All