VB 0.6 TreeView Control lesson Part5

Visual Basic 6 By
بسم الله الرحمن الرحيم
توقفنا فى الجزء الرابع السابق عند خواص الـ Node
و موضوع اليوم ان شاء الله عن ربط الـ Tree-view بقاعدة بيانات MS Access 2003
TreeView & MS Access2003 Database
 و المثال سيكون عباره عن : لدينا قاعدة بيانات Access 2003 سنقوم بعرض اسماء الجداول على شكل Root و اسماء الحقول على شكل Child و البيانات فى Text-boxes قابل للتعديل ( اضافة و حذف ) .
أى أننا سنقوم بعمل برنامج يقوم باستدعاء أى قاعدة بيانات Access 2003 و تعديلها كما نحب , و سنبدأ بمشروع جديد .
حيث سيكون شكل البرنامج النهائى كما بالشكل رقم (1) .
شكل البرنامج النهائى
1) قاعدة البيانات :
قم بتصميم أى قاعدة بيانات Access 2003 , فى المثال قاعدة البيانات باسم (Employees.mdb) تحتوى على جدولين (Info - Salary)
حيث Info عبارة عن 4 حقول هى
(ID P.Key Text 50 - Name Text 50 - Age Text 50 - Section Text 50)
و Salary عبارة عن 5 حقول هى
(ID P.Key Text 50 - Total Number Double - Cuts Number Double - Net Number Double - Month Date/Time)
يتم التوصيل بقاعدة البيانات باستخدام تقنية ADO 2.8 
2) الشرح :
عند بداية البرنامج تختار أى قاعدة بيانات و لتكن قاعدة البيانات التى صممناها عن طريق مفتاح Browse حيث يظهر مسارها فى TextBox ثم نضغط على Connect لتوصيلها بالبرنامج حيث تظهر محتوياتها فى الـ TreeView
عند الضغط على أى Root اذا كان به Child s يقوم بعرضهم فى مستوى أقل منه و تكون عباره عن اسماء الجداول ثم على اسم الجدول عند الضغط عليه يقوم بعرض Child فى مستوى أقل منه و تكون اسماء الحقول ثم عند الضغط على اسم الحقل اذا كان به Child تظهر فى مستوى أقل منه و تكون عباره عن القيمة التى تعرض فى الـ TextBox الثانى .
عند ظهور القيمة فى الـ TextBox يمكن تحديثها , و يمكنك اضافة الاكواد و الافكار كما تشاء حيث يمكنك عمل مشروعات كامله من هذا المثال ....
3) رابط المشروع MediaFire.com
4) اذا كان لديك أى سؤال أضف تعليق و سيتم الرد عليه ان شاء الله فى اقرب وقت

Visual Basic 6.0 Lessons, Tricks, Tutorials and help links :
- Visual Basic 6.0 TreeView Control lesson (Part1 - Part 2 - Part3 - Part4 - Part5) Arabic.
visual basic 6, vb6 source code,vb6 tutorials
My name is Ahmed Samir, I work as an Internal Auditor in a Gov. major co. My passion is in programming and blogging.

Comments

  1. AnonymousJuly 15, 2015 at 3:56 PM

    What's up to all, it's really a fastidious for me to pay a
    visit this site, it contains important Information.

    Here is my page ... ClintNStanbaugh

    ReplyDelete
  2. AnonymousJuly 15, 2015 at 4:20 PM

    If you are going for most excellent contents like I do, just go to see this site all the time as it offers
    quality contents, thanks

    My weblog - ErnestoZMcneeley

    ReplyDelete
  3. AnonymousJuly 19, 2015 at 10:12 PM

    Ahaa, its good discussion about this post here at this blog, I
    have read all that, so at this time me also commenting
    at this place.

    Also visit my web blog; CandanceMSaults

    ReplyDelete
  4. AnonymousJuly 21, 2015 at 7:07 PM

    I'm not sure exactly why but this blog is loading
    very slow for me. Is anyone else having this problem or is it a problem
    on my end? I'll check back later and see if the problem still exists.


    Look into my web page; AntoneJNiedzwiecki

    ReplyDelete
  5. AnonymousJuly 21, 2015 at 9:13 PM

    Hey there fantastic website! Does running a blog like this take a massive amount work?

    I have no knowledge of computer programming but I was hoping to
    start my own blog soon. Anyway, should you have any ideas or tips for new blog owners please
    share. I know this is off subject however I simply had to ask.
    Thanks a lot!

    Feel free to surf to my webpage ... XiomaraEHolihan

    ReplyDelete
  6. AnonymousJuly 22, 2015 at 9:11 PM

    I’m not that much of a online reader to be honest but your blogs
    really nice, keep it up! I'll go ahead and bookmark your website to come back later.
    All the best

    Visit my webpage: JacintaEStinton

    ReplyDelete
  7. AnonymousJuly 25, 2015 at 3:59 AM

    I'd like to find out more? I'd love to find out some
    additional information.

    Here is my web site - CarollKNeblett

    ReplyDelete
  8. AnonymousJuly 29, 2015 at 9:16 PM

    I am actually grateful to the holder of this web site who has
    shared this enormous paragraph at here.

    Also visit my blog - NatishaGMolima

    ReplyDelete
  9. AnonymousJuly 31, 2015 at 3:29 AM

    Hmm is anyone else experiencing problems with
    the pictures on this blog loading? I'm trying to figure out if its a problem on my
    end or if it's the blog. Any feed-back would be greatly appreciated.


    Have a look at my web blog :: LauraleeSMaedche

    ReplyDelete
  10. AnonymousAugust 1, 2015 at 6:46 AM

    Thanks for sharing your thoughts on books. Regards

    Feel free to visit my web page: TennieOBlazosky

    ReplyDelete

