LATEST ARTICLES BY – MINDSTICK

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

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’

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.

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

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.

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

C#
C# 

The DataGridView control for displaying data from your SQL database.

C#
C# 

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# 

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# 

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

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

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 

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

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

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

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 

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.

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.

Stored procedures are defined as precompiled object stored in a database. Here I had mentioned precompiled object that means such type of entity which is compiled and after compilation the form that we get is stored in database.

A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.

Windows forms Tree View control helps to represent data in hierarchical format. Whenever you want to display data in the format of parent child relationship or in hierarchical format then we can use concept of tree view control. The best example of t

C#
C# 

When we create any windows based application then we need to deploy it on target machine. For deploying windows based application on target machine we have so many option such as xcopy command utility provided by MSDOS or click once method

Setup 

The DataGridView control enables you to connect to a database and display data in tabular format.

C#
C# 

ErrorProvider control allows us to set an error message for any control on the form when the input is not valid.

C#
C# 

ToolTip is used to display some text when the mouse is move over a control. This control is helpful in providing quick information when the user moves the mouse over an associated control.

C#
C# 

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!