Latest Articles by – MindStick

A Trigger is a special kind of stored procedure that is invoked whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT, UPDATE OR DELETE or Data Definition Language (DDL)....

 8981 View(s)

A Stored Procedure is a precompiled object stored in the database....

 4408 View(s)

We know HTTP is stateless protocol; this protocol cannot store user information on page because Web server treats each HTTP request for a page as an independent request. The server retains no knowledge of variable values....

 7809 View(s)

In this demonstration I am going to show you that how can we use nested list view control in asp.net. For example suppose we want to display some categories and sub categories of any records. Following demonstration will show you that how to perform...

 38418 View(s)

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between columns on table. A JOIN is a means for combining fields from two tables by using values common to each....

 5032 View(s)

First, you have to add a namespace in your existing namespaces that will be System.Net which will provide the functionality to represent the networking related facilities in our programming...

C#
C# 
 8912 View(s)

A Cookie is a small bit of text that store user-specific information requests and pages as they go between the Web server and browser....

 16518 View(s)

In SQL Server TRY..CATCH statement which helps us to handle the errors effectively in the back end....

 4921 View(s)

Some time we have a situation to copy a set of rows of a Table 'A' into the Table ‘B’, it means suppose if we have thousand of records in a table ‘A’ and I created another table ‘B’ to maintain data but records is available in table ‘A’...

 6918 View(s)

SQL aggregate functions are used to sum, count, get the average, get the minimum and get the maximum values from a column or from a sub-set of column values. SQL aggregate functions return a single value, calculated from values in a column....

 8003 View(s)

Basically the logical conjunction is used to check that two conditions are true, in logical conjunction both conditions must be verified....

 33216 View(s)

As a user, you need to create tables to store data in database. While creating the tables in database, you have to follow specify certain rules and constraints for columns that specify the kind of data to be stored....

 4067 View(s)

The Process component is useful to obtain the list of the processes that are running on the system....

C#
C# 
 4651 View(s)

The DataGridView control for displaying data from your SQL database....

C#
C# 
 14977 View(s)

A Strong Name consists of the assembly's identity—its simple text name, version number, and culture information (if provided)—plus a public key and a digital signature. Strong Name is similar to GUID (It is unique in space and time)....

C#
C# 
 9480 View(s)

Globalized connection string meant for that if you are designing a vast application that having so many windows forms and u need to control all the application using an app.config file. So here is just a demo to create a Globalized connection string...

C#
C# 
 7857 View(s)

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies make sense. Both of these are worthy goals as they reduce the amoun...

 13819 View(s)

The intentional introduce of redundancy in a table in order to improve performance is called “Denormalization”....

 22691 View(s)

XML (Extensible Markup Language) is a flexible way to create common information formats and share both the format and the data on the World Wide Web, intranets, and elsewhere....

XML
XML 
 44075 View(s)

The Windows Control Library project template is used to create custom controls to use on Windows Forms .In the VS .NET IDE environment, controls can be found by clicking the toolbox icon. Windows controls can be either UI controls like "Edit" , "Labe...

 24491 View(s)

The concept of a constraint is to enforce a rule in the database....

 10009 View(s)

Whenever you want to provide different types of restriction to different user such as different-2 users can see different records in same table then we can use the concept of views. Views can help in simplifying query execution when the query involve...

 8717 View(s)

Before I am going to tell an example which demonstrates the use of Click Once deployment technology, let’s firstly understand how this technology works....

Setup 
 13613 View(s)

Web Services are application components which communicate system to system by using open protocols such as http. Web services worked with the help of two platforms....

 14161 View(s)

When we want to resolve concurrency issue in database we can use concept of triggers. In Sql server various kinds of triggers can be used for different types of data manipulation operations. The Sql server supports the following types of triggers....

 8950 View(s)