Full description of the file
Download source and code of vb.net MS Access database query editor
Today, in this post, for you, dear users of the website, we have prepared a source file and the software code of vb.net, the MS Access database query editor, ready for download.
Sample image at runtime
Try creating a Union query with MS Access or Update or Insert If you want to see (or edit) the Sql query, sometimes it's hard to remember the names of the tables, you need to remember the names of the tables/queries/columns (or go to their sites to copy and paste) I think the above is reason enough to make me sick of that editor and make my own………
Anyway… this is a windows application developed in VB.Net 2008 IDE. A very productive and easy tool to edit your Sql queries.
ما مزایا را از طریق این آموزش کوچک خواهیم دید.
- اتصال به DB جدید:
- ذخیره پرس و جو فعلی در یک فایل:
- طرح واره پایگاه داده:
When you connect to a new database you will see a tree of its objects (queries-tables-columns).
هر ستون در درخت دارای نمادی است که نوع داده آن را توصیف می کند.
And in this tree you will see a sub-tree of functions that can be used in creating queries.
You can drag and drop table names, query names, column names, or function names from the tree to the editor.
- کلمات کلیدی رنگ آمیزی:
You will see your query nicely colored, more readable, so, even more, you can change the color to your preferences, and it will save your preferences for next time.
- اضافه کردن پارامترها:
It provides a grid for you to enter parameter names and values to use in parameterized queries.
- تکمیل خودکار:
Pressing (Ctrl + Space) provides auto-completion, the autocomplete list includes everything you can use in your query (table names, query names, column names, function names, parameter names) , if you've started typing a word, and pressing (Ctrl + Space) filters the autocomplete list so it only contains words that start with part of the word you've already entered, then you can use one of There are three ways to select what you like from the list (double-clicking it, pressing Space while it's selected, or pressing Enter while it's selected,
When you select your target from the list, it replaces part of the word you've already entered.
Whenever you don't want to use the autocomplete list shown, you can press ESC or click it.
(در ادامه در مورد درمان های فنی صحبت خواهیم کرد).
- 7. نظر دادن و اجرای بخش انتخاب شده:
MS access queries do not support commenting. Bringing information from a source, and needing to execute part of it,
In any case, the user will be a programmer and should know that he cannot use the query in the form of the editor here.
And so to "execute the selected part", I think there is no need to say more for this, all the user has to do is to select a part of the written text in the editor and execute it,
However, you can create a "single-line comment" by preceding it with a dash -- or a "multi-line comment" by putting this /* and following it with this */ (just with this / * Surround it. */ God willing)
- متن به کد:
It provides a nice tool that converts the query expression into code that can be used in either VB.Net or C#.
- صادرات خروجی به اکسل:
It provides three methods to export grid output to Excel sheet. I know one method is enough, but I wanted this tool to be more of an educational tool than a commercial or utility tool, so you'll see three ways to export data to it. Excel sheet (and there are others)
- رابط کاربری دوستانه: