To take backup of dll in GAC follow the below setps.
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.
In the GridView RowDataBound we will find the DropDownList and Country then fetch the state list for the Country and bind the state list to DropDownList.
Steps to write GetJSON extension method.
When you truncate the table data, table Identity will be reset automatically. But when you delete the records in the table Identity will not be reset.
Below query will reset the table Identity in SQL server.
Below are the differences between Truncate and Delete in MS-SQL.
This example shows you how to restore SQL database from a backup file using SQL Query.
In the above example SampleDB is the database name. N'E:\DB\Bakup\SampleDBBackupfile.bak' physical path of backup file.
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.
Sometimes when you done changes in table columns and save, you will get the below 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.
To resolve this issue simple do the below two setps.
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
In the below example we have a dataset contains student details and product details. By using EPPlus.dll we will export the data to excel. Datatable1 (students) data will be exported to students sheet and Datatable2 (products) data will be exported to products sheet in the same excel. And we can dynamically merge the heading of the sheet and can give the border for dynamic data.
This example shows you how to insert data from dataset or datatble to sql table using sql bulk copy in c#.
SQL table before data inserted
SQL table after C# datatable/dataset data inserted using sql bulk copy