SKOTechLearn Tips

Find Duplicate Items in Excel Tips

noreply@blogger.com (SKOTechLearn) — Wed, 29 Jun 2022 21:34:00 +0000

Suppose, we have records containing duplicate values. And we want to find records that can repeat many times in records in Excel. So, In MS Excel tools provide following way to find Duplicate value in Excel or Find Duplicate in Excel.

Find Duplicate through Simple Process in Excel

Find Duplicate with Custom Color or Style in Excel

Find Duplicate through Function in Excel

Find Duplicate Row in Excel Using Formula

So, Lets start with every option in given above with following steps:

(1). Find Duplicate through Simple Process in Excel :

For Simple Process, you have to follow the steps:

Select All Rows And Columns in Which you want to find duplicate items.

Find “Conditional Formatting” option from “Home” Tab.

Click on “Conditional Formatting”, it will show popup List Containing many options.

Go to “Highlight Cells Rules”. It also shows a list of Option. Click on “Duplicate Values..” option.

This will show “Duplicate Vales” window. Contains options and Color indicator for duplicate value.

After Selecting desire color. Click on “OK” button. This will highlight duplicate values or items with chosen color.

As you can see, there will be colored cells of duplicate items in MS Excel.

(2). Find Duplicate with Custom Color or Style in Excel :

If you want to change Duplicate Item’s cell’s color, border or font then, you have to follow steps:

First Select All Rows and Columns in which you want to indicate duplicate values or items.

In “Conditional Formatting” click on “New Rule…” from it.

This will display “New Formatting Rule” dialog.

Select “Format only unique or duplicate values”. After this option selection, press “Format…” button. This will show “Format Cells” dialog.

If you want to Change Font Name, Size or Font Color then go to “Font” Tab. If you want to change border Style then go to “Border” Tab. If you want To change cell’s background color then go to “Fill” Tab.

After that press “OK” button from “Format Cells” dialog. Then press “OK” button from the dialog of “New Formatting Rule”.

This steps show Duplicate Items in different style like bellow:

This way you can Highlight Duplicate in Excel.

(3). Find Duplicate through Function in Excel :

Now if you want to find duplicate items through custom rules applying with formula. Then we have to use “COUNTIF” function like following steps:

Same as above Go to “Conditional Formatting” then click on “New Rule…”.

This will show “New Formatting Rule” dialog. Here we select “Use a formula to determine which cells to format”. After selecting this, “Format values where this formula is true:” Formula Box will appear.

The duplicate formula function Syntax is :

=COUNTIF (range, criteria)>1

Details:

=COUNTIF(Selection Of Rows and Columns, Selection For Which cell will be count) > 1

Example:

=COUNTIF($A$2:$B$11, A2:B11) >1

Then click on “Format…” button for color and style of duplicate items. Then click “OK” button.

This process will also show duplicate items with style and color.

(4). Find Duplicate Row in Excel Using Formula :

Suppose, you want to check duplicate Row in Excel not duplicate cell. Then you have to use same process as describe above but using different formula “COUNTIFS” with following steps:

Same as above Go to “Conditional Formatting” then Click on “New Rule…”.

This will show “New Formatting Rule” dialog. Now go to the option “Use a formula to determine which cells to format”. After Selecting this, “Format values where this formula is true:” Formula Box will appear.

Write formula as describe below:

=COUNTIFS($A$2:$A$11, $A1, $C$2:$C$11, $C1)>1

This will show Duplicate Row in Excel.

So, In this way we can find the duplicate items in Excel and Duplicate rows in Excel and find Duplicate in Excel with easy tech tips.

Excel Filter Types And Use Filter in Excel Tips

noreply@blogger.com (SKOTechLearn) — Sat, 25 Jun 2022 20:54:00 +0000

In MS Office, you will find that there is many features which provide easy data handling for any company or concern. So here we will discuss and learn about Types of Filter in Excel and Use Excel Filter with easy tech tips. In MS Office, Excel provide many advanced features.

Shortcut Key : ( Ctrl + Shift + L) or ( Ctrl + Shift + l) for Add Filter in Excel Column or Remove Filter in Excel Column.

Find Filter Option In Excel :

First When you open excel sheet, you will find that your excel file open with “Home” tab. This tab contain some option.

1. Find ‘Editing’ option from this tab.

2. ‘Editing’ option contain many options (‘AutoSum’, ‘Fill’, ‘Clear’, ‘Sort & Filter’, ‘Find & Select’).

3. Here, you will click on ‘Sort & Filter’ Option. This will Show Options List. Select ‘Filter’ option.

1. Find “Data” Tab from menu. This Tab contain many option.

2. Go to “Sort & Filter” Option. And Select “Filter” option.

3. This will add filter button on every Column Header as describe above image.

4. When you click on this button, it will show popup window containing filter option. Like above image. And when you apply filter then the Filter Button icon will change.

Here are following excel filter types:

Manual Filters

Text Filters

Numbers Filters

Filter by Color in Excel

Now Lets Start with Point to Point and step by step to understand amazing feature of filters.

(1). Manual Filters :

If you want to set filter manually, then there is a list will popup when you click on Filter button containing particular column record.

First remove check from “Select All”.

Or Clear tick mark from all Check Boxes. Then check that items which you want to show like bellow.

As you can see, the output will appear in desire filter selection base.

(2). Text Filters :

In this filter, if table column's rows contain string or alphanumeric value then this filter automatic show "Text Filters" option after clicking on filter button on particular column.

This Filter have many options. The details and steps are as follows:

Equal Filter in Excel :

1. In this filter select "Equal" option.

2. Input your filter value or string in "Custom AutoFilter" window's Textbox.

3. Then click on "OK" button.

And the output will look like above.

Begins With Filter in Excel :

If you want to show data that contain starting character then this filter is helpful.

1. Click on "Begins With..." option from "Text Filters".

2. Then once again Input some part or the beginning of string in TextBox which is in the side of Type Combobox with "begins with" option.

Ends With Filter in Excel :

If you want to show records according to containing last character. Then this filter will help.

1. Click on "Ends With..." option from "Text Filters".

2. Then once again Input some character that end with that string which you want to filter in TextBox which is in the side of Type Combobox with "Ends with" option.

Contains Filter in Excel :

This is the most used filter in business area. If you want to search records or list of all record that have match any character of that particular cell's then this will help.

1. Click on "Contains.." option from "Text Filters".

2. Then once again Input some character that will be exist in string which you want to filter in TextBox which is in the side of Type Combobox with "contains" option.

(3). Numbers Filters :

In this filter we will learn some filters which is mostly used. This filter will apply on That Column which have a list of Number or Numeric values.

Greater Than Filter in Excel :

Suppose, there is a list of Numbers, in which you want to find Greater Numbers list with given filter number. Then this filter will help.

1. Click on "Greater Than..." option from "Number Filters...".

2. Then input number in "Custom AutoFilter" dialog, which will filter greater number.

Less Than Filter in Excel :

Suppose, there is a list of Numbers, in which you want to find Less Numbers list with given filter number. Then this filter will help.

1. Click on "Less Than..." option from "Number Filters...".

2. Then input number in "Custom AutoFilter" dialog, which will filter Less number.

Between Filter in Excel :

Between filter will apply when you input Greater Than value and Less Than Value in filter like below. This will show the Between Filter Output describe in image.

1. Click on "Between..." option from "Number Filters...".

2. Then input number in "Custom AutoFilter" dialog, which will between the greater than or equal And less than or equal number of given input value.

(4). Filter by Color in Excel:

Here we can filter records by particular color selection. Following Image will describe how it will work?

Note: This filter will work only when cells contain background color on particular column's rows.

1. For this filter you have to click on "Filter by Color" option.

2. Choose whatever color's record want to show like below.

Show Records from particular Column's rows color in Excel.

So, these are the Types Of Filter in Excel and How to Use Excel Filter with step by step process.

How to Add Columns and Items in TreeView in Python Tkinter

noreply@blogger.com (SKOTechLearn) — Sun, 19 Jun 2022 08:32:00 +0000

If you want to show items in rows and columns like table, tkinter provide Treeview widgets in python. This widget is use as Listview for display records. So here we learn Listview in Python or How to add Column Hearder in Treeview in Python Tkinter or How to add items in Treeview in Tkinter python?

Now, we will cover following points that will solve all given questions.

Add Column in TreeView in Tkinter Python

Set Column width in TreeView in Tkinter

Set Treeview Column color in tkinter

Add Items in Treeview in Tkinter

Tkintter Treeview Row Color in Python

So, here we use Treeview as Listview in Tkinter with following way:

(1). Add Column in TreeView in Tkinter Python :

Now, let’s see how we add columns with names with different ways in python.

Fist Way:

from tkinter import *
from tkinter import ttk

TrvFrm = Tk()

MyTrv = ttk.Treeview(TrvFrm, columns=('Column1', 'Column2', 'Column3'), show='headings')

MyTrv.heading('MyCl1', text='SKID')
MyTrv.heading('MyCl2', text='SKName')
MyTrv.heading('MyCl3', text='SKFName')

Second Way:

from tkinter import *
from tkinter import ttk

TrvFrm = Tk()

MyTrv = ttk.Treeview(TrvFrm, show='headings')
MyTrv['columns']=('MyCl1', 'MyCl2', 'MyCl3')

MyTrv.heading('MyCl1', text='SKID')
MyTrv.heading('MyCl2', text='SKName')
MyTrv.heading('MyCl3', text='SKFName')

You can choose any one of them and proceed for further Process, So, Let’s see what will happen?

Show Columns in TreeView in Tkinter

Now, here we will put complete code with output as follows:

from tkinter import *
from tkinter import ttk

TrvFrm = Tk()
TrvFrm.title('TreeView Column Header')
TrvFrm.geometry('305x110')

MyTrv = ttk.Treeview(TrvFrm, columns=('MyCl1', 'MyCl2', 'MyCl3'), show='headings')

MyTrv.heading('MyCl1', text='SKID')
MyTrv.heading('MyCl2', text='SKName')
MyTrv.heading('MyCl3', text='SKFName')

MyTrv.pack(side=TOP, fill="both", expand=True)

TrvFrm.mainloop()

When you run this code, it will show Form including Treeview with columns in python.

(2). Set Column width in TreeView in Tkinter :

If you want to set or fix Column width at run time then you have to write code like:

MyTrv.column('MyCl1', width=40)
MyTrv.column('MyCl2', width=50)
MyTrv.column('MyCl3', width=70)

Ok, we will insert this code in our existing above code.

from tkinter import *
from tkinter import ttk

TrvFrm  = Tk()
TrvFrm .title('TreeView Column Header')
TrvFrm .geometry('300x100')

MyTrv = ttk.Treeview(TrvFrm, show='headings')

#Create Column
MyTrv['columns']=('MyCl1', 'MyCl2', 'MyCl3')

#Set Column Name
MyTrv.heading('MyCl1', text='SKID')
MyTrv.heading('MyCl2', text='SKName')
MyTrv.heading('MyCl3', text='SKFName')

#Set Column Width
MyTrv.column('MyCl1', width=40)
MyTrv.column('MyCl2', width=50)
MyTrv.column('MyCl3', width=70)

MyTrv.pack(side=TOP, fill="both", expand=True)

TrvFrm.mainloop()

After running this code her we find output:

As you can see, we adjust the treeview Column width in tkinter according to need.

(3). Set Treeview Column color in Tkinter :

If you want to change Tkinter Treeview column color like Background color or foreground color and also want to change Treeview Column Font size in Tkinter or Treeview Column Font Name in Tkinter. Then just add Tkinter ttk style on your code.

mytkstyle = ttk.Style()
#Treeview Style in tkinter with Column Color with Font Size and Font Name
mytkstyle.configure("Trstyle.Treeview.Heading", background='#ffedd4', foreground='#f38755', font=('Georgia', 10,'bold'))

#Add ttk style on treeview
MyTrv = ttk.Treeview(TrvFrm, show='headings', style="Trstyle.Treeview")

Now, just add above given code and implement code like bellow given example:

from tkinter import *
from tkinter import ttk

TrRoot = Tk()
TrRoot.title('TreeView Column Header')
TrRoot.geometry('300x100')

mytkstyle = ttk.Style()

mytkstyle.configure("Trstyle.Treeview.Heading", background='#ffedd4', foreground='#f38755', font=('Georgia', 10,'bold'))

TkTree = ttk.Treeview(TrRoot, show='headings', style="Trstyle.Treeview")
TkTree['columns']=('MyCl1', 'MyCl2', 'MyCl3')

TkTree.heading('MyCl1', text='SKID')
TkTree.heading('MyCl2', text='SKName')
TkTree.heading('MyCl3', text='SKFName')

TkTree.pack(side=TOP, fill="both", expand=True)

TrRoot.mainloop()

Now the above code is ready for display following output with different color of width of column after executing code:

Add items in Treeview in Tkinter Python

Add items in Listview in Tkinter

(4). Add Items in Treeview in Tkinter :

Here we add some items or records in Treeview as Listview in Tkinter using ‘insert’ command. You can add items manually or through Loop as describe bellow:

(a) Add Items in Treeview in Tkinter manually :

from tkinter import *
from tkinter import ttk

TrvFrm  = Tk()
TrvFrm .title('TreeView Column Header')
Trv = ttk.Treeview(TrvFrm, show='headings')
Trv['columns']=('Clm1', 'Clm2', 'Clm3')

Trv.heading('Clm1', text='SKID')
Trv.heading('Clm2', text='SKName')
Trv.heading('Clm3', text='SKFName')

Trv.insert('', END, values=('1', 'SKO', 'AAAAAAA'))
Trv.insert('', END, values=('2', 'Tech', 'BBBBBB'))
Trv.insert('', END, values=('3', 'Learn', 'CCCCCCCC'))


Trv.pack(side=TOP, fill="both", expand=True)

TrvFrm.mainloop()

Output:

(b) Add Items in Treeview in Tkinter through Loop :

Suppose you want to add some items through loop in Treeview then here we use 'for' loop in python for insert records in treeview tkinter.

from tkinter import *
from tkinter import ttk

TrvFrm  = Tk()
TrvFrm .title('TreeView Add Itmes through Loop')

MyTrv = ttk.Treeview(TrvFrm, columns=('MyCl1', 'MyCl2', 'MyCl3'), show='headings')

MyTrv.heading('MyCl1', text='CLID')
MyTrv.heading('MyCl2', text='CLName')
MyTrv.heading('MyCl3', text='CLFName')

for sn in range(1, 6):
    MyTrv.insert('', END, values=('MyIDs'+ str(sn), 'MyName'+ str(sn), 'FName'+ str(sn)))

MyTrv.pack(side=TOP, fill="both", expand=True)

TrvFrm.mainloop()

Output:

(5). Tkinter Treeview Row Color in Python :

Now, the next step to add color in rows according to desire. For it, we will use, 'ttk.Style' for color and 'tag_configure' for treeview widget for apply color. Now here we use following code for better look of treeview as Table in tkinter.

ttk style in Treeview in tkinter

Example:

from tkinter import *
from tkinter import ttk

TrvFrm = Tk()
TrvFrm.title('TreeView Row Color')
TrvFrm.geometry('300x150')

style = ttk.Style(TrvFrm)

# ttk Style theme
style.theme_use("default")

# Set treeview Row Colomn Color
style.map('Treeview', background=[('selected', '#BFBFBF')])

MyTrv = ttk.Treeview(TrvFrm, columns=('MyCl1', 'MyCl2', 'MyCl3'), show='headings', selectmode = 'browse')
MyTrv.column("#0", width=60, minwidth=30, stretch=NO)
MyTrv.column("MyCl1", width=80, minwidth=20, stretch=NO)
MyTrv.column("MyCl2", width=100, minwidth=30, stretch=NO)
MyTrv.column("MyCl3", width=100, minwidth=30, stretch=NO)

MyTrv.heading('MyCl1', text='CLID')
MyTrv.heading('MyCl2', text='CLName')
MyTrv.heading('MyCl3', text='CLFName')

# Set treeview row font color or foreground color
MyTrv.tag_configure('Cl1', background = '#f9fbdb', foreground = '#c26981')
MyTrv.tag_configure('Cl2', background = '#fbdbf1', foreground = '#6f9594')

