Results for "Author: darryn frost"
Uses DTS (Data Transformation Services) from within VB
The program Creates a VB Class Module from a DTS Package on a SQL Server, with all events, and its own events(Progress, currentTask, etc) It creates a very compact script, so you can very large packages in a single routine. The Class Module "ClassDTSScript" is what is created when you get a package from the server and script it. Simply remove the example, and add one you have done to test it. The example execution asks you to navigate to the source and destination Access Databases, and uses the filepath to pass in an ADO style connection string for the source and destination connections. The parsing routine in the class module will work for SQL Server or ACCESS. I have not handled more complicated transformations such as Many to one column mappings and such, but Execute SQL and DATAPUMP Tasks work quite well. The Example "ClassDTSScript" module included was created from a package in SQL Server 7, and includes a couple of queries, two transformations, and running a stored procedure with a parameter, as well as demonstrating using the events that are called by the DTS Package object. Read the comments in the code carefully to better understand the uses.
This code allows you to have the smooth-scrolling effect seen in better applications on your datagrids(could also apply to other scroll bars in VB) When you grab the trackbar and move it, VB doesn't do anything until you let go. Or if you click on the trackbar itself, the grid just jumps. This code shows you how to change these effects so that the grid(or text) will scroll smoothly as you drag or click.
Optimizing VB String Parsing – Using Byte Arrays and Binary Searches to parse and color code
This code is a custom control I wrote for use in our companies products. It has tons of implemented ideas in it - way, way too much to list. So a full HTML help file is also included. The grid will bind directly to an ADO recordset, or will make an internal copy of the recordset if you wish. I would like to thank everybody that posts on this site. Some of the examples have been invaluable over the years, so I like to return the favors.
This is the code from a class module for exporting from any Jet database to any ISAM format out there. I think it neatly encapsulates the process, and uses properties and methods to make the process as easy as possible.
It allows you to import any .DBF file into an access database. You can choose the new table names, select individual fields, and create a new Access97 or 2000 database if one is not there already.
Uses DTS (Data Transformation Services) from within VB
The program Creates a VB Class Module from a DTS Package on a SQL Server, with all events, and its own events(Progress, currentTask, etc) It creates a very compact script, so you can very large packages in a single routine. The Class Module "ClassDTSScript" is what is created when you get a package from the server and script it. Simply remove the example, and add one you have done to test it. The example execution asks you to navigate to the source and destination Access Databases, and uses the filepath to pass in an ADO style connection string for the source and destination connections. The parsing routine in the class module will work for SQL Server or ACCESS. I have not handled more complicated transformations such as Many to one column mappings and such, but Execute SQL and DATAPUMP Tasks work quite well. The Example "ClassDTSScript" module included was created from a package in SQL Server 7, and includes a couple of queries, two transformations, and running a stored procedure with a parameter, as well as demonstrating using the events that are called by the DTS Package object. Read the comments in the code carefully to better understand the uses.
This code allows you to have the smooth-scrolling effect seen in better applications on your datagrids(could also apply to other scroll bars in VB) When you grab the trackbar and move it, VB doesn't do anything until you let go. Or if you click on the trackbar itself, the grid just jumps. This code shows you how to change these effects so that the grid(or text) will scroll smoothly as you drag or click.