Post a Comment

visual basic 6 source code says (Hi)

VB6 Popular Posts

VB 0.6 TreeView Control lesson Part3

7 comments Visual Basic 6 By
بسم الله الرحمن الرحيم توقفنا فى الجزء الثانى السابق عند خاصية LabelEdit . و موضوع اليوم ان شاء الله عن خاصية SelectedItem " اذا لم تكن قد قمت بتحميل المشروع " SelectedItem Property - خاصية العنصر المختار و موضوع اليوم ان شاء الله عن خاصية SelectedItem أو العنصر المختار و هى خاصية من خصائص الـ ActiveX Control عموما و لكن فى TreeView تشير الى Nodes و هى العناصر التى يمكن اختيارها . الــــــــكود : Object.SelectedItem حيث Object تشير الى Node . - و عند تنفيذ SelectedItem فانه يعود بقيمة هى العنصر التى تم اختيارة من مجموعة العناصر . - مثال : حذف جميع الـ Nodes المختاره و التى ليست Root . اضف مفتاح Command للـ TreeView4 باسم Delete Child Nodes و الصق الكود التالى فى الحدث Click ' If the selected object is not the root, then remove the Node. If TreeView4.SelectedItem.Index <> 1 Then Treeview4.Nodes.Remove TreeView1.SelectedItem.Index End If   قم بتجريب المشروع و اختار اى Node من TreeView4 ثم اضغط على Command باسم De
Visual Basic 6.0

vb6 ms-access 2003 design phonebook 2

Post a Comment Visual Basic 6 By
Image
MS-Access 2003 Database design vb6 MS Access 2003 Database Design for Phonebook project In this part of the tutorial we will design the database according to the VB6.0 Project Requirements , we have 3 TextBoxes and 1 Image control, so we will need 4 fields in the database table. We will create only one table because there is no need to create two, just simply like that. Note, there are several ways to store data from Visual Basic windows application project on the hard drive, using MS-Access 2003 is one of the easiest ways to accomplish this task, considering your are creating a personal windows desktop application, also it is a very handy and effective method considering creating this application for some else (client). If you don't have Microsoft Access 2003, then download it included in MS Office 2003 package from Microsoft. Access 2003 Database is the most well known database ever used with Microsoft Visual Basic 6. Microsoft Access 2003 (*.mdb) file capacity is 2GB, of course
Visual Basic 6.0

Free download Visual Basic 6 Documentation MSDN

Visual Basic 6 By
Image
Free download Visual Basic 6 Documentation MSDN Free download Visual Basic 6 Documentation MSDN What is visual basic 6 MSDN ? It stands for Microsoft Developer Network. How is VB6 MSDN useful ? It is a collection of sites ( msdn.microsoft.com ) for the developer community that provide information, documentation, and discussion that is authored both by Microsoft and by the community at large. Recently. It is available in many languages. Online Visual Basic 6 (vb6) MSDN link at Microsoft.  Here Online Visual Basic 6 (vb6) MSDN previous version .  Here Download Visual Basic 6 (vb6) MSDN. vb6 MSDN CD1 (DN60AENU1) zip  109.05MB(Password: vb6access2003.blogspot.com) vb6 MSDN CD2 (DN60AENU2) zip  537.32MB (Password: vb6access2003.blogspot.com) Download Visual Basic 6 (vb6) Samples.  Here Download Lou Tylee best seller book - VB 0.6.pdf  Here ♥   Visual Basic 6.0 Course Online : Automate MS-Access Database in Visual Basic 6.0  though a net work Visual Basic 6.0 An
Visual Basic 6.0