for sn in range(1, 6):
    if (sn % 2) == 0:  
        MyTrv.insert('', END, values=('MyIDs' + str(sn), 'MyName' + str(sn), 'FName' + str(sn)), tags = 'Cl1')
    else:  
        MyTrv.insert('', END, values=('MyIDs' + str(sn), 'MyName' + str(sn), 'FName' + str(sn)), tags = 'Cl2')

MyTrv.pack(side=TOP, fill="both", expand=True)

TrvFrm.mainloop()

After that, we will find a colorful listview or treeview as given in following output:

These are the tips and way to show data in treeview in tkinter. And you can choose color of tkinter treeview according to need for your project. If you follow above given point then you can create an application with showing data in table model with desire color. So, this is the way to Add Columns in treeview tkinter or Add items in Treeview in Tkinter or Style treeview in tkinter.

Style and Use Entry Box in tkinter and TextBox in tkinter

noreply@blogger.com (SKOTechLearn) — Sun, 18 Jul 2021 07:05:00 +0000

If you want to use Entry Box in tkinter and TextBox in tkinter or you can say that tkinter Entry Widget and tkinter Text Widget. So, here we describe following way to use or Style EntryBox or Style TextBox in tkinter. The Text or Entry widget Style will be defined in following points.

Create and Set Location and Size of Entry or Text Widget in tkinter

Set Color of Entry or Text in tkinter

Set Selection Background and Foreground Color of Entry or Text in tkinter

Text or Entry Box Font Setting in tkinter

Text or Entry Border Style in tkinter

Now, here we learn interesting way to style widget in tkiter.

(1). Create and Set Location and Size of Entry or Text Widget in tkinter :

Now, if you want to set particular control or widget in desire location of window and want to set Entry box Height and Width in tkinter then we use “place” method in following way:

from tkinter import *  

TkFrm = Tk()
TkFrm.geometry("250x200+500+400")
TkFrm.title('Entry Box or Text Box Location And Size in Tkinter')
#Create Entry Box
MyEntryBox1 = Entry(TkFrm)
#Set Entry Widget Location and Size in Form
MyEntryBox1.place(x=14, y=30,  width=256, height= 35)
#Add Text to Entry Widget in Python
MyEntryBox1.insert(END, 'SKOTechLearn')

#Create Entry Box
MyTxtBox = Text(TkFrm)
#Set Text Widget Location and Size in Form
MyTxtBox.place(x=14, y=90, width=256, height=50)
#Add Text to Text Widget in Python
MyTxtBox.insert(END, 'SKOTechLearn')

TkFrm.mainloop()

Here we add some text in both widgets in python tkinter. And after running it will show output:

This way we can increase or decrease height and width of tkinter widgets.

(2). Set Color of Entry or Text in tkinter :

Here, we set Background, Foreground, Border Selection color or Entry Box or Text Box in Tkinter.

Following method will use for color setting in tkinter:

Method	Details
bg or background	Use for Background color of Widgets
Fg or foreground	Use for Font color of widgets
highlightbackground	This method is use for Border color
highlightcolor	This method is use for border color when focus on entry or text widget.

Entry And Text Widget Color Setting in tkinter:

When you want to apply border color change when lost focus and got focus, and want to change font and back color, you have to apply and write following code:

from tkinter import *  

TkFrm = Tk()
TkFrm.geometry('290x200+500+300')
TkFrm.title('Entry Box or Text Box Color Setting in Tkinter')

#Set Entry Widget Color and Border Color
MyEntryBox1 = Entry(TkFrm, highlightcolor = 'green', bg='#F3FEFF', fg='red', highlightbackground='red')

#Set Widget Location and Size in Tkinter
MyEntryBox1.place(x=14, y=30,  width=256, height= 35)
#Add Text to Entry Widget in Python
MyEntryBox1.insert(END, 'SKOTechLearn')

# Text Widget Color and border Color in Tkinter
MyTxtBox = Text(TkFrm, highlightcolor = 'blue', highlightbackground='brown', fg='Navy', bg='#FFEFE7')
#Set Widget Location and Size in Form
MyTxtBox.place(x=14, y=90, width=256, height=50)
#Add Text to Text Widget in Python
MyTxtBox.insert(END, 'SKOTechLearn')

TkFrm.mainloop()

When you execute this code, and when you focus on widget, it will change the border color as describe bellow image.

(3). Set Selection Background and Selection Foreground Color of Entry or Text in tkinter :

If you want to change Selection Color, when you select String or Value in Entry or Text Box, then you have to use ‘selectbackground’ for selection back color and ‘selectforeground’ for selection font color.

from tkinter import *  

TkFrm = Tk()
TkFrm.geometry('290x200+500+300')
TkFrm.title('Entry Box or Text Box Selection Color in Tkinter')

#Selection Color Setting in Tkinter Entry Widget
MyEntryBox1 = Entry(TkFrm,  selectbackground='yellow', selectforeground='green')
MyEntryBox1.place(x=14, y=30,  width=256, height= 35)
MyEntryBox1.insert(END, 'SKOTechLearn')

#Selection Color Setting in Tkinter Text Widget
MyTxtBox = Text(TkFrm, selectforeground='yellow', selectbackground='red')
MyTxtBox.place(x=14, y=90, width=256, height=50)
MyTxtBox.insert(END, 'SKOTechLearn')

TkFrm.mainloop()

Output:

(4). Text or Entry Box Font Setting in tkinter :

Now, lets see the code, how to change font in Entry widget in tkinter or change font in Text widget in tkinter. Or Change the font size in tkinter widgets.

from tkinter import *  

TkFrm = Tk()
TkFrm.geometry('290x200+500+300')
TkFrm.title('Entry Box or Text Box Font Setting in Tkinter')

#Font Settings in tkinter
MyEntryBox1 = Entry(TkFrm,  font='Verdana 12 bold')
MyEntryBox1.pack()
MyEntryBox1.insert(END, 'SKOTechLearn')

#Font Settings in tkinter
MyTxtBox = Text(TkFrm, font='Georgia 13 italic bold')
MyTxtBox.pack()
MyTxtBox.insert(END, 'SKOTechLearn')

TkFrm.mainloop()

Output:

(5). Text or Entry Border Style in tkinter :

Now, let’s find the last point to change Border Style in tkinter widgets. Can use following method in you code. You can change style of Text Widget Border in tkinter or Entry Widget Border in Tkinter.

Method	Details
relief	Change Border Style (raised, sunken, solid, flat, ridge, groove)
highlightthickness	Change Border width when widget gain focus
borderwidth	Change Border Width

Lets find code:

from tkinter import *  

TkFrm = Tk()
TkFrm.geometry('290x200+500+300')
TkFrm.title('Entry Box or Text Box Border Setting in Tkinter')

#Tkinter Widgets Border Setting
MyEntryBox1 = Entry(TkFrm,  relief='raised', highlightthickness=1, borderwidth=2)
MyEntryBox1.pack()
MyEntryBox1.insert(END, 'SKOTechLearn')

#Tkinter Widgets Border Style
MyTxtBox = Text(TkFrm, relief='sunken', highlightthickness=1, borderwidth=2)
MyTxtBox.pack()
MyTxtBox.insert(END, 'SKOTechLearn')

TkFrm.mainloop()

Output:

So, this way you can change Enty Widget Style in Tkinter or Text Widget Style in Tkinter.

PySide Center Screen and Window State Maximized in PySide

noreply@blogger.com (SKOTechLearn) — Mon, 05 Jul 2021 07:19:00 +0000

As you know PySide provide stylish GUI comparing Tkinter and feature rich QT base application. So first, here we learn how to set Center Screen window in Pyside in Python? And also we learn Window State Maximize in Pyside in Python. Here we also include how to Set window title in PySide?

Let’s find it in following points:

Set window Size in PySide6 and Set Window Location in PySide6

Python Center Screen Window in PySide6

Set Window State Maximized in PySide6

Set Window Title in PySide6

How to Set Center Screen in Tkinter and Set window size in Tkinter?

(1). Set Window Size in PySide6 and Set Window Location in Pyside6 :

Suppose, you want to create a Form using PySide and want to display at run time with specific size with specific location on screen. Then here PySide provide ‘setGeometry’ or ‘move’ and ‘resize’ function. The syntax is used in following way:

‘setGeometry’ Syntax:

MainForm.setGeometry(Form_Left, Form_Top, Form_Width, Form_Height)

Example:

from PySide6.QtWidgets import QMainWindow, QApplication

SKapp = QApplication()
MyPyForm = QMainWindow()

#Set Form's Location and Size
MyPyForm.setGeometry(150, 100, 330, 250)

MyPyForm.show()

SKapp.exec()

‘move’ Syntax:

MainForm.move(Left_Location, Top_Location)

‘resize’ Syntax:

MainForm.resize(Form_Width, Form_Height)

Now, we are using both function in given example:

from PySide6.QtWidgets import QMainWindow, QApplication

SKapp = QApplication()
MyPyForm = QMainWindow()

#Set Location of Form in PySide
MyPyForm.move(150, 100)
#Set Form Size in PySide
MyPyForm.resize(330, 250)

MyPyForm.show()

SKapp.exec()

Now, you will get same output when run application like bellow:

(2). Python Center Screen Window in PySide6 :

In this point, we learn how to set start position for form in center screen. For center screen form in Pyside we have to import following:

from PySide6.QtGui import QScreen

Here are following two ways from which you can set Center Screen in Python.

Note: Remember one thing before positioning form in center screen, you have to first define the form or dialog size then write center screen code.

First we use ‘QScreen.availableGeometry(QApplication.primaryScreen())’. This will show screen available geometry.

PySide Center Screen Example 1:

from PySide6.QtWidgets import QMainWindow, QApplication
from PySide6.QtGui import QScreen

SKapp = QApplication()
MyPyForm = QMainWindow()

#Set Form Size
MyPyForm.resize(330, 250)

#Get Screen geometry
SrcSize = QScreen.availableGeometry(QApplication.primaryScreen())
#Set X Position Center
frmX = (SrcSize.width() - MyPyForm.width())/2
#Set Y Position Center
frmY = (SrcSize.height() - MyPyForm.height())/2
#Set Form's Center Location
MyPyForm.move(frmX, frmY)

MyPyForm.show()

SKapp.exec()

Pass Value from Text To Label in Tkinter.

Pyside Center Screen Example 2:

from PySide6.QtWidgets import QMainWindow, QApplication
from PySide6.QtGui import QScreen

SKapp = QApplication()
MyPyForm = QMainWindow()

#Set Form's Location and Size
MyPyForm.resize(330, 250)

#Get Screen Center Position
Fmcenter = QScreen.availableGeometry(QApplication.primaryScreen()).center()
Fmscr = MyPyForm.frameGeometry()

#Set Form in Center Position
Fmscr.moveCenter(Fmcenter)

MyPyForm.show()

SKapp.exec()

Both codes will show same output:

(3). Set Window State Maximized in Pyside6 :

Here SKOTechLearn describe two way to set window state maximized in PySide, and both will show same output as described bellow:

PySide6 Maximized Form Example 1:

from PySide6.QtWidgets import QMainWindow, QApplication
from PySide6.QtGui import QScreen

SKapp = QApplication()
MyPyForm = QMainWindow()

#Set Form's Location and Size
MyPyForm.resize(330, 250)

SrcSize = QScreen.availableGeometry(QApplication.primaryScreen())

#Get Screen Width
frmX=SrcSize.width()

#Get Screen Height
frmY=SrcSize.height()

#Pyside Window State maximized
MyPyForm.setGeometry(0, 0, frmX, frmY)

MyPyForm.show()

SKapp.exec()

PySide6 Maximize Form Example 2:

import sys
from PySide6.QtWidgets import QMainWindow, QApplication
from PySide6.QtGui import QScreen

class App(QMainWindow):

    def __init__(self):
        super().__init__()
        self.title = 'PySide6 Maximize Window State'
        
        #Pyside6 Maximize Form
        MyScn = QScreen
        self.setGeometry(0, 0, MyScn.availableGeometry(QApplication.primaryScreen()).width(), MyScn.availableGeometry(QApplication.primaryScreen()).height())  
    
        self.show()    
    
if __name__ == '__main__':
    app = QApplication(sys.argv)
    ex = App()
    sys.exit(app.exec())

You will get maximized form:

(4). Set Window Title in PySide6 :

The simple way to set window title or form title in PySide using ‘setWindowTitle’. Her we use it with two way at design time and change Form title in PySide at run time.

(i). Set Window Title at design time :

import sys
from PySide6.QtWidgets import QApplication, QMainWindow

app = QApplication(sys.argv)
mainwindow = QMainWindow()

mainwindow.setGeometry(300, 300, 300, 150)

#Set Window Title in PySide
mainwindow.setWindowTitle('PySide Set Window Title')

mainwindow.show()

app.exec()

(ii). Set Window Title at run time :

Here we use ‘QPushButton’ to change Title at run time when we click on button.

import sys
from PySide6.QtWidgets import QMainWindow, QPushButton, QApplication

class MyTitle(QMainWindow):
    
    def __init__(self):
        super().__init__()
        
        self.initUI()
        
    def initUI(self):      

        Pysbtn = QPushButton('Show title', self)
        Pysbtn.move(70, 40)
        
        #Call Click Event which is defined bellow
        Pysbtn.clicked.connect(self.ClickToChangeTitle)
        
        self.setGeometry(300, 300, 300, 150)
        self.show()


    #QPushButton Click Event in PySide    
    def ClickToChangeTitle(self):
            self.setWindowTitle('Click to Change Title in Pyside')
        
if __name__ == '__main__':  
    app = QApplication(sys.argv)
    ex = MyTitle()
    sys.exit(app.exec())

Output:

Set Window Title in Python

Now here are some Pyside windows tips, this way you can easily Maximized Window in PySide and Also Set Center Screen Window in PySide in Python. And Also Set Window Title or Form Title in PySide.

Use ScrollBar in Tkinter and Set ScrollBar in TextBox in Tkinter

noreply@blogger.com (SKOTechLearn) — Wed, 30 Jun 2021 07:33:00 +0000

If we are creating a project and want to start programming in python using tkinter and want to use scrolling in many widgets like- TextBox, Listbox, TreeView etc. Then we will use ScrollBar widget in Tkinter python.

Here we learn How to use ScrolledText in Tkinter or how can we Set Scrollbar in Textbox in Python Tkinter or How to use Tkinter ScrollBar in Python?

So, Lets learn Following Point wise steps.

Learn about Tkinter ScrollBar in Python

Change Tkinter ScrollBar Color and Style

How to Set ScrollBar in Textbox in Python Tkinter

When you are start programming in python, you will find very useful widget, as you know Scrollbar Widget in tkinter, you can use it in many widgets.

(1). Learn About Tkinter ScrollBar in Python :

In Python you can find that, you can use scrollbar in vertical and horizontal way.

Vertical ScrollBar in Tkinter:

This will scroll the details or information of a widget from up to down. You can scroll down or return to scroll up for getting information given inside a widget.

Horizontal ScrollBar in Tkinter:

This will scroll the details of information of a widget from left to right. You can scroll left or return to right to get information given inside that particular widget.

(2). Change Tkinter ScrollBar Color and Style :

For styling scrollbar, we use “ttk.Style ()”. Using Style will change the Background, DarkColor, LightColor, ArrowColor, TroughColor etc. Example is given bellow:

Note: For using style, you have to use ttk.Scrollbar in your application.

Syntax:

style = ttk.Style()
#Set Style
style.configure('SetStyleName', background='Set Color', troughcolor='Set Color', arrowcolor='Set Color', highlightcolor='Set Color') 

Vsrl.configure(style = 'SetStyleName')

Example:

from tkinter import *
from tkinter import ttk

SKForm = Tk()
SKForm.title('Tkinter Scroll TextBox')

Vsrl = ttk.Scrollbar(SKForm)
Vsrl.pack(side = RIGHT, fill = Y)

#Create Style For ScrollBar
style = ttk.Style()
#Set Style For ScrollBar
style.configure('TScrollbar', background='#E66565', troughcolor='#E0F5DA', arrowcolor='#65E6A9', highlightcolor='#E0F5DA') 

Vsrl.configure(style = 'TScrollbar')

MyTkTextBox = Text(SKForm, yscrollcommand = Vsrl.set)

MyTkTextBox.config(wrap = NONE, width = 22, height = 12)

#Add Record in TextBox in Tkinter
for ist in range(16):
    MyTkTextBox.insert(END, str(ist) + " = Set Horizontal and Vertical Scroll Bar in TextBox"+ "\n")

