Appunti e HowTos raccolti durante la navigazione

Ultimo Aggiornamento 13 Maggio 2006

 

Access

 

How to add a digital signature to an Access 2003 run-time application

This article describes two methods that you can use to add a digital signature to a Microsoft Office Access 2003 run-time application. You want to add a digital signature to an Access 2003 run-time application so that the end user is not prompted with security warnings when the end user opens the application. The following are the two methods that you can use:

 

• Use the Custom Startup Wizard to add a digital signature

• Add a digital signature manually

 

HOW TO: Create a Microsoft Access Database Using ADOX and Visual Basic .NET

Programmers may have to create databases programmatically, but neither ActiveX Data Objects (ADO) nor ADO.NET provides the means to create Microsoft Access databases. However, you can create Access databases by using the Microsoft Jet OLE DB Provider and Microsoft ADO Ext. 2.7 for DDL and Security (ADOX) with the COM Interop layer.

 

API

 

How to use high-level access control APIs from Visual Basic

The Win32 API provides two sets of APIs for working with security descriptors (SDs) and access control lists (ACLs). Low-level as well as high-level access control API sets provide an interface for working with SDs and ACLs. For Microsoft Windows 2000 and MIcrosoft Windows XP, the high-level access control APIs have been enhanced to support object-specific access control entries (ACEs), directory service (DS) objects, and automatic inheritance. This article provides sample code that uses high-level access control APIs to modify an existing discretionary access control list (DACL) on a folder securable object.

 

Ado.net

 

How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET

The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual C# .NET to read and write binary large object (BLOB) fields.

 

Asp.net

 

How to dynamically page through a large result set in ASP.NET by using SQL Server stored procedures in Visual C# .NET

This step-by-step article describes how to use SQL stored procedures to dynamically page through a large result set in Microsoft ASP.NET

 

How to use an ASP.NET application to query an Indexing Service catalog by using Visual Basic .NET

This step-by-step article describes how to create an Indexing Service catalog. It also describes how to use an ASP.NET Web application to query Indexing Service catalogs.

 

Datagrid

 

BUG: The original data appears in the DataGrid control although you have removed the data from the DataSet object

To make your data appear on a form, you bind a Microsoft Windows Forms DataGrid control to a DataTable object that is included in a DataSet object.
After your data has appeared in the DataGrid control, you use the Tables.Clear method to remove the DataTable object from the Tables collection of the bound DataSet object. However, although the bound DataSet object no longer contains any data, your original data continues to appear in the DataGrid control
.

 

Encryption

 

How to encrypt and decrypt a file by using Visual Basic .NET or Visual Basic 2005

This article describes how to use the cryptography classes that are provided by the Microsoft .NET Framework. You can use the cryptography classes to encrypt a text file to an unreadable state. Then, you can decrypt that text file back to its original format.

 

Gac

 

How to display an assembly in the Add Reference dialog box

When you are developing a class library, you may want Visual Studio .NET to list your library in the Add Reference dialog box on the .NET tab without the user having to browse for it.
This issue is not resolved if you install your assembly to the Global Assembly Cache (GAC), because the Add Reference dialog box is path-based and does not enumerate the components from the GAC
.

 

Icone

 

How to use the SHGetFileInfo function to get the icons that are associated with files in Visual C# .NET

This step-by-step article describes how to use the SHGetFileInfo function to get the icons that are associated with files.

 

How To Retrieve an Icon for a File Class Without a File

This article explains how to use the SHGetFileInfo API to retrieve the icon for a file class without having a specific file of that class available.

 

IIS – Internet Information Services

 

How to repair IIS mapping after you remove and reinstall IIS

After you install the Microsoft .NET Framework Software Development Kit (SDK), Microsoft Visual Studio .NET 2002, Visual Studio .NET 2003, or Visual Studio 2005, Microsoft Internet Information Service (IIS) mappings are created to associate the new file extensions and settings for ASP.NET. If you did not have IIS installed when you ran the SDK or Visual Studio Setup, or if you uninstalled and reinstalled IIS after you ran the SDK or Visual Studio Setup, those settings will not be in place. You experience unexpected behavior when you try to view ASP.NET pages.

 

Internet Explorer

 

HOW TO: Invoke the Find, View Source, and Options Dialog Boxes for the WebBrowser Control from Visual Basic .NET

This article describes how to invoke the Microsoft Internet Explorer Find, Internet Options, and View Source dialog boxes in an application that hosts the WebBrowser control.

 

Office – Excel / Word

 

HOW TO: Handle Events for Excel by Using Visual Basic .NET

This step-by-step article describes how to handle Excel events from an Automation client that is developed with Visual Basic .NET.

 

How to transfer data to an Excel workbook by using Visual Basic .NET

This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual Basic .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best for your situation.

 

