toront's Q&A profile

• Microsoft ISV Community Center Forums Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add(Connection:=connstring, Destination:=Range("B1"), Sql:=sqlstring) .Refresh End With 'Part B: Format the cells i = 1 Do While ActiveSheet.Cells(1 + i, 2) <> "" vals ...Show All

• SQL Server Meta Data Management / Dependancy Analysis

  BI perspective, meta data management is quite crucial. In SQL 2000, as far as I know we didn't have a great support for meta data. Has that changed in SQL2005 What about dependancy analysis For example if I drop a column from a SSIS data flow what would be affected Is it possible Thanks Jamie As you say someone will come up with something soon. It is going to be a valuable tool. Clients enquire this type feature when we try to sell MS DW solution to them. Maybe Darren and Allan can come up with something hint hint :-) Thanks Sutha PS - Jamie, I haven't done that mail yet ...Show All

• Smart Device Development Errors during installation of some cabs ?

  When I tried to install SPB_PocketPlus3_en.arm.cab to emulator of WM 5 I got an error " SPB_PocketPlus3_en.arm.cab cannot be opened. Either it is not signed with a trusted certificate, or one of its components cannot found. Yiu might need to reinstall or restore this file". The same error I got with resco explorer cab. What is wrong   alekz wrote: I don't have any actual device ;-). I am current PALM User and going to buy WM5 Pocket. Now I am investigating what applications I need using emulator. I made some more actions with emulator. I managed to install MagicButton 2.0 to WM5 Po ...Show All

• Visual C# How to open a window

  Hi, I have made a button and by clicking on it a new window opens. The code in the button is  Form myForm = new Form(); myForm .Show(); This works fine, but how do I actually work on myForm visually Or how do I make myForm one of the files of my project I'm using Visual C# 2005 which includes .net. Thanks, Behrouz   BruceB wrote: The code in the button is  Form myForm = new myForm(); Try:   My Form myForm = new M yForm(); ...Show All

• Visual C# VS 8 Performance makes it unuseable

  Hi, We have converted a large c# solution with 12 projects and about 60 Mb of code from VS7 to VS8 and find that working in the IDE is impossibly slow. We are running on a P4 3.2 Ghz 1 Mb RAM with Windows XP SP2 (clean install). It seems slow in all areas of development. The only area where perfomance is as good or better is in running the release code. So far it's a major backwards step when compared to VS 7. Is anyone else experiencing this or does anyone have any advice on how to make developing large projects in the IDE at least as efficient as it was in VS 7 Regards Steve Crabb Hi, Yes, this ...Show All

• Windows Forms How to get icons of applications and system ?

  Dear all, Currently, I had create listview which sames window explorer. However, I have a issue to get icons of applications or system associate with items in listview. I think somebody had same my issue. If you had solved it please share it for me. Thanks for your help. Steven. See How to use the SHGetFileInfo function to get the icons that are associated with files in Visual C# .NET http://support.microsoft.com/ kbid=319350 ...Show All

• Windows Live Developer Forums Traffic Overlay

  I would like to use the traffic overlay in an app I'm building. Does anyone know if there is any way to use this or would I have to recreate this using some sort of traffic data Thanks, :// 13one ...Show All

• Visual Basic Display Files From Directory Faster

  I am using a listView control to display files from a directory on the hard drive. For each file in the list, I need to display the CreationDate the FileName and the FilePath and also the appropriate icon for the filetype. This is the approach I have used so far: Me .lstNewFaxes.BeginUpdate() For Each fiFile As FileInfo In My .Computer.FileSystem.GetDirectoryInfo( My .Paths.NewFaxes).GetFiles      Dim imageIndex As Integer = 0      Dim lstItem As ListViewItem      Dim lstSubItem As ListViewItem.ListViewSubItem      If fiFi ...Show All

