By host on
2/3/2012 9:53 AM
In order to reuse or simplify part of code, it’s common to break down your stored procedure into multiple smaller stored procedures and call them as nested stored procedures. In most of the cases, your original stored procedure affects the content of the database. In order to make sure that the database is still consistent in case something unexpected occurs, the best solution is to use transactions and proper error handling.
Read More »
|
By host on
2/1/2012 4:01 PM
With SQL Server 2012 currently available for download as a Release Candidate and an official launch coming early this year, now is a better time than ever to start learning about some of the new features it offers.
Read More »
|
By host on
2/1/2012 2:33 PM
LINQ to SQL is a component found in the .NET Framework version 3.5 and higher. It provides a run-time infrastructure for mapping relational data as objects. This
Read More »
|
By host on
1/13/2012 1:29 AM
While developing an application, there is a necessary of showing and hiding the particular controls during the run time. Today’s tip is how to show or hide a Jquery controls dynamically.
Read More »
|
By host on
1/10/2012 1:01 AM
There are different ways split the string based on the delimiter. Here is one of the examples in C# to split the string. Place two textboxes in the form. Rename the first textbox to txtString and second textbox to txtDelimited.
Read More »
|
By host on
1/4/2012 5:55 AM
There are different methods to load a data in the dropdown control. Some of the common methods that are used are xml, hashtable, arraylist and database.
Read More »
|
By host on
1/2/2012 3:39 AM
The User Defined functions is routines that can take parameters, perform operations and return the result. There are three types of functions available.
Read More »
|
By host on
12/27/2011 12:02 AM
Normally we can set a tooltip for column header in the gridview during the mouse over using ColumnHeaderTooltip. If there is a requirement of setting a tooltip to column cells depending on the data, it is somewhat tedious. Here is an example of setting a tooltip to gridview Column during mouse over.
Read More »
|
By host on
12/26/2011 12:41 AM
In .net applications, printing and previewing the form can be done using PrintDocument class. The PrintDocument component is an object that allows users to send an output to a printer.
Read More »
|
By host on
12/21/2011 12:48 AM
In an asp.net application while using grid view to display a data there will be a requirement of exporting Grid view data to excel file. The following code will be used to export the grid view data to excel.
Read More »
|
By host on
12/20/2011 4:02 AM
In the Common language runtime CLR stored procedure will be implemented as public static methods on a class in a Microsoft .Net Framework Assembly. Static Methods can be declared as void or return an integer value.
Read More »
|
By host on
12/14/2011 4:07 AM
Usually you can able to sort a grid view by clicking the header of the grid. If you want to sort the grid view dynamically, without changing the store procedure of the binding object, the following code will help.
Read More »
|
By host on
12/12/2011 10:34 PM
The IsNullOrEmpty() is a user defined function in SQL server which is used to check the given variable is null or empty.
Read More »
|
By host on
12/12/2011 4:28 AM
To pass dynamic value to table valued function we can use the cross apply
Read More »
|
By host on
12/7/2011 2:19 AM
When developing and testing an application we insert dummy data that is stored in a database. When the testing phase is complete and the application is ready to go live, the identity column of a table needs to be reset.
Read More »
|