MyTkTextBox.pack(side = TOP, fill = "both", expand = True)

Vsrl.config(command = MyTkTextBox.yview)

SKForm.mainloop()

Add Text in TextBox in Tkinter

Output:

(3). How to Set ScrollBar in Textbox in Python Tkinter :

If you want to set Scroll Bar in Text in Tkinter. Here we will write some sentences or multi-line text in TextBox in Tkinter. And want to scroll then we use following code for scrolling.

Set Vertical ScrollBar in TextBox in Tkinter:

from tkinter import *

SKForm = Tk()
SKForm.title('Vertical Scroll TextBox')

Vsrl = Scrollbar(SKForm)
Vsrl.pack(side = RIGHT, fill = Y)

MyTkTextBox = Text(SKForm,  yscrollcommand = Vsrl.set)
MyTkTextBox.config(wrap = NONE, width = 22, height = 12)

for ist in range(16):
    MyTkTextBox.insert(END, str(ist) +" = Set Vertical Scroll Bar in TextBox"+ "\n")

MyTkTextBox.pack(side=TOP, fill="both", expand=True)

# Set Vertical Scroll Bar to configure Text Y View
Vsrl.config(command = MyTkTextBox.yview)

SKForm.mainloop()

Now, you will get the given output.

Using ScrolledText in Tkinter for Vertical Scrolling:

When you will use ScrolledText Widget in Tkinter, there is no need for add extra Scroll widget in Tkinter for Vertical Scrolling. ScrolledText Widget has inbuilt Vertical Scrollbar as describe in bellow python code:

from tkinter import *
from tkinter.scrolledtext import ScrolledText

SKForm = Tk()
SKForm.title('ScrolledText in Tkinter')

skt = ScrolledText(SKForm)
skt.config(width = 39, height = 6)

#Add Text in ScrolledText in Tkinter
for ist in range(8):
    skt.insert(END, str(ist) +" = Using ScrolledText Widget Scroll "+ "\n")
    
skt.pack()

SKForm.mainloop()

Now, let’s see the output:

(c) Set Vertical and Horizontal ScrollBar in TextBox in Tkinter:

Here we use Both Vertical and Horizontal ScrollBar in Text widget in Tkinter. Or here we set ScrollBar Orientation in Tkinter.

Horizontal ScrollBar in Text in Tkinter

Example:

from tkinter import *

SKForm = Tk()
SKForm.title('Tkinter Scroll TextBox')

#Create Horizontal ScrollBar in Tkinter
Hsrl = Scrollbar(SKForm, orient = 'horizontal')
Hsrl.pack(side = BOTTOM, fill = X)

#Create Vertical ScrollBar in Tkinter
Vsrl = Scrollbar(SKForm)
Vsrl.pack(side = RIGHT, fill = Y)

#Create TextBox and Set Scroll Bar
MyTkTextBox = Text(SKForm, xscrollcommand = Hsrl.set, yscrollcommand = Vsrl.set)

MyTkTextBox.config(wrap = NONE, width = 22, height = 12)

for ist in range(16):
    MyTkTextBox.insert(END, str(ist) +" = Set Horizontal and Vertical Scroll Bar in TextBox"+ "\n")

#Set TextBox widget to Form at top
MyTkTextBox.pack(side=TOP, fill="both", expand=True)

# Set Horizontal Scroll Bar to configure Textox X View
Hsrl.config(command = MyTkTextBox.xview)

# Set Vertical Scroll Bar to configure Textox Y View
Vsrl.config(command = MyTkTextBox.yview)

SKForm.mainloop()

Output:

After running application, this will show above given output, you can easily scroll your Textbox content left to right or Up and down.

So, this way SKOTechLearn describe the way to use ScrollBar in Tkinter Python or you can set ScrollBar in Text Widget in Tkinter.

How to Connect or Show Data from SQLite in VB.Net or C#

noreply@blogger.com (SKOTechLearn) — Tue, 22 Jun 2021 14:56:00 +0000

As you know that SQLite free to use in any platform. But here we will learn How to Use SQlite Database in VB.net and we will also learn how to show SQLite Data in VB.Net or C#.

But In Vb.net if we want to call data from SQLite then we have to use “System.Data.SQLite.dll” file or add as reference in VB.Net. Now when we insert this dll file, we have first import following class in your programming.

VB.Net :

Imports System.Data.SQLite

C# :

using System.Data.SQLite;

After that we will proceed with following points:

How to Connect SQLite in VB.Net

Show Data from SQLite in VB.Net through Query

Show SQlite Data in ListBox in VB.Net

Show SQLite Data in Listview in VB.Net

When you add this reference to your vb project then you have to first learn what is the SQLite ConnectionString in VB.Net.

First, there is following table we created in Sqlite3 Database.

SQLite Database with Tables

After that we will learn point wise described bellow.

(1). How to Connect SQLite in VB.Net :

For any database connection in any programming language require ConnectionString, so first we will write code for connection String:

VB:

Dim SQLiteConn As New SQLiteConnection

SQLiteConn.ConnectionString = "Data Source=MyPath\MysqliteFile.db; Integrated Security=true"

SQLiteConn.Open()

C#:

SQLiteConnection SQLiteConn = new SQLiteConnection();

SQLiteConn.ConnectionString = @"Data Source=MyPath\MysqliteFile.db; Integrated Security=true";

SQLiteConn.Open();

This way you can connect SQLite with VB.Net.

(2). Show Data from SQLite in VB.Net through Query :

Now, Lets try to show data from Local SQLite Database’s Tables through query in VB.Net. Suppose we want to show only single record of one field then we have to write following code:

VB:

Dim SQLitecnStr As String ="Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true"
Dim SQLiteConn As New SQLiteConnection
Dim SQLitecmd As New SQLiteCommand
Dim SQLiteReader As SQLiteDataReader

SQLiteConn.ConnectionString = SQLitecnStr
SQLiteConn.Open()

SQLitecmd.Connection = SQLiteConn
SQLitecmd.CommandText = "SELECT * from MySQLiteTable LIMIT 1;"
SQLiteReader = SQLitecmd.ExecuteReader()
	
Msgbox(SQLiteReader("MyName").ToString)

SQLiteReader.Close()
SQLiteConn.Close()

C#:

string SQLitecnStr = @"Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true";
SQLiteConnection SQLiteConn = new SQLiteConnection();
SQLiteCommand SQLitecmd = new SQLiteCommand();
SQLiteDataReader SQLiteReader;
	
SQLiteConn.ConnectionString = SQLitecnStr;
SQLiteConn.Open();
	
SQLitecmd.Connection = SQLiteConn;
SQLitecmd.CommandText = "SELECT * from MySQLiteTable LIMIT 1;";
SQLiteReader = SQLitecmd.ExecuteReader();
	
MessageBox.Show(SQLiteReader["MyName"].ToString(), "SQLite Connection in VB.Net");
	          
SQLiteReader.Close();
SQLiteConn.Close();

When we execute this code, the output will present in MessageBox.

(3). Show SQLite Data in ListBox in VB.Net :

Now, Suppose you want to show SQlite’s Table’s particular Fields records or show Data in ListBox in VB.Net or Listing particular Field in List then here we use while loop without using ‘LIMIT’ in Query just same as bellow:

SQLite Select Query Example

VB:

MyListbox1.items.clear()
Dim SQLitecnStr As String ="Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true"
Dim SQLiteConn As New SQLiteConnection
Dim SQLitecmd As New SQLiteCommand
Dim SQLiteReader As SQLiteDataReader
SQLiteConn.ConnectionString = SQLitecnStr
SQLiteConn.Open()

SQLitecmd.Connection = SQLiteConn
SQLitecmd.CommandText = "SELECT * from MySQLiteTable;"
SQLiteReader = SQLitecmd.ExecuteReader()
 
While SQLiteReader.Read()
    MyListbox1.Items.Add(SQLiteReader("MyMono").ToString)
End While

SQLiteReader.Close()
SQLiteConn.Close()

C#:

MyListbox1.Items.Clear();
string SQLitecnStr = @"Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true";
SQLiteConnection SQLiteConn = new SQLiteConnection();
SQLiteCommand SQLitecmd = new SQLiteCommand();
SQLiteDataReader SQLiteReader;

SQLiteConn.ConnectionString = SQLitecnStr;
SQLiteConn.Open();

SQLitecmd.Connection = SQLiteConn;
SQLitecmd.CommandText = "SELECT * from MySQLiteTable;";
SQLiteReader = SQLitecmd.ExecuteReader();

while (SQLiteReader.Read())
    {
       MyListbox1.Items.Add(SQLiteReader["MyMono"].ToString());
    }

 SQLiteReader.Close();
 SQLiteConn.Close();

After executing this code, we will find following output.

(4) Show SQLite Data in ListView in VB.Net :

Now, Lets Learn about important point that we use in every simple programming process in vb.net or any other programming Languages. Here we will talk about ListView (Showing Multiple Rows with multiple columns) with containing SQLite Records in VB.Net.

Here we learn how to Use SQLite in ListView in VB.Net. So we have to follow the code like:

VB:

MyLstView.Items.Clear()
Dim SQLitecnStr As String ="Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true"
Dim SQLiteConn As New SQLiteConnection
Dim SQLitecmd As New SQLiteCommand
Dim SQLiteReader As SQLiteDataReader

SQLiteConn.ConnectionString = SQLitecnStr
SQLiteConn.Open()

SQLitecmd.Connection = SQLiteConn
SQLitecmd.CommandText = "SELECT * from MySQLiteTable;"
SQLiteReader = SQLitecmd.ExecuteReader()

While SQLiteReader.Read()
    Dim Lstv As New ListViewItem
    Lstv.Text = SQLiteReader("MySrno").ToString
    Lstv.SubItems.Add(SQLiteReader("MyName").ToString)
    Lstv.SubItems.Add(SQLiteReader("MyMono").ToString)
    MyLstView.Items.Add(Lstv)
End While

SQLiteReader.Close()
SQLiteConn.Close()

C#:

MyLstView.Items.Clear();
string SQLitecnStr = @"Data Source=C:\MYSQLiteDBForVB.db; Integrated Security=true";
SQLiteConnection SQLiteConn = new SQLiteConnection();
SQLiteCommand SQLitecmd = new SQLiteCommand();
SQLiteDataReader SQLiteReader;

SQLiteConn.ConnectionString = SQLitecnStr;
SQLiteConn.Open();

SQLitecmd.Connection = SQLiteConn;
SQLitecmd.CommandText = "SELECT * from MySQLiteTable;";
SQLiteReader = SQLitecmd.ExecuteReader();

while (SQLiteReader.Read())
     {
        ListViewItem Lsvw = new ListViewItem();
        Lsvw.Text = SQLiteReader["MySrno"].ToString();
        Lsvw.SubItems.Add(SQLiteReader["MyName"].ToString());
        Lsvw.SubItems.Add(SQLiteReader["MyMono"].ToString());
        MyLstView.Items.Add(Lsvw);
     }

SQLiteReader.Close();
SQLiteConn.Close();

So, the output will displayed like below to showing SQLite Records in ListView in VB.Net.

Here are the above given details with step by step points for Showing Data of SQLite in VB.Net. Try to implement more your project with above given examples.

Login Form in Python GUI with MYSQL and MSSQL Connection

noreply@blogger.com (SKOTechLearn) — Tue, 20 Apr 2021 08:15:00 +0000

In python, if we want to Design Login Form with database authentication with MYSQL or MSSQL then we have to follow the following process with step by step guide.

Here we will learn How to Design Login Form in Python GUI with MYSQL connection in Python or SQL Server Connection in Python.

First we have to Create table For authentication with following field Name:

Login_tbl
usrname	passwrd
sko	tech

Same type of table we create in MSSQL.

After that we will use following tkinter widget:

Name	Tkinter Wiidget
Bannerlabel	Label
UserLabel	Label
PassLabel	Label
UserTxt	Entry
PassTxt	Entry
LoginBtn	Button

After that we will proceed with following points:

Login Form Design in Python GUI with MYSQL Connection

Login Form Design in Python GUI with MSSQL Connection

Now we will first Start with MYSQL connection then MS SQL Server Connection.

(1). Login Form Design in Python GUI with MYSQL Connection :

Now, first we will import ‘mysql.connector’ for connection. Then write code for establish connection with MYSQl after that write code for query like following way:

import mysql.connector as mysqlconnector
import tkinter as mytk
from tkinter import *
import tkinter.messagebox as mymessagebox

MyLoginForm = mytk.Tk()
MyLoginForm.title('Login Form with MYSQL Connection')
#Set Form Size
MyLoginForm.geometry("380x200")

def ClicktoLogin():
    #MYSQL ConnectionString
    mydb = mysqlconnector.connect(host="xxx.xxx.xxx.xx", user="sko", password="mypassword", database="skotechlearn")
    mycursor = mydb.cursor(dictionary=True)
    mycursor.execute("SELECT * FROM login_tbl where usrname = '"+ UserTxt.get() +"' and passwrd = '"+ PassTxt.get() +"';")
    myresult = mycursor.fetchone()
    if myresult==None:
       mymessagebox.showerror("Error", "Invalid User Name And Password")

    else:
       mymessagebox.showinfo("Success", "Successfully Login")
            
    mydb.close()
    mycursor.close()

# Set Tkinter Widget Size Location and Style
Bannerlabel = Label(MyLoginForm, text = "Login Form......", width=40, bg= 'yellow')
Bannerlabel.place(x=20, y=20)

UserLabel = Label(MyLoginForm, text = "User Name:", width=10)
UserLabel.place(x=20, y=60)

UserTxt = Entry(MyLoginForm,  width=27, relief="flat")
UserTxt.place(x=120, y=60)

#Set Focus on User Entrybox in Tkinter
UserTxt.focus()

PassLabel = Label(MyLoginForm, text = "Password :", width=10)
PassLabel.place(x=20, y=90)

PassTxt = Entry(MyLoginForm,  width=27, relief="flat")
PassTxt.place(x=120, y=90)

#Set Password Char in Entry Widget
PassTxt.config(show="*");

LoginBtn = Button(MyLoginForm, text ="Login", command = ClicktoLogin, relief="groove", fg='blue')
LoginBtn.place(x=280, y=140)

MyLoginForm.configure(background='#54596d')
MyLoginForm.mainloop()

When we execute this code. We will see the output looks like bellow.

As you can see we have changed Form, Label color for better look. After successful Login there will be a message displayed like above figure.
Now, Lets come to another point with MSSQL Connection in Python.

(2). Login Form Design in Python GUI with MSSQL Connection :

For MSSQL Connection first we install pymssql.

pip install pymssql

pip3 install pymssql

After that we will import pymssql in python code.

For Import and for MSSQL Connection String in Python, we will write following code.

MSSQL Server Connection in Python

Connection String Code:

# pymssql.connect(MSSQLServerIP, UserName, Password, Database)
pymssql.connect("xxx.xxx.xxx.xx", "myusername", "myPassword", "MyDatabase")

Let’s see how can we connect MSSQL Server with Python Tkinter Login Form?

import pymssql as MSSQLCnn
import tkinter as mytk
from tkinter import *
import tkinter.messagebox as mymessagebox

MyLoginForm = mytk.Tk()
MyLoginForm.title('Login Form with MSSQL Server Connection')
MyLoginForm.geometry("380x200")

def ClicktoLogin():
    #MSSQL Server ConnectionString
    MSSQLdb = MSSQLCnn.connect("xxx.xxx.xxx.xx", "SQLServerUser", "SQlServerPassword", "SQLServerDatabase")
    mySQLcursor = MSSQLdb.cursor()
    mySQLcursor.execute("SELECT * FROM login_tbl where usrname = '"+ UserTxt.get() +"' and passwrd = '"+ PassTxt.get() +"';")
    mySQLresult = mySQLcursor.fetchone()
    if mySQLresult==None:
       mymessagebox.showerror("Error", "Invalid User Name And Password")

    else:
       mymessagebox.showinfo("Success", "Successfully Login")
            
    MSSQLdb.close()
    mySQLcursor.close()

Bannerlabel = Label(MyLoginForm, text = "MSSQL Server Login Form......", width=40, bg= '#81907E', fg='white')
Bannerlabel.place(x=20, y=20)

UserLabel = Label(MyLoginForm, text = "User Name:", width=10, bg='#FFE6D8')
UserLabel.place(x=20, y=60)

UserTxt = Entry(MyLoginForm,  width=27, relief="flat")
UserTxt.place(x=120, y=60)

