Description: I think this a very useful Vb database skills, so VB automatically formatted according to the data field type DataGrid table, database connectivity drivers as: Provider = Microsoft.Jet.OLEDB.4.0 Data Source = db_manpower.mdb Persist Security Info = False. Month salary can be an employee number, employee name, base salary, overtime, seniority pay, total rewards, duties allowance, absenteeism costs, the total punishment, pension insurance, unemployment insurance, and other fields should be reduced if the data is automatically formats as specified type, the child deal with the process of code:
Dim fld
For Each fld In Adodc1.Recordset.Fields
If field type is money, then format the column
If fld.Type = 6 Then
Set f1 = DataGrid1.Columns (fld.Name). DataFormat
f1.Format = "##,## 0.00"
End If
Next
End Sub
To Search:
File list (Check if you may need any files):
VB根据字段自动格式化DataGrid表格中的数据\db_manpower.mdb
........................................\main_gzgl.frm
........................................\main_gzgl.frx
........................................\main_gzgl_gzgl.frx
........................................\工程1.vbp
........................................\工程1.vbw
VB根据字段自动格式化DataGrid表格中的数据
Download