从老外那儿转帖过来的
很酷,只要修改几个参数就可以了,很有帮助
<%@ LANGUAGE = JScript %>
<%
var ConnStr= "DSN=admin"; //
var UserLogin= "sa"; // input empty Login and Password,
var UserPassword= ""; // if your DSN works via WinNT trust connection
var CharSet= "gb2312"; // as sample "windows-1251"
var PgSize= 10;
%>
MS SQL(SQL Server培训 mySQL培训 ) Structure Viewer Version 1.2
MS SQL WebTools >> Table Structure Viewer |
written by
Alexander Tkalich
|
|
<%
var trColor1= "#7f9faf", trColor2= "#bfcfd7";
var trColor= trColor1;
function isDef( Value){
if( Value== ( Value "")) return true;
return false;
}
function QOutSelect( Conn, Name, Value, FirstName, FirstValue, SQL, SSize){
var Rs= Conn.Execute( SQL);
Response.Write( "
if( FirstName!= "")
Response.Write( "
for( ; !Rs.EOF; Rs.MoveNext()){
Id= Rs( 0);
Nm= Rs( 1);
if( Value== "" Id) S= 'selected'; else S= '';
Response.Write( "
}
Response.Write( "");
}
var S, DbName, TbName, Tbl, Row;
if( !isDef( DbName= Request.Form( "DbName")))
DbName= Request.QueryString( "DbName");
if( !isDef( TbId= Request.Form( "TbId")))
TbId= Request.QueryString( "TbId");
Tbl= Request.QueryString( "Tbl");
Row= Request.QueryString( "Row")/ 1;
%>
<%
var Conn= Server.CreateObject("ADODB.Connection");
Conn.Open( ConnStr, UserLogin, UserPassword);
if( !isDef( Tbl)){
%>
|