Wesley Wong's Q&A profile

• SQL Server Cannot compare data types of System.Int32 and System.String. Please check the data type returned by the filter expression

  I have this filiter on my table in SQL Server Reporting Services 2005: =CInt(Fields!FeeGoal_AZ.Value)    !=      0 I get this error when trying to preview the report: "Cannot compare data types of System.Int32 and System.String.  Please check the data type returned by the filter expression." I am not sure why it's comparing a string here.  The data type for FeeGoal_AZ in the database table is Bigint   I also tried   =Iif(Fields!FeeGoal_AZ.Value = 0,True,False)    !=    True Note: the 0 as filter value is interpreted as string constant. Use =0 inst ...Show All

• .NET Development Web service that calls methods from imported dll doesn't work on IIS but it woks on development environment.

  I have web service that imports "xx.dll" written in c++. This "xx.dll" make a connect to the MapPoint activex and return some data from MapPoint. Everything works fine in development environment, but when I deploy to IIS, then I'm getting "External component has thrown an exception". I did a trace in "xx.dll" and I find out that everything stops on call "MapPointApp->Connect()". I think it could be problem with permissions in IIS, but I don't know what Thanks, Miran You have to check what are the permissions required in order to make a call ...Show All

• Visual C++ Windows Oriented Alternative to system(MS-DOS COMMAND)...

  Hello, I recently migrated from LAZY AutoplayMenuBuilder4.0 AutoRun Menus with MS-DOS Batch Files for functions because they didnt DO enough. I am quickly catching on to Visual Studio 2005 PRO CLR Windows Apps in C++. However, I have a few issues: I need to know how to use a more .NET C++ oriented alternative to system("IF EXIST file command ") and a windows oriented alternative to system("copy file & move file & del file ") Help, Please! flamethrower0 Thanks ...Show All

• Visual FoxPro Need VFP 9.0 Report Help

  Hi I have a report that in the detail band I have the following info: QTY     Part Number      Description              Price           Extended Price   5       2222-009          5500 Watt 220V       $2500.00     $2500.00                       ...Show All

• Visual Studio Tools for Office Outlook and VSTO

  I am working on defining the requirements for a new CRM system.  We want to fully integrate the interface the CRM System with Outlook as much as possible.  We have done some prototyping with the Janus controls which simulate an Outlook interface and we have just begun looking at VSTO for Outlook.  After looking at VSTO for Outlook, I’m not sure what we want to do is technically feasible or not. What we would like to do is create a Visual Studio.Net interface within Outlook…One major folder within Outlook would be “CRM” and would be on the same level as the standard major Outlook folders (Mail, Contacts, Calendar, Tasks, et ...Show All

• Visual Basic Update database

  Hi I am new to .net programming.I generated form automatic,following is the code in update command. It do update dataset but database is not updated.Please help me on this. Private Sub CustomersBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CustomersBindingNavigatorSaveItem.Click Me .Validate() Me .CustomersBindingSource.EndEdit() Me .CustomersTableAdapter.Update( Me .NWINDDataSet.Customers) Me .NWINDDataSet.AcceptChanges() End Sub ZaAbdullah Hi, First, you shouldn't need to call AcceptChanges on your Da ...Show All

• Windows Forms Problem with value DataGridViewComboBoxCell

  In VB 2005 Express I have a problem, which completely do not understand. I use a DataGridViewComboBox in a DataGridView. When I change data and save it, I have no problem. But when I close the form I a repeting error, being: System.ArgumentException: DataGridViewComboBoxCell value is not valid. Can anybody help Thanks in advance, Simon Use the following link: http://lab.msdn.microsoft.com/productfeedback/Default.aspx   -mark DataGridView Program Manager Microsoft This post is provided "as-is"   ...Show All

• Windows Forms using treeview to display disk drives

  I'm using vs 2005, how can I use a treeview to display diskdrives For example on my computer I have a partitioned hard drive with a C and X drives, and I want the treeview to display with the C, D, and X drives as the root nodes. Can anyone tell me how to do this Thanks, smtraber You'll have to iterate over the logical drives creating treeview nodes. Use the static Environment.GetLogicalDrives method to return the drives of your computer. ...Show All

• Visual Studio Team System How can I run a perfomance test capturing the time taken to an open a document from the application

  Our web application enables the opening of a PDF file in an inline frame. Is it possible to measure the performance of when the document open request is made and when it is completed. Running a number of tests always returns the same results which I assume is just the start of the request as the time does not vary in anyway even though it can take a long time for the PDF to open. Response time will be the amount of time it took to download the PDF file. If you're talking about measuring the length of time Acrobat process the PDF, that isn't possible since web tests work at the HTTP level and don't actually open any files in applications ...Show All

• .NET Development How to execute queries on a DataSet

  Is there a way to execute queries on a Dataset Thanks in advance for your answers Dim MyDataRows () As DataRow = MyDataset . Tables (0).Select( MySQLStatement ) ...Show All

• Visual Basic how to determine upload finish

  hi all with this code:    Threading.Thread.Sleep(10000) 'riposo di 10 secondi tra un upload e l'altro    My.Computer.Network.UploadFile(file1, indirizzo1, user1, pass1) i use this (up) to upload my files,but i have insered sleep() ,because i can't know hot to determine when upload are finisced, for upload next file if i remove a function sleep(), and upload are running,return an error, becaus is an esecution how to determine upload finish thanks p.s. please send here,code example,i'm a newbie :) Try checking the byte array that the UpLoadFile method returns, it should contain a response from the server that you up ...Show All

