Jamador's Q&A profile

• Windows Forms Deployment options

  I have not been able to try out Whidbey's ClickOnce deployment yet, but reading through the documentation I could find, I still have a few questions.  These questions come from what we had to do to get the Updater Application Block to work for our situation. In some corporate environments, there are ten-thousand desktops using a server or mainframe for  ...Show All

• Visual C++ LNK2028 when using /clr:oldSyntax in VS2005

  It appears that the error relates to using /clr:pure, but I am not.  The class it is complaining about is in the unmanaged library, and that library is specified in the link options.  It was migrated to and built by VC++ 2005 from the 2003 version. I don't understand the extern "C" part of the error msg because there is nothing in this class that references any C code - it is all C++.  There is a C code module in the library, but not related to the class CErrorWindow. This is a Web Service project that compiles and works under VS2003. The instance of CErrorWindow that is referenced in the code is a global instance that is crea ...Show All

• SQL Server Problem with nested INSERT EXEC

  Hi All, I am having a problem with nested insert exec. Say for example I have three stored procedure procA, procB and procC. I am executing procedure procC in procB; I am storing the values returned by procC in a tempTable. The code is INSERT INTO #Temp EXEC procC And in procA, I am executing procB, and the values returned by procB are stored in another temp table. The code is INSERT INTO #TempOne EXEC procC When I execute the procA, I am getting error as An INSERT EXEC statement cannot be nested. My requirement is like this, please give me a solution. ...Show All

• .NET Development Importing Encrypted Web Data to Local Database

  This is completely outside anything I've ever worked with, so please excuse me if this isn't the right forum for this question: Our company uses an encrypt/decrypt component on its website that functions perfectly provided you only use it AT the website. I've been asked to link an Access 2000 backend to the web data, so I need to be able to decrypt the encrypted strings in-house and haven't the first idea of how to accomplish it. The component is called DyncuEncrypt ( www.dynu.com ) and they offer this code on their site: Set oEncryptor = Createobject("Dynu.Encrypt") Dim sEncrypted, sDecrypted As String REM Encrypt t ...Show All

• .NET Development What should be done first? Class or E/R?

  Does there exist a converter from e/r to class diagrams If not I have a question in how to make classes. Suppose I havea Person table and a Role table, the person may have many Roles, so I have an intermediate table that relates rows from both tables right I am customed to make E/R diagrams and not classes, How would I make those 3 tables on a class diagrams Thanks Creating ER stuff, also as XSD, gives u general view of the system, like interface, w/out concentration on the realization. Besides, there are a lot of instruments that generate code from ER for u. Now about DAL. I reckon u need 2 DALC - one for person and other for person ...Show All

• SQL Server Script Component task, values such as "000-00-00" to smalldatetime field

  From a text file I'm importing date values by a variable. dFecha = Left(Row.Column21, 4) & "/" & Mid(Row.Column21, 5, 2) & "/" & Right(Row.Column21, 2) After that I've got values as "0000-00-00" and obviously sql (at target smalldatetime) doesn't support them. How do I for to solve If IsDate(dFecha) Then .Parameters( "@FecEnajenacion" ).Value = dFecha Else .Parameters( "@FecEnajenacion" ).Value = vbNull End If TIA You should be able to do this in a Derived Column component. Just check for it being valid in there rather than a ...Show All

• Windows Forms Suggestions on what to do?

  Hello everyone, My disk space has been getting low recently and so I decided to write a program to list files/folders above 300 megs in a listbox. Unfortunately, I have no idea what kind of controls I'd want to use in C# and I don't want to use VB as I'm trying to learn C#, so this should be a good project. Any ideas There was a very slight difference occasionally with the MSIL created by vb.net and c# in 1.0/1.1 (see here  for an example). THis was so small, as to be imperceptible. Both compilers were altered in 2.0, and the MSIL they create is now even closer. Cathal ...Show All