How to transfer data to an Excel workbook by using Visual C# 2005 or Visual C# .NET

This step-by-step article describes several methods for transferring data to Microsoft Excel 2002 from a Microsoft Visual C# 2005 or Microsoft Visual C# .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best for your situation.

 

How to transform a DataSet to spreadsheet XML for Excel by using Visual Basic .NET and ASP.NET

This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and cell formatting.

 

Office application does not quit after automation from Visual Studio .NET client

When you automate a Microsoft Office application from Microsoft Visual Basic .NET or Microsoft Visual C# .NET, the Office application does not quit when you call the Quit method.

 

HOW TO: Handle Events for the Office Web Components in Visual Studio .NET

The default class wrappers that are generated by Microsoft Visual Studio .NET do not allow you to handle events for the Office XP Chart, Spreadsheet, and PivotTable Web components. To handle the events for these components, you can modify the source code for these class wrappers, and then recompile. This article describes how to modify and how to regenerate the class wrappers for the Office XP Web Components so that you can manage their events in a Visual Studio .NET application.

 

How to use the AdvancedSearch method to search for an item in Outlook

The Microsoft Outlook Object Model in Microsoft Outlook 2002 provides a programmatic approach that you can use to search Outlook items by using the AdvancedSearch method. This method performs an SQL-like syntax search and has four parameters that permit you to customize the search. The AdvancedSearchComplete event fires because of the AdvancedSearch method, and you can access the results collection in the AdvancedSearchComplete event handler.

 

How to automate Excel by using Visual C# to fill or to obtain data in a range by using arrays

This article demonstrates how to automate Microsoft Excel by using Microsoft Visual C# 2005 or Microsoft Visual C# .NET to fill and retrieve values in a multi-cell range by using arrays.

 

INFO: Develop Microsoft Office solutions with Visual Studio .NET

This article is a resource for developers who work in Microsoft Visual Studio .NET to build solutions using the Microsoft Office family of products. This article supplements the Microsoft Developer Network (MSDN) content for Office Development with Visual Studio 6.0, which covers a much broader scope of development options.
This article provides a rudimentary guide to quickly transition developers who are already familiar with Office development in Visual Studio 6.0 to perform the same tasks using Visual Studio .NET.

 

Considerations for server-side Automation of Office

It provides samples and points out any known problems and issues that you may experience when you work with Microsoft .NET.

Developers can use Automation to Microsoft Office to build custom solutions that utilize the capabilities and features that are built into the Office product. While such programmatic development can be implemented on a client system with relative ease, there are a number of complications that can occur if Automation is to take place from server-side code such as Active Server Pages (ASP), DCOM, or an NT Service.

This article discusses the complications that developers may face, offers alternatives to Automation that can speed performance, and suggests ways to configure Office if server-side Automation is unavoidable. Developers should be aware, however, that the suggestions provided below are for informational purposes only. Microsoft does not recommend or support server-side Automation of Office.

Note In this context, the term "server-side" also applies to code that is running on a Microsoft Windows NT or Microsoft Windows 2000 workstation, provided that it is running from a WinStation other than the interactive station of the user that is logged on. For example, code that is started by Task Scheduler under the SYSTEM account runs in the same environment as "server-side" ASP or DCOM code, and therefore experiences many of the same issues. For more information on WinStations and COM, see the "More Information" and "References" sections.

 

Outlook

 

How to use the Microsoft Outlook Object Library to create an Outlook contact in Visual Basic .NET

This article describes how to use the Microsoft Outlook Object Library to create a contact in Microsoft Visual Basic .NET.

 

Printing

 

How to print the content of a RichTextBox control by using Visual Basic .NET or Visual Basic 2005

This step-by-step article describes how to print the content of a RichTextBox control. The RichTextBox control does not provide a method to print its content. However, you can extend the RichTextBox class to use the EM_FORMATRANGE message. You can then send the content of a RichTextBox to an output device, such as a printer.

 

How to send raw data to a printer by using Visual Basic .NET

This step-by-step article shows you how to use Win32 spooler functions from a program that you create by using Visual Basic .NET.

 

HOWTO: Set Duplex Printing for Word Automation

Microsoft Word for Windows does not provide a method for Automation clients to set the duplex print flag before starting a print job. Although there is a parameter in the PrintOut method that indicates support for duplex printing, the parameter does not provide true duplex printing and may not be available depending on your operating system or installed language. However, developers can work around this limitation on Windows systems by changing the duplex flag for the active printer driver before calling Word's PrintOut function.

This article demonstrates how to use the Windows API to change the duplex setting of the active printer and allow a Word document to be printed in duplex.

 

Registry

 

How to recover from a corrupted registry that prevents Windows XP from starting

