Search VB 2010

Saturday, November 02, 2013

VB 2010 Advantage Database Example

Sybase Advantage Database With Visual Basic 2010

Update Sybase Advantage Database using XML file from Visual Basic 2010 [Client-Server] Idea.
Update Sybase Advantage Database using XML file from Visual Basic 2010 [Client-Server] Idea.
1. Create New VB2010 Windows Application Project
2. Path to Project (I.e. D:\MySyBase\)
3. Path to Database (I.e. D:\MySyBase\Bin\Debug)
4. Sybase Advantage Database (MyDB.add)
5. Sybase Advantage Database Username : AdsSys - Password : ahmed
6. Sybase Advantage Database Table (I.e. MyInfo.adt)
We will create a personal Info application, so the table structure will be like that :
Sybase Advantage Database
Visual Basic 2010 - Sybase Advantage Database
Note : All other fields will vary in [Size] only but all fields are [cicharacter] Data Type.

Visual Basic Form Deign :
Visual Basic 2010
Visual Basic Online Courses
Note : I have made TextBoxes with Naming convenient (I.e NameTxt, EmailTxt, MobileTxt .... etc). Also I've placed 1 DataGridView and some Buttons. I also have 1 Module [Module1].

SaveBtn : Save new record to the Advantage Database
SearchBtn : Search for records using by Sname
EditBtn : After search, edits the record
DeleteBtn : After search, deletes the record
CancelBtn : Reset the form and the DataGridView
ExitBtn : Exits the application

In order to use Sybase Advantage Database with Visual Basic 2010 and just like any other Database, you must call the References to the Database :
Visual Basic 2010 - Add Reference to Sybase Advantage Database

The Codes
Module1

Form1
Sub ClearAll()
Private Sub Form_Load()
Private Sub ExitBtn_Click()
Private Sub SaveBtn_Click()
Private Sub SearchBtn_Click()

Private Sub CancelBtn_Click()
Private Sub EditBtn_Click()
Private Sub DeleteBtn_Click()

Note : You will need 2 Pictures PNG [On : Off] to refer to the Database Status, path [..Bin/Debug].

Another Lesson : How to Remote Database using XML :

1) Create an XML file in path [.\bin\Debug\] Folder and call it [XmlFile.xml]
2) Open [XmlFile.xml] with NotePad.exe and paste the following code into it :

3) Save the Xml file.
4) Open our VB 2010 Project and add a ToolStrip to the Form1, Dock = Buttom
ToolStrip VB 2010 Xml Database Update
ToolStrip VB 2010 Xml Database Update
5) How does it work "The Main Idea" : When you want to Alter structure or Edit the Advantage Database of your Advantage Database "DB.Add" on a Client's "User's" computer you will need to do something like what I did, easy and guaranteed. Find a Server and send SQL Statements to the Xml File and when the user checks for update [Check For Update] button, the application will open the XmlFile.xml and execute the Sql-Statement within, simply like that. When you use Version Number along with the update, it makes the Update process so easy to be tracked, so we will need to create and extra Database Table in the Advantage Database and call it [DB_Version].
6) DB_Version table structure :
Update Advantage Database [MyDB.Add] using XML and Visual Basic 2010
Update Advantage Database [MyDB.Add] using XML and Visual Basic 2010
Note : UpdateDT column is Date DataType.
7) Now each time you send updates to XML file, the user Checks for update and choose the XML file from Open Dialog Box and it compares the Date and Version of the Update, if New then it executes the Sql Statement line, if not, then it gives message [MsgTxt.Text] You're Up-To-Date.
8) Download Example from MediaFire.com [Testing.ZIP]

AdsConnection GetSchema tip :

How to retrieve Advantage Data Dictionary Schema in VB 2010.
VB 2010 GetSchema - Retrieve Tables, Columns From Ads Data Dictionary (AdsConnection)

Advantage DataTypes conversion in VB 2010

Type

Length

Available in DBF Table

VB 2010 Value

Character
1 to 65530
Yes
4
CICharacter
1 to 65530
No
20
Date
4
Yes
3
Logical
1
Yes
1
Memo
9
Yes
5
Double
8
VFP, Extended
10
Integer
4
VFP, Extended
11
Numeric
2 to 32
Yes
2
Image
9
Extended
7
Binary
9
Extended
6
ShortInteger
2
No
12
Time
4
No
13
TimeStamp
8
No
14
AutoIncrement
4
No
15
Raw
1 to 65530
No
16
CurDouble
8
No
17
Money
8
No
18
ModTime
8
No
22
RowVersion
8
No
21

Best Use, For example :
When you try to Retrieve Advantage Data Dictionary Table Structure you will get column names, and you will may need to retrieve Data Types [Field_Type], Advantage Data Arc. provides System.Columns Field_Type column within the System.Columns Table that return values like [Character], now when you do that in Visual Basic 2010 or any Visual Basic .Net version, you will not get [Character] but you will get [4] instead and you will want to convert it into [Character] name, you can do that using a function or a Select Case expression in VB 2010.
So, in order to retrieve Field_Type or DataType of a certain column in Advantage Database, you may use this code:

Some Exceptions and Errors noticed :

Error : 
Table doesn't appear in the Data Dictionary [ARC.exe] but though it appears in the Data Dictionary Folder.
Description :
When you try to create a free Table [ADT Table] using Sql Statement from VB 2010 like this. The result will be a free Table but not included in the Data Dictionary, but you will only see it in the Folder contains the Database.
Cause :
The User Id section in the connectionString is Empty, but if you tried to create another table with the same name you will get an Error specifying that ISAM found a table with the same name "Table already exists" though it doesn't appear in the Data Dictionary.
Solution :
Provider a User ID or a User Id and Password if possible in the connectionString Whether you are using OleDBConnection or AdsConnection to work with this Data Dictionary.

