使用环境 :
Window 7,ColdFusion 9,ColdFusion Builder,MS SQL Server 2008 R2 开发版本
1. 设置数据源
2. 查询与显示
<cfquery name = "GetWeixiu" datasource = "MSSQL2008R2">
SELECT [id]
,[编号]
,[设备名称]
,[设备品牌]
,[设备型号]
,[设备数量]
,[单位]
,[厂家名称] FROM Weixiu
ORDER BY id
</cfquery>
<h3>cfgrid Example</h3>
<i>Currently available courses</i>
<!--- cfgrid must be inside a cfform tag. --->
<cfform>
<cfgrid name = "FirstGrid" format="Flash"
height="320" width="580"
font="Tahoma" fontsize="12"
query = "GetWeixiu">
</cfgrid>
</cfform>
或
<cfoutput query="GetWeixiu">
#GetWeixiu.id#,#GetWeixiu.编号#,#GetWeixiu.设备名称#,#GetWeixiu.设备品牌#<br>
</cfoutput>