Eric Totten's Q&A profile
Visual Studio Express Editions Answer for How do I bring the animation in my form, to front of the controls?
(Because the question is in an old post with a lot of 'first try' code. I decided to put this answer with much better code in a separate thread.) The following example is a modified version of a program by Bob Powell that was written in an older version of Visual basic. (Uses shapes instead of circles.) When the conversion wizard upgraded the older program, it retained the old style of not using partial classes. For form1 of the example program we will follow suit and do the same thing. So, CUTTING AND PASTING OF THIS PROGRAM WILL BE SLIGHTLY DIFFERENT THAN YOU ARE NORMALLY USED TO. The code below is clearly divided into three blocks; (block1, block2, and block3), which we will refer to in the following instructions: 1. Open ...Show All
SQL Server Year based Sequence Clustering
How do I limit (or partition) a sequence clustering by year I would like to do it within the sequence clustering mining structure instead of partition at the OLAP cube/ You can right click on the mining structure in the mining structure tab on the data mining designer and select "Define Mining Structure Cube Slice". You can specify independent slices on the structure and each nested table. ...Show All
SQL Server Proxies: What is it for?
Let me know any link for that. tia If you mean the proxy account SQL Server can run under, that is just a security impersonation for the case that you want to run xp_cmdshell with other priviledges than the Service Account. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Visual C# Parametrized Query in Visual C# 2005
Hello, I have a problem in setting a dynamic query in my application. Actually, I know how to work with a parametrized query and how to pass a value for one of the elements in my where clause, but I need to pass more than a value like other criteria or generally i need to change the structure of my SQL in the given query. My database is Oracle 8i. Does anybody know how I may address this Thanks Sorry M, I have no idea either. I never use the tableAdapters. I much prefer the old DataAdapter, SQLConnection, SQLCommand way of doing things. I think tableAdapters are compiled/created at design time, which is why you have to use the wizards to fill them. Unless you start m ...Show All
Visual Studio Using item group created from CreateItem in another Task?
Hello, I have the following structure in my MSBuild project file: < Target Name = " Build " > < CallTarget Targets = " CreateProjectItems " /> < Message Text = " Here are the projects: " /> < Message Text = " @(MyProjects) " /> <!-- displays nothing --> < CallTarget Targets = " TestTarget " /> <!-- displays the MyProjects correctly --> </ Target > < Target Name = " TestTarget " > < Message Text = " @(MyProjects) " /> <!-- displays all items in MyProjects correctly! --> </ Target > < Target Name = " CreateProjectItems &q ...Show All
SQL Server For-Loop and Failed Items
All, I am currently in the middle of writing a package that needs to loop round a record set and extract data from various source DB's in a common format. The inner package is a simple data pump that relies on a dynamic OLEDB connection being set at run time via a variable in the outer package. This works wonderfully, providing the value in the outer package points to a verifiable data source. However, If I make the data source invalid the execution status stops, In DTS 2000 this was simple to overcome with an Active X script, as you would set the package status to waiting and loop back to the next record. Waht i need to know is the object and property/method that will do this in SSIS, I've looked through BOL and theres ...Show All
SQL Server Unicode characters stored incorrectly in SQL 2005
I have SQL 2005 installed as back-end for MCMS 2002 , when storing a unicode content like Arabic , and query it direclty from SQL it appears like كيف الحال The english text stored correctly and can be read. Note that same senario with SQL 2000 the unicode data cane be viewed correctly. Regards Does this affect operation of MCMS or not " actually the content appears correctly on the web page. the types in 2000 and 2005 are the same as following: (< NodeId , int ,> ,< PlaceholderId , int ,> ,< Id , int ,> ,< PropName , nvarchar ( 100 ),> ,< IsResource , tinyint ,& ...Show All
SQL Server Trigger data corruption
I have a weird issue with a trigger... I have a table called category, which has a column [Name], and a record "113_Install". I have the following query in an AFTER UPDATE trigger on this table: INSERT INTO DataPump_PendingCategory (CategoryName) SELECT i.[Name] from DELETED After changing the data in Category, I see the following record in my pending table..."113_Ins D" or something similarly corrupt looking. From what I can tell, both of the tables have the same settings, any thoughts unfortunately there are other tables involved as constraints as well... I have verified that all of the data types match up, and as mentioned, recreating the tables from the schema, and the triggers on the new tables, I cann ...Show All
Visual Basic What's the deal with Generics
Hi, I have the following Function Public Function EnterOrder( ByVal custCollection As Generic.List( Of CustomerDTO), ByVal OrderDTO As OrderDTO) As Boolean Dim customerBOCollection As New Generic.List( Of CustomerBO)(custCollection) ...............Do stuff End Function I get an error when I run the program basically saying unable to convert CustomerDTO to CustomerBO. What other way around this do I have CustomerDTO is my serialized object and CustomerBO (name speaks for itself) is the one with the rules etc. With one customer it works like this Dim customerBO as new CustomerBO(CustomerDTO) I now need to pass a collection of customers and I was turning to Generics for assistance. Any ideas ...Show All
Visual C# Problem in accesing functions in a dll
Hi All, I have a strange problem... I have VS2005 on WinXP and am making a Windows Project.When I ran the project I got an error "Unable to find an entry point name "foo" in dll "foo.dll". However the dll is present in Windows\System32 directory and the Path also references the directory So I added a reference to the dll in the System32 folder but it showed an error that "A reference to ....dll cannot be added.Please make sure that the file is accessible, and that it is a valid assembly or COM component". Next I ran "tlbimp foo.dll" from VS2005 command prompt.I got an error "The input file 'foo.dll' is not a valid type library.So I ran "regsvr32 foo.dll" and I got an error &quo ...Show All
.NET Development Remoting / Binary Serialization compatibility between versions 1.1 and 2.0 of the Framework
In order to use .NET Remoting and Binary Serialization (BinaryFormatter) between versions 1.1 and 2.0 of the Framework, a patch must be installed for .NET Framework 1.1. The patch is currently available only from Microsoft Product Support Services. Mention KB article number 907262 (note that the actual text of the KB article is not yet available outside of Microsoft, but the PSS engineer will be able to give you the patch.) Update: For detailed information, see my blog post here: http://blogs.msdn.com/eugeneos/archive/2006/03/15/552315.aspx Finally had an opportunity to actually put this to the test, and for anyone interested, initial testing appears to indicate that patched and unpatched 1.1 ...Show All
Visual C++ resize array then insert data
array<String^>^ sTemp = gcnew array<String^>(10) 10 elements in this array, i want to add a string at element 5 and have the data shift down so that the new array size will be 11 seems like i will need to resize the array first, shift the data and then insert the new data, any ideas on how this might be accomplished I don't think the Array is the right structure for your needs. You can use ArrayList which supports inserting elements at a specified index. You could also use the generic List class which also supports inserting elements into the middle of the list. ...Show All
Visual C++ /QIfist deprecated, but bad fp conversion still sometimes generated?
I've noticed that specifying the /QIfist switch to the compiler in 2005 raises a deprecation warning; according to the documentation this is because the compiler now generates the correct code under all circumstances without it. With the /fp:fast option set, most of the time this seems to result in a call to _ftol2_sse. However I have noticed that in some cases, specifically the assignment of a float onto an unsigned int (such as the one detailed below), the compiler still generates the terrible fnstcw..fldcw..fistp...fldcw instruction stream, which is a serious performance hit for us. At first I thought this was because of the unsigned nature of the output, but upon examination the fldcw is simply setting the rounding mode of the FPU t ...Show All
SQL Server how to combine text data rows into single row?
H i !!!! Need some quick help on SQL.....DTS packages. I’ve loaded data from text files into a table which is in the following format..... Seq_No Row_No Data 1 1 ABC 2 2 DEF 3 3 GHI 4 4 JKL 5 1 MNO 6 2 PQR 7 3 STU 8 4 VWX Every four lines correspond to one single logical record. So, all the data in every 4 rows have to be combined into one big string which’ll then be loaded into one col of another temporary table .....stru ...Show All
Visual Studio Team System Email notifications not working
I am not receiving any email notifications. It does however seem to be working for the SOAP notifications. (i.e. I have an event which adds builds to the fixed in build field and it works) the same query does not however work for email notifications. I managed to figure it out. I changed the reporting service SMTP server to the IP Address from the server name and it works now. Must not have been able to resolve properly. ...Show All