Loading
Articles by Rohatash Kumar
User-Defined Sequence Object in SQL Server 2012
Today, I have provided an article showing how to use Sequence Object in SQL Server 2012. In this article we have also covered the difference between sequence and identity.
New Logical Functions in SQL Server 2012
Today, I have provided an article showing you how to utilize the two new logical functions Choose() and IIF() in SQL Server 2012.
New Data Type Conversion Functions in SQL Server 2012
Today, I have provided an article showing how to utilize the new data type conversion Functions in SQL Server 2012.
Move a Database Using Detach and Attach in SQL Server 2012
This article introduces how to Detach and Attach a database in SQL Server 2012 by using SQL Server Management Studio.
Issue While Achieve Method Overloading in WCF
Here I am creating a WCF service to describe method overloading with name the property of the OperationContract attribute.
Issue While Returning DataTable Through WCF Service
Today, I have provided an article showing you how to return a datatable using a WCF service from C# code.
Insert, Update and Delete Data With DataGridView in Windows Form Using WCF Service
Learn how to perform Insert, Edit, Update, and Delete operations in a DataGridView using a WCF Service in C#. This tutorial covers creating a SQL Server database table, implementing a WCF Service with CRUD operations, and integrating it into a Windows Forms Application. Ideal for beginners using Visual Studio 2010 and SQL Server 2008.
WCF Service to Connect Between Windows Forms Application and SQL Database
Today, I have provided an article showing you how to insert and display data in a DataGridView control using a WCF service from C# code.
Insert, Update and Delete Data in GridView Using WCF Service
Today, I have provided an article showing you how to insert, delete and update data in a GridView using a WCF service from C# code.
Insert Data Into SQL Server Database Using WCF Service
This article introduces how to insert data into SQL Server using a WCF service from C#.
Concept of Exists Condition in SQL Server
Learn how to use EXISTS and NOT EXISTS in SQL Server to filter rows based on matching or nonmatching records in another table.
Retrieving User Password and Email Address From Database Using C#
Today, I have provided an article showing you how to retrieve a user's password and email address from a database in ASP.NET.
Disable Saving Changes is Not Permitted Dialog Box in SQL Server
When we try to change an existing table in SQL Server 2008, you might receive a Save (Not Permitted Dialog) box pop-up. This article explains the error and what to do about it.
Dynamically Add and Delete Items in ListBox Using ASP.NET
Today, I have provided an article showing you how to add and delete items in a ListBox using ASP.NET.
Binding DropDownList With Database in ASP.NET
Today, I am providing an article showing you how to bind a DropDownList with a database and display the bound data in a GridView in ASP.NET.
How to Display Data in ListBox From SQL Database in ASP.NET
Today, I have provided an article showing how to display SQL table data in a ListBox in ASP.NET.
Uploading Multiple Files With ListBox in ASP.NET
This article explains how to upload multiple files using a ListBox control in ASP.NET. Unlike the standard FileUpload control, which supports single file uploads, this method combines FileUpload with a ListBox for easier file management.
C# Windows Validation by ErrorProvider Control in Visual Studio 2010
Today, I have provided an article showing you how to use the ErrorProvider control in a Windows Forms application.
Sort the GridView Column Using DataView in ASP.NET
Today, I have provided an article showing you how to sort the GridView column using a DataView in ASP.NET.
Rotate Ads With AdRotator Using SQL Server in ASP.NET
Today, I have provided an article showing you how to rotate ads with AdRotator using SQL Server in ASP.NET.
Changing Color of Text Using DropDownList in C#
Today, I have provided an article showing you how to change the color of text using a DropDownList in ASP. NET.
Bind Countries to a DropDownList in ASP.NET
Today, I have provided an article showing you how to get a list of all countries and bind them to a DropDownList in ASP. NET.
Print a String in Single and Double Quotes in C#
Today, I have provided an article showing you how to print a string in single and double quotes in C#.
Identify Duplicate Rows From a SQL Server Table in C#
This article shows how to identify duplicate records. Usually we use a primary key or unique key to prevent insertion of duplicate rows in SQL Server. But if we don't use them, then duplicate rows can be entered by the user. After inserting duplicate rows into a table, it becomes a major issue to identify those duplicate rows.
Remove Duplicate Rows From a SQL Server Table in ASP.NET
Usually we use a primary key or unique key to prevent insertion of duplicate rows in SQL Server. But if we don't use them, then duplicate rows can be entered by the user. After inserting duplicate rows into a table, it becomes a major issue to delete those duplicate rows. This article will help to delete those duplicate rows to resolve the issue.