• Visual Basic Static function bug?

  Lets say you create a static function under namespace A and inside class B (in C++/CLI as a part of a managed wrapper). Then I call this static function: Imports A ... Dim d1 As New MY_DATE() d1.nYear = 2010 d1.nMonth = 5 d1.nDay = 23 Dim strDate As String B.DateToString(d1, strDate) Doing so gives a warning: warning BC42025: Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated. This is weird because I am not using an instance but the class itself. However if I write it out with namespace the warning goes away: A.B.DateToString(d1, strDate) ...Show All

• Smart Device Development Using Notification: HTML Image?

  Hi all, I'm using a Notification. When I show it, I would like to display an Image as part of it's HTML content. The application is running in "disconnected mode", and I would like to pull the source image from the file system. 1) Is this possible If so, in the code: HTMLString.Append("<img src='{ }myImage.jpg' width='75' height='75'>"); 2) How do I reference { } from the file system 3) Is there a better way Thanks in advance, Eric I think now i got the problem Actually I dont know what notification HTML uses like is it a temp HTML window or A parser in ...Show All

• Visual Studio Tools for Office C# with Excel - are ranges with letters no longer usable, like "A3"

  So can "A3" only be referred to as Cells[3, 1] In VB6 it was      .ActiveSheet.Range("A3").CopyFromRecordset but now it would be Excel.Range range1 = (Excel.Range)sheet1.Cells[3,1]; range1.CopyFromRecordset(object data,object maxrows,object maxcolumns) or is there some way to still use the "A3" range Hi, if I get a Microsoft.Office. Interop .Worksheet from ActiveSheet I have no Controls collection as in Microsoft.Office. Tools .Excel (Office2007). How do I get to a Microsoft.Office.Tools.Excel.Worksheet object of the active sheet Thanks, Thomas ...Show All

• .NET Development Load and Save XML Page

  I have an access program that needs to download and load XML data from a site. The access program then imports this XML.  The code i'm using is below. It is having two problems (and i've tryed a few other syntaxes to save the file...). 1) The Save File dialog box is opening up, even tho i do pass in a path (and i've tried with both one \ and with \) and use FALSE for the second argument... 2) Even when i type the filename manually in the dialog box, it only gives options to save as HTML, not as XML. The file is only understood if it is XML. Note that if i manually use file-save as in the IE window that access has opened in the code abov ...Show All