how will i create a program...?

[whippersnapper76]

how will i create a program in visual basic 6.0 that reads all the tables and all the fieldnames of the table adikkaymonic

[noshaba mariam]

u need to create a connection object to access the database and a recordset object to access a table. then with the help of that recordset u can access the values of fields. ex: private sub form_load() dim cn as new adodb.connection dim rs as new adodb.recordset dim query as string cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=mbdb;Data Source=abc" cn.Open query = "selet * from table1" rs.open query , cn if rs.eof = false then txtbox1.text = rs.fields("field1") end if rs.close set rs = nothing cn.close end sub try this hope it will help u Noshaba

[whippersnapper76]

what im asking is that how can i copy all the tables and their fiels. not exactly the values of the fields. and put them on a txtfile or in a textbox. anyway thank you... youre the man..... adikkaymonic

[whippersnapper76]

what im asking is that how can i copy all the tables and their fields. not exactly the values of the fields. and put them on a txtfile or in a textbox. anyway thank you... youre the man..... adikkaymonic