https://msdn.microsoft.com/en-us/library/system.windows.forms.flowlayoutpanel.aspx

https://stackoverflow.com/questions/7511478/hide-a-groupbox-and-also-remove-the-space-where-it-was-present-in-winform

Screen Record Online and Post link for Others to view

http://www.screenr.com

Control.Focus() or Control.Select() not work during form load

https://stackoverflow.com/questions/6597196/how-to-put-focus-on-textbox-when-the-form-load

Tally Topics

1) Group behave like Sub-Ledger mean?
http://tallyerp9book.com/Pages/Web-Page/Home-TallyERP9Book/Group-Ledger/The_Group.html

Sub-Ledger -> 'No' means many ledger in the group

Sub-Ledger -> 'Yes' means only one ledger, itself.

Create Table and Run SQL Online

http://sqlfiddle.com

https://stackoverflow.com/questions/21407259/oracle-query-for-opening-and-closing-balance
http://sqlfiddle.com/#!4/7b79a/27

https://www.codeproject.com/Questions/544696/queryplusforplusfindingplusBalanceplusofpluscredit

Knowledge during Window App Development

Login Form

1. Objective- Press Enter in Textbox then go to Next Control
Process- If we write Key_Up event for textbox then issue arises.
Issue- Scenario is when i clicked submit button then alert message comes and cursor goes to invalid textbox and when i pressed enter to close alert popup then cursor move to next control from invalid textbox.
Solution- We write Key_Down event

2. Objective- Stop beep Sound when move to next control or Press Enter Button
Solution- e.SuppressKeyPress=true; e.Handled = true; These two lines write under Key_Down event.

3. Issue- In a form, there is a datagridview and two button New and Edit. When i click New button then New form shows. And when i close New form then cursor focus does not go to datagridview.
Solution- When click New button then write first line datagridview focus and then send to other form.

