Using the Define Names dialog, we can define a name using these parameters: Name: box.Excel accepts this definition of the chart data, but it converts the dynamic range name to a static range address. Range("Cht Source Data"), _ Plot By:=xl Columns End If End Sub ; if so, it resets the chart’s source data range. There’s an easier way to make your whole chart dynamic, adding or removing points or series in the chart as rows and columns are removed or added in the source data range.You can read the full text of past Basically Visual columns. Here I present solutions to a few problems that I have encountered in my programming. Customizing the Web Browser control Avoid using the Internet Transfer control Validating web links Sending email from a Visual Basic program Clear all Text Boxes on a form Create blinking text on a form Display 3-D text on a form Change Text Box margins Aligning controls at a specific position Don't forget the Tag property Sizing a Form's interior Getting colors from a Picture Box control Auto Redraw and the Paint event Capturing screens from a Visual Basic program Filtering Text Box input Getting and using screen information Clipping the mouse cursor Move the mouse cursor in code Drawing "rubber-band" boxes Undo for Text Box controls Disable a form's Close button Modify the System menu Accept only uppercase letters in a Text Box Keeping a form on top Using custom mouse cursors Ensuring that all forms unload Remembering a form's size and position Support formatted text with the Rich Text Box control Toggling a form's title bar at run-time Understanding the Combo Box control Get to know the Sys Info control Changing Combo Box height Implement auto-find in a List Box Selecting all text when a Text Box gets the focus Save time with control arrays Adding controls to a form at runtime Scrolling controls on a form Understanding the Key Preview property Create a pane splitter Changing text alignment for Forms and Picture Boxes Create an "auto-OK" dialog box Create a "Sticky" Button Creating Graphical Command Buttons Implementing mouse-over effects Using the Picture Clip control Implement a Mouse Exit event Fire a Command Button repeatedly Create a temporary file name Verify that a path is writable Determining the type of a drive Using INI files for program settings Deleting files to the recycle bin Dragging files to your Visual Basic program Display file properties Display a select folder dialog Reverse character order in a string Parsing strings Is that on a weekend?These were originally published in Visual Developer magazine. Perhaps you will find something that is useful to you. Encoding and decoding passwords Implementing a stack Counting strings Converting numbers between decimal and binary Use the Data Report Designer Making the most of UDTs Comparing dates in Visual Basic Using the Collection object Normalize spaces in a string Send raw data to the printer port Creating synthetic keystrokes Detecting the state of the "lock" keys Using the standard input/output streams in Visual Basic Playing WAV files Playing the Windows system sounds Keeping an application log file Detecting a sound card Reduce the size of Visual Basic distribution files Easy creation of database connection strings Do you Do Events?For each value you will choose the data type, scope and a default value.These values will be saved in a file named app.config in your project folder and in a file named .config in output folders after builds such as \bin\Debug\ if building in debug mode.This is the type of request Sql Client sends if you invoke any of the managed class.Bulk Load is different from the other requests because is the only request that starts execution before the request is complete on the TDS protocol.
The gist of it is that when your application whats the database to do anything it will send a request over the TDS protocol.The request itself can take several forms: This request type contains just T-SQL text for a batch to be executed.This type of requests do not have parameters, but obviously the T-SQL batch itself can contain local variables declarations. (November/December 1999) Active X Documents part 1. (September/October 1999) Visual Basic for Applications. Column 3 (August/September 1996): Using resource files with Visual Basic Column 2 (June/July 1996): Variant speed penalties, uses for collections. (July/August 1999) Data Sources, Data Sinks (part 2). Column 4 (October/November 1996): Taskbar tray icons.If different users login and use your application, each user can maintain their own separate and unique values making them perfect for user specific preferences. scoped values will be saved in a completely new user.config file.This is actually clever and ensures that each version of your application does not clash or overwrite values from a previous version.If you are a developer writing applications that use SQL Server and you are wondering what exactly happens when you ‘run’ a query from your application, I hope this article will help you write better database code and will help you get started when you have to investigate performance problems. The only way to interact with the back-end database is by sending requests that contain commands for the database.The protocol used to communicate between your application and the database is called TDS (Tabular Data Sream) and is described on MSDN in the Technical Document [MS-TDS]: Tabular Data Stream Protocol.One limitation of this approach is that it can only account for dynamic numbers of points in a series, but not dynamic numbers of series in a chart. Let’s start with a simple data range as shown below.Following best practices, the data is arranged with series in columns, the category labels (X values) are in the first column, the series names are in the first row, and the top left cell of the range is blank.