IE? client side script? <script language="JavaScript">
var adoConn = new ActiveXObject("ADODB.Connection");
adoConn.Open("Provider=SQLOLEDB;Server=YourServerName;Database=YourDBName;UID=YourSQLLoginID;PWD=YourSQLLoginPassword");adoRs = new ActiveXObject("ADODB.RecordSet");
adoRs.Open("SELECT * FROM YourTable",adoConn,1,1);while ( !adoRs.EOF )
{
for (var i=0; i < adoRs.Fields.Count;i++)
{
alert(adoRs.Fields.item(i).Name + "=" + adoRs.Fields.item(i).Value);
}
adoRs.MoveNext();
}adoRs.Close();
adoConn.Close();adoRs=null;
adoConn = null;</script>
var adoConn = new ActiveXObject("ADODB.Connection");
adoConn.Open("Provider=SQLOLEDB;Server=YourServerName;Database=YourDBName;UID=YourSQLLoginID;PWD=YourSQLLoginPassword");adoRs = new ActiveXObject("ADODB.RecordSet");
adoRs.Open("SELECT * FROM YourTable",adoConn,1,1);while ( !adoRs.EOF )
{
for (var i=0; i < adoRs.Fields.Count;i++)
{
alert(adoRs.Fields.item(i).Name + "=" + adoRs.Fields.item(i).Value);
}
adoRs.MoveNext();
}adoRs.Close();
adoConn.Close();adoRs=null;
adoConn = null;</script>
解决方案 »
- 求一个sql--在线等,马上给分!
- 关于合计问题,大伙请进
- 绝顶高手们过来!一个小小挑战交给您了!
- 求教!如何在数据结构中自动抽取和生成数据索引
- 我是使用vb开发程序,sql的自定义函数,原码需要放到哪里sql server还是vb代码里呢?
- 有点难度的问题。急
- js文件如何导入数据库?
- 请教创建的视图里怎样使用ORDER BY排序?
- 合并复制错误, uniqueidentifier 列的索引出错???
- 我想学ASP+SQLServer,但不知Asp+,SQLServer2000与Asp3,Sqlserver7的差别大么?
- sqlserver的问题!请ZHUZHICAO来回答!
- 在SQL Server2000中如何让table存放在指定的file group中?
<script language="JavaScript">
to
<script language="JavaScript" runat="server">PHP has their own library to access database