#Focus of User Entrybox in Tkinter
UserTxt.focus()

PassLabel = Label(MyLoginForm, text = "Password :", width=10, bg='#FFE6D8')
PassLabel.place(x=20, y=90)

PassTxt = Entry(MyLoginForm,  width=27, relief="flat")
PassTxt.place(x=120, y=90)

#Set Entry box Password Char in Tkinter
PassTxt.config(show="*");

LoginBtn = Button(MyLoginForm, text ="Login", command = ClicktoLogin, relief="groove", fg='blue')
LoginBtn.place(x=280, y=140)

MyLoginForm.configure(background='#FFE6D8')
MyLoginForm.mainloop()

After the execution of this code in python, the following output will present.

This way you can easily Create or Design Login Form in Python GUI with Tkinter and Connect Login Form with MSSQL in Python Or Connect Login Form with MYSQL in Python.

MySQL Connection in Python with MYSQL Select Query in Python

noreply@blogger.com (SKOTechLearn) — Mon, 05 Apr 2021 06:00:00 +0000

When we want to connect MYSQL Database with application then we have to first consider about MYSQL Connection Driver and MySQL ConnectionString. So here we will describe MYSQL Database Connection in Python or MYSQL connection in Python with database in three ways.

Using Pyodbc in MYSQL Connection

Using mysql.connector for MYSQL Connection

Using pymysql for MYSQL Connection

Fist thing we have to know that if we want to connect any type of Database organization, then we have to use Driver from particular database organization like MYSQL. So, Lets Start from pyodbc in python.

(1). Using Pyodbc in MYSQL Connection :

For using pyodbc, you have to install pyodbc through pip. Now, lets know the following connection string of pyodbc.

pyodbc.connect("DRIVER={Driver_Name}; User=Server_User; Password=server_Password; Server=localhost/server IP; Database=DatabaseName;")

So, Write following code to show database table’s record in following way:

import pyodbc 

mysqlcn = pyodbc.connect("DRIVER={MySQL ODBC 8.0 ANSI Driver}; User=sko; Password=xxxxxx; Server=xxx.xxx.xxx.xx; Database=mydatabase; ")
dbcursor = mysqlcn.cursor() 
dbcursor.execute("SELECT * FROM TestTable") 
myfield = dbcursor.fetchone() 
# Loop to fetch one by one data.
while myfield:
      # Print partuculat column data from table
print (myfield[0]) 
myfield = dbcursor.fetchone()

#Now Close cursor and connection
dbcursor.close()
mysqlcn.close()

In this code we use “MySQL ODBC 8.0 ANSI Driver” in pyodbc.

This will show following output:

Show MySQL Data in Listbox in Python

If you want to show data or you can use MYSQL Select Query in Python to show data in Listbox then following code will be help in you coding.

Show Database Record in Listbox:

import tkinter as mytk
from tkinter import *
import pyodbc 

MytkForm = mytk.Tk()
MytkForm.title('MySQL with pyodbc')
MytkForm.geometry("250x100")

# Create Listbox
MyTklist = mytk.Listbox(MytkForm)
#Clear Listbox
MyTklist.delete(0,END)
mysqlcn = pyodbc.connect("DRIVER={MySQL ODBC 8.0 ANSI Driver}; User=sko; Password=xxxxxx; Server=xxx.xxx.xxx.xx; Database=mydatabase;")
dbcursor = mysqlcn.cursor() 
#MySQL Select Query in Python
dbcursor.execute("SELECT * FROM TestTable") 
myfield = dbcursor.fetchone() 
while myfield:
    # Add Field data in Listbox
    MyTklist.insert(END,myfield[0]) 
    myfield = dbcursor.fetchone()

dbcursor.close()
mysqlcn.close()
MyTklist.pack()

MytkForm.mainloop()

OUTPUT:

(2). Using mysql.connector for MYSQL Connection

In this point we will learn how to use mysql.connector for database connection and also learn how to List MYSQL data through column name in python.

Mysql.connector ConnectionString in Python

mysql.connector.connect(host="XXX.XXX.XXX.XX", user="Database_User", password="Database_Password", database="DatabaseName")

Now Lets, see how to show data?

import mysql.connector
#ConnectionString
mydb = mysql.connector.connect(host="XXX.XXX.XXX.XX", user="sko", password="mypassword", database="mydatabase")
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM TestTable")
myresult = mycursor.fetchall()
for mycol in myresult:
   # Get Second Column's row List
   print(mycol[1])

mydb.close()
mycursor.close()

OUTPUT:

In this given output, you can see, we show only second column data through “mycol[1]” this code.

MySQL Column Value show through Column Name in Python in Listbox:

As you saw before, we are showing data through Column Number, but if we have more columns and want to show particular column value then we have to determine Column Name.

So, through following way you can use to show column value through Column Name. You have to add following code in cursor method.

mycursor = mydb.cursor(dictionary=True)

Lets see with full details:

import mysql.connector
import tkinter as mytk
from tkinter import *

MytkForm2 = mytk.Tk()
MytkForm2.title('MySQL with mysql.connector')
MytkForm2.geometry("270x120")

MyListData= mytk.Listbox(MytkForm2)
mydb = mysql.connector.connect(host="XXX.XXX.XXX.XX", user="sko", password="mypassword", database="mydatabase")

#Fetch Particular Column Value through Column name with using dictionary
mycursor = mydb.cursor(dictionary=True)

mycursor.execute("SELECT * FROM TestTable")
myresult = mycursor.fetchall()
for MyColName in myresult:
    MyListData.insert(END, MyColName ["MyDetails"]) 
mydb.close()
mycursor.close() 
MyListData.pack()

MytkForm2.mainloop()

Now, This will Show output according to Column Name.

(3). Using Pymysql for MYSQL Connection

You can use another connector in python that's call pymysql. First you have to install pymysql. After that you have to use following connection string.

pymysql.connect(host="XXX.XXX.XXX.XX", user="MySQLUsername", password="MYSQLPassword", database="MYSQLDatabase")

Then write following code to show data in Python.

import pymysql

# database connectionstring
connmysql = pymysql.connect(host="XXX.XXX.XXX.XX", user="sko", password="mypassword", database="mydatabase")
cursordb = connmysql.cursor()

# execute your query through execute().
cursordb.execute("SELECT * FROM TestTable")

# get all row through fetchall().
data = cursordb.fetchall()
for colnm in data:
    print(colnm[0])

# close connection
connmysql.close()

OUTPUT:

Conclusion: You can use any one of these method. You will find some performance differences. But you will find exact result using any connector in python.

So, this way you can Connect MYSQL in Python with step by step process.

How to Make Image Selected Area Transparent in Gimp

noreply@blogger.com (SKOTechLearn) — Sat, 27 Mar 2021 20:29:00 +0000

In this post SKOTechLearn will describe How to Make Image Selected Area Transparent in GIMP or Image Selected Area Transparent in GIMP. As you know GIMP provide image processing of all kind of image formats. You can modify, beautify and change format of image through this application.

Here, we will describe three way to make area transparent in GIMP. You just follow the steps described bellow with following points:

Use ‘Rectangle Select Tool’ To Make Selected Area Transparent

Use ‘Free Select Tool’To Make Selected Area Transparent

Use ‘Eraser Tool’To Make Selected Area Transparent

So, First Open your Image in Gimp. Then proceed with following way:

(1). Use ‘Rectangle Select Tool’ To Make Selected Area Transparent :

If you want to use ‘Rectangle Select Tool’, you have to follow the steps in GIMP.

Right click on Image in Gimp.

A drop down menu will appear, Go to ‘Layer’ option.

In ‘Layer’, go to ‘Transparency’ option.

Then Select ‘Add Alpha Channel’.

Let's see the instruction given in following figure.

After that select ‘Rectangle Select Tool’ from ‘Tools’.

Now, select area where you want to make selection transparent.

And Press ‘Delete’ from Keyboard.

Now, let's proceed to second process.

(2). Use ‘Free Select Tool’ To Make Selected Area Transparent :

Like above given Points for ‘Add Alpha Channel’. You have to do same in this process.

(Right Click) Image >> “Layer” >> “Transparency” >> “Add Alpha Channel”

After this Process, you have to go to ‘Tools’ window and select ‘Free Select Tool’.

Then point on area which you want to make transparent.

And then join start and end point of ‘Free Select Tool’ then Press ‘Delete’ Button from Keyboard.

This will make desire area transparent.

(3). Use ‘Eraser Tool’ To Make Selected Area Transparent :

Same way you have to select ‘Add Alpha Channel’ like first process.

(Right Click) Image >> “Layer” >> “Transparency” >> “Add Alpha Channel”

After that Select ‘Eraser Tool’.

Then go to ‘Eraser Tool’ Properties and Increase or decrease Eraser ‘Size’ according to area selection.

Then click on area of Image.

This will make eraser area transparent.

Note: If you want to increase or decrease transparency level, you have to simply go to ‘Eraser’ tool’s Properties window and Increase or decrease ‘Opacity’ from 0 to 100%.

This is the simplest and easy way to manually select area and make it transparent.

In Gimp, you will find many other tools that provide facility to transparent selected part in GIMP. So, this way you can make Image Selected Area transparent in GIMP with SKOTechLearn easy tips.

Add Itmes in ComboBox in Tkinter Python with Loop Example

noreply@blogger.com (SKOTechLearn) — Thu, 25 Mar 2021 07:29:00 +0000

Here, we will discuss and Learn about Tkinter Combobox in Python. Here we will learn how to Add Items in Combobox in Tkinter or Add Items in ComboBox in Tkinter through Loop in Python. So, we will proceed with step by step Process with following points.

Manually Add Items in ComboBox Tkinter in python

Add Items in ComboBox Tkinter in python through Loop

Now, lets Learn point wise given bellow.

How To Get value From Textbox to Label in Tkinter in Python?

(1). Manually Add Items in ComboBox Tkinter in python :

If you want to add items in design time or manually then you have to write following code in Python. Tkinter provide ttk class to show combobox and its attributes. So, Manually add items process code in tkinter described in following way:

import tkinter as tk
from tkinter import *
from tkinter import ttk

MyrootDialog = tk.Tk(className="Add Items in Tkinter Combobox")
#Set Tkinter window Size
MyrootDialog.geometry("300x100")

mytkcombo = ttk.Combobox(MyrootDialog, values=['SKO', 'Tech', 'Learn'])
#Set Combobox Position in Python
mytkcombo.place(relx=0.5, rely=0.3, anchor='center')
mytkcombo['state'] = 'readonly'
#mycombo.pack()

MyrootDialog.mainloop()

When you run this code, this will show you following output.

Items in Tkinter ComboBox in Python

So, In this way you can add items in ComboBox tkinter in Python through static way. Now let’s Learn about dynamic way at run time.

How to Use String and How to Concatenate String in Python with Example?

(2). Add Items in ComboBox Tkinter in python through Loop :

Now, if You want to add itmes in tkinter combobox at runtime with loop or loop to add items in tkinter combobox in python, you have to implement some code in python like bellow:

Example 1:

import tkinter as tk
from tkinter import *
from tkinter import ttk

MyrootDialog = tk.Tk(className="Add Items in Tkinter Combobox")
#Set Tkinter window Size
MyrootDialog.geometry("300x100")

mytkcombo = ttk.Combobox(MyrootDialog)
# For Loop
for x in range(5):
   # Add itmes in combobox through Loop code
   mytkcombo['values']= tuple(list(mytkcombo['values']) + [str(x)])
mytkcombo.place(relx=0.5, rely=0.3, anchor='center')

MyrootDialog.mainloop()

This is the dynamic way to show items in combobox at run time through loop. This will show following output:

Loop Items in ComboBox

Show Month in Combobox Tkinter through Loop

Example 2:

Now, lets See another Example to showing month name in ComboBox through Loop . In this example we use array list to add items in ComboBox Python.

import tkinter as tk
from tkinter import *
from tkinter import ttk
import calendar

MyrootDialog = tk.Tk(className="Add Items in Tkinter Combobox")
#Set Tkinter window Size
MyrootDialog.geometry("300x100")

mytkcombo = ttk.Combobox(MyrootDialog)
# Define Array List
strList=['']
for mnt in range(1, 13):
   #Add Month Name through Loop
   strList.append(calendar.month_name[mnt])
#Add Items in Tkinter Combobox through Array
mytkcombo['values'] = strList
mytkcombo.place(relx=0.5, rely=0.3, anchor='center')

MyrootDialog.mainloop()

Using If Else Statement in Python.

After running this code you will see the output like following way:

Show Month Name in Tkinter ComboBox in Python

So, these are the three way to show or Add Items in Combobox in tkinter in Python, you can choose anyone according to your application or software requirement.

Tkinter Label Features and Use Of Label in Python.

Steps to Change Dark Theme to Light Theme in Visual Studio Code

noreply@blogger.com (SKOTechLearn) — Wed, 19 Aug 2020 10:43:00 +0000

If you like Light Theme in Code Editor in Visual Studio Code then here SKOTechLearn will describe the steps to Change Dark Theme to Light Them in Visual Studio Code. And Here we will also describe the steps to Customize Color or Theme in Visual Studio Code.

By default VS Code contain Dark theme. You know that Visual Studio is highly customized code editor compare to all other code editor. And you can find many feature to change Look and Feel in Visual Studio Code.

Change visual studio code background color

Now, we can choose any one process for Change Code Editor Color in Visual Studio Code:

Change Theme of Visual Studio Code through Shortcut Key

Change Theme of Visual Studio Code through Settings

Change Color Theme of Visual Studio Code through Code

(1). Change Theme of Visual Studio Code through Shortcut Key:

When you open VSCode, and want to change theme, then simply you have to press two different shortcut Key one by one same time.

Press First Shortcut Key: CTRL + K
After that Press second Shortcut Key: CTRL + T

Now, you will see a drop down Option Box “Select Color Theme (Up/Down Keys To Preview)” will appear containing list of existing theme like bellow:

This Option Box contain two types of Theme Category first is “light themes” and second is “dark themes”. If you want to change VSCode in light theme, then choose first category.

(2). Change Color Theme of Visual Studio Code through Settings:

If you want to proceed for color change through VSCode settings, then you have to follow the steps:

First Go to “File” menu.

Find “Preferences” and select it.

And then select “Color Theme[Ctrl+K Ctrl+T]” option from it.

Now, a drop down list will appear containing themes options. Choose anyone which you like.

As you can see, in this way you can change Dark Theme to Light Theme in VSCode.

(3). Change Color Theme of Visual Studio Code through Code:

This is very interesting process to Change Look and Feel Of Visual Studio Code. In this Process you can change every Part of VSCode Tool's color according to your desire. You have to Simply proceed with following way:

Same as above given steps, you have to first go to “File” menu then “Preferences” then “Settings”.

You will find “Settings” Tab will appear. Go to Search Bar and search for “.json”.

You will get “Edit in Settings.json” option. Just click on it.

Now “Settings.json” file will display. Add color code like bellow:

{
     "workbench.colorCustomizations": {
     //For Code editor Color Change
     "editor.background": "#edeafa",
     "editor.foreground": "#4b4548",

     //For Sidebar Color Change
     "sideBar.background": "#fddcaa",
     "sideBar.foreground": "#612144", 

     //Change Activity Bar Color
     "activityBar.background": "#7f61a7",
     "activityBar.foreground": "#c5ff3e",
     "activityBar.inactiveForeground": "#6dc58f"
     }
}

After writing this code, save it and see what happen:

As you can see you can manually create theme in VSCode.

So, this way you can easily Customize Theme Color of Visual Studio Code. And also set Light theme in VSCode.

Steps to Get Entry Or Text Value in Label in Python Tkinter

noreply@blogger.com (SKOTechLearn) — Tue, 18 Aug 2020 04:45:00 +0000

In python using Tkinter, there are two types of Input Box first is Tkinter Entry Box and Second is Tkinter Text. And if you want to get String or Get Value from Entry in Tkinter or Get Tkinter Text Value in Python then here you will find detailed process to consider how to use it in your Project.

How to use Tkinter Label in Python with features

Important Note: We Find that Text widget can not work in Tab Order. You have to write more code effort to perform Tab order in Text in Tkinter. But if you use Entry widget in python. There will no problem in tab order.

Now Let’s Learn How to Get Value from Entry in Python Tkinter or Get Value from Text with following way:

Get Entry Value in Label in Python Tkinter

