hologram's Q&A profile

• SQL Server Find my Syntax Error!! (Because i cant see it)

  Im getting an syntax error in the insert into statement is what my error message says, but i cant see it. So if you could take a look and maybe find the problem it would greatly help. You need to delimit all column names that have spaces. Change Contact Name to [Contact Name] , etc. A good way to debug a SQL statement that you generate is to look at the commandtext string either from debugger or by printing it out and inspecting from SQL ...Show All

• .NET Development Firewall and Remote Events

  could you send a small repro Could you zip up and send a small repro project, including your configuration files   I'd like to run through your scenario locally, taking a look at how each of your channels is configured. Regards, JJustice [MSFT] ...Show All

• Visual Studio Express Editions Request related to ADO

  Hello, I studied ADO .net in C# but I forgot too many things aboud it, Specially I forgot how to work with SQL Server so please If any one just make a small example contains code of (Add, Delete, Insert, Search) in Sql Server database I searched about that in many sites but I didn`t a completely code that I want. I`ll continou searching and tring to get it and I hope you help me too Thanks hi, you can check this thread h ...Show All

• Visual Basic Anomalous Access Database Results.....

  I have a test database... the Table called Bluish is filled with the following data: Bluish RecordNo RecordType OwningCategory Name Author DateCreated DateModified Descriptor Document 0 SubCategory Bluish Puppies 2/7/2006 9:32:40 PM 2/7/2006 9:32:40 PM 1 ...Show All

• Windows Forms Delay when opening form with designer / changing Misc->Language

  Hello, I'm using VC++ .net 2003 with .net framework 1.1. It always takes a long time (10-20 seconds) opening my form with the designer, although only about 40 Controls are used (it says that there are about 1000 resources when I build the project). When I change the actual used Language of the form (localizing it for different countries) I also have to wait a long time till "the show goes on".. The windows resource localization editor is much f ...Show All

• Windows Forms Center form?

  Hi. I want to know how I can programmatically set my form back to the center of the screen in .NET 2.0 (C#) I would have modified the form size etc.. during a user selection but then wish to return the form back to the original size (which is done) and then also center the form back to the center of the screen. Would this be the best way   this .Left = ( Screen .PrimaryScreen.Bounds.Width - this .Width) / 2; this ...Show All

• .NET Development File or assembly name xxx.dll, or one of its dependencies, was not found.

  I found loads of similar issues when searching for a solution, but none of their solutions seemed to fix the problem I am having.  My project works for a while, then will produce the following error.  The errors have begun every time on a sunday (meaing it works fine monday through saturday).  I am not sure if the day is just coincidence or if there is some significance to that day.  Suggestions for this I have seen include g ...Show All

• Visual Studio Team System Project permissions

  I've created a new project and added windows users to the TFS project groups (contributer & project admins) but users (actually only 1 of them at the moment) get's a message when opening the project about not having any rights. Is there any special tricks to do this I'm using B2 on a single server install. Thanks I think there is something that refreshes/resync's the accounts.  I still get the issue with new accoun ...Show All

• .NET Development Marshalling complex parameters in C# (legacy C dll, with cdecl callbacks)

  Hi all, I'm writing a C# application which accesses a legacy C-Dll. The C-Dll contains a number of C-functions, each of them has a couple of parameters. All but one of these parameters are pointers to structs. The remaining parameter is a pointer to a callback function. I managed to marshal the structs so far that I'm able to call the C-functions in the Dll successfully. Only when it comes to triggering the callback function ...Show All

• SQL Server Pre-Execute AcquireConnection method call fails inside Sequence Container (transaction required)

  I've created an SSIS package that contains a Sequence Container with TransactionOption = Required. Within the container, there are a number of Execute Package Task components running in a serial fashion which are responsible for performing "Upserts" to dimension and fact tables on our production server. The destination db configuration is loaded into each of these packages using an XML configuration file. The structure of these "U ...Show All

• SQL Server Dynamic query: EXEC - Need to get a return value from query

  I use dynamic SELECT statement trying to achive the followng: DECLARE @table varchar(50) DECLARE @ColumnA varchar(50) DECLARE @Result float SET @table = 'TABLE_A' SET @ColumnA = 'COLUMN_1' SET @SQL = ' SELECT @Result = (SUM(( ' + @ColumnA + ' )) FROM ' + @table EXEC (@SQL) I need to assign the outcome of this statement to the @Result variable. It does not work because of different contexts for @ ...Show All

• Visual Studio Express Editions How can I make text flash using Graphics.DrawString

  Is there a way to make the text in the following code flash on/off every 750ms Dim Empty As New System.Drawing.Font( "Arial" , 8, FontStyle.Bold) e.Graphics.DrawString( "Empty" , Empty, Brushes.Black,97, 153) Ken I finally got it. For anyone following this thread here is the sample code and the link where I found the answer. ms-help://MS.VSExpressCC.v80/MS.NETFramework.v2 ...Show All

• Visual C# How to write the code automaticly into the InitializeComponent?

  I make some component and controls in the my toolbox when I drag them to the form, i hope VS can write the code into the InitializeComponent automaticlly,just like I drag a VS button in the form. How to archieve this pls give me some idea Thanks namespace Phone_Number_Control { public class PhoneTypeConverter : TypeConverter { public PhoneTypeConverter() { } public override ...Show All

• .NET Development movie play list

  Hi All I am using Windows Media Player embed on my site. Can you show me how to make a play list ore menu that will play in the same Windows Media Player. Thank you leecsone. ...Show All

• Visual Studio Can't get Build Rules add-in to launch

  I had Build Rules add-in work with a project. Now I want to use it for a different project but the add-in doesn't load in VS. How do I force an add-in to load I also tried to launch VS by devenv /setup. I get a DOS box and what seems VS was going to launch and then it disappears. What gives Abdu I recently used that Add-In (PrePostBuildRules) and, as you can see, it is actually from Microsoft (it is part of ...Show All