• .NET Development strongly typed dataset

  Hi, The following line populates a datagrid using a strongly typed dataset. dsEmps is the .xsd file in the foreach line I would like to loop through each record I get an error on the foreach line and it says: specified cast is not valid I think this line has to be somehow casted employeeDetailsData.Employees.Rows EmpBusRule.EmpService.dsEmps employeeDetailsData; EmpBusRule.Employees br = new EmpBusRule.Employees(); employeeDetailsData = br.GetDataEmployee(); if (employeeDetailsData.Employees.Rows.Count < 1) { throw new Exception("No record found."); } grdEmps.DataSource = employeeDetailsData.Employees; forea ...Show All

• Windows Forms DateTimePicker Control question

    I have a form that has a DateTimePicker control on it. This control is databound and the data is stored to an sql database table. The user can select a date and this date is saved to the database. When the form is reopened the correct date is displayed in the control. SO everything seems to work fine. However if I put a line of code in such as below: MsgBox(StartDateDateTimePicker.Value) I get todays date displayed not the date that is displayed in the control. and if I put MsgBox(StartDateDateTimePicker.text)  "" nothing is displayed. Again even though the date I want is displayed in the dtp control. & ...Show All

• Visual Basic immed?

  In vb 6 I could use the immedaite window to do something like form3.DataGridView1.Width to see the width of a column... then form3.DataGridView1.Width = 800 to set it and see if it looks right.. then I'd write a procedure to set up data grid appearance. How do I do that in vb.net Getting furstrated... Brian ok.. when I do that I get "unable to evaluate the expression" when I do form3.datagridview1.columns(0).width I get "unable to evaluate the expression. This is from both the immediate window and the Watch window. ...Show All

• Visual C++ problem passigng variables from c# to mined C++

  hey guys, im having quite a small problem yet i dont know the solution to. i have a c# application, and a managed c++ dll. in the c++ dll i have a native implementation of a funtion, and in the managed c++ i wrap that native implementation with another class. and i pass form c# to managed c++ class 2 objects with abunch of variables in each. that managed c++ class intrun passes these values to the native class, calculates something, assigns the result back in variables. and as soon i get mack to my managed c++ class, from the native class, these values disaplear, and im back with my old values. that will result in old values in c#. here ...Show All

• SQL Server Problems installing SQL Server 2005 Mobile on device

  I have a Fujitsu-Siemens LOOX 520 running WM 5 version 5.1.70 on which I am trying to create a Server 2005 Mobile database. I have installed the following files on the Pocket PC after a hard reset to make sure the unit was in its vanilla state: NETCFv2.wm.armv4i.cab sqlce30.dev.ENU.ppc.wce5.armv4i.CAB sqlce30.ppc.wce5.armv4i.CAB sqlce30.repl.ppc.wce5.armv4i.CAB All the files appeared to succesfully install. Connecting to the device in VS2005 works with no problems. Creating a small test app in VB.NET and running it on the device works no problems, so the device is satisfactorily connected to VS2005. My problem is this: ...Show All

• Visual C++ Cannot find Bitmap::GetHistogram

  Hi all, I have a problem using the VC++2005. I'm trying to recover the histogram of a picture using GDI+, it seems that the GetHistogram method does not exist. Any ideas I have tried to find this method in the gdiplusbitmap.h and I cannot find it either. System: Both VS2003.NET and VS2005 installed. The docs for this method say GDI++ 1.1 version. I didn't even knew that there is another GDI++ version than 1.0. Also the docs I saw have a note at the top: "Note: This documentation is preliminary and is subject to change." so I assume that this version of GDI++ si currently ...Show All

• Windows Forms IssueVision for VS2005/.NET 2.0

  IssueVision is an outstanding reference application for WinForms and offline access. I was wondering if anyone had gotten this working for Whidbey and would post that code Hi Sam. You can find the Visual Studio 2005 Beta 2 version of IssueVision right here: http://www.sayedhashimi.com/PermaLink.aspx/24b174da-4011-43a5-b35b-8dcc42cf5627 ...Show All