dotnetdeveloperguide.blogspot.com
.NET Developer Guide: Editable ListBox User Control
http://dotnetdeveloperguide.blogspot.com/2009/11/editable-listbox-user-control.html
Monday, November 2, 2009. Editable ListBox User Control. System.Collections.Generic;. System.Windows.Forms;. EditBox.Location = new. System.Drawing. Point. EditBox.Size = new. System.Drawing. Size. EditBox.Text = ". EditBox.BackColor = Color. EditBox.KeyPress = new. System.Windows.Forms. KeyPressEventHandler. EditBox.LostFocus = new. ItemText = ( string. EditBox.Location = new. System.Drawing. Point. EditBox.Size = new. System.Drawing. Size. RWidth - 10, r.Height);. EditBox.Text = itemText;.
tejaspatel82.blogspot.com
Tejas Patel: June 2009
http://tejaspatel82.blogspot.com/2009_06_01_archive.html
Tuesday, June 16, 2009. Tips for Selecting Non-Clustered Indexes. Selecting non-clustered indexes is somewhat easier than clustered indexes because you can created as many as is appropriate for your table. Here are some tips for selecting which columns in your tables might be helped by adding non-clustered indexes. Non-clustered indexes are best for queries that return few rows (including just one row) and where the index has good selectivity (above 95%). An index is only useful to a query if the WHERE c...
tejaspatel82.blogspot.com
Tejas Patel: May 2009
http://tejaspatel82.blogspot.com/2009_05_01_archive.html
Friday, May 29, 2009. The DataAdapter and optimistic concurrency. Before we get into some of the methods for handling concurrency issues in updating a database with ADO.NET, let's talk a little about the DataAdapter. The Four Basic Concurrency Handling Options. At this point, you have four basic optimistic concurrency options in SQL update queries:. 1) Include Only the Primary Key Columns. The CommandBuilder object does not offer this optimistic concurrency option; the Visual Studio.Net Data Adapter ...
tejaspatel82.blogspot.com
Tejas Patel: SELECT COUNT(*) performance
http://tejaspatel82.blogspot.com/2009/06/select-count-performance.html
Wednesday, June 10, 2009. If you have ever performed a SELECT COUNT(*) on a very large table, you know how long it can take. For example, when I ran the following command on a large table I manage:. It took 1:09 to count 10,725,948 rows in the table. At the same time, SQL Server had to perform a lot of logical and physical I/O in order to perform the count, chewing up important SQL Server resources. A much faster, and more efficient, way of counting rows in a table is to run the following query:.
sqlserverdeveloperguide.blogspot.com
SQL server guide: SELECT COUNT(*) performance
http://sqlserverdeveloperguide.blogspot.com/2009/06/select-count-performance.html
Tuesday, June 16, 2009. If you have ever performed a SELECT COUNT(*) on a very large table, you know how long it can take. For example, when I ran the following command on a large table I manage:. It took 1:09 to count 10,725,948 rows in the table. At the same time, SQL Server had to perform a lot of logical and physical I/O in order to perform the count, chewing up important SQL Server resources. A much faster, and more efficient, way of counting rows in a table is to run the following query:.
dotnetdeveloperguide.blogspot.com
.NET Developer Guide: September 2009
http://dotnetdeveloperguide.blogspot.com/2009_09_01_archive.html
Monday, September 7, 2009. Put HTML page break for printing. You can use any of the following style for HTML page break (specially for printing). Labels: HTML page break for printing. Friday, September 4, 2009. Single border around HTML Table cell. Labels: Single border around HTML Table cell. Select Distinct Column Values From DataTable. Dt = dv. ToTable. True, "Col1", "Col2","Col3" .);. Labels: Distinct Column Values From DataTable. Wednesday, September 2, 2009. Get mouse position in c#.
dotnetdeveloperguide.blogspot.com
.NET Developer Guide: get mouse position in c#
http://dotnetdeveloperguide.blogspot.com/2009/09/get-mouse-position-in-c.html
Wednesday, September 2, 2009. Get mouse position in c#. I might be wrong but you can try following two. Labels: Mouse Position C#. Subscribe to: Post Comments (Atom). Coffee Mona Lisa - Awesome! Tips for Selecting Non-Clustered Indexes. Tips for Selecting Non-Clustered Indexes. View my complete profile. Put HTML page break for printing. Single border around HTML Table cell. Select Distinct Column Values From DataTable. Get mouse position in c#. Do you really like this blog?
tejaspatel82.blogspot.com
Tejas Patel: Tips for Selecting Non-Clustered Indexes
http://tejaspatel82.blogspot.com/2009/06/tips-for-selecting-non-clustered.html
Tuesday, June 16, 2009. Tips for Selecting Non-Clustered Indexes. Selecting non-clustered indexes is somewhat easier than clustered indexes because you can created as many as is appropriate for your table. Here are some tips for selecting which columns in your tables might be helped by adding non-clustered indexes. Non-clustered indexes are best for queries that return few rows (including just one row) and where the index has good selectivity (above 95%). An index is only useful to a query if the WHERE c...
