Jump to content

simple ado sql manager


ldb68

Recommended Posts

The project is a simple sql manager using ADO compoment (eg. yuo can use any database via odbc connection).

 

It show a tree with database tables.

It build the sql statement for selecting rows.

You can save/edit/delete row.

You can build insert/update query.

Rudimental autofit colunn show.

 

 

In the same isapi / exe folder add a "dsn.ini" text file with string connection for the database, es.

 

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=casavalentina;Data Source=HOME-PC\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=HOME-PC;Use Encryption for Data=False;Tag with column collation when possible=False;

AjaxSQL.zip

post-13-0-00373700-1318499395_thumb.jpg

  • Upvote 2
Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...
  • 2 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...