Use jquery ajax to read Databases

Make sure there is a jquery file. I use 1.4.2, but I haven't searched for it in a hundred degrees.

 

Test. aspx

<SCRIPT type = "text/JavaScript" src = "jquery1.4.2.js" mce_src = "jquery1.4.2.js"/> <br/> <Div id = "listdiv"> </div> </P> <p> <SCRIPT type = "text/JavaScript"> list. init (); </SCRIPT> </P> <p>

 

Ajax. js

VaR list = <br/>{< br/> init: function () <br/>{< br/> $. ajax (<br/> type: "Post", <br/> datatype: "html", <br/>/data :{}, // parameter <br/> error: function () {alert ("Access failed. ") ;}, <Br/> URL:" Get. aspx "<br/> success: function (result) <br/>{< br/> document. getelementbyid ("listdiv "). innerhtml = result; <br/>}< br/>) <br/>}</P> <p>

 

Get. aspx. CS

try <br/>{< br/> string connstr =" Integrated Security = sspi; initial catalog = pubs; datasource = location; Connect timeout = 20 "; <br/> sqlconnection conn = new sqlconnection (connstr); <br/> Conn. open (); <br/> string sqlstr = "select ID, name, sex from [EMP]"; <br/> using (sqldataadapeter da = new sqldataadapeter (sqlstr, conn) <br/>{< br/> datatable dt = new datatable (); <br/> da. fill (DT); <br/> string result = ""; <br/> foreach (datarow row in DT. rows) <br/> {<br/> result + = row [0]. tostring () + row [1]. tostring () + row [2]. tostring (); <br/>}< br/> response. write (result ); <br/>}< br/> catch <br/>{}< br/> finaly <br/>{< br/> Conn. close (); <br/>}< br/>