Here are some online Visual Basic lessons and courses :

Sunday, August 11, 2013

Visual Basic Online Course FlexGrid

Visual Basic 2010 - FlexGrid

Visual Basic 2010 FlexGrid
Visual Basic 2010 FlexGrid
The Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid displays read-only data.

You can put text, a picture, or both, in any cell of an MSFlexGrid. The Row and Col properties specify the current cell in an MSFlexGrid. You can specify the current cell in code, or the user can change it at run time using the mouse or the arrow keys. The Text property references the contents of the current cell.

If the text in a cell is too long to display in the cell, and the WordWrap property is set to True, the text wraps to the next line within the same cell. To display the wrapped text, you may need to increase the cells column width (ColWidth property) or row height (RowHeight property).

Use the Cols and Rows properties to determine the number of columns and rows in an MSFlexGrid.

Note : Before you can use an MSFlexGrid in your application, you must add the MSFlxGrd.ocx file to your project. To automatically include the file in your project, put it in the Autoload file. When distributing your application, you should install the MSFlxGrd.ocx file in the users Microsoft Windows System directory. For more information about adding an ActiveX control to a project, see "Standard ActiveX Controls" in the Visual Basic Programmers Guide.

How to add a FlexGrid component to Visual Basic .Net Form ?

- MSFLXGRD.OCX is a COM not a Net component but it can be added to a .Net Form in Visual Basic 2010 and work with it. In order to do so :

1) Open Visual Basic 2010 - New Project - Windows Form Application
Visual Basic 2010 Online Courses Free
Visual Basic Windows Form Application
2) Make sure you are displaying the design mode of the Form1.vb, to be able to choose components
Visual Basic 2010 online courses free
Visual Basic 2010 Form Design Mode
3) From Tools at the left side of the form, right-click anywhere and there will be a list, choose [Choose Items....]




Visual Basic Online Courses
Visual Basic 2010 Tools - Add FlexGrid
4) You will notice a new dialog box is opened where you get to pick up .Net components and Com components, click on the Tab with COM Components, then navigate to [Microsoft FlexGrid Control].

FlexGrid in VB2010 .Net
Visual Basic 2010 - Adding FlexGrid to Form
5) Click OK. Now from Tools, navigate to the end of the current section and you will file [Microsoft FlexGrid Control], just drag it on the Form or Double-Click it to be placed automatically on the Form
Visual Basic Online Courses
FlexGrid in VB2010 .Net Form
6) Now you successfully placed a COM component on .Net Form. Visual Basic 2010 will automatically convert this COM component into .Net component when Building your application.

Here are some online Visual Basic lessons and courses :

Monday, July 01, 2013

Visual Basic Online Course OOP Classes

Visual Basic Application Development
Object Oriented Programming 

Introduction

After creating so much applications and working with Databases, I was always afraid of getting close to OOP (Object Oriented Programming). OOP is the essence of Programming languages, understanding OOP is a sign which tells you "You are a talented programmer". 

We all know that there is a difference between programming practitioner and freelancer programmer, some say that practitioners are much secure, they don't need to learn more to get paid because they already have a job, but a freelancer is a guy who is talented in something (In this example : Programming) and in addition he/she wants to make something out of it.
VB 2010 OOP
VB 2010 OOP
OOP or Object Oriented Programming, means programming the programming, Yes! Before studying OOP we used to write codes and place tools, then hoke them up together to come up with something magnificent for ourselves or for our clients for money or some school degrees as a project.

No client will ever ask you to create a programming tool for him, or to modify a built-in tool for him, unless he is another programmer trying to sell something over the internet, if you ever worked in a freelance agency such as for example Freelancer.com, Odesk.com or Vworker.com those and others are major hiring websites for freelancers, not just in programming field but in so much things.

Each and every desktop application written and designed in Visual Basic .Net includes for most of us, basic interfaces : The form, the controls on the form, coding the controls, packing all above, to come up in the end with an application, well this is not exactly how it works in OOP programming.

In OOP programming you create your own everything from scratch to start using it in your form or coding controls on the form or creating controls (TextBoxes, Labels, ..... etc.) for yourself for later work. OOP is written within a Class.

Since .Net Framework started, and almost everything in Visual Basic became a separate Class of its own. Notice when you open the form to write a code, the first line says (Public Class Form1) then in the end (End Class).

A Class is the mother and the father of each and single object in Visual Basic .Net, everything you see in Visual Basic .Net came from a Class. To create a Class, you need to need to create a Class, I'm not kidding, I mean it, if you want to create a Class in your project then you must need one unless it won't make any sense, since logic is key stone and the only motivation for programmers to start designing coding, and Classes is one of those jobs as designing and coding then logic (The need for creating a Class) must be present in order to succeed and make sense.

VB 2010 OOP
VB 2010 OOP

When do we need to create a Class for our Visual Basic .Net Project ?

If you are trying to create your own Textbox or label, or if you are generally trying to create your own Visual Basic .Net Control, then you are definitely in need for a Class, as a result, you need to know OOP.

If you developed a method with a 3rd party for example, and you need to always include this method in further applications, then you need to create a Class for yourself, and also as a result you will have to learn and read about OOP.

Last thing, the basic thing to need to create a Class is when you are trying to contain your code blocks into a container for further development, then you need a Class.

VB 2010 OOP
VB 2010 OOP
Yes, all we need now is an example of a Class to start working. See you next chapter.

Here are some online Visual Basic lessons and courses :

Visual Basic Courses - Share