社区
数据库(包含打印,安装,报表)
帖子详情
请问:Ado.Recordset.Fields(0).DataFormat 中DataFormat属性怎么使用呢?
cdq_550126
2009-01-09 03:09:13
我想设置Recordset对象中某一字段的显示格式.好像是用Field下的DataFormat属性. 但不知道该属性怎么使用.
希望大虾能给个例子!
十分感谢!
...全文
171
1
打赏
收藏
请问:Ado.Recordset.Fields(0).DataFormat 中DataFormat属性怎么使用呢?
我想设置Recordset对象中某一字段的显示格式.好像是用Field下的DataFormat属性. 但不知道该属性怎么使用. 希望大虾能给个例子! 十分感谢!
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
1 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
cebdou
2009-01-09
打赏
举报
回复
帮你顶一下。
我也只找到了一点儿,但没有找到例子
DataFormat属性
设置或返回StdDataFormat对象,一个绑定对象将附加到它。在设计时或运行时都可读写。
语法
object.DataFormat = formatobject
DataFormat属性语法有如下的部分:
部分 描述
object 一个对象表达式,其值是“应用于”列表中的一个对象。
formatobject 必需的。一个StdDataFormat对象。
说明
DataFormat属性也能通过属性窗口的属性页设置。如果代码中的设置值与属性页的设置值不一样,那么属性页的设置值将应用于第一个取到的记录,之后,将使用代码中的设置值。
DataCombo 控件的 DataFormat 属性是 Extender 属性。因此在属性单上它总是可见的并且能在代码中设置。然而 DataCombo 控件仅仅格式化列表顶部的项。对于看到一个顶端项格式化、而仅给出一个未格式化项的列表供选择的终端用户来说,这可能是令人不安的。格式化的项也可能误导用户,使他认为项要以格式化的形式输入数据库。由于这些原因,建议在使用 DataCombo 控件时不要设置DataFormat 属性。
VB编程资源大全(英文源码 数据库)
1 ,
data
file.zip
"This sample demonstrates how to do file input and output using Visual Basic. The sample creates a new
data
base file and allows you to view, add, or delete records in this
data
base."
2 , dbprint.zip
This demonstrates how to print
data
from a
data
base.
3 , edittbls.zip
This is an EXCELLENT example on how to edit
data
base Tables through VB.
4 , graphdb.zip
This demonstrates how to graph in
format
ion from a
data
base to a picturebox.
5 , ClassBuilder1.zip
Class Builder - reads SQL Server or Access
data
base and creates a class of the selected table
6 ,
ado
View1.zip
ADO
viewer. Retrieve all columns, querys and
field
s of a
data
base and put them in a TreeView(using OpenSchema
ADO
Connection method)
7 , imagechunk1.zip
This application will save JPG,BMP,GIF files in your
data
base and allows you to fetch the same. Code example for saving and fetching the same in oracle and sql is also given.
8 , DBImpExp.zip
A utility to import/export Access
data
base from/to other application
format
s, e.g. Excel and text files. With sample files and help, as well as ample remarks.
9 , pb_test.zip
Test project illustrating high performance
Data
Access for SQL Server using
ADO
command objects and Stored Procedures for Insert, Update, Delete and Select. Two methods for Selects are shown
10 , Employees.zip
This is a
data
base project, for storing employees
data
.
11 , DBProject2.zip
New version of DBProject. Allows you view, scroll through, and edit an access
data
base.
12 ,
ado
view.zip
ADO
Viewer,This code retrieve all columns, querys,
field
s of a
data
base(Access, SQL Server, etc...)
13 , Cheques2.zip
New version of Cheques program. Must see...
14 ,
ADO
SQLcodeGenerator.zip
SQL and
ADO
Code Generator. Generate SQL statement and
ADO
Code Connection without the use of an
ADO
Data
Control.
15 , client.zip
This application is about programming with Client Side Cursors.
16 , AccessSecurity.zip
An Access97 security tool. Replaces going into Access97 and switching between security forms.
17 ,
Data
baseViewandEdit.zip
Do about anything with Access
data
bases. View, edit, export contents to Word or Excel, etc., etc.
18 , VBSales.zip
This is a complete
data
base program for sales which help you to create purchase order, Invoice, etc.
19 , accidents.zip
A programme meant to add, edit,delete,and searching
data
. It includes how to show statistics regarding the accidents in
format
ion.just try it. It is handy in studying
data
base programming.
20 , MySQLExplorer.zip
Explorer for MySQL
Data
Base.You can retrieve and execute your query.
21 , ICDBaseSource115.zip
DAO based
data
base program with many features in it
22 , ICDBSourceBeta115.zip
teach people just beginning with
data
bases and also i am new to
data
bases so this is pretty well commented.
23 , Diary.zip
This application everything you need.t has a CALCULATOR.It has TIME & DATE u can even set the system time
24 , L_
data
b.zip
The functions are for open
Data
bases including passwords, creating
Recordset
s , executing SQL statements, renaming tables and many more.
25 , CodeGen.zip
VB code generator,The application currently generates
data
classes for Access '97
data
bases.
26 , dbexample.zip
The best part about using a MS JETDB EnGINE4 is that the DB can be accessed through a network.
27 , ComboLookup.zip
Zip Code
Data
base Is A Program To Find Zip Codes By Using A Lookup
Field
.
28 , UDL.zip
This is a class that lets you create and edit UDL files
29 , qbd-dbCoder131.zip
This code shows how to take
data
from a VB
data
base application and place it into an Excel spreadsheet.
30 , Family_v2_upload_Apr_05_2000.zip
This is a family address book program created using VB6.
31 , datsearch.zip
Application which searches an Access
data
base for a specified search term entered by the user.
32 , DBTextGrid.zip
This program is the modification of my previous Textgrid.Now you can Add, Modify, Delete, View, Save
data
to/from your
data
base with this Grid. The grid was formed with array of text boxes.
33,txtgrid.zip
This program creates text box array dynamically and loads the
data
base
field
s onto it.
34,DAOLike.zip
This program Demonstrates how to use LIKE operator in Jet SQL Query (uses DAO).
35,xmlcreator.zip
This project is a demonstration of how to convert a
recordset
into an XML
format
file. Its well documented and more XML stuff to come along.
36,compmdb.zip
This program will allow the user to select a MDB file to compact. Its then backed up just in case, compressed and then the original is deleted before the new compacted version is moved back in place of the original.
37,dbinfo.zip
We've written this mainly for when we develop
data
bases, but really you could adapt it for productive use too. By supplying a DSN entry, it will attempt to connect to that
data
base and list all the tables in it. When you click on a table, it lists all
38,3a.zip
An Inventory System, you can add, edit, sort, find, delete, print, change your password and create a backup of your
data
base
39,A417Source.zip
Full original RANDOM
DATA
INDEXING (SY-32)METHOD),Faster
DATA
access than a classical
data
base application. the 1st source of new indexing method (SY-32)
40,student.zip
This is Student Administration Project , u can administrate student through this programme in any institute when u run the programme please use password "mars3" then u can run please check it.
41,
ADO
Viewer.zip
ADO
Data
Base Viewer. Can open multiple concurrent
data
bases from seperate providers. Works with Access, SQL Server and DSN. I included the ODBC Logon from VB6 so it should be able to hook up to any
data
provider that supports
ADO
.
42,rptparam.zip
Passing parameters with
data
reports. I have set two parameters and passed them during run time.Open with VB6.
43,CompactRepair.zip
A small application that shows you how to compact and repair a Microsoft Access mdb or mde using
ADO
(JRO).
44,Ledgerinvb5.zip
This is simple GL ledger Project, again a
data
base program. It has an interesting part if you click About button. Must see it.
45,
Ado
Sort.zip
Ado
Data
Sort Control will display your
data
from
data
base, filter, sort (up to 3 levels) all in HFlexGrid!!!
46,
ado
xml.zip
Use
ADO
to convert
data
base records into an XML file. All users must have MSXML.dll version 3.0, and Internet Explorer 5.5.
47,
Data
Cntl.zip
Simple application that shows how to use the
Data
Control to connect to the Biblio.mdb
data
base and display all authors in the Authors table.
48,MyTool.zip
An SQL Query tool for SQL Server or Oracle.
49,fab15.zip
Complete
Data
base Address book With Lots Of New Facilites.....下载 Now.
50,
Data
BaseViewer.zip
Data
Base Viewer is a program that lets you to look at your
data
base files. It opens the
recordset
s in a table for easy viewing and also has a percents and progress bar to show the exact loading progress of the
RecordSet
.
51,Dynarep.zip
This program generates a dynamic
data
report during runtime without using any
Data
Environment object. I have passed the
data
source and
recordset
properties during run time. Opens with VB6.
52,EditUDL2.zip
This is a newer version of the Edit UDL class. This version 2.3 enables you to Create, Edit and Save UDL files either by the UDL properties Dialog Box or by a connection string. The class adds some additional Properties. The Zip file contains not only the class but a sample project demonstrating the use of the UDL class.
53,
ADO
client-side.zip
In a network environment, open a connection to a
data
base, retrieve
data
, close the connection, work with the
data
, reopen the connection to communicate with the
data
base again and do a batch update.
54,udl2.zip
This application reads universal
data
link files from disk, creates them, and saves modifications to them to a file. UDL files contain
ADO
connection in
format
ion to
data
sources. Their output can be used as a connection string in your applications.
55,timebilling.zip
This is a full 3-tier dababase application which includes a activex dll project(business objects) and a standard exe(UI).
56,
ADO
DAOpw.zip
Application which shows how to access a password protected Access
data
base using DAO and
ADO
.
57,DBExplorer.zip
Data
base explorer for viewing all tables and queries in a
data
base. Also includes an SQL editor similar to SQL Query Analyzer.
58,FriendsDb.zip
ADO
Data
base, Improved login and made the program smaller but with the same options as before just a few extra ones with the login such as write the login to the registry instead of just to a ini file also better encryption for the ini file... Now you can save your password as a number, in the previous login the encryption was poor.
59,FriendsDb105.zip
ADO
Data
base... Friends
Data
base Version 1.05 ... Updated Again, Added even more error handling and images to the listview box also added a few forms to stay on top. Some major error additions i skipped before, runs much smoother now not that it didn't before.
60,Friends.zip
GREATLY UPDATED: Added much better error handling just to be safer and more neat... Also added more sound so all commands have a sound and upon loading a 3 second wav plays also included is the advanced progress bar and ocx that i found in someone elses source that is great for multiple reasons..
61,Friends
Data
base.zip
My first
ADO
data
base, i learned from tutorials on here specifically from Jerry Barnes so i think this would be great for people new to
ADO
data
bases to learn from but i suggest finding Jerry Barnes
ADO
For beginners source because it is incredibly commented on and will surely have you creating
ADO
within 20 minutes.
62,user_query.zip
The Application basically allows you to connect to any Access
Data
base view records of each table, along with the table design ,write sql statements on the fly(any dml statement).Most Of The Functionality Of The Application Has Been Automated. A must See..
63,
Data
base.zip
Data
base application. Must see...
64,Cheque.zip
Cheques. Must see...
65,ICDBaseSource.zip
DAO based
data
base program with many features in it, I also noticed after searching around I seen no
data
bases that supported saving gaming info so I made one witht he ability for saving game info such as favorite game, gaming handle, clan name, clan rank...
66,pizza.zip
Pizza Program. Must see...
67,prj
Data
Env.zip
This VB
data
base application shows how to use
Data
Environment in code.
68,Familyv3.zip
This is new version of a family address book that I released some time ago. This time around I mostly use
ADO
instead of DAO and now the user isallowed to add or remove any category of their choice.
69,AgendaRBC.zip
An Agenda which uses a text
data
base file.
70,project26.zip
Stocks Portfolio.
71,vbasics.zip
This is a
data
base project that uses the VB DBGrid control to display and scroll through all records in an Access
data
base.
72,vbWales.zip
Data
base app. I did as a college assignment. Only simple stuff but there is some good tab strip code etc...
73,DBProject.zip
Data
base Viewer application. Allows you to view and scroll through all of the records in a
data
base.
74,dbCoder.zip
Access97
Data
base Coder. Analyses a
data
base and writes the code required to create blank copy. Two projects dbCoderAddIn.vbp can be compiled as an add-in and will place the code in a new module of the active project.
75,move_vb6.zip
Demonstrates how to use the
data
control to move through a
recordset
.
76,
ado
.zip
Opens an access
data
base using
ADO
and then displays all records, provider properties and error in
format
ion in a list box.
77,f_119.zip
An example of a bound form using the
ADO
control(4KB)
78,f_118.zip
Examples of a connectionless
recordset
(2KB)
VB & 数据库交互(一)——交互知识总结
看完了数据库SQL-server的视频,对数据库有了大概宏观的了解,随着总结的继续,了解也在不断的深入,总结了更多的是理论知识,这几天完成了VB与数据库的交互,进入了简单的实践当
中
,慢慢的体会到了数据库的重要性。下边是我这几天的总结。 VB与数据库交互的必备知识: 一.
ADO
(ActiveX
Data
Object),此项技术不仅可以在Visual Basic
中
开发数据库应用程序,也可以...
使用
ADO
或
ADO
控件访问数据库
目录: 1、数据库的基础知识以及创建Access数据库 2、数据库的接口 3、
使用
ADO
或
ADO
控件访问数据库 上篇文章,为大家讲解了数据库的接口,大家对
ADO
也有了较为基础的了解,这篇文章主要解决大家对
ADO
的用处的疑惑。VB为用户提供了很多访问数据库的方式: 【方法一】
使用
ADO
对象,通过编写代码访问数据库 【方法二】
使用
ADO
Data
控件和数据环境设
ado
.cpp
//// MODULE:
Ado
.cpp//// AUTHOR: Carlos Antollini //// mailto: cantollini@hotmail.com//// Date: 11/19/2002//// Version 2.09//#include "stdafx.h"#include "
ado
.h"#if defined(UNICODE) || defined(_UN
c++
ADO
数据库
VC用
ADO
访问数据库全攻略,介绍了VC用
ADO
来访问数据库的各个对象及各方法,很经典,也很实用,很值得一看。 正文一、
ADO
概述
ADO
是Microsoft为最新和最强大的数据访问范例 OLE DB 而设计的,是一个便于
使用
的应用程序层接口。
ADO
使您能够编写应用程序以通过 OLE. DB 提供者访问和操作数据库服务器
中
的数据。
ADO
最主要的优点是易于
使用
、速度快、内...
数据库(包含打印,安装,报表)
1,216
社区成员
55,954
社区内容
发帖
与我相关
我的任务
数据库(包含打印,安装,报表)
VB 数据库(包含打印,安装,报表)
复制链接
扫一扫
分享
社区描述
VB 数据库(包含打印,安装,报表)
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章