Bind data to DropDownList in GridView
This example shows you how to bind data to DropDownList in GridView based on the Grid Row Value. In this example we will bind the States to DropDownList based on Country in Row.
Convert DataSet to JSON - C# extension method example
This example shows you how to write C# extension method and how to convert DataSet to JSON using JavaScriptSerializer.
SQL Query to reset the Identity
Below query will reset the SQL table Identity.
Difference between truncate and delete in MS-SQL Server
This article describes the differences between truncate and delete in MS-SQL Server.
SQL Query to restore database from backup file
This example shows you how to restore SQL database from a backup file using SQL Query.
Show jQuery tooltip based on the textbox entered value
This example shows you how to show/hide the jQuery UI tooltip based on the given value in a textbox. In this example we have taken a textbox for age and when the user enter the age not in the range of 1 to 100 then it should show the tooltip.
Fixing SQL Server "Saving changes is not permitted" error
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.
Export Datatable or Dataset data to excel using EPPlus in asp.net and c#
This example shows you how to export datatable or dataset data to excel in asp.net and c#. By using EPPlus.dll we can easily export datatable or dataset data to excel. You can merge cells, give background color and can format the cell text in excel using EPPlus.dll in c# and asp.net
Insert dataset or datatable data to sql table using sql bulk copy in c#
This example shows you how to insert data from dataset or datatble to sql table using sql bulk copy in c#.
Highlight matched table rows based on entered text in a textbox using angularjs
This example shows you how to highlight or change background color of table when the table row data matched with the entered text in a textbox. You need to set the ng-class directive to the table row and write the expression to return true when the row/cell text match the entered text in textbox.