《2022年在IE中直接连接SQL数据库SQL server]教程.docx》由会员分享，可在线阅读，更多相关《2022年在IE中直接连接SQL数据库SQL server]教程.docx（7页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、2022年在IE中直接连接SQL数据库SQL server教程运用ODC文档运用一个ODC文档可以很轻松在IE阅读器中连接到SQL SERVER数据库的表，ODC文档示例如下：<html><head><meta http-equiv=Content-Type content=text/x-ms-odc; charset=utf-8><meta name=ProgId content=ODC.Table><meta name=SourceType content=OLEDB><meta name=Catalog content=K
2、0712><meta name=Schema content=dbo><meta name=Table content=T_Material><xml id=docprops></xml><xml id=msodc><odc:OfficeDataConnection xmlns:odc=urn:schemas-microsoft-com:office:odc xmlns=http:/www.w3.org/TR/REC-html40> <odc:Connection odc:Type=OLEDB> <
3、odc:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=develop;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DEVELOP;Use Encryption for Data=False;Tag with column collation when possible=False;Initial Catalog=K071
4、2</odc:ConnectionString> <odc:CommandType>Table</odc:CommandType> <odc:CommandText>K0712.dbo.ICInventory</odc:CommandText> </odc:Connection> </odc:OfficeDataConnection></xml><style><!- .ODCDataSource { behavior: url(dataconn.htc); }
5、-></style></head><body onload=init() scroll=no leftmargin=0 topmargin=0 rightmargin=0 style=border: 0px><table style=border: solid 1px threedface; height: 100%; width: 100% cellpadding=0 cellspacing=0 width=100%> <tr> <td id=tdName style=font-family:arial; font-si
6、ze:medium; padding: 3px; background-color: threedface> nbsp; </td> <td id=tdTableDropdown style=padding: 3px; background-color: threedface; vertical-align: top; padding-bottom: 3px> nbsp; </td> </tr> <tr> <td id=tdDesc colspan=2 style=border-bottom: 1px threedshad
7、ow solid; font-family: Arial; font-size: 1pt; padding: 2px; background-color: threedface> nbsp; </td> </tr> <tr> <td colspan=2 style=height: 100%; padding-bottom: 4px; border-top: 1px threedhighlight solid;> <div id=pt style=height: 100% class=ODCDataSource></div&
8、gt; </td> </tr> </table><script language=javascript>function init() { var sName, sDescription; var i, j; try { sName = unescape(location.href) i = sName.lastIndexOf(.) if (i>=0) { sName = sName.substring(1, i); } i = sName.lastIndexOf(/) if (i>=0) &#
9、123; sName = sName.substring(i+1, sName.length); } document.title = sName; document.getElementById(tdName).innerText = sName; sDescription = document.getElementById(docprops).innerHTML; i = sDescription.indexOf(escription>) if (i>=0) { j = sDescription.indexOf(escription>, i + 11)
10、; } if (i>=0 j >= 0) { j = sDescription.lastIndexOf(</, j); if (j>=0) { sDescription = sDescription.substring(i+11, j); if (sDescription != ) { document.getElementById(tdDesc).style.fontSize=x-small; document.getElementById(tdDesc).innerHTML = sDescription; }
11、25; } } catch(e) { } } </script></body></html>这样，可以很便利的在Web页面上显示数据表了J会Web编程的都知道其实是一个HTML文本，采纳Javascript来初始化窗口布局，加粗的部分是数据连接的关键部分，如下所示：<odc:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=develop;Use
12、Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DEVELOP;Use Encryption for Data=False;Tag with column collation when possible=False;Initial Catalog=K0712</odc:ConnectionString> <odc:CommandType>Table</odc:CommandType> <odc:CommandText>K0712.dbo.ICI
13、nventory</odc:CommandText>其中，odc:ConnectionString是数据库连接串，运用和ADO一样的格式，不用多说了吧J；odc:CommandType是查询类型，Table是表查询，SQL是标准SQL语句查询；odc:CommandText是查询吩咐文本，假如是Table类型的，就只要写出表名称就可以了，如master.dbo.sysobjects，假如是SQL类型的话，就是一般的SQL语句，如“SELECT t0.*FROM ICStockBill t0 INNER JOIN ICStockBillEntry t1 ON t0.FStockBillID=t1.FstockBillID ORDER BY t0.FStockBillID”