| XWidgetSoft Forum https://bbs.xwidget.com/ |
|
| Connect Database with my Widget https://bbs.xwidget.com/viewtopic.php?f=10&t=2486 |
Page 1 of 1 |
| Author: | Achinthac [ January 2nd, 2013, 3:37 am ] |
| Post subject: | Connect Database with my Widget |
How do i connect MS Access or My Sql Database with my widget ? |
|
| Author: | Tony [ January 2nd, 2013, 8:37 pm ] |
| Post subject: | Re: Connect Database with my Widget |
you can try to uses Activex/OLE in script to connect MS Access |
|
| Author: | Achinthac [ January 6th, 2013, 6:35 am ] |
| Post subject: | Re: Connect Database with my Widget |
Thanks i got it ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sub button2OnClick(Sender) Dim strConnection, conn, rs, strSQL strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='D:\MyData\DB\waste.mdb'" Set conn = CreateObject("ADODB.Connection") conn.Open(strConnection) Set rs = CreateObject("ADODB.recordset") strSQL = "Select * from Items" rs.Open strSQL,conn rs.MoveFirst while not rs.EOF Print(rs("Item_des")) rs.MoveNext WEND rs.Close Set rs = Nothing conn.Close Set conn = Nothing End Sub ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| Author: | alfredorhz [ March 20th, 2013, 6:55 pm ] |
| Post subject: | Re: Connect Database with my Widget |
Hi, can u be more especific, please? or please an example Can make a list from a db, with autoupdate? gracias |
|
| Author: | hamid [ July 3rd, 2014, 1:08 am ] |
| Post subject: | Re: Connect Database with my Widget |
| Page 1 of 1 | All times are UTC - 8 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|