Results for "Category: Databases/ Data Access/ DAO/ ADO"

Well.. for those who where happy about the previous version, heres a little update with scripting for Views, StoredProcs and missing tables. Works like a tierelier (Dutch ;-)). For those who don't know about the previous version, it compares 2 SQL-server databases. Also if somebody doesn't know how to implement a splitter, here's a idea how to do that :-).

This control will take care of you when you do database application, it serves as your recordset for your form, it will LOCK objects for you, do the BACKCOLORING of objects and Clear Values of objects. Just add the object to its control collection and bind data on it. The nice part of it is that you can save IMAGES to your database without calling or adding codes that will handle chunks. It can also search the database up to 3 columnar search, for more precise record retreiving. It has also a good error handles to avoid error when user encode a wrong value to the database. I hope you find this code useful and your vote would gladly appreciated. THANX.

***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.

This is a Password Program. does what the Windows 98/95 Password screen does. But the program cover's the whole screen. It shows how to use Database... And find the computer's Username...

I had problems using the datagrid attached to an ADOdc control. Here is what I found.

Any true application uses a database, however after deployment, some times you add or modify some fields, and it becomes tiring to adjust the changes manually at clients sites. this is a stripped down version of the application ( there may be some errors due to the stripping down of unneeded funstions ) . Enjoy it without reservations. Vote if you feel like this is something beneficial for you.

SQL Server Documenter can display, print and export to Excel a complete overview of all fields and indexes in a table. This started as a "hello world" type of thing for SQL-DMO and this is the result. It's great for debugging or documenting your databases (that's why I wrote it ;-)). Try it and any suggestions are always welcome.

This project shows you how a user login to program and access menu based on his/her level. Program will display every possibility fails message whenever user failed try to login. The chances for login are only 3 times. After that, user must try again from begining. I also made a form to manage user account, that can be accessed only by user with level 'Admin'. Password field was encrypted in database. 'Admin' can manage all user accounts (add, edit, update, delete, change password, decrypt password, view user activity that saved in database, convert/transfer user activity data to log text file, and view that log text file). User can change his/her password. If user level is 'Operator' or 'Manager', he/she can only change his/her own password, but 'Admin', he can change all password user, and his too, of course. And I made menu to compact, repair, and backup database to manage your database performances. I use database Access97 password protected. I also made setting menu to change program setting (run program at startup - this will be occured if you had made an .exe file named 'LOGIN.exe', display screen saver if program idles in for a certain time, protect screen saver with user password, and don't show tips at startup. There is a 'Tips of Day' which display its data from text file. You can learn how to make a tips form and display the tips form or hide it at startup. The user activities that saved in database can be transfered to text file, and this log text file can be displayed from this program, too. So, user activities data can be transfered to text file, and you can delete the records from database. This will reduce your database file size. I made a screen saver form with analog clock. I used Thaha Husain's code to make the needle clock movement (just like a clock in your wall). Thanks to Husain for this code. Screen saver cannot be interrupted by 'Ctrl-Alt-Del', 'Alt-F4', 'Ctrl-Break', etc. Only active/current user can quit form screen saver. If user quit from this program, there will be an offers from program whether your computer would be shut down directly by program or not. Well, that's all I think. Hope it's very useful for you. Any comments, feedback, and votes would be appreciated. Thank you.

TreeView control is one of the most overlooked controls by developers for use in database applications to display picklists. This is mainly due to the lack of data binding and time required to code. This wrapper does it for you! It simplifies the display of complex data relationships using ADO and the TreeView control. I've made it as generic and flexible as possible whilst significatly improving loading performance over manually coded methods. Features include:- --- Loading records on an "as-needed" basis when Nodes are expanded (includes optional control over the expanding of Nodes) - significatly reduces load time. --- Simple and complex data relationships with support for:- a). recursive record linking; b). many-2-one data relationships; c). one record can be displayed multiple times - each instance of the same record can be fully customised i.e. different images, colors, etc...; d). unlimited data relationships and nesting levels. --- "A pictures is worth a thousand words!" - color coded ranges; Images as warning indicators; color coded regions, etc... Built-in automatic support for customisation of *ALL* Node display properties on a "Per Record" basis - NO MANUAL CODING REQUIRED! (Does not use the .Tag property of each Node - does anyone want this property automatically filled?) --- User defined sorting - uses the SQL "ORDER BY" clause instead of each Node's .Sort property --- Custom filter criterias --- Persistance of data relationships (with associated icons). This gives several benefits: - a). the defined relationship is portable and can be stored in the registry, as a resource, record in the database, or to disk (in-built function); b). Bind your database to the treeview control with only 3 lines of code when using a persisted data relationship! c). Can copy any part (or all) of data relationships between different instances using the .Contents property; d). any modification to icons or filtering can be persisted allowing progmatic or user customisation between sessions &/or applications, users, etc... o ... Load-on-Demand (using its own wrapper class) is exposed for use with other non-ADO bound TreeView Controls within your application. It's very easy to Use the wrapper - Define a data relationship, point to the Database, and then the wrapper will do the rest. The zip file includes: all source codes, VBADOTree.Dll, Five (6) demonstration applications ranging from simple implementation of the Load-on-demand feature (non-ADO Demo) through to a complex inter-table relationship (9 tables) with recursive data structures, custom filter criterias, non-alphanumeric (custom user-defined) sorting, and conditional node properties. Both the Wrapper DLL and demonstration applications are fully commented. Demonstration applications also include very detailed comments and notes on how the data binding and automatic SQL building actually works. This should make implementation in your own projects very easy.

