{
var connection = new ActiveXObject("ADODB.Connection") ;
var connectionstring="Data Source=
Data Source=MSSQL2005;Initial Catalog=TravelAruba;User ID=aruba;Password=aruba01" ProviderName="System.Data.SqlClient
connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
document.write(rs.fields(1));
rs.movenext;
}
rs.close;
connection.close;
}
No comments:
Post a Comment