This article describes how to recover a Windows XP system that does not start because of corruption in the registry. This procedure does not guarantee full recovery of the system to a previous state; however, you should be able to recover data when you use this procedure.

 

 

Visual studio

 

HOWTO: Getting information specific to VB.NET and C# projects from an add-in or macro

This article describes how to get information not available in the general extensibility model of Visual Studio .NET (EnvDTE namespace) because it is specific to VB.NET and C# projects.

 

How to set up and use remote debugging in Visual Studio .NET or in Visual Studio 2005

This step-by-step article describes how to set up and use remote debugging in Microsoft Visual Studio .NET or in Microsoft Visual Studio 2005.

 

INFO: Code Sample That Demonstrates How to Create a Custom Form Designer by Using Visual C# .NET

To create a custom form designer, you must implement and use multiple interfaces. The sample code that this article contains illustrates the concepts that are involved in creating a custom form designer. The following are the two most important interfaces that you must implement:

IDesignerHost: This is defined in the System.ComponentModel.Design namespace.

IContainer: This is defined in the System.ComponentModel namespace.

Implement the IDesignerHost interface to provide support for designer transaction, for component management, and for retrieved designers.

When you implement the IContainer.Add method, see if the component that you are adding is the first component. If the component is the first component on your custom form designer, retrieve the corresponding IRootDesigner interface. If the component is not the first component on your custom form designer, retrieve the corresponding IDesigner interface. After you retrieve the appropriate interface (IDesigner or IRootDesigner), associate the retrieved designer with your custom form designer to provide the basic framework for your custom form designer. Then display your custom form designer. For more information, see the code sample and the associated documentation. Microsoft does not provide any support for the code sample.

 

How to detect the installed version of the .NET Framework in a Visual Studio Setup and Deployment package

This step-by-step article describes how to use the Microsoft Visual Studio .NET IDE to verify the version of the .NET Framework that is installed on a client computer for software installation purposes.

 

How to populate a TreeView control with XML data in Visual C# 2005 or in Visual C# .NET

This step-by step article describes how to populate a TreeView control by using Extensible Markup Language (XML) data in Microsoft Visual C# 2005 or in Microsoft Visual C# .NET. Because both XML and the TreeView control represent the data in a hierarchical format, the TreeView control is a natural choice to display XML data.

 

How to remove Visual Studio .NET 2003

This step-by-step article describes two methods that you can use to remove Microsoft Visual Studio .NET 2003 from your computer.

 

How to remove Visual Studio 2005

This step-by-step article describes two methods that you can use to remove Visual Studio 2005 from your computer. You may not always be able to completely remove Visual Studio 2005 by using Add or Remove Programs in Control Panel. This article also discusses how to manually remove Visual Studio 2005.

 

How to deploy a .NET Framework application to run from a network location

The step-by-step article describes how to deploy an application that is built on the Microsoft .NET Framework to run from a network drive.

 

HOW TO: Invoke the Find, View Source, and Options Dialog Boxes for the WebBrowser Control from Visual Basic .NET

This article describes how to invoke the Microsoft Internet Explorer Find, Internet Options, and View Source dialog boxes in an application that hosts the WebBrowser control.

 

How to recursively search directories by using Visual Basic 2005 or Visual Basic .NET

This article demonstrates through code how to recursively search subdirectories for files, starting with a root directory. A search string is specified so that you can search for files that match a certain criteria. Each part of the code is explained as necessary. A working code sample is also provided at the end of the article.

Directory recursion is a common IO task for developers. The FileSystemObject makes this task easy for Component Object Model (COM) applications. Now this task has become even easier in the Microsoft .NET Framework. Similar to the FileSystemObject, the classes in the System.IO namespace provide an object-oriented way to access files and directories.

 

How to trace and debug in Visual Basic .NET or in Visual Basic 2005

This article demonstrates how to use the Debug and the Trace classes. These classes are available in the Microsoft .NET Framework. You can use these classes to provide information about the performance of an application either during application development or after deployment to production. These classes are only one part of the instrumentation features that are available in the .NET Framework.

 

 

How To Use the WebBrowser Control to Open an Office Document in Visual Basic .NET

You may want to display, or embed, an Office document directly on a Visual Basic .NET Form. Unlike earlier versions of Visual Basic, Visual Basic .NET does not provide an OLE control that allows you to embed an Office document on a form. If you want to embed an existing document and open it as an in-place ActiveX document object within a Visual Basic .NET form, a potential solution for you is to use the Microsoft WebBrowser control.

This article demonstrates how to browse to an existing Office document and display it inside a Visual Basic .NET form by using the WebBrowser control.

 

Print | posted on sabato 13 maggio 2006 21:39

Feedback

No comments posted yet.

Your comment:





 
Please add 2 and 6 and type the answer here:

Copyright © Luciano Bastianello

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski