how to retrive data from database using javascript]

Question

i am using wab app and in my form i need to retrive name from database i just create text box and enter a char and i need to show a name like the entered char

Muhammad Imran · Answer

I copied the below text from: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2804&lngWId=14 '************************************** ' Name: ADO With JavaScript ' Description:I have not found any sample that shows database access with javaScript. Well I created one. It is very simple since Javascript has the activeXObject that allow us to call an external object in the same way that vbscript uses CreateObject. ' By: Marcio Coelho ' ' Assumes:You need SQL Server a valid login and know the name of a table and at least one column to test the sample. ' 'This code is copyrighted and has' limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=2804&lngWId=14'for details.'************************************** var conn = new ActiveXObject(ADODB.Connection) ; var connectionstring = Provider=sqloledb; Data Source=itdev; Initial Catalog=pubs; User ID=sa;Password=yourpassword conn.Open(connectionstring) var rs = new ActiveXObject(ADODB.Recordset) rs.Open(SELECT gif description page location FROM menu1 conn) // Be aware that I am selecting from this table but you need to pick your own table while(!rs.eof) { alert(rs(0)); rs.movenext } rs.close conn.close //-->