Archive for February 2016
Examples of SQL Commands - DDL, DML
Example for SQL commands – DDL,
DML
--Create database Db_Product and check it in Databases Folder
create database
Db_Product
--using product database (Selected in databases dropdown)
use Db_Product
--create table Tbl_Items with 3 cols - Id.
TCL commands
B – Begin Transaction (To start recording transactions)C – Commit (To save the transaction permanently)R – Rollback (To revert the database to the state where recording starte.
DML commands
SUDI
S – Select (To retrieve data)U – Update (to update data)D – Delete(to delete rows of data)I – Insert (to insert new row of dat.
DDL commands
DRCAT
D – Drop (To delete a database or table)R – Rename (To change the column name)C – Create (To create a database or table)A – Alter (To work on columns)T – Truncate(To clear entire table data)Alter contains three commands:Alter Add (To add column)Alter.
Introduction to SQL
SQL is a language used to interact with the database. SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL is an ANSI (American National Standards Institute) standard. SQL is not case sensitive.
RDBMS
RDBMS stands.
Windows Forms User Controls
User Controls are controls that are created by the users with customized requirements. We can create a new control with so that we can reuse it in our project.Implementing User Controls
Steps to create user control
File – New Project – Select language.
StringBuilder and string
StringBuilder is mutable which means we can append, insert or replace text in string without creating new memory for it everytime. Once a StringBuilder is created text can be added to the existing text without creating new memory everytime whenever.
Dialogs
Dialogs will allow the user give their inputs.
ColorDialogAllows the user to select a color from the system colors.
FolderBrowserDialogAllows the user to select a folder his system.
FontDialogAllows the user to select the font style available in.
StatusStrip
StatusStrip is a collection of controls which are displayed at the bottom of the form which is generally used to display the status of the window form.Default Event: Click which is fired when user click on the item.Steps to create StatusStripDrag and.
ContextMenuStrip
Context menus are appeared when user right-click. They looks like a floating menu. Different context menus can be displayed in a form based on the location where user has clicked. Multiple context menus can be created and they has to be assigned to.
ToolStrip
It is a menu present at the top of the form which is capable of hosting Button, Label, SplitButton, DropDownButton, Separator, ComboBox, TextBox and ProgressBar controls.Default Event: Click which is fired when user click on the controls in toolbox.Steps.
MenuStrip
MenuStrip adds a menu bar at the top of the windows form. Default Event: Click which is fired when you click on that specific menuitem. Each item will have its own click event.Steps to create a MenuStripDrag and drop a menustrip control to the form.
TabControl
Controls are displayed under different tabs. Different controls can be displayed in the same location and with the selection of tab controls inside that tab are displayed in the runtim.
SplitContainer
Divides a container’s display area into two resizable panels to which you can add controls.You can drag and drop controls into one of the two container and in the runtime the panels can be resize.
GroupBox
Displays a frame around the controls with an optional caption. The frame of the groupbox will be visible in the output.Properties:Text: The text that is displayed as the caption on groupbox control in output.Steps to use a panelDrag and drop a group.
FlowLayoutPanel
It is capable of holding multiple controls inside it and it will arrange them in automatically an order.Properties:FlowDirection: Specifies the direction in which controls are laid out.Example: LeftToRight, RightToLeft, TopDown, BottomUpWrapContents:.
Panel
Used to group collection of controls.Panel is not visible in the output but helps in design time to group collection of controls. All the controls inside panel can be moved at once and they can be relatively arranged inside a panel.Steps to use a panelDrag.
Containers
Containers are controls which can hold other controls
inside them.
Example: Panel, FlowLayoutPanel, GroupBox etc.
They are used to hold multiple controls and helps in
easy organization of controls inside the form.
WebBrowser
It is used to browse web pages inside the windows form.Property:Specifies the URL that the web browser control has to display. Example: http://www.google.comThis will work only when internet is availabl.
TreeView
It is used to display items in hierarchy in parent and child nodes format.Adding items to treeview:Click on the smart tag – Edit nodes. Add root to add root items under which child items can be added with a click on Add child option by selecting the.
ToolTip
Displays information when the user moves the cursor over an associated control.Steps to use tooltip:Drag and drop a tooltip control to the design window. It is displayed on the bottom panel.Properties: TootlTipTitle: Determines the title of the tooltip.Now.
TextBox
It is used to take input from user.Default Event: TextChanged which is fired when text in textbox changed.Example code to take input from user and print immediately in a label control
private void textBox1_TextChanged(object sender, EventArgs e)
.
RichTextBox
It is used to take input from user like textbox and it is capable of holding text styles.Default Event: TextChanged which is fired when text in RichTextBox changed in runtime.Example code to print text in RichTextBox in label with a change in text
private.