dgolds's Q&A profile

• SQL Server Render RS Report to Excel and changes Sheet Names

  I am wondering if anyone knows how to change the sheet names in Excel when exporting a report from Reporting Services 2005. In other words, I have a report with approximately 5 page breaks built in. When I render the report to Excel, it creates the 5 sheets as I expect, but it names them "Sheet1", "Sheet2", "Sheet3" etc... Is there a way to specify the name of the sheets I am currently using a different table in my report for each sheet, but I am open to structuring this differently if needed. As I am a developer on my own, I have several solutions in mind which ar really only workarounds. One thing would be to pass the definition (sheet names) in a hidden Table, which wi ...Show All

• Windows Forms problem

  Espanol: Tengo un problema, al crear un grupo de trabajo con mi windows nt en mi pentium II, algo a ocurrido que al inicar sesion me pide usuario y contrasena, pero no las se, ya probe con admin y 0000 o amdin y 1234 (y envez de admin tambien con administrador y administrator) y tambien con contrasena en blanco, pero ningun me la acepta, que puedo hacer necesito entrar a mi pc con urgencia, gracias. English: I have a problem, when creating a work group with my Windows NT in my pentium II, something happen, when i start session  the pc requests user and password to me, but i dont now them, I probe with admin and 0000 or admin and 1234 (and instead of admin also ...Show All

• Visual Basic INSERT, DELETE, UPDATE Staments for 2 tables

  In VB.NET 2005, INSERT, DELETE, UPDATE Staments for a TableAdapter can be generated automatically; but not for the two related tables. I find it very hard creating these statements manually. I request the members of this forum to help me with some examples. As for as I understand, SqlCommandBuilder works with DataAdapter, not with TableAdapter. Secondly, SqlCommandBuilder does not generate these statements for SQL containing JOINs. Thirdly, I want to learn that which I don't know.  My question is more explained as below: I am using the following SQL statement: SELECT tblDrugs.DrugID AS DrugID, tblDrugs.DrugName, tblDrugs.PriceID AS PriceID, tblPrices.* FROM tblDrugs LEFT JOIN t ...Show All

• SQL Server first form normalizations and second form normalization

  Hi everyone, What is the main difference between first form normalizations and second form normalization In my opinion, they are both generated for the same operation which is to prevent redundancy(in other words; duplication of data in several records). So would you please explain it to me Thanks Taken from: http://databases.about.com/od/specificproducts/a/normalization.htm First normal form (1NF) sets the very basic rules for an organized database: Eliminate duplicative columns from the same table. Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key). Second normal form (2NF) further addresses the concept of removing duplicative data: ...Show All

• Smart Device Development Pocket PC Installer

  You'll need a .inf file to go with your custom action for your install program. I googled "pocket pc install custom action icon" and the first result was: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/netcfdeployment.asp which has some really nice tips. In the project properties you'll need to assosciate a new icon with it, and your .inf file will specify where to create shortcuts.. here is an example .inf file i used to deploy my WM5 C# app (with some web-safe alterations): [Version] Signature="$Windows NT$" Provider="Me" CESignature="$Windows CE$" [CEStrings] AppName="MyMobileApp" InstallDir=%CE1%\%AppName% [Strings] Manufacturer="Me" [CEDevice] ...Show All

• SQL Server Table visibility problem

  Hi,I have a report with various tables, some of them can be empty. When empty, and hidden property set to false only one line apears blank in my report, but if i set the hidden property to true it results in an empty space with the same height as the table i’m trying to hide. My goal is to have no blank spaces at all when a table is empty. Anyone can help thanks. I need to know directly from the table, because i have multiple tables with the same dataset, the diference between them is their filters. Is there any way to do this Thanks... ...Show All

• Windows Forms Publish ClickOnce project with Team Build?

  Does anyone have any examples of how to create a Team Build BuildType that publishes the project similiar to the way you manually do it in visual studio I already have the BuildType created and working (it gets kicked off on a schedule). I've also created a BeforeDropBuild task that does GenerateApplicationManifest and GenerateDeploymentManifest that also works. This was a bit confusing -- when the BuildType is run not through the GUI many of the properties don't exist and most of the examples appear to assume they would. Anyway, these steps work in that the build does not fail. Somehow I need to publish the manifest I suppose, but I can't find any examples of how to do it. I'm not even sure I know the right questions to ask. Any help w ...Show All

• SQL Server Creating process doing specific job periodically

  Hi, can I create a background process in SQL Server doing specific jobs periodically Stored procedure is the only solution Hi, I'd go for an OS scheduled task, running SQLCmd.exe to execute the desired Transact-SQL statement... something like SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.History ( Id int NOT NULL IDENTITY, data varchar(25) DEFAULT 'will be removed', Registered datetime NOT NULL DEFAULT DATEADD(Hour, -1, GETDATE()) ); GO WHILE (SELECT COUNT(*) FROM dbo.History) < 10 BEGIN INSERT INTO dbo.History DEFAULT VALUES; END; INSERT INTO dbo.History VALUES ( 'this will not be removed', GETDATE()); GO SELECT * FROM dbo.History; GO PRINT 'actual statement to be scheduled every hour'; DELETE FROM d ...Show All

• Visual Basic Read/Write Decimal Value to File Problem

  Hi, I'm having a problem with writing Decimal values to file and reading them back again. For some reason, the last digit is truncated when I read the value back again. Take a look at the following code snippet. Dim Value As Decimal = 0.1234D FileOpen(1, "test.dat" , OpenMode.Binary, OpenAccess.Write, OpenShare.LockReadWrite) FilePut(1, Value) FileClose(1) Value = 0D FileOpen(1, "test.dat" , OpenMode.Binary, OpenAccess.Read, OpenShare.LockReadWrite) FileGet(1, Value) FileClose(1) For some reason, when I read Value back again, it is 0.123 instead of 0.1234. The '4' is truncated off the end. It is not a rounding issue as this is a Decimal type and it truncates any digit off ...Show All

• Visual Studio DIA SDK 8 and managed code bug with SymTagUDT?

  Hello Everyone: I've bee using DIA SDK 8 with Visual Studio 2005 and .NET 2.0 for over a month now. In that time I've never been able to get querying the root of a .pdb for SymTagUDT for managed code. It always returns 0 items. Even MS's example program, dia2dump returns 0 items for managed code. (Unmanaged code works fine.) I have msdia80.dll installed, the debugger download installed, etc... Has anyone else run into this problem or have any thoughts on a solution Thanks, ...Show All

• Software Development for Windows Vista conime.exe

  Hi Oliver, Could you please refer to the thread below http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1097952&SiteID=1&mode=1 Thanks for your help and answer! Vian Hi Bruce, What's result of this issue Will MS fix it ~ Vian ...Show All

• Visual Studio 2008 (Pre-release) Disabling binding based on visibility

  I have an ItemsControl with a binding on ItemsSource and I was wondering what is the easiest way to enable/disable that binding based on visibility property of that control. I don't want the control to be updated when it is invisible. I ended up using Style.Triggers to set binding based on ItemsControl.Visibility. It seems to be working although I'm not sure if this is the best way to do this since the binding probably gets recreated everytime control becomes visible. It seems that it would be more efficient to just turn a binding on and off when needed. ...Show All

• .NET Development How to copy a file to a folder shared on the network

  I am generating a zip file then I have to move it to a folder shared on one of the system in the network. How Can I to move a folder into shared folder on one of the system in the network in C# .net 2.0 NTFS permissions are permissions on a folder or a file. If you share a folder you can set permissions on that share which are not the same permissions as the NTFS permissions. Windows works with the most restrictive permissions. For example: NTFS permissions on C:\test = Read Share permissions on C:\test = Write Result = Read Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual Studio 2008 (Pre-release) Media Element Will Not Play.

  I tracked the error down with the on failed error, and I THINK this is ther error: Insufficient memory to continue the execution of the program. I can only say think so because the routed events confuse me somewhat. lester - MSFT wrote: If media element is not playing then its likely that your media player is an older version. v10 or higner is needed Wrong, WMP11 doesn't work. I had to roll back to v10 to get MediaElement to work ...Show All

• SQL Server Clustering , how to start ?

  Dear Friends, i'm using windows 2003 server on both computers i wanted to practice clustering with sql 200/2005 [two nodes] but it asks for a quorum disk as a shared disk between the two clustered nodes, i didn't know what a quorum disk it, the internet when i searched for says that a quorum disk should be either a scsi or fiber channel disk, i've never seen a scsi disk, i'll purchase it today, but what i'm confused about is, how will i connect one single scsi disk two two computers/nodes i mean does a scsi disk have a long cable to connect to and if yes, then where does the cable fit in on either of the nodes, or is it not physcially shared then if it's logical then how do i configure it. pls reply soon, regards, and thanks ...Show All