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