danskcarvalho's Q&A profile

• SQL Server How to ZAP a table?

  Is there a way to zap a table. If not could you name a sys.sp_.... that could do it Thanks Thank you. I've already created a stored procedure to do it. Do I have to open a connection to the database with an sql statement specifying the table I need to truncate from C# code or not ...Show All

• Visual Basic COM Exceptions bypassing exception handler

  Hi, I have some interop issues with a flakey, third-party, COM dll that causing me tons of grief. I’ve wrapped its primary functions in managed calls with built-in exception handling and retries like this: Do Try 'Do risky work here. blnSuccess = True Catch ex As System.Runtime.InteropServices.COMException intTries += 1 If intTries > 10 Then Throw New System.InvalidOperationException("Failed 10 times to... ", ex) 'Wait and try again System.Threading.Thread.Sleep(miRETRY_DELAY) End Try Loop Until blnSuccess However, occassionally, the exception seems to bypass the COMException handler and propagate up unhandled. It’s still a COMException and I can tell from the stack trace where it’s co ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I rotate the camera around a specific point (eg. the player)?

  Sorry, I'm full of questions tonight! :) I've been playing rotating my camera around stuff, like this: // Rotate camera float rotation = GamePad.GetState(PlayerIndex.One).ThumbSticks.Left.X / 50; if (rotation != 0) { GamePad.SetVibration(PlayerIndex.One, rotation, -rotation); angle += rotation; } else { GamePad.SetVibration(PlayerIndex.One, 0, 0); } Vector3 camera = Vector3.Transform(new Vector3(2, 2, 2), Matrix.CreateRotationY(angle)); effect.View = Matrix.CreateLookAt(camera, new Vector3(0, 0, 0), Vector3.Up); But the rotation is always around the axis. I'm not trying to make the thumbsticks work like Halo controls - one to move the camera along the X and Z axis, and the other to rotate the camera around the playe ...Show All

• Visual C# How to transfer color images to grey images using C#

  Hi, I am trying to use C# 2.0 and visual studio 2005 to compile a window app or web app. In this app, I have to transfer almost 2,000 colorful images to grey images. I do not know how to do that Anyone can provide a block of simple example for that Thanks a lot. Hi, FugersonHall Use colorMatrix to gray the image can be the efficient way. Hope it helps. Thanks ...Show All

• Visual Studio Express Editions copy forms between versions of Visual Express

  Summary: Can we copy forms between versions of Visual Express If someone has a real nice set of forms in Visual Basic Express and I want to use the same basic forms in C#, and I don't want to manually enter all the buttons and boxes and labels and positions, etc, is there a way to import the form into C#. I don't expect to get to be able to use the code, but getting the buttons would be nice. I strongly suspect that the core engines that drive all the Visual Express products are the same, only the syntax and grammar rules differ for the languages. If so, the conversion should be simple. That seems to work. I opened up the for design window in C#, selected all with ctl-A, then pasted into a form design window in Basic and it co ...Show All

• Visual C++ Getting started with C++/CLI

  Hi! I think the thread's subject is quite significant. I'm able to write native c++ code and now I want to start with C++/CLI. Do you have ideas where to start Do you know good tutorials (perhaps in German) I'm open for every suggestion which helps getting started with C++/CLI. Thank you I wrote an article for MSDN a few years ago introducing C++/CLI. It was written before the new compiler was available in beta but most of it is still relevant and helpful when moving to C++/CLI. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/vs05cplus.asp My friend Nish also recently wrote a book on the topic: http://www.amazon.com/C++-CLI-Action-Nishant-Sivakumar/dp/1932394818 Cheers, Kenny Kerr ...Show All

• Visual C# Hiding a virtual function (if it can be done)

  Say you have a class with a public virtual funciton: public class A { public virtual void F() {...} } Now it happens that I have a subclass that I do not want F() to be exported. Using the C++ 'mode' of accomplishing it , i tried public class B: A { private override void F() {} } Compiler says: BAD. virtual function cannot be private. Next, try public class B: A { protected override void F() {} }; Also bad. Access modifier of a virtual function can't be altered. Next, try public class B: A { private new void F() {} }; Well, the compiler does not complain. But when F is called: B b = new B(); b.F(); // A's F() get called!!! My Questions are 1. Is there no way to hide a base class' public virtual function 2. If so, what is the rationale, ...Show All

