corblet's Q&A profile

• Visual Studio Emulate QueryStatus call

  Hi I'm trying to create VQ top-level sensitive menu.I have a ToolWindow which contains tree and depend on selected node in the tree I need to have VS spetical menu. There for I need to call QueryStatus function myself when occurs tree node selection. Is there the way to call this function The other way is intended for VS 2005 add-ins: you cast the DTE.Commands property to EnvDTE.Commands2 and call the method. You can get the DTE object also from a VS package using GetService(typeof EnvDTE.DTE)). ...Show All

• SQL Server SQl Server CE database connection issue

  Hi, I have created my sql mobile database in c drive ( c:\SQlMobile\sqlmobile.sdf).now when i try to connect it with following code, it gives "The path is not valid. Check the directory for the database" error. i have tried all path options but no one is working.please help me. ( i am using visual studio 2005 and SQl server mobile) code: SqlCeConnection ssceconn = new SqlCeConnection ( "Data Source=c:\\SQlMobile\\sqlmobile.sdf;Password=XYZ11!@#" ); ssceconn.Open(); MessageBox .Show( "Ok" ); ssceconn.Close(); Try giving the database path in quotes. Modify the following line of your code from "Data Source=c:\\SqlMobile\\sqlmobile.sdf;...." to ...Show All

• SQL Server OLE DB Destination Component

  when loading the transformed data into OLE DB destination, there is no options to truncate destination table first. Have to insert a middle step to run script to truncate the destination table first. I'm very confused. We even has the options of keeping or deleting the data in destination table in SQL2000 DTS package. Why we don't have this option in SQL2005 Phil, is there any component in SSIS package that can let us run flexible SQL Script again the input dataset just like the input dataset is a table ...Show All

• SQL Server Config files for .Net code in managed sprocs

  I have been attempting to create a managed stored procedure which calls a web service using WSE 3.0 for security. It appears that the WSE-generated config file (or possibly the app.config file) is not accessible to the .Net code. Is there a method for using config files with CLR managed sprocs Thanks, Max As being on the list of safe assemlies you can use the System.Configuration class for this. As colleague of mine posted a sample sometime ago: http://sqljunkies.com/Article/6CA864E9-E107-408E-B30A-4BA15B0CD11C.scuk HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Windows Networking Development Weird one - Router Death by Vista

  Here's a weird one. It seems that Vista RC2 is routinely killing my ADSL router I have a dual boot system (patched up XP Pro vs Vista RC2). Vista seems to be killing my D-Link DSL-500 like...., several times a day while Vista is running. Has anyone else noticed this I'm thinking.... some sort of weird network plug and play thing (which is disabled - by the way) RickW The symptoms sound similar. I will try disabling IPv6 too. BTW: When I went to reply.... the router had hung and needed to be rebooted . ...Show All

• SQL Server how to convert DT_NTEXT to DT_WSTR in Script Component

  The IC column referenced in the script below is DT_NTEXT, so when I run it the output value column gets "Microsoft.SqlServer.DTS.Pipeline.BlobColumn" instead of the individual codes (separated by "*"). Also, there is only 1 output row per input row, instead of 1 output row per code. I found some references to the GetBobData() method, but replacing Row.IC.ToString() with Row.IC.GetBlobData(0, CInt(Row.IC.Length)).ToString() puts "System.Byte[]" in the value output column. There is still only output row per input row. So how do I convert the IC column to a String that can be Split() Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) Dim seq As Integer = 0 For Each code As String In ...Show All

• Visual Studio Tools for Office How to combine two wordml documents?

  I am looking for a way to combine multiple word documents in xml format WITHOUT using word instance in c#. This web application creates late payment letters for the clients. The application processes the uploaded "late payment letter template" in xml format (with smart-tags & XML schema) to merge client name, address, etc from database into the document without using MS Word instance for the user to download . I cannot use MS Word instance, since MS Word 2003 is not installed on the web server. The problem is, if user selects 50 clients and clicks "generate late payment", user has to download 50 individual files. This is tedious task for them. Thus, user wants to download one file that contains all 5 ...Show All

• SQL Server SQL Server 2000 - SQL Server 2005

  A simply (hopefully!) question. I have a .bak file from a client who backed up there SQL Server 2000 database. Can I "restore" this into our SQL Server 2005 engine so that his database is created from scratch or do I need to first create his database and data schema, then do a restore Thanks, G You can restore a SQL 2000 backup to SQL 2005 using the [WITH MOVE] option. There may be additional issues related to logins, etc. I have included a number of articles that may be of help. Moving Server/Database/Logins http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving system dbs 2005 http://www. ...Show All