Get Text Value in Label in Python Tkinter

So, Let’s Start.

(1). Get Entry Value in Label in Python Tkinter :

As you know that for perform any action in Python you have to define Function. So for getting value you have to define function as bellow and Get Entry Value.

Python Code:

from tkinter import *

MyRootDialog=Tk()
#Set Tkinter Size And Location
MyRootDialog.geometry("200x150+100+100")

#Set Tkinter Title
MyRootDialog.title("Get Input Value in Label")

# Define Function for get Value
def Get_MyInputValue():
     getresult = MyEntryBox.get()
     myTKlabel['text'] = getresult

# Create Tkinter Entry Widget
MyEntryBox = Entry(MyRootDialog, width=20)
MyEntryBox.place(x=5, y=6)

myTKlabel = Label(MyRootDialog, borderwidth=1, relief="ridge", height=3, width=25)
myTKlabel.place(x=4, y=42)

#command will call the defined function
MyTkButton = Button(MyRootDialog, height=1, width=10, text="Get text", command= Get_MyInputValue)
MyTkButton.place(x=4, y=112)

mainloop()

One more thing here you can use get value in Label through following two way:

myTKlabel['text'] = getresult

myTKlabel.config(text = getresult)

You can use it according to your desire. Both will present same result.

Output:

You can also Set Tkinter window in Center Location.

(2). Get Text Value in Label in Python Tkinter :

Now if you use Tkinter Text widget in python then you have to write following code to get Tkinter text in python.

Note: Get Value from Tkinter Entry Widget code: MyEntryBox.get()
And for get Value from Tkinter Text Widget code: MyTktextBox.get("1.0", 'end-1c')

In Text Widget you have to pass Index inside Get() function:

Code:

from tkinter import *

MyRootDialog=Tk()
#Set Tkinter Size And Location
MyRootDialog.geometry("200x150+100+100")

#Set Tkinter Title
MyRootDialog.title("Get Input Value in Label")

# Define Function for get Text Value
def Get_TKTextValue():
      myTxtresult = MyTktextBox.get("1.0", 'end-1c')
      myTKlabel.config(text = myTxtresult)

# Create Tkinter Text Widget
MyTktextBox=Text(MyRootDialog, height=1, width=20)
MyTktextBox.place(x=5, y=6)


myTKlabel = Label(MyRootDialog, borderwidth=1, relief="ridge", height=2, width=25)
myTKlabel.place(x=4, y=42)

#command will call the defined function
MyButton = Button(MyRootDialog, height=1, width=10, text="Get text", command= Get_TKTextValue)
MyButton.place(x=4, y=92)

mainloop()

Now, when you run you code, this will present following output.

Different types of Multi Line String process in Python

Output:

So, these above given code process is use to Get Tkinter Text Value in Label or Get Entry Value in Python.

Simply Add Items in Tkinter ComboBox in Python with Example

String in Python with Single, Multi-Line, Concatenate in Python

noreply@blogger.com (SKOTechLearn) — Thu, 13 Aug 2020 06:28:00 +0000

First of all you have to understand about String in Python. Basically a String is a collection of characters which is used to define a word or sentence or paragraph with single or multiple lines. And here we also describe some basic Format of String or Integer Concatenation in Python.

In Python, when we define a string, it will be define either Single (‘ ’) Quote or Double Quote ( “ ”).
For simple example you can use print() function for display simple word or sentence as form of string as given bellow:

print( "SKOTechLearn" )
print( 'SKOTechLearn' )

Output:

>>>
SKOTechLearn
SKOTechLearn
>>>

So, let’s see the types and use of String with following way:

Single Line String using Variable
Use String to Passing value in Function
Multi-Line Sting using Variable
Concatenate Strings in Python
Concatenate integer or number with String

(1). Single Line String in Python using Variable :

Suppose you want to store your word or sentence and show during process then we simply assign a Variable.

mystrng = "Hello SKOTechLearn"
print(mystrng)

Output:

>>>

Hello SKOTechLearn

>>>

(2). Use String to Passing value in Function in Python:

This is very important point which is used in every programming process. Here you can use string for passing in other function or references.

You can simply cover following points:

➤ Python pass function as argument with parameters
➤ How to pass string as parameter in python function?
➤ Python pass function name as argument
➤ Python call function from string with arguments

You have to simply learn following process:

Myfstr = "skotechlearn"
MyPFunc( Myfstr )

def MyPFunc ( Myfstr ):
    # upper() method is use to show Characters in Capital Letters
    skstr = Myfstr.upper()
    print (skstr)

Output:

>>>
SKOTECHLEARN

>>>

You can simply use this process with many ways according to your application requirement process.

(3). Multi-Line Sting in Python using Variable :

As you can understand how to store or show string in python, but when you want to store multiline sentence or paragraph on your application, what is the code process we apply?

You have to simply write word or sentence in start and end with Triple Quotes (""" """) or You can simply use “\n” between you sentence with following way:

Multi-line String using Triple Quotes (""" """) :

MyMultilineStr = """This is Triple Quote multiline Sentence
Using Python Code
With Simple output"""
print (MyMultilineStr)

Output:

>>>
This is Triple Quote multiline Sentence
Using Python Code
With Simple output

>>>

Multi-line using “\n” :

MyNextLineStr = "This is multiline Sentence \n Python Code \n With Next Line Process "
print (MyNextLineStr)

Output:

>>>
This is multiline Sentence
Python Code
With Next Line Process
>>>

(4). Concatenate Strings in Python :

There are 4 ways for concatenating string in Python.

First Process:

You can simply use “+” Sign for concatenate word or sentence.

FstStr = "SKO"
SecStr = "Tech"
ThirdStr = "Learn"

FinalStr = FstStr  + " " + SecStr + " " + ThirdStr
print (FinalStr)

Output:

>>>
SKO Tech Learn
>>>

Second Process:

You can simply use “{}{}{}”.format(StrVar1, StrVar2, StrVar3) function.

Tips1: "{}{}{}".format(StrVar1, StrVar2, StrVar3): if you don’t need space between string.
Tips2: "{} {} {}".format(StrVar1, StrVar2, StrVar3) : if you need to add space between string.

Note: Input Number of “{}” Curly Brace according to the number of string variable.

PStr1= "SKO"
PStr2 = "Tech"
PStr3 = "Learn"
PStr4 = "Tips"

#concatenate String without space
print("{}{}{}{}".format(PStr1, PStr2, PStr3, PStr4)) 

# concatenate String with space
print("{} {} {} {}".format(PStr1, PStr2, PStr3, PStr4))

Output:

>>>
SKOTechLearnTips
SKO Tech Learn Tips
>>>

Third Process:

In this process you can use "% s % s % s" % (StrVr1, StrVr2, StrVr3). Here you can add number of “% s” according to number of string value or variable.

"% s % s % s" : if you want to add space during concatenating variable. This will show sentence with space.
"% s% s% s" : This will show Concatenate variable without space.

For Example:

myVr1 = "This"
myVr2 = "is"
myVr3 = "Concatenate"
myVr4 = "Code"
#Sentance without space
print("%s%s%s%s" % (myVr1, myVr2, myVr3, myVr4)) 

# Add space between word or sentence
print("%s %s %s %s" % (myVr1, myVr2, myVr3, myVr4))

Output:

>>>
ThisisConcatenateCode
This is Concatenate Code
>>>

Forth Process:

Use .join for concatenate in python. For Simply you have to follow following syntax:

Concatenate Without Space: "".join([SkVr1, SkVr2, SkVr3])
Concatenate With Space: "".join([SkVr1, SkVr2, SkVr3])

For Example:

SkVr1 = "Learn"
SkVr2 = "Concatenate"
SkVr3 = "process"
# Concatenate process without space
print("".join([SkVr1, SkVr2, SkVr3])) 
# Concatenate process with space 
print(" ".join([SkVr1, SkVr2, SkVr3]))

Output:

>>>

LearnConcatenateprocess
Learn Concatenate process

>>>

(5). Concatenate integer or number in Python with String:

When you will try to concatenate integer in Python with alphabet or sentence, you will get the following error with normal process like bellow:

print(1 + "This is Alphabet")

>>>
Traceback (most recent call last):

print(1+"This is Alphabet")

TypeError: unsupported operand type(s) for +: 'int' and 'str

>>>

As you can see the above error will display. So, we try following way to solve this problem. There are four process for Concatenating Integer with String:

Process 1:

Simply input number inside Double Quote(“ ”):

print("2"+ ". This is Alphabet")

Output:

>>>

2. This is Alphabet

>>>

Process 2:

Using str() for converting Integer :

mynum = 2
combstr = "This is Alphabet"
print(str(mynum) + "=  " + combstr)

Output:

>>>

2= This is Alphabet

>>>

Process 3:

Using .format method for concatenate of integer :

mynum = 2
combstr = "This is Alphabet"
print "Point No. {} is - {} for concatenate with Integer".format(mynum, combstr)

Output:

>>>

Point No. 2 is - This is Alphabet for concatenate with Integer

>>>

Process 4:

Using “% s” for Concatenate integer :

mynum = 2
combstr = "This is Alphabet"
print("No. % s % s" % (mynum, combstr))

Output:

>>>

No. 2 This is Alphabet

>>>

So Friends, these are the process for Using String in Python, easily show Multi-line String in python, Passing String in function in Python, Concatenate String in Python, Concatenate Integer in Python.

Static or Dynamic Way to Display Image in jFrame in Java Swing

noreply@blogger.com (SKOTechLearn) — Tue, 21 Jul 2020 19:18:00 +0000

In this post, SKOTechLearn describe the static and dynamic way to Display Image in jFrame in Java Swing with Netbeans through jLabel. Simply we can add image through Properties Settings or using Code which is described bellow.

Why we use jLabel for displaying image? Because, This is the simple way to handle any files like: jpeg, png etc using jLable pallet.

Open jFrame through Another jFrame in Java Swing

If you want to show external image or use it as internal way like add as logo or banner, then here we will describe as dynamic and static way. So lets learn with following two process:

(1) Display Image in jLabel in Java Swing Static way

(2) Display Image in jLabel in Java Swing Dynamic way

Come to the point by point description.

(1) Display Image in jLabel in Java Swing Static way :

In this process just create an image file or use your existing file and copy that file in your particular package. For this step by step process let's find following.

Suppose if you create a picture file and want to show. Then first copy that particular file and paste it on your project's package, or you can access through external path.

Drag Image File In Package

Tips to Auto Resize Control Setting in Java Netbeans

As you can see, I simply copy my particular file and paste on my package. After that simply drag a jLabel from palette and adjust it's height width and location according to desire and after that follow the steps:

Right click on jLabel.

Select 'Properties' option or go to directly on 'Properties' window.

Find “icon” option. And select your particular file.

If it not show any file just click on 'Custom editor' button

And select file from there.

For 'Custom editor' button, you can see that it will contain with icon's option of Properties windows. For easily understanding process follow the image.

jLabel icon setting

When you done all this process. It will display picture like shown in above figure.
So, this is the way of showing picture in static way.

How to Design or Change Look of jLabel in Java in Netbeans

(2) Display Image in jLabel in Java Swing Dynamic way:

If you want to show image in dynamic way, you have to write code for it, Suppose you want to show picture during jFrame's open or activate. So write code as we describe bellow.

But first, you have to import some class inside your java Package:

package simple_java; 

  import java.awt.image.BufferedImage;
  import java.io.IOException;
  import javax.imageio.ImageIO;
  import javax.swing.ImageIcon;

Now lets write show picture code on WindowsOpened evets:

private void formWindowOpened(java.awt.event.WindowEvent evt) { 
   try{
       BufferedImage image1 = ImageIO.read(getClass().getResource("skotechlearn.png"));
       jLabel1.setIcon(new ImageIcon(image1));
   }catch(IOException imgl){}

 }

How to show external image in jLabel?

If you want to show picture from external url or path, then write code like:

String myimgpath; 
myimgpath= "your exteral file path";
Icon myimgicon = new ImageIcon(myimgpath);
jLabel1.setIcon(myimgicon);

When you run application then it will load picture during runtime and display it on jLabel.

Note:- You can also set jLabel as background image by setting the height width of jLabel according to jFrame.

So, this is the way of displaying image on jFrame in java Netbeans with static and dynamic process which is easily described in above given step by step process in SKOTechlearn post.

Simple Tips to Creating Swing GUI Application in Java

For further learning of coding, programming or simple tips and trick related to OS, follow SKOTechlearn and learn things as simple as possible.

Tips to Use of jList for Showing Data in Java Swing

Show Drives With Folders and Files in TreeView in VB.Net, C#

noreply@blogger.com (SKOTechLearn) — Wed, 08 Jul 2020 11:33:00 +0000

If you are trying to show Drives, Folders, Sub-Folders and Files without using FolderBrowserDialog or OpenFileDialog through VB.Net Code. Then you can try TreeView control for this process. To use TreeView as File Explorer or Folder Explorer, there are some simple and easy coding and setting tips you have to apply.

So, here we try to Show Drives with Folders and Files in TreeView in VB.Net, C# coding.