• SQL Server Visibility Expression not working?

  I have the following Visibility expression set on a SQL 2000 RS report set on the hidden value: =iif(Parameters!state.Value= "Institutional Agency",true, false) Problem is that when I choose Insititutional Agency from the drop down list it evaluates the expression and shows the textbox, when another state is choosen it still shows the textbox and I dont want it to I have ran a test to show the expression ( Parameters!state.Value ) in a text box, and its showing the right values each time i run the report Still no luck, here is the report, the textbox is textbox12, and the footnote is footnotetext, its not a true footer, just what I called it. < xml version="1.0" encoding="utf-8" > <Re ...Show All

• SQL Server Application Role And SSRS

  Hi dear reader I made an application that uses a Sql Server 2005 Express DataBase. In the database I made a application role. When the user logs into my application I run this procedure: If Not sqlConnectionCR Is Nothing Then If Not sqlConnectionCR.State = ConnectionState.Open Then sqlConnectionCR.Open() SqlConnection.ClearAllPools() ConsultasSqlCommand = New SqlCommand ConsultasSqlCommand.CommandType = CommandType.Text ConsultasSqlCommand.CommandText = "sp_setapprole 'appRole', 'drowssap" ConsultasSqlCommand.Connection = sqlConnectionCR ConsultasSqlCommand.ExecuteNonQuery() End If Else.... I understand that this procedure connects to my sqlserver database as ...Show All

• SQL Server Strict Transaction Nesting Bug with CLR

  Dear all, I am constantly running into this error when calling CLR functions from triggers (even when the triggers are CLR functions themselves): The context transaction which was active before entering user defined routine, trigger or aggregate "[name of CLR sp]" has been ended inside of it, which is not allowed. Change application logic to enforce strict transaction nesting. However, there is no cyclic nesting going on here. In fact, the error only appears when the CLR function is writing to the database. Only executing SELECT statements inside the statements doesn't freak out the SQL server (2005 SP1 in my case). I am not ending any transaction at all. This error shows up in many places: as exceptions from ASP.NET web pages, ...Show All

• .NET Development Can't figure out this error message

  Good Day all, I seem to have hit a dead end. I am "attempting" to write a web application to retrieve, insert and update information in a SQL2000 database. I can retrieve information just fine but when I try to update it I keep getting the following message: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'UDPATE'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataS ...Show All

• SQL Server why job can't start automatically

  hello,everyone,i meet a problem that the job can't start automatically while i set the schedule,the job can start manual,so i don't know why somebody can help me,thank you Hello, A few questions: 1. What version of MSSQL are you running 2. What is the error you receive in the job run history 3. If you receive no errors in task history, are you sure you've created and enabled a valid job schedule Cheers, Rob ...Show All

• Visual Studio Team System Cannot install TFS (DEU) on a Windows 2003 Server (ENU) with SQL Server 2005 (ENU)

  Hello, i try to install the TFS (DEU) on a Windows 2003 Server (ENU) with SQL Server 2005 (ENU). While setup is installing the components i get the following error EventType : visualstudio8setup     P1 : 12840     P2 : 8.0.50727.147._vstf_x86_cd     P3 : msi     P4 : inst     P5 : f     P6 : - P7 : -     P8 : 1603     P9 : -     P10 : -   thanks and regards j3ns3n i checked how the installation process is done: it's started from the setup.exe and the standard installation has been done, the onl ...Show All

• Visual Studio Team System Team Build and Test Config Deployment Item Issue

  When we add a deployment folder to a test config the items will deploy without any issue locally. However, when we use the same test run config in a team build the build fails to deploy the items correctly and the build fails to run the tests. To reproduce this create a solution with a test project and a DB project. Add some files to the Create Scripts folder in the DB project. Add a unit test to the test project that passes. Under Solution Items right click on the test run config and choose properties. Add the Create Scripts folder from the DB project to the deployment items (Note: add the folder not the individual items). Run the unit test to see if it passes and check the output folder for the test result to see that the fil ...Show All

• Visual Studio Tools for Office VSTA and Generics

  Just started using Visual Studio Tools for Applications. I have a working model, however, I am having some difficulties with generics. I noticed that the docs indicated that ProxyGen does not support generics. When I look at the proxy file generated for a model using generics it seems to make sense. The GetProperty("Elements"..., fails with "Element not in Dictionary Exception" I guess my more general Question can I use Generics in my model and and expose generic types, methods, etc to the AddIn If I can then how is that done Thanks. public global ::System.Collections.Generic. Dictionary <System. Guid , Vitech.Core.Domain. Element > Elements { get { object [] _param = n ...Show All