4. Objective- Best way to search text in datagridview
Solution- Exact matches: (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("Name='{0}'", searchTextBox.Text);
Contains matches: (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("Name LIKE '%{0}%'", searchTextBox.Text);

5. Objective- Best way to fill items in Dropdown or Combobox
Solution-(1)    string[] items = new string[dt.Rows.count];
                       for(int i=0; i < dt.Rows.Count; i++)
                            items[i] = dt.Rows[i][j].ToString();
                       ddl.Items.AddRange(items);

               (2)   ddl.DataSource = dt;
                       ddl.DisplayMember = "Column Name";
                       ddl.ValueMember = "Column Name";

6. Info - Difference Between IsDigit() and IsNumber()
Answer - https://stackoverflow.com/questions/228532/difference-between-char-isdigit-and-char-isnumber-in-c-sharp   To get answer please read comments by "Matas Vaitkevicius".

SQlite Database Password Protection

https://stackoverflow.com/questions/5669905/sqlite-with-encryption-password-protection

Create Profile or Cover Photo online

https://quotescover.com/

First Window Application with SQLite

http://www.c-sharpcorner.com/UploadFile/5d065a/how-to-use-and-connect-sqlite-in-a-window-application/


Future Proof Coding
https://stackoverflow.com/questions/34873318/database-driven-windows-desktop-application-with-embedded-database-on-visual-stu

Cannot add sqlite3.dll as a reference in Visual Studio 2017

https://social.msdn.microsoft.com/Forums/SqlServer/en-US/a8e3bf50-0676-45ba-9d3c-ad11f15ddf3b/cannot-add-sqlite3dll-as-a-reference?forum=csharpgeneral

Inventory Management Table

https://docs.oracle.com/cd/E16582_01/doc.91/e15119/tables_used_by_inv_mngmnt.htm#EOAIM00476

https://stackoverflow.com/questions/4380091/best-structure-for-inventory-database

SQLite

https://sqlite.org/whentouse.html

SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.

Client/server SQL database engines strive to implement a shared repository of enterprise data. They emphasize scalability, concurrency, centralization, and control. SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.

Because an SQLite database requires no administration, it works well in devices that must operate without expert human support. SQLite is a good fit for use in cellphones, set-top boxes, televisions, game consoles, cameras, watches, kitchen appliances, thermostats, automobiles, machine tools, airplanes, remote sensors, drones, medical devices, and robots: the "internet of things".

The advantage of SQLite is that it is easier to install and use and the resulting database is a single file that can be written to a USB memory stick or emailed to a colleague.

Website
SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.

Data analysis
People who understand SQL can employ the sqlite3 command-line shell to analyze large datasets. More complex analysis can be done using simple scripts written in Tcl or Python (both of which come with SQLite built-in) or in R or other languages using readily available adaptors. Possible uses include website log analysis, sports statistics analysis, compilation of programming metrics, and analysis of experimental results. Many bioinformatics researchers use SQLite in this way.

Raw data can be imported from CSV files, then that data can be sliced and diced to generate a myriad of summary reports. 

choose SQLite!

For device-local storage with low writer concurrency and less than a terabyte of content, SQLite is almost always a better solution. SQLite is fast and reliable and it requires no configuration or maintenance. It keeps thing simple. SQLite "just works".

https://stackoverflow.com/questions/6749556/what-is-a-good-choice-of-database-for-a-small-net-application

https://stackoverflow.com/questions/913067/sqlite-as-a-production-database-for-a-low-traffic-site

Number to Words in Excel

=SpellNumber(2450) will display as Rupees Two thousand Four hundred Fifty only 

How to create the sample function Called SpellNumber

1. Start Microsoft Excel.
2. Press ALT+F11 to start the Visual Basic Editor.
3. On the Insert menu, click Module.
4. Type the following code into the module sheet.

Function SpellNumber(amt As Variant) As Variant
Dim FIGURE As Variant
Dim LENFIG As Integer
Dim i As Integer
Dim WORDs(19) As String
Dim tens(9) As String
WORDs(1) = "One "
WORDs(2) = "Two "
WORDs(3) = "Three "
WORDs(4) = "Four "
WORDs(5) = "Five "
WORDs(6) = "Six "
WORDs(7) = "Seven "
WORDs(8) = "Eight "
WORDs(9) = "Nine "
WORDs(10) = "Ten "
WORDs(11) = "Eleven "
WORDs(12) = "Twelve "
WORDs(13) = "Thirteen "
WORDs(14) = "Fourteen "
WORDs(15) = "Fifteen "
WORDs(16) = "Sixteen "
WORDs(17) = "Seventeen "
WORDs(18) = "Eighteen "
WORDs(19) = "Nineteen "
tens(2) = "Twenty "
tens(3) = "Thirty "
tens(4) = "Fourty "
tens(5) = "Fifty "
tens(6) = "Sixty "
tens(7) = "Seventy "
tens(8) = "Eighty "
tens(9) = "Ninety "
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
FIGLEN = Len(FIGURE)
If FIGLEN < 12 Then
FIGURE = Space(12 - FIGLEN) & FIGURE
End If
If Val(Left(FIGURE, 9)) > 1 Then
SpellNumber = "Rupees "
ElseIf Val(Left(FIGURE, 9)) = 1 Then
SpellNumber = "Rupee "
End If
For i = 1 To 3
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & "crore "
ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & "lakh "
ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & "thousand "
End If
FIGURE = Mid(FIGURE, 3)
Next i
If Val(Left(FIGURE, 1)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 1))) + "hundred "
End If
FIGURE = Mid(FIGURE, 2)
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
FIGURE = Mid(FIGURE, 4)
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & "Paise "
If Val(Left(FIGURE, 2)) < 20 And Val(Left(FIGURE, 2)) > 0 Then
SpellNumber = SpellNumber & WORDs(Val(Left(FIGURE, 2)))
ElseIf Val(Left(FIGURE, 2)) > 19 Then
SpellNumber = SpellNumber & tens(Val(Left(FIGURE, 1)))
SpellNumber = SpellNumber & WORDs(Val(Right(Left(FIGURE, 2), 1)))
End If
End If
FIGURE = amt
FIGURE = Format(FIGURE, "FIXED")
If Val(FIGURE) > 0 Then
SpellNumber = SpellNumber & "only "
End If
End Function

Picture/Photo Resize

Jumb to this site http://picresize.com

Change the folder/file Attribute from Hide to Unhide

Open CMD and type the following command:

attrib -H -S C:\path\to\your\file.doc /S /D

You can also use the asterisk character to define multiple extensions. For example:

attrib -H -S C:\raymond\*.* /S /D

This would remove the Hidden and System attribute of all files in the raymond folder on the C drive. The /S and /D arguments are optional. /S will recurse down into all sub folders and /D will unhide the folders themselves if they have the System or Hidden attribute set.

This content is taken from this Site https://www.raymond.cc/blog/reset-system-and-hidden-attributes-for-files-or-folders-caused-by-virus/
Read More:

Read More: https://www.raymond.cc/blog/reset-system-and-hidden-attributes-for-files-or-folders-caused-by-virus/

Android Development Video Tutorials

http://www.businessofapps.com/top-android-development-tutorials-youtube/

Screen Recorder

Good One srecorder.com

Create Calender of any Year in different Style (Weekly/Monthly/Yearly)

https://www.timeanddate.com/calendar/create.html?year=2017

INTEL GRAPHICS DOWNLOAD LINK

https://downloadcenter.intel.com/download/26228/Intel-Graphics-Driver-for-Windows-10-and-Windows-7-8-1-15-40-