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 //-->

how to retrive data from database using javascript]

Answers (1)