Colm Smyth's Q&A profile

• Visual Studio Tools for Office passing a worksheet in excel with VB.NET

  Hi I need to be able to pass a worksheet in a workbook into different functions. It will all live one workbook. There will be no other work book. I am also trying to loop though the column heading from a SQL dataset using the offset method from the range class. I have passed the workbook and the worksheet. Dim rng As Excel.Range = CType (activeSheet.Cells(1, 1), Excel.Range) With objBook Dim columnName1 As St ...Show All

• Visual Studio Two Help Collections provide duplicate content

  I've got SQL Server 2005, MSDN 2005 and VS.NET 2005 installed on the same machine. Therefore, I've got the SQL Books Online in two places - in MS.VSIPCC.v80 and MS.MSDN.v80. The symptom is similar to that seen when installing VS.NET 2003 and MSDN - you would typically de-select one of the collections from inside the viewer launched from VS.NET. What's the process now Thanks! Hello rbellamy, When y ...Show All

• Visual Basic Can it show that?

  Hello, can i find out, if the Internet Explorer can show a File from the file extension For example: My String Path="C:\Documents\my.exe" This file cannot be shown in Internet Explorer. Now i want, that the String Accept="No" The answer to the core quesion is "no". Here is a quote from a MS Security Bulletin : "No. Internet Explorer does not determine file ...Show All

• Visual C# How to overwrite an existing Bitmap file

  using ( Bitmap bitmap = new Bitmap (( int )(scale * page.Width), ( int )(scale * page.Height))) { Graphics graphics = Graphics .FromImage(bitmap); graphics.SmoothingMode = SmoothingMode .AntiAlias; graphics.ScaleTransform(scale, scale); graphics.Clear( Color .White); page.Draw(graphics); bitmap.Save( "C:\\Image.tiff" , ImageFormat .Tiff); } As you can see in the code above, I am generatin ...Show All

• Visual Studio Express Editions ItemTemplate Problem

  I'm making ItemTemplates for me to save time when building applications and I came across some problems... I can see the itemtemplate I created in the New Project Item dialogue box, but when I click it it gives me an error. The error occurs every time and has something to do with the <language></language> and <ProjectItem></ProjectItem>tags in my AboutBox.vstemplate file. Edit: I have tried rewriting the code to no avail ...Show All

• Software Development for Windows Vista recommend way to do IPC between app and service

  Hi guys, until now I've used (unnamed) Pipes to communicate between apps and services. For that to work I used OpenProcess(serviceProcessHandle, PROCESS_DUP_HANDLE), so that I can duplicate the pipe handle from the service to the app. This still works in Vista with UAP turned off - even from a guest account. But as soon as I turn UAP on, OpenProcess fails with "access denied" - even in elevated mode. I guess that's intended So since ...Show All

• Windows Forms Automating Office from a Webserver

  I'm using ASP.NET Webforms to create an application that processes user supplied Excel spreadsheets against a mainframe database. My current application allows users to upload an excel spreadsheet, specify some lookup options, and then process a routine against the&nbs ...Show All

• Visual C++ How do I? Complete Newby.

  I've got following problem. I'm working with Visual Studio .NET and I need to populate my typed DataSet object with some data. It's a table, which is stored in a simple text file. But the number of columns is not defined (can vary from 5-10), so I have to create a new DataColumn object dynamically, as I read the column from the file stream. I have no idea, how to do this. I'm really sorry, if I'm wrong here. It seems, that this foru ...Show All

• Visual Studio Connect to SAP BW Query

  Hi all, I was wondering if it was possible to connect to a BW SAP query with Crystal Reports engine that gets shipped with Visual Studio 2005.  If not what steps would I have to take in order to get this functionality in my VS 2005.  I have tried to connect but I get an error saying the crdb_bwquery.dll could not be loaded. Cheers Hello, Crystal Reports for Visual Studio 2005 does not have support for ...Show All

• Visual Studio Express Editions How to get the returned dataset from storeprocedure

  VB 2005 Code cmdFind.CommandType = CommandType.StoredProcedure cmdFind.Connection = cnAlfol cmdFind.CommandText = "POS_ItemFindDetailByItemID" 'define parameters cmdFind.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.BigInt, 50, "@ItemID")) 'define parameters cmdFind.Parameters("@ItemID").Value = CType(value, Integer) cnAlfol.Open() XXXXXXX < ------ ...Show All

• Windows Forms How can I update the databinding programatically

  I have a DataGrid that is updated from XML file. This XML has user, password list. This list is shown in the datagrid. It is set like this. this->LoginGrid->SetDataBinding(scripts->LoginList, "dbrow"); During the current session, logged users can create or modify the XML (the XML file is updated and closed properly). At this time, I set the binging again like this to show the updated XML data. this->LoginGrid->SetDataBin ...Show All

• .NET Development Generic List(Of T) Unexpected Results

  I'm having some unexpected results when using generics.   Here's some sample code with results below:  When I change an item in the filtered generic list is changes the original generic list as well.  Any help understanding why the two generic lists aren't isolated from each would be appreciated.  Thanks. Private Class item Private _address As String Private _name As String Public Sub New ...Show All

• Visual C# Reset LAN user's Password

  Hi, How can I reset a password in the active directory using C# Many Thanks, Jassim Rahma Did you try your options in the "System.DirectoryServices" for managing directory entries If not, I will suggest to investigate those. The MSDN library does have quite a great deal of samples for you on how to use the classes in this namespace. ...Show All

• Visual Studio Team System Proxy setting non-binding for localhost

  Using declarative webtest, proxy setting is being ignored when making localhost connections. In the webtest, you can specify the proxy host&port in the webtest properties, or if your IE proxy setting is set before it is launched, it is automatically populated in the webtest. Requests do seem to be passed through proxies - except when making calls to the localhost. It looks like the proxy setting is ignored by Visual Studio when mak ...Show All

• Visual Studio Generate documentation under .Net 2.0?

  I really need to generate some documentation under .Net 2.0. I know that this issue has been raised in a previous post few month ago, but no explicit solution has been provided. Also the NDoc project seems dead (as suggest the broken wiki). Does anyone has a practical (even minimal) solution to generate documentation for .Net 2.0 Thanks in advance, Joannes Hi Joannes, There is an option to create an XML file ...Show All