(File's Icons in ListView) Show List of Files with Files' Icons in Listview

But, first we understand why we need TreeView as FileExplorer? The answer is very simple, whenever we develop1 an application and want to show files, folders or drives in static way then we use many controls like ListBox, ListView or TreeView as File browser or Folder browser.

Now, Lets proceed with following point:

Show Drives with Folders and File in TreeView in VB.Net (VB, C#)
Get TreeView Selected Node Path in Label VB.Net (VB, C#)

Now, let's start with point wise.

Searching Files from Folders or Sub-Folders through code using VB.Net

(1). Show Drives with Folders and File in TreeView in VB.Net (VB , C#) :

First we have to add some controls like Button, Label, Treeview. Now here we use these controls with following Names.

ExplorerBtn : Button
MytrView1 : Treeview
MyPathLabel : Label

First, we write code inside Button for calling Drives.

Button’s Click Event for Showing Drives in TreeView.

VB.Net :

 Private Sub ExplorerBtn_Click(sender As Object, e As EventArgs)
  'Clear TreeView
  MytrView1.Nodes.Clear()

  'Loop For Get Drives
  For Each myDrives As System.IO.DriveInfo In System.IO.DriveInfo.GetDrives()
     Dim myDrivesNode As TreeNode = MytrView1.Nodes.Add(mydrives.Name)
     'Adding "Expand" string is use for Add Expand "[+]" option on Drives
     myDrivesNode.Nodes.Add("Expand")
  Next

 End Sub

C# :

 private void ExplorerBtn_Click(object sender, EventArgs e)
 {
    //Clear TreeView
    MytrView1.Nodes.Clear();

    //Loop For Get Drives
    foreach (System.IO.DriveInfo myDrives in System.IO.DriveInfo.GetDrives())
    {
       TreeNode myDrivesNode = MytrView1.Nodes.Add(myDrives.Name);
       //Adding "Expand" string is use for Add Expand "[+]" option on Drives
       myDrivesNode.Nodes.Add("Expand");
    }

  }

So, this code will present output in following way:

After that, we use 'BeforeExpand' event of Treeview for getting Folders and Files List on particular Drives.

VB.Net :

 Private Sub MytrView1_BeforeExpand(sender As Object, e As TreeViewCancelEventArgs)
   Dim MyExistNode As TreeNode = e.Node
   'Clear TreeNode
   MyExistNode.Nodes.Clear()

   Try
     'Loop For Get Folders
     Dim mypath As String = MyExistNode.FullPath

     'Loop For Get Folders
     For Each myFolders As String In System.IO.Directory.GetDirectories(mypath)
        Dim FldrNode As TreeNode = MyExistNode.Nodes.Add(System.IO.Path.GetFileName(myFolders))
        'Here, Expand is use for add Expanding option "[+]" on folder
        FldrNode.Nodes.Add("Expand")
     Next

     'Loop For Get Files
     For Each MyFiles As String In System.IO.Directory.GetFiles(mypath)
        Dim FLNode As TreeNode = MyExistNode.Nodes.Add(System.IO.Path.GetFileName(MyFiles))
     Next

    Catch ex As Exception

    End Try
  
 End Sub

C# :

private void MytrView1_BeforeExpand(object sender, TreeViewCancelEventArgs e)
  {
     TreeNode MyExistNode = e.Node;
     //Clear TreeNode
     MyExistNode.Nodes.Clear();

     try
      {
        string mypath = MyExistNode.FullPath;

        //Loop For Get Folders
        foreach (string myFolders in System.IO.Directory.GetDirectories(mypath))
        {
           TreeNode FldrNode = MyExistNode.Nodes.Add(System.IO.Path.GetFileName(myFolders));
           //Here, Expand is use for add Expanding option "[+]" on folder
           FldrNode.Nodes.Add("Expand");
         }

        //Loop For Get Files
        foreach (string MyFiles in System.IO.Directory.GetFiles(mypath))
         {
                
            TreeNode FLNode = MyExistNode.Nodes.Add(System.IO.Path.GetFileName(MyFiles));
               
          }

       }
        catch (Exception FlErr)
       {
          MessageBox.Show(FlErr.ToString());
       }

   }

OK, when you run your application this will show following output:

As you can see, when you click on any drive this will expand with containing Folders and files and when you expand any folder this will show your list of sub-folders and files in Treeview.

Styling ProgressBar in VB.Net

(2). Get Treeview Selected Node Path in Label VB.Net (VB, C#) :

Now, let’s try to get selected Node path in Label from Treeview. So, here we go through code process.

You have to first go to “AfterSelect” event of Treeview and write following code:

VB.Net:

 Private Sub MytrView1_AfterSelect(sender As Object, e As TreeViewEventArgs)
    
  Dim MySelectedNode As TreeNode = e.Node
  'Get Selected Node Path
  MyPathLabel.Text = MySelectedNode.FullPath
    
 End Sub

C# :

private void MytrView1_AfterSelect(object sender, TreeViewEventArgs e)
  {
     TreeNode MySelectedNode = e.Node;
     //Get Selected Node Path
     MyPathLabel.Text = MySelectedNode.FullPath;
    
  }

This will work like following way:

Okay, now we have learned how to Show Drives with Folders and Files in TreeView in VB.Net using VB and C# code. You can also try and ask any question related to this topic describe in SKOTechLearn Tips.

Change jTable Column Header and Rows Color in Java NetBeans Easily

noreply@blogger.com (SKOTechLearn) — Fri, 03 Jul 2020 10:12:00 +0000

In this post, SKOTechLearn will explain how to Change Color of jTable in Java like Column Header Color, grid Color, Rows Color, Selection Color. When I was started programming in java and using jTable, I faced problem of jTable background color foreground color of particular cells or rows and columns.

So here are the simple and easy tips to Change jTable Column Header and Rows Color in Java Netbeans Easily.

Easily Add Column Header in jTable with Grid Settings in Java

So here SKOTechLearn will described, how to Change jTable Column Header and Rows Color in Java NetBeans in simple way?

So, Let’s take a look of Following Color changing point.

jTable Column Header Background Color and Foreground or Font Color
jTable Column Header Background Color and Foreground Color in NetBeans
jTable Rows Background and Foreground Color
Change Background and Foreground Color of Particular Column's Rows in jTable
jTable Selection background and Foreground Color
jTable Selection Background and Foreground Setting in NetBeans

First you have to import Color Class:

 import java.awt.Color;

Now, Let's Proceed with above given point.

(1). jTable Column Header Background Color and Foreground or Font Color :

There are many ways to change Header’s back color. You can change it through predefined system color or you can use custom color.

Column Header background with default system Color:

 MyTblView.getTableHeader().setBackground(Color.MAGENTA);

Column Header background with Custom Color :

 MyTblView.getTableHeader().setBackground(Color.decode("#696B9E"));

Or you can use JTableHeader class.

Enable or Show jTable Sorting Option in Java

First import this class:

 import javax.swing.table.JTableHeader;

Then use this class with following way:

 JTableHeader TblHeader = MyTblView.getTableHeader();
 TblHeader.setBackground(Color.GREEN);

Same above code process will apply here; we can set Foreground color with system default and custom color setting.

Column Header Foreground with default system Color :

 MyTblView.getTableHeader().setForeground(Color.BLUE);

Column Header Foreground with Custom Color :

 MyTblView.getTableHeader().setForeground(Color.decode("#FCE7FC"));

JTableHeader class for Foreground color code:

JTableHeader TblHeader = MyTbleView.getTableHeader();
 TblHeader.setForeground(Color.RED);

When you run any code the output will show in following way:

(2). jTable Column Header Background Color and Foreground Color in NetBeans :

If you are using NetBeans for swing GUI project using jTable, the column header color will apply in different coding way. You have to use DefaultTableCellRenderer class in NetBeans Code.

DefaultTableCellRenderer MyHeaderRender = new DefaultTableCellRenderer();
MyHeaderRender.setBackground(Color.decode("#696B9E"));
MyHeaderRender.setForeground(Color.decode("#FCE7FC"));

MyTblView.getTableHeader().getColumnModel().getColumn(0).setHeaderRenderer(MyHeaderRender);
MyTblView.getTableHeader().getColumnModel().getColumn(1).setHeaderRenderer(MyHeaderRender);
MyTblView.getTableHeader().getColumnModel().getColumn(2).setHeaderRenderer(MyHeaderRender);

After that this will show given output:

(3). jTable Rows Background and Foreground Color :

There is simple code for doing this. But remember one thing; it can change color of all rows. The simple and easy codes are as follows:

 MyTblView.setBackground(Color.LIGHT_GRAY);
 MyTblView.setForeground(Color.BLUE);

This code will not be use for particular rows settings.

This will show the following output.

(4). Change Background and Foreground Color of Particular Column's Rows in jTable :

Now, this is the very interesting point, because I have searched this point in many web-page and not find any suitable way to do this.

But, SKOTechLearn will explain simple tips to change Particular Column color of jTable in Java it, write or copy given code and see what happen.

First you have to import DefaultTableCellRenderer class:

import javax.swing.table.DefaultTableCellRenderer;

After that write given code:

 DefaultTableCellRenderer MyCellrendar = new DefaultTableCellRenderer();
 
 MyCellrendar.setBackground(Color.yellow);
 MyCellrendar.setForeground(Color.RED);

 MyTblView.getColumnModel().getColumn(1).setCellRenderer(MyCellrendar);

The output will be display like:

In getColumn() method, you can put any column number inside it and this will apply on that particular column's rows.

(5). jTable Selection background and Foreground Color :

In java, there is facility to change selection color of particular rows in jtable according to requirement.

You can apply one line code as described below:

 MyTblView.setSelectionBackground(Color.BLACK);
 MyTblView.setSelectionForeground(Color.YELLOW);

(6). jTable Selection Background and Foreground Setting in NetBeans :

If you are using NetBeans, then you can simply go to “Properties” window and find “selectionBackground” and “selectionForeground” option and choose color according to your requirement.

Steps are described in given following image:

So, these are the color changing process which is explained in Change jTable Column Header and Rows Color in Java NetBeans Easily.

Add Column Header in JTable and Grid Line Settings in jTable in Java

noreply@blogger.com (SKOTechLearn) — Sat, 27 Jun 2020 08:04:00 +0000

When you design you java project and want to show list of data in rows and columns format, you require a table or list, but List only contain one column with multiple rows and table contains multiple columns with multiple rows. You can find complete details of jTable class.

So Friends, here SKOTechLearn will discuss about jTable in Java with details description of Add Column Header in JTable in Java with jTable Grid setting in java NetBeans.

Change jTable's Column Header, Rows, Cell, Selection Color With Simple Steps

Suppose, you want to display some records which contains some Column. Then we have to drag jTable or write code for Adding Column Header in Java with Grid Settigns.

Add Sort option in JTable in Java

Here we proceed with following way:

Add Column Header in jTable in Java Code
Add Column Header in jTable in Netbeans through Properties
jTable Grid Line Setting in java code
jTable Grid line Setting in java Netbeans through Properties

So, let’s start with point to point.

(1). Add Column Header in jTable in Java Code :

For Column Header in JTable, you have to import some class as describe bellow:

 import javax.swing.JFrame;
 import javax.swing.JScrollPane;
 import javax.swing.JTable;
 import javax.swing.table.DefaultTableModel;

After that simply write following code:

 import javax.swing.JFrame;
 import javax.swing.JScrollPane;
 import javax.swing.JTable;
 import javax.swing.table.DefaultTableModel;

 public class MyTableClass {

   public static void main(String[] args) {
    // TableModel is use for showing rows and columns
    DefaultTableModel MyTablemodel = new DefaultTableModel();
    //Create New Table
    JTable MyTableView = new JTable(MyTablemodel);
    // Add jTable in jScollPane for Showing Column Header
    JScrollPane MyScrollPane= new JScrollPane(MyTableView);
    //Add Column Name 
    MyTablemodel.addColumn("MyColHead_ID");
    MyTablemodel.addColumn("MyColHead_Name");
    MyTablemodel.addColumn("MyColHead_Contact");
    //Add jFrame for showing Table inside frame
    JFrame MyTblFrame = new JFrame();
    MyTblFrame.setTitle("jTable Column Header Frame");
    //Set jFrame Size
    MyTblFrame.setSize(410, 320);
    MyTblFrame.add(MyScrollPane);
    MyTblFrame.setVisible(true);
   }
    
 }

Note : If you want to add rows and columns, DefaultTableModel will provide facility to do this.

When you execute this code this will show the following result:

(2). Add Column Header in jTable in NetBeans through Properties :

If you are using NetBeans for Java, First drag jTable in jFrame after that simply follow the following steps.

Right Click on jTable control and find “Table Contents…” option.

Click on “Table Contents…” option. “Customizer Dialog” will be displayed.

“Customizer Dialog” contains three tabs (Table Model, Columns, Rows ).

For headers, you have to choose “Columns” tab.

In “Columns” tab, you will find a table containing “Title, type, Resizable, Editable”. This is use for Column header settings.

Choose “Columns” tab which is also contain some buttons(Insert, Delete, Move Up, Move Down).

‘Insert’ button is used to add Columns, ‘Delete’ is used for delete Columns, ‘Move Up’ and ‘Move Down’ button is used for move column left or right in jTable according to your requirement.

Select ‘Title’ Column from table and go to “Title” box and write your column Name.

After that simply close “Customizer Dialog”.

Column Header Settings in NetBeans

When all settings will be done, your table will looks like bellow.

(3). jTable Grid Line Setting in java code :

If you want to change Grid Line color of jTable, first you have to add some rows and then you can write following code which is very simple and one line code.

Grid Color Setting Code:

 MyTableView.setGridColor(Color.red);

Now check it with following code:

public static void main(String[] args) {
    DefaultTableModel MyTablemodel = new DefaultTableModel();
    JTable MyTableView = new JTable(MyTablemodel);
   
    //jTable grid Line Settings
    MyTableView.setGridColor(Color.red);
    
    JScrollPane MyScrollPane= new JScrollPane(MyTableView);
    MyTablemodel.addColumn("MyColHead_ID");
    MyTablemodel.addColumn("MyColHead_Name");
    MyTablemodel.addColumn("MyColHead_Contact");
    // add some rows
    MyTablemodel.addRow(new Object[]{"Col1Row1_0000", "Col2Row1_ABCD", "Col3Row1_XXX0124556"});
    MyTablemodel.addRow(new Object[]{"Col1Row1_0001", "Col2Row1_EFGH", "Col3Row1_XXX01253344"});
    
    JFrame MyTblFrame = new JFrame();
    MyTblFrame.setTitle("jTable Column Header Frame");
    
    MyTblFrame.setSize(410, 250);
    MyTblFrame.add(MyScrollPane);
    MyTblFrame.setVisible(true);
  }

This will display output in given following figure:

(4). jTable Grid Line Setting in java Netbeans through Properties :

If you are using NetBeans for creating Swing project, you will find that jTable has no GridLines. First you have to add Gridlines then you can change Grid color according to your requirement.

 MyTableView.setShowGrid(true);
 MyTableView.setGridColor(Color.MAGENTA);

Or you can simple choose Grid Color from “Properties” window like bellow:

So, In this post you can see, how amazing is to work in java and NetBeans framework. You can simply Add Column Header in JTable and Grid Line Setting in jTable in Java which is detailed explained by SKOTechLearn.

Best Way of JTable Sorting in Java Netbeans with Details

noreply@blogger.com (SKOTechLearn) — Wed, 24 Jun 2020 07:48:00 +0000

jTable basically used for displaying information in the form of rows and columns. In Java you can easily design your table according to your need, so In this post we learn the Best way of jTable Sorting in Java NetBeans.

Easy Way to Add Coulmn Header and Change Grid Line Color of jTable in Java

Here, SKOTechLearn will explain row sorting of jTable with following way.

Static way to Enable Row Sorting of jTable in Java
Sort Particular Column of jTable in Java dynamically
Disable Particular Column for Sorting of jTable in Java dynamically

Suppose we add some records in table. Now we have to proceed with above given point.

(1). Static way to Enable Row Sorting of jTable in Java :

If you want to enable row sorting during design time. And sort it during run time then it can be done by two ways:

Enable Row Sorting through Properties in NetBeans

In NetBeans, you can just go to jTable’s "Properties" window, and find “autoCreateRowSorter” option from it.

Now, you have to check this option for enabling sorting like bellow.

autoCreateRowSorter Setting

When you will check mark on “autoCreateRowSorter” and run application, you have to double click on any Column Header, the column will be sorted according to row’s value in ascending or descending way.

jTable Column Sorting

Enable Row Sorting through code in Java NetBeans

if you want to set RowSorter through code then you can simply add this "MyTableView.setAutoCreateRowSorter(true);" code in following way.

 public TableSortFrame() {     
   initComponents();
   //Here MyTableView is jTable   
   MyTableView.setAutoCreateRowSorter(true);
 }

So, this way you can easily create jTable with row sort setting in design time.

(2). Sort Particular Column of jTable in Java dynamically :

Suppose, you make a project or application where you need to sort only specific column, then you have to follow with further steps.

Suppose, we want to sort Column No. 2 as describe above given table’s data. Now we sort “MyCol2” at runtime.

But first we have to import some classes:

 import javax.swing.table.TableModel;
 import java.util.ArrayList;
 import java.util.List;
 import javax.swing.table.TableRowSorter;
 import javax.swing.RowSorter;
 import javax.swing.SortOrder;

After that, we will drag jButton and write code for it like bellow:

 private void ColSortBtnActionPerformed(java.awt.event.ActionEvent evt) {  
   // MyTableView is jTable        
   TableRowSorter<TableModel> ColSort = new TableRowSorter<>(MyTableView.getModel());
   MyTableView.setRowSorter(ColSort);
   List<RowSorter.SortKey> ColSortingKeys = new ArrayList<>();
   //"SortColNo" is use to set Column No for Sorting
   int SortColNo = 1;
   //"SortKey" is used for sort order for a particular column
   ColSortingKeys.add(new RowSorter.SortKey(SortColNo, SortOrder.ASCENDING));
 
   ColSort.setSortKeys(ColSortingKeys);
   ColSort.sort();
  }

In above code, We have changed jTable’s Name with “MyTableView”.

When you run jFrame. And click on “ColSortBtn”. This will show the following output:

Friend, in above given way, you can easily sort any specific or particular column of jTable in Java at run time.

Note: If you Double Click on any other column, then the sorting will also be apply on that column.

(3). Disable Particular Column for Sorting of jTable in Java dynamically :

As you can see, the above given sorting process will be apply on any other column at run time.

If, you want to fix that only particular column will be sort and other column will not be used as sorting process. Then you have to disable that particular column for sorting.

Disable Column Sorting of jTable in Java

Suppose, you want to apply sorting in Column No. 3, and Disable Sorting in Column 1 and Column 2 then you will simply write following code for this process:

 private void ColSortBtnActionPerformed(java.awt.event.ActionEvent evt) {  
    TableRowSorter<TableModel> ColSort = new TableRowSorter<>(MyTableView.getModel());
    MyTableView.setRowSorter(ColSort);
    List<RowSorter.SortKey> ColSortingKeys = new ArrayList<>();
    //"SortColNo" is use to set Column No for Sorting
    int SortColNo = 2;
    //"SortKey" is used for sort order for a particular column
    ColSortingKeys.add(new RowSorter.SortKey(SortColNo, SortOrder.ASCENDING));
 
    ColSort.setSortKeys(ColSortingKeys);
    ColSort.sort();
    //Disable sorting in column 0 and column 1
    ColSort.setSortable(0, false);
    ColSort.setSortable(1, false);
 }

When you run it, this will work like following image.

So Friends, you can try it yourself and find that what will happen. Simply create project in Java and write code for jTable Row sorting in Java Netbeans using SKOTechLearn Tips.

SQL Server Database Connection String in Java NetBeans with Query

noreply@blogger.com (SKOTechLearn) — Tue, 23 Jun 2020 06:02:00 +0000

In java, when you want to connect MS SQL Server Database and want to show Table’s record in java, then you have to remember one thing, you have to require suitable database driver for java.

So, Here SKOTechLearn will describe the process steps by step for SQL Server Database Connection String in Java with Query.

Connect Database And Access All Tables and Records with NetBeans

For This process you have to follow the steps given following.

Download “sqljdbc4.jar” file
Attach “sqljdbc4.jar” File in Project’s Package
Import SQL Class and Other Related Class
SQL Server Connection Code in Java with Example
Use SQL Server Query in Java NetBeans

Step(1). Download “sqljdbc4.jar” file :

If you want to use database connection on your projects, you have to know that you have to required suitable driver for database connection in java.

So, For SQL Server Connection in Java, you can use “sqljdbc4.jar” file for driver.

You can find it from many sites, and here are two sites where you can find this driver easily.

First Site
Second Site

Step(2). Attach “sqljdbc4.jar” File in Project’s Package :

After that you have to create your project and when you expand your project in NetBeans, you will find there are many Package Folders available.

Find “Libraries” Package Folder from you project.

Right click on “Libraries” Package Folder. And Select third option “Add JAR/Folder…”.

This option will show you “Add JAR/Folder” Window.

Browse your downloaded “sqljdbc4.jar” file.

This jar file will be added on your project’s “Libraries” like above given image.

How to Set Default Main Class in Java Using Netbeans

Step(3). Import SQL Class and Other Related Class :

Now, before start connection string, you have to import some class as described below.

 //java.sql.Connection is use for establishing connection from database
 import java.sql.Connection;
 //java.sql.DriverManager is used for calling driver with connection string
 import java.sql.DriverManager;
 //javax.swing.JOptionPane for Display Message
 import javax.swing.JOptionPane;

Step(4). SQL Server Connection Code in Java with Example :

Now let’s try to connect database from server in java Netbeans, We will write code inside jButton’s ActionPerformed event.

 private void SQLConn_BtnActionPerformed(java.awt.event.ActionEvent evt) {    
  try {
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
     Connection SQlCnn = DriverManager.getConnection("jdbc:sqlserver://XXX.XXX.X.XX; databaseName= MySQLDB; user= MYSQLUser; password= MySQLPasswrd");
     JOptionPane.showMessageDialog(null, "SQL Server Connection Successfully.");
     SQlCnn.close();
  }catch (Exception CnnErr){
     JOptionPane.showMessageDialog(null, "SQL Server Connection Problem");
  }
 }

When you run this code, the following output will be shown:

Simply copy above code and modify servername, databasename, username and password then run your project.

Simple Way to Display Image in Java

Step(5). Use SQL Server Query in Java NetBeans :

Suppose we have a table “MySQLDBTable” and there is two column “MyTBL_ID” and “MyUsrName”. And this table contains some records like bellow:

So, if you want to display all records, you have to use “Select Query Statement”. And write code in NetBeans in following way.

Use of Select Query in Java

private void SQLQuery_BtnActionPerformed(java.awt.event.ActionEvent evt) {
  try {
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
     Connection SQlCnn = DriverManager.getConnection("jdbc:sqlserver://XXX.XXX.X.XX; databaseName= MySQLDB; user= MYSQLUser; password= MySQLPasswrd");
     Statement MyDBstmt = SQlCnn.createStatement();
     ResultSet MyRSet = MyDBstmt.executeQuery("Select * From MySQLDBTable");
     while( MyRSet.next()) {
          System.out.println(MyRSet.getString("MyTBL_ID") + "   |   " + MyRSet.getString("MyUsrName"));
        }    
     MyRSet.close();
     MyDBstmt.close();
     SQlCnn.close();
        
   }catch (Exception DBErr){
      JOptionPane.showMessageDialog(null, "SQL Server Connection Problem");
   }
 }

When you run this code, this will show you following output.

So, these are the steps for establishing connection from database server or SQL Server Database Connection String in Java Netbeans with Query.

What Settings for Auto Resize Control in Java Using Netbeans?

Show Files List With Icons In Listview Using ImageList in VB6.0

noreply@blogger.com (SKOTechLearn) — Fri, 19 Jun 2020 11:28:00 +0000

In this post, we will learn items with image in Listview. Sometimes we require a list which contain image including items. The listview will use for this process due to its fast and easiest way in vb6.0. There is a simple process for doing practical on your VB6.0 application development. So, SKOTechLearn will explain the way to Show Files List with Icons in Listview using ImageList in VB6.0.

In the following steps we describe the 3 code process, in which you can use anyone code process for your desire.

Dynamically Add Items in ListView in VB6

Show files List with Path and Icon in Listview using ImageList in vb6.0 like bellow:

Let’s find and learn, how can we find this type of output?

(1). Create some images for Icons:

We have to create some images for showing as icon in Listview. Now ,try to create through Paint with Print Screen process as I created bellow.

(2). Drag Some Controls:

Now drag some controls like Command button for doing activity and Listview for Showing List with icons and Path and ImageList Control for fetching images.

Here we changed Listview1 name is MyLstView and ImageList1 name is MyImageList

Simply use ListView for Edit or Delete Selected Items

(3) ImageList and Listview Settings:

First we add some image in ImageList through properties and set every image with Key name, which is use for calling inside Listview. After that we setting on Listview Properties like Column header and View type etc.

In above given image you can Set Listview Properties with Column Header easily.

Now write code for listing Files with icon as describe bellow.

Process(1):

In this process we use Select Case Statement for showing files with path and icons in Listview.

VB6.0:

 Private Sub ShowFileIcon_Btn_Click()
 'First you have to set listview smallicon with ImageList
 Set MyLstView.SmallIcons = MyImageList
 Dim i As Integer
 i = 1
 With MyLstView

  Dim myFilesList As String
  'Use Dir for Collection files' List
  myFilesList = Dir("C:\SKOTechLearn_Files\*.*")
  'Clear Listview
  MyLstView.ListItems.Clear
  'Loop wntil Files' list will not Null or Empty
  While myFilesList > vbNullString

   Dim MyFLExten As String
   'Following formula is used for Extract "Extension" from Files
   MyFLExten = UCase(Mid(myFilesList, InStrRev(myFilesList, "."), Len(myFilesList)))
      
   Select Case MyFLExten
      Case ".JPG"
           ' Listview.ListItems.Ass [Index], [key], [Text],[Icon], [SmallIcon]
           .ListItems.Add , , myFilesList, , "ImgIco1"
      Case ".PNG"
              .ListItems.Add , , myFilesList, , "ImgIco1"
      Case ".XLS", ".XLSX"
              .ListItems.Add , , myFilesList, , "XlsIco6"
      Case ".PDF"
              .ListItems.Add , , myFilesList, , "PdfIco2"
      Case ".TXT"
              .ListItems.Add , , myFilesList, , "TxtIco4"
      Case ".XPS"
              .ListItems.Add , , myFilesList, , "XpsIco7"
      Case ".DOC", ".DOCX"
              .ListItems.Add , , myFilesList, , "DocIco5"
      Case Else
              .ListItems.Add , , myFilesList, , "OtherIco8"
    End Select

    .ListItems(i).ForeColor = vbBlue
    'List with Path and Files
    .ListItems(i).ListSubItems.Add , , "C:\SKOTechLearn_Files\" & myFilesList
    .ListItems(i).ListSubItems(1).ForeColor = vbRed
    .ListItems(i).ListSubItems.Add , , MyFLExten
    ' retun remaining Dir File's List
     myFilesList = Dir
    DoEvents
    i = i + 1
  Wend

 End With

 End Sub

Remove Multiple Checked Items from Listview Easily

Process(2):

In this Process we Use If Else Statement for showing Files List with icons in ListView.

VB6.0:

 Private Sub ShowFileIcon_Btn2_Click()
 'First you have to set listview smallicon with ImageList
 Set MyLstView.SmallIcons = MyImageList
 Dim i As Integer
 i = 1
 With MyLstView

   Dim MyFlList As String
  'Use Dir for Collection files' List From path
   MyFlList = Dir("C:\SKOTechLearn_Files\*.*")
   MyLstView.ListItems.Clear
   While MyFlList > vbNullString

      Dim MyFLExt As String
     'following formula used to extact "Extension" From Files
      MyFLExt = UCase(Mid(MyFlList, InStrRev(MyFlList, "."), Len(MyFlList)))

      If MyFLExt = ".JPG" Or MyFLExt = ".PNG" Or MyFLExt = ".XLS" Or MyFLExt = ".XLSX" Or MyFLExt = ".PDF" Or MyFLExt = ".TXT" Or MyFLExt = ".XPS" Or MyFLExt = ".DOC" Or MyFLExt = ".DOCX" Then

          If MyFLExt = ".JPG" Then
              ' Listview.ListItems.Ass [Index], [key], [Text],[Icon], [SmallIcon]
              .ListItems.Add , , MyFlList, , "ImgIco1"
          End If
          If MyFLExt = ".PNG" Then
              .ListItems.Add , , MyFlList, , "ImgIco1"
          End If
          If MyFLExt = ".XLS" Or MyExt = ".XLSX" Then
              .ListItems.Add , , MyFlList, , "XlsIco6"
          End If
          If MyFLExt = ".PDF" Then
              .ListItems.Add , , MyFlList, , "PdfIco2"
          End If
          If MyFLExt = ".TXT" Then
              .ListItems.Add , , MyFlList, , "TxtIco4"
          End If
          If MyFLExt = ".XPS" Then
              .ListItems.Add , , MyFlList, , "XpsIco7"
          End If
          If MyFLExt = ".DOC" Or MyExt = ".DOCX" Then
              .ListItems.Add , , MyFlList, , "DocIco5"
          End If
          
      Else
              .ListItems.Add , , MyFlList, , "OtherIco8"
      End If

      .ListItems(i).ForeColor = vbBlue
      .ListItems(i).ListSubItems.Add , , "C:\SKOTechLearn_Files\" & MyFlList
      .ListItems(i).ListSubItems(1).ForeColor = vbRed
      .ListItems(i).ListSubItems.Add , , MyFLExt
      ' retun remaining Dir File's List
       MyFlList = Dir
     DoEvents
     i = i + 1
   Wend

 End With
 End Sub

Process(3):

In this process we use FileSystemObject for show Files in Listview with Icons.

How To Add FileSystemObject (scrrun.dll) in VB6.0?

For Using FileSystemObject, you have to first add references ‘Microsoft Scripting Runtime’. This reference contains FileSystemObject class.

The following image will show how to add Microsoft Scripting Runtime (scrrun.dll) in VB6.0.

Go to Project menu and find “References..” option.

Click on this option and this will show “References..” window.

This window will show the Available References List.

Find “Microsoft Scripting Runtime” and check on it.

In this way you can add any Reference.

After adding Microsoft Scripting Runtime. Write following code.

VB6.0:

 Private Sub FilesListFSO_Cmd_Click()
 Dim myfsobj As New FileSystemObject
 Dim myfldr As Folder
 Dim myfl As File
 Set myfldr = myfsobj.GetFolder( "C:\SKOTechLearn_Files\" )
 'First you have to set listview smallicon with ImageList
 MyLstView.ListItems.Clear
 Set MyLstView.SmallIcons = MyImageList

 With MyLstView
   Dim li As Integer
   li = 1

   For Each myfl In myfldr.Files
      Dim MyFLExten As String
      'Extract Extension through FileSystemobject's GetExtensionName method
      MyFLExten = UCase(myfsobj.GetExtensionName(myfl))

      Select Case MyFLExten
          Case "JPG"
              .ListItems.Add , , myfl.Name, , "ImgIco1"
          Case "PNG"
              .ListItems.Add , , myfl.Name, , "ImgIco1"
          Case "XLS", "XLSX"
              .ListItems.Add , , myfl.Name, , "XlsIco6"
          Case "PDF"
              .ListItems.Add , , myfl.Name, , "PdfIco2"
          Case "TXT"
              .ListItems.Add , , myfl.Name, , "TxtIco4"
          Case "XPS"
              .ListItems.Add , , myfl.Name, , "XpsIco7"
          Case "DOC", "DOCX"
              .ListItems.Add , , myfl.Name, , "DocIco5"
          Case Else
              .ListItems.Add , , myfl.Name, , "OtherIco8"
      End Select

      .ListItems(li).ForeColor = vbBlue
      .ListItems(li).ListSubItems.Add , , myfl
      .ListItems(li).ListSubItems(1).ForeColor = vbRed
      .ListItems(li).ListSubItems.Add , , MyFLExten
      DoEvents
      li = li + 1

   Next
 End With
 'After show files list, clear Files Folders and FileSystemObject class
 Set myfl = Nothing
 Set myfldr = Nothing
 Set myfsobj = Nothing
 End Sub

Give above 3 process will show the same output as shown bellow image.

So, SKOTechLearn has Explained with some simple process to Show Files List With Icons In Listview Using ImageList in VB6.0.

How to move checked items from one Listview to Another?

About HTML and HTML Element with HTML Example

noreply@blogger.com (SKOTechLearn) — Sun, 14 Jun 2020 06:40:00 +0000

Whenever a developer desires to jump from desktop application’s development to web development. Then he has to learn about HTML. Suppose, you want to be a web developer or you want to develop your own website. Then you must have the knowledge of HTML.

If you learn HTML, the door of web development will be open for you. So, here we will Understand About HTML and HTML Document with Example.

So here we learn it through following point:

What Is HTML?
Understand about HTML Document
HTML Syntax with Base Code process
Best Tool For HTML Code Editor
Simple Example of HTML Coding Structure

What Is HTML?

In simple word the definition is defined inside its full form (Hypertext Markup Language ). HTML language is used with Hypertext and markup language, where it displays the information in the form of (text, images etc) to users’ screen on any web-browser( Firefox, Chrome, Internet Explorer etc.)

In HTML, hypertext is the way where we put the link that can be active or explore through key process. Basically hypertext is Hyperlink which is defined by Anchor (< a >) Tags.

And the markup language is the writing way where we can write code for web document with the use of HTML Tags. HTML Tag is markup Language.

Understand about HTML Document

When we prepare a file including layout, text, Images and hyperlinks with “.html” extension for web process. And what to execute it on any web-browser. Then that execution time this file will be Displayed in any web browser called HTML Document.

Now, in this time you are viewing or reading HTML Document on your web browser.

Basically web page is HTML Document which is mainly written in HTML.

HTML Syntax with Code process

Now, we will learn what is the code writing process and what is syntax of HTML?

When you want to create or design web page then the HTML Syntax will be use. The HTML has following syntax:

<tag open> Content </tag close>

eg.: <h1> HTML Heading Tag example </h1>

So, the whole html code is base on Tags and Elements.

Now, let's know about Tag.

What is Tag in HTML?

In simple word, The entire code of the HTML revolves around the Tags. And The Tag is surrounded by Angular Brackets "< >".

For example if you see the above syntax. We use <h1>. Here h1 is Tag. There are may tags like
<p>
<h2>
<div>
<table>
etc.

What is Element in HTML?

Normally, you can define Element is the combination of Opening Tag + Content + Closing Tag. Now, let's try to understand by given following example.

<html>
  <head>
    <title> First Element with "Title" Tag </title>
  </head>
  <body>
    <h1> Second Element with "h1" Tag </h1>
    <div> Third Element with "DIV" Tag </div>
  </body>

</html>

Best Tool For HTML Code Editor

Now, the next point is in which Tool we can write code for HTML document of Web-page Design. The answer is, there are many tools which you can use for it easily like (Notepad, Notepad++, NetBeans,VS Code, Eclipse etc.).

But remember one thing, For HTML Code writing, you have to need Text Editor or HTML Designer Tool and Reading this code or HTML file you need Web-browser on your PC or laptop.

Basically HTML Document of File is simple or normal text files. And Web-browser works to understand the tags of HTML code and other supporting code like CSS, JavaScript etc.

So, Text Editor and Web-browser is necessary for HTML Coding.

Simple Example of HTML Coding Structure

Now, if you have some basic knowledge of computer or OS then you can easily proceed in following way. You can now write following code or you can copy that code and see the output.

HTML Code Example:

<html>
 <head>
   <title> SKOTechLearn Document Title </title>
 </head>
 <body>
   <h1> SKOTechLearn HTML Heading H1 </h1>
   <p> SKOTechLearn HTML Paragraph </p>
 </body>
</html>

When you run this file, the following output will be displayed. You can easily copy this code and try it yourself.

Now, you can also try to design a web-page after learning Easy Understand About HTML and HTML Document with Example.

Set Tkinter Window Position and Size or Center Screen Tkinter in Python

noreply@blogger.com (SKOTechLearn) — Tue, 09 Jun 2020 09:35:00 +0000

When you start programming in python using Tkinter. You will find that the default form or dialog location is not appear as desired location. You will have to move it by mouse. And also in some cases you just need to show Tkinter window in center position on the screen. Find latest version of Python.

So, here SKOTechLearn will explain and describe step by step process to Set Tkinter Window Position and Size or Center Screen Tkinter in Python.

Easy Way to Use Tkinter Label in Python.

Let’s Start with following way:

Set Tkinter Window Size in Python
Set Tkinter Window Position in Python
Center Screen Tkinter Window in Python

By default tkinter is set in 200x200 height and width size.

(1). Set Tkinter Window Size in Python :

If you make an application in python using tkinter. And you want to increase or decrease the size of Window or Height width of your window, you have to use following syntax:

Tk().geometry("widthxheight")

In this syntax, you have to change width and height with desired number or integer.

Now lets see the example how its work?

 from tkinter import * 
 TkForm = Tk()

 #Set Height and Width of Window
 TkForm.geometry("350x150") 

 #Set the Title according to desire
 TkForm.title("TK Size in Python")

 TkForm.mainloop()

When you run this code, the following geometry will show bellow

Tk Size Output

This way you can set the size of your application form.

Python If Else Statement with Details Description and Example.

(2). Set Tkinter Window Position in Python :

Like above given Size setting, you can set the position using “geometry” option in TK() class. So, let’s see the syntax of position setting.

Tk().geometry("+Left+Top")

Here, you have to replace “Left” and “Top” with integer.

So, the simple example of position settings is shown bellow.

 from tkinter import * 
 TkForm = Tk()
 #position setting with desire location.
 # "+" sign indicate the Window's position in geometry option. 
 TkForm.geometry("+120+50")

 TkForm.title("TK Position Setting")
 TkForm.mainloop()

Now the output will be like this.

Location Setting

Now, if you want to set height and Width and Position of Tkinter window in one line code, then you have to use following syntax:

Tk().geometry("widthxheight+Left+Top")

Lets see, how its work with given following example:

 from tkinter import * 
 TkForm = Tk()
 # Width and Height with Location Setting
 TkForm.geometry("350x150+220+80")

 TkForm.title("TK Position Setting")
 TkForm.mainloop()

This will display the output like:

Height and Width with Location Setting

So, In This way, you can set the Size and Position of Tkinter easily.

(3). Center Screen Tkinter Window in Python :

Now, if you want to set widow as center Screen with desire screen Size, then we have found following way where you can set center screen in python.

Remember one thing, first you have to get the size of Screen by given root option.

winfo_screenwidth(): This will show the screen Width
winfo_screenheight(): This will show the screen Height

you can get more details of .geometry() from here.

Process (1):

 from Tkinter import *
 MyTkForm = Tk()

 #Set desired Tkinter Window Size.
 MyTkForm.geometry("350x150")

 #Same size will be defined in variable for center screen in Tk_Width and Tk_height
 Tk_Width = 350
 Tk_Height = 150

 #calculate coordination of screen and window form
 x_Left = int(MyTkForm.winfo_screenwidth()/2 - Tk_Width/2)
 y_Top = int(MyTkForm.winfo_screenheight()/2 - Tk_Height/2)
 
 # Write following format for center screen
 MyTkForm.geometry("+{}+{}".format(x_Left, y_Top))

 MyTkForm.title("Process (1): Center screen with size")

 MyTkForm.mainloop()

Process (2):

 from tkinter import * 
 
 MyTkForm = Tk()

 # Set desired size (height and width) in following variable
 Tk_Width = 350
 Tk_Height = 150
 
 #calculate coordination of screen and window form
 positionRight = int( MyTkForm.winfo_screenwidth()/2 - Tk_Width/2 )
 positionDown = int( MyTkForm.winfo_screenheight()/2 - Tk_Height/2 )

 # Set window in center screen with following way.
 MyTkForm.geometry("{}x{}+{}+{}".format(500,200,positionRight, positionDown))

 # Set Desired Title
 MyTkForm.title("Process (2) : Center screen with size")

 MyTkForm.mainloop()

Process (3):

from tkinter import *

 TkForm2 = Tk()

 #set center screen window with following coordination
 MyLeftPos = (TkForm2.winfo_screenwidth() - 500) / 2
 myTopPos = (TkForm2.winfo_screenheight() - 300) / 2
 TkForm2.geometry( "%dx%d+%d+%d" % (500, 300, MyLeftPos, myTopPos))

 TkForm2.title("Process (3): TK Center Screen")
 TkForm2.mainloop()

Process (4):

import tkinter as tk

 TkForm3 = tk.Tk()

 # set window width and height
 mywidth = 350
 myheight = 150

 # get screen height and width
 scrwdth = TkForm3.winfo_screenwidth()
 scrhgt = TkForm3.winfo_screenheight()

 # write formula for center screen
 xLeft = (scrwdth/2) - (mywidth/2)
 yTop = (scrhgt/2) - (myheight/2)

 # set geometry 
 TkForm3.geometry(str(mywidth) + "x" + str(myheight) + "+" + str(xLeft) + "+" + str(yTop))

 TkForm3.title('Process (4): Center screen with size')
 TkForm3.mainloop()

So, all the process will work as same for center screen. You can choose anyone for your application development. The output will looks like:

Center Screen Window

These are the process for Set Tkinter Window Position or Center Screen Tkinter in Python with complete description.

Features and Use of Label in Python Tkinter Example

noreply@blogger.com (SKOTechLearn) — Sat, 06 Jun 2020 07:45:00 +0000

In Python, when you want to display desired text or desired Image, There are many widgets availabel in python. you can Simply use label for multiple purpose. So, here we learn about how to use Tkinter Label in Python. But first you should understand about Tkinter.

What is Tkinter?
Tkinter is Python’s Basic Package or you can say it is Basic Graphical User Interface Toolkit, which contains many widgets. And a beginner programmer can start GUI Base application using Tkinter.

So, Here SKOTechLearn Describe the easy way to use Label in Python using Tkinter Example. And we describe the use of Label widgets in Python.

Check How if else statement will work in Python?

Now, Let’s start the basic Options, we need for Label Settings in Python.

Options	Details and use
text	Input desire string or value for display
anchor	This will align the text in Left, Right, Center. eg.: For Left align : anchor=W For Right align : anchor=E For Center align : anchor=CENTER by default Label already set in center align.
bg / background	Label’s background color change option
fg / foreground	Label’s Text or Font color change option
relief	Option to set border style (raised, groove, solid, ridge, sunken, flat)
font	Set the font with font name, size and style. This option syntax is: font=("FontName", Size, style) eg: font=("Courier", 14, "bold")
image	This option will be use to display image inside Label and Image Control.
textvariable	This option is used to call predefined string to pass the variable in label to that particular class. This option uses StringVar for variable control.
bd / borderwidth	You can set border width from these two option: either bd or borderwidth.
height	Increasing or decreasing Label’s height will be control by this option by passing value like: height=4
width	Increasing or decreasing Label’s width will be control by this option by passing value like: width=30

Now Lets start to understand how to pass variable in label and some basic label’s setting through above given options:

Here, first you have to import all widgets from Tkinter toolkit.

from Tkinter import *

After that you will proceed:

 from Tkinter import *
 Myroot = Tk()
 myLbl = Label(Myroot, text="SKOTechLearn", relief="groove", bd=2) 
 myLbl.pack()
 Myroot.title("Tkinter Label in Python")
 Myroot.mainloop()

After executing this code, the following output will be show:

Tkinter window position and size setting with center screen process in Python

Now, Let’s see the textvariable example in Tkinter Label.

Font, background or foreground color and border settings of Label in Python:

So, following code will cover the point:

Tkinter Label font style in Python
Tkinter Label Background Color in Python
Tkinter Label Foreground Color in Python
Tkinter Label Border Setting in Python

 from Tkinter import *
 Myroot = Tk()
 myvar = StringVar()
 myLbl = Label( Myroot, textvariable=myvar, relief = "groove", font =( "Courier", 14, "bold"),  bd=1, fg = "red", bg ="#DDEEF0" )    
 myvar.set( "SKOTechLearn" )
 myLbl.pack()
 Myroot.title( "Label in Python" )
 Myroot.mainloop()

This will show the following output.

And the Last Example will be use to show the multiple line label in Python.

Tkinter Multi-Line Label in Python

So, the simple process is to use “\n” inside text variable like following example.

 from Tkinter import *
 Myroot = Tk()
 myvar = StringVar()
 myLbl = Label( Myroot, textvariable=myvar, relief = "groove", font =( "Courier", 14, "bold"),  bd=1, fg = "red", bg ="#DDEEF0" )   
 # Use "\n" for Next Line in Python by Following Way .
 myvar.set( "SKO \n Tech \n Learn \n Tips" )
 myLbl.pack()
 Myroot.title( "Label in Python" )
 Myroot.mainloop()

And the final Multiline Label in Python output will be as:

So, this is the easy way to understand how to use Tkinter label in Python with step by step process and descriptions described in SKOTechLearn Tips.

Display Date time in Different DateTime Format in Vb6 or VB.net

noreply@blogger.com (SKOTechLearn) — Sat, 30 May 2020 12:14:00 +0000

If you want to display date and time or get system Date Time with various format or specific format then there are various type of method available in VB or VB.Net or C# code. In this post SKOTechLearn explain how to Display Date Time in Different DateTime Format in VB or Vb.Net programming.

Search Files Tips From Folders and Sub-Folders in VB.Net Programming.

First, you have to know that, In programming you can use Date Time Formatting with two way:

Predefined Format method
User-defined Format method

(1) Predefined Format Method:

Following details and code will describe, how these method will work to show predefined DateTime Format. Let's follow the following Table:

Predefined Format Method	Uses
Now	VB6.0, VB.Net
Date	VB6.0, VB.Net
Time	VB6.0
Format (Now, "Short date")	VB6.0, VB.Net
Format (Now, "Long Date")
Format (Now, "General date")
Format (Now, "Short Time")
Format (Now, "Long Time")
Today	VB.Net
TimeOfDay	VB.Net
DateTime.Now.ToString()	C#, VB.Net
DateTime.Today.ToString()
DateTime.Now.TimeOfDay.ToString()
DateTime.Now.ToShortDateString()
DateTime.Now.ToLongDateString()
DateTime.Now.ToLocalTime().ToString()
DateTime.Now.ToShortTimeString()
DateTime.Now.ToLongTimeString()

So, let's see the examples which can be use to format predefined type in VB6, VB.Net and C# code:

Step by Step to Design Menu and Sub-Menu with Settings in VB6.0.

VB6.0:

 Private Sub MyButton1_Click()
    MyTxtBox1.Text = Now
    MyTxtBox2.Text = Date
    MyTxtBox3.Text = Time

    MyTxtBox4.Text = Format(Now, "Short date")
    MyTxtBox5.Text = Format(Now, "Long Date")
    MyTxtBox6.Text = Format(Now, "General date")
    MyTxtBox7.Text = Format(Now, "Short Time")
    MyTxtBox8.Text = Format(Now, "Long Time")
 End Sub

After Executing application, you will find that the following output will be Shown:

VB.Net :

 Sub MyDateBtnClick(sender As Object, As EventArgs)
     MyText1.Text = Now.ToString
     MyText2.Text = Today.ToString
     MyText3.Text = TimeOfDay.ToString
     MyText4.Text = Format(Now, "Short date")
     MyText5.Text = Format(Now, "Long Date")
     MyText6.Text = Format(Now, "General date")
     MyText7.Text = Format(Now, "Short Time")
     MyText8.Text = Format(Now, "Long Time")
 End Sub

This will show the following output:

PreDefined DateTime Format in C#

C# :

void MyDateBtnClick(object sender, EventArgs e)
  {
     MyCTxt1.Text = DateTime.Now.ToString();
     MyCTxt2.Text = DateTime.Today.ToString();
     MyCTxt3.Text = DateTime.Now.TimeOfDay.ToString();
     MyCTxt4.Text = DateTime.Now.ToShortDateString();
     MyCTxt5.Text = DateTime.Now.ToLongDateString();
     MyCTxt6.Text = DateTime.Now.ToLocalTime().ToString(); 
     MyCTxt7.Text = DateTime.Now.ToShortTimeString();
     MyCTxt8.Text = DateTime.Now.ToLongTimeString();                  
   }

After compiling this code, you will find the following output, when you click on Button.

So these are the predefined method in VB6, VB.Net and C#. Now Let's Find Custom method or User-Defined Method for Display Date and Time.

How to Create Login Form with Database Connection in Vb6.0?

(2) User-defined Format method :

The following table describe the method of User-defined DateTime Format in VB6.0, VB.Net and C# code.

User Defined Format Method	Use
Format ( now, “Your Formatted String” )	VB6.0, VB.Net
Now.Today.ToString ( “Your Formated String” )	VB.Net
DateTime.Now.ToString ( “Your Formated String” )	C#, VB.Net
DateAndTime.Now.ToString ( “Your Formated String” )	VB.Net

Why user defined format method is required? The answer is, in some case or sometime we required specific date time output on their application. So, the user defined format method is used.

SQL Server Connection String with Example and SQL Query Process in VB.Net.

Now, follow the following method for User Defined format process.

VB6.0 :

Private Sub UsrDtBtn_Click()
    UsrTxtBox1.Text = Format(Now, "dd")
    UsrTxtBox2.Text = Format(Now, "dddd")
    UsrTxtBox3.Text = Format(Now, "MM")
    UsrTxtBox4.Text = Format(Now, "MMMM")
    UsrTxtBox5.Text = Format(Now, "yyyy")
    UsrTxtBox6.Text = Format(Now, "dd/MM/yyyy" )
    UsrTxtBox7.Text = Format(Now, "dd-MM-yyyy" )
    UsrTxtBox8.Text = Format(Now, "MM/dd/yyyy hh:mm:ss AMPM" )
    UsrTxtBox9.Text = Format(Now, "hh:mm:ss AMPM" )
    UsrTxtBox10.Text = Format(Now, "hh:mm:ss" )
 End Sub

When you run VB Form, The following image output will be show.

VB.Net :

Sub UsrDTBtnClick(sender As Object, e As EventArgs)
    
    UsrTxt1.Text = Now.ToString("dd/MM/yyyy")
    UsrTxt2.Text = Now.ToString("MM/dd/yyyy hh:mm:ss tt")
    UsrTxt3.Text = DateAndTime.Now.ToString("dddd")
    UsrTxt4.Text = DateAndTime.Now.ToString("MMMM")
    UsrTxt5.Text = DateTime.Now.ToString("hh:mm:ss tt")
    UsrTxt6.Text = DateTime.Now.ToString("dddd; dd-MMMM-yyyy")
    UsrTxt7.Text = Format(Now, "dd-MM-yyyy")
    UsrTxt8.Text = Format(Now, "MMMM, yyyy")
        
 End Sub

Ok, Let's see the output:

C# :

void UserDtBtnClick(object sender, EventArgs e)
 {
     DateTime UsrDt;
     UsrDt = DateTime.Now;
     MyText1.Text = UsrDt.ToString("dd/MM/yyyy");
     MyText2.Text = UsrDt.ToString("MM/dd/yyyy hh:mm:ss tt");
     MyText3.Text = UsrDt.ToString("dddd");
     MyText4.Text = UsrDt.ToString("MMMM");
     MyText5.Text = UsrDt.ToString("hh:mm:ss tt");
     MyText6.Text = UsrDt.ToString("dddd; dd-MMMM-yyyy");
     MyText7.Text = UsrDt.ToString("MMMM, dd-yyyy");
     MyText8.Text = UsrDt.ToString("dd-MMMM-yy");
                    
  }

After that we get following output:

Now, these are the process to use to Display Date Time in Different DateTime Format in VB6.0 or VB.Net and C# with SKOTechLearn Tips.

Styling ProgressBar with Color Change and Settings in Vb6.0 or VB.Net.