• Visual Studio 2008 (Pre-release) FrameworkElement.SizeChanged not fired when Visibility changes

  SizeChanged event is not fired when Visibility changes (from Collapsed to Visible). I believe it must be because in a Collapsed state, the object is simply removed from the rendering of the visual tree, not resized to 0. Hiding and resizing are two separate functions, and the parent of the object will just account for that object not taking up any space. ...Show All

• Visual Studio Express Editions Your &￡%"￡$%"￡ site doesn't accept my email!!! GRRRRRRRRRRRRRRRRR

  Microsoft sites are very very complicated!!! You are driving me crazy!!! The procedure to obtain a key for the software installed DOESN'T WORK GRRRRRRRRRRRRRRRRRR!!!! I insert my email but the web page says that it is invalid. Are you stupid It's not invalid! Also because I just used to register a microsoft passport access. I tried with another justfotspam email and it says email invalid. ***! All this is very.... grrrrr complicated!!!!!!!!!!!! I would like to write in my language to be sure to use the right bad words and insults to describe all I'm thinking of your register procedure!!!!!!!!!!!! You probably need to update your profile first. http://profile.microsoft.com http:/ ...Show All

• Visual Basic How to create a "Hardware Profile"

  I need to create a "Hardware Profile" of the machince running my app.  Specifically i need it to gather info about hardware pieces that aren't commonly upgraded such as the hard drive then combine that into a string and hash it for privacy since i only need it for comparision reasons.  Any help on how to get manufacturers, models numbers, and serial numbers from hardware is appriciated. Thank you.   EDIT: I made a small change to the search term i was using on MSN and may have found what i need WMI, but from what i could read i dodn't undsertand how to get the details I need, anyone know of any code showing implimentation of WMI for simular use as I want EDIT2: ok i did some more digging while waiting for a respo ...Show All

• SQL Server How would you interpret this Error Message

  I am attempting to complete a package that calls four "worker" packages in parallel. The connections are part of the worker packages. When I start the calling package, I get a message: Error at XYZ (the name of one of the packages): The connection is not specified. Which connection Each worker package has three connections. So just to experiment, I delete that Execute Package Task and I get that same message about another package. So why does it not identify which connection is the concern and why did it stop with the first one instead of listing all the connection issues And why is it asking for a connection at all At present, all it does is call the other packages. Still hanging in there... IanO ...Show All

• Windows Forms ClickOnce ISV Mode

  Hi All, I've only been looking at ClickOnce for a very short time and so this question may be way too early. In any case: Is there a way ClickOnce can be used to distribute ShrinkWrapped Software. My question is specifically around building the bootstrap executable. Can we manage all of the following requirements: a) There are some redistributables that need to be set up and cannot just do an XCopy and so must be part of the Prerequisites. b) We dont want each customer hitting the Vendor's download area c) We dont want to host the downloads on our own site d) We only want to bundle all of the prerequisites with our deployment media (cd etc.) e) We want to let the customer choose a suitable distribution mode - CD/Network Share/ ...Show All

• Visual Studio Express Editions Compile as dll?

  MSVC++ used to have an option under templates>Win32 for dll templates. Now it doesn't. I read on a help issue that if this is the case you "compile as a dll". I have no clue how to do that, please help. What version of Visual C++ 2005 are you using The Express Edition does not support developing Windows programs straight out of the box - you first need to download and install the PSDK and then "tweak" some code to enable the appropriate Wizards. This  page explains how to do this. If you are using one of the other versions of Visual C++ 2005 the File -> New -> Project... -> Win32 -> Win32 Project allows the choice of creating a Win32 DLL. ...Show All

• Windows Forms Looping problem in capturing image using webcam

  Hi, I've application to capture video of image and grab the still image. It runs well until I put loop to regrab the still images many times automatically. It gives one exception error: NullReferenceException was unhandled a ” Object reference not set to an instance of an object". I found that, this error come out because of calling file from outside of the main code of the programming. These are the code that calling file from the outside of the main body of code programming. //// apply filter subtract===>>>> call file from out bin folder <<<<===== System.Drawing. Bitmap subtract = filter1.Apply(image2); . . . // =====>>> call file ScanFirs ...Show All