It is a great visual tutorial to learn about Databases in Visual Basic. This is the part I because i couldn't upload the zip file. Please download part II at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44042&lngWId=1. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

Please download part I at http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=44040&lngWId=1. I'm sorry but i can't load the zip file in one. It is a great visual tutorial to learn about Databases in Visual Basic. This is not a simple tutorial, it have steps by step and with every step have a photoscreen to guide you With it you can learn: - How to link an Access database to VB - How to view the database in labels - How to create, delete and edit the differents register - How to make a filter (search engine) of strings, number and Dates - How to resolve common problems with DB - How to show the database in a sheet like Excel (Datagrid control) - How you can manipulate the DB with the Ado Control invisible - How to specify a format for a type of data like "$ 23.80" or "23/sep/2003" - and much more... Also have a very good example divided in VB in three parts: 1- View, add and edit DB 2- Find in DB 3- Non visible Ado Control with Datagrid control I recomend it for beginner or newbies in DB and also for that who want to make better

This project shows how we can print a very simple report to text file using RichTextBox control and to printer. The report contains simple information with quantity and sum of item per page, the sum of money per page, and total of sum of money in the end of report. User can select category to display the report. User also can change the number of record would be displayed in the screen/printer, and can change which printer will be used in combobox. The selected printer is the default installed printer in your computer. Including functions to adjust text-alignment in the report. This is very useful for you who want to print a simple report with many record to your screen and to your printer, without using the third party activex control. Any comments, feedback, and votes would be truly appriciated.

This artical simplifies the usage of ADO objects . If you like me article, please vote for me!

This example shows a way to manage persistence with classes in VB using a 3 Tier framework with XML for inter layer communication.

This Sample create's a Datareport by filtering a Database. It is quit useful for small Reports. (Sorry this is the Englisch Version!)

update from my previus posting. This my sample code how to manipulate Datareport without using DataEnvironment this sample included datashape concept and how to link image dynamicly.

Using ADO & ADOX, convert between various database formats like Text, Access, Excel, dBASE, Paradox & HTML. This is a NEW VERSION of Any-to-Any Database converter. Please follow the link if you like to vote me / to get the original version http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=47434&lngWId=1

This is a One Form One Ini solution to the frustration of writing repetitive VB/ADO/ASP Database code. I hope you will find this extremely useful for certain tasks, and a sound concept for improved coding and tailoring to individual requirements. As I can't live without it now - so I thought I would share it. (1) Opens any Access 97/2000 Database and Lists Tables, Fields, Types. (2) Type one line of code, program will replicate the line using the correct Fieldnames/Numbers/Types and Sizes - ASP programmers dream. (3) Create a choice of connection strings based on the Open database. (4) Create Sql INSERT, UPDATE & SELECT statments with actual field names. (5) Print your output code, or Double Click Ouputbox to send to clipboard. (6) Split Screen to adjust to preferred ListBox v Outputbox areas. (7) Most settings saved, return to where you were when restarting. (8) MRU File List, Auto-Open last database, Synchronized Clipboard etc. (9) Tool Tips explain most items, can be turned off when desired. (10) Reminder bar shows current User Keys, DblClick to turn off. (11) Disconnected Recordsets, freeing off DB during development. (12) All Translation 'Keys' are user definable. At the simplest level, Open a database and type in a template like - MyArray(##) = rs("$$") In the Ouputbox, ## and $$ get translated as FieldNumber and FieldName MyArr(0) = rs("ID") MyArr(1) = rs("qCode") MyArr(2) = rs("Title") MyArr(3) = rs("Lastname") MyArr(4) = rs("firstname") ........... ........... and so on to n fields

This little utility allows the user to select an Access database and then generates the code to make a connection. It also allows the user to select a table from the database which then generates a simple SQL. Also attached are instructions for use and a test program If there is sufficient interest I will continue to develope code writing programs and submit them to PlanetSourceCode. Although a few votes would be nice I am more interested in feedback. Taken from an idea by Carlos Vara, thanks.

Hi everybody, This is for a database programming lovers especially those beginners...There will be no module so you will understand the flow of the program....Not Fully documented yet co'z I have no time for that....Maybe in my next update !....You will enjoy while using this program co'z there are lots of animations in this program....I hope you have learned from my codes co'z that was I wanted for beginners....Have fun coding ! If you like this program please vaote for me or just rate it...Thanks ! For comments email !