• Visual Basic VB Futures, VB 2005 Essential Content, Other Content From PDC '05

  Hi Forum Readers - I just wanted to give you a heads up about some of the pretty exciting announcements and content coming out of PDC '05 this week, so you can share in the fun.  I discuss the overall activities and Essential Content available from PDC here: http://blogs.msdn.com/pauly/archive/2005/09/12/464207.aspx I discuss the announcements of LINQ and next generation Visual Basic features here: http://blogs.msdn.com/pauly/archive/2005/09/13/464965.aspx   Best, Paul Yuknewicz Visual Basic Not sure i like the idea of VB infering data types for me. Spose it ones of those things you gotta get use ...Show All

• Visual Studio Tools for Office Best way to do this?

  Hello, Hopefully someone would have some advice, I'd like to trigger an action inside outlook from outside outlook. I.e. pop-up a new contact window for the user to access. Should I approach this from a mapi standpoint or use IPC with a VSTO add-in inside of Outlook... I'm not sure what the "most correct" way to go about this is. Thanks! Well, I'm far from being an expert, but in my opinion an Outlook add-in is meant to create functionality from within the application... since what you need is to trigger an action from outside Outlook, I would rather simply use the Outlook Object Model from a diff ...Show All

• Visual Basic Moving a picture

  could someone help me with this all i want to do is you click the picture, move it, let go of click and it stays there Public Class Form1     Dim MDown As Boolean     Dim Formloc As Point     Dim pbLoc As Point     Dim CaptionHeight As Integer = System.Windows.Forms.SystemInformation.CaptionHeight     Private Sub cbExit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cbExit.Click         End     End Sub     Private Sub pb1_MouseDown(ByVal sender As Object, ByVal e As ...Show All

• SQL Server SQL Express Manager: Error occurred during application start up sequence

  TITLE: SQL Express Manager ------------------------------ Error occurred during application start up sequence. Application will be shut down. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.ExpressManager.SRMainError&EvtID=ErrorDuringApplicationStartup&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: Method not found: 'Void System.Windows.Forms.MenuStrip.set_Raft(System.Windows.Forms.RaftingSides)'. (XMApp) Program Location:    at Microsoft.SqlServer.ExpressManager.XmApplicationModule.CreateMainMenu()    ...Show All

• SQL Server SELECT INTO OUTFILE?

  Hi, how do I redirect the output from a SELECT to a text-file, or Excel-file It is possible in MySQL, but what about Transact-SQL Thanks YOu have to use the OPENDATASOURCE method or a linked server to insert data in another destination than the local SQL Server. More information (including a sample can be found in the BOL) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Architecture Why custom business object's while i can't update my database with them ?

  Hi, i have this big problem in my architecture : i want to build my object model by using the idea of collections, so i have a Customers object, a Customer object, an Orders object, and an Order object, and so on... the Problem is that those custom business objects, hold my data, and of corse, i want to update my database by using the data in those object's, and oop's, the DataAdapter don't accept custome business objects as a parameter !! (only dataset are allowed). I know that a dataset is also a collection of tables, and i could write my business objects as a dataset's and tables inside them, but with this method, i am obliged to ac ...Show All

• Visual Studio Team System TFS on same server as Project Server?

  We have a dedicated server that has Project Server 2003 running on it. It has extra capacity so we would like to install TFS on it if possible. In reading the installation instructions for it, there are a couple of concerns I have as to whether this is possible. SQL Server - Project Server is not using the default SQL instance. It seems like TFS expects to use the default instance. In this case, they do not seem to conflict. Is this correct WSS - WSS is running on this box for Project Server. It uses a db called STS_boxname_1 that is not on the default SQL Server instance. The install instructions for TFS (WSS portion) ask not to pr ...Show All

• Visual C# Casting to nullable generics

  Hi. I have this method: public static TVal DoIT<TVal>( object value) { return (TVal) Convert .ChangeType(value, typeof (TVal)); } But it fails in case of DoIt< DateTime >( DateTime .Now) . (Invalid cast from 'System.DateTime' to 'System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.) How can I make it working I was trying to catch that case myself (happy with typeof (TVal).IsNullable ), but I'm not able to create required nullable type because no constructor I found takes a System. Type (which I can get using Nullable .GetUnderlyingType ...Show All