In the article, we will learn about various date conversion method that converts date type String to data type date. To better understand this tutorial, you should be knowledgeable in following C# programming topic: C# if statement Sting to Date conversion is one of the most used transformations in software development. For some reasons, software developers... » read more
In this article, I will explain how to create a backup of a SQL Server database in ASP.NET using C#. To better understand this tutorial, you should know following C# programming topic: C# if statement First, let’s create a web form Asp.NET solution, and then add a button to the default page as shown below:... » read more
Dictionary Initializer got introduced in Visual Studio 2015, .NET 4.6 and C#6.0. With its use, we were able to map indexer during the initialization of the dictionary object. Let us now look in the fact of how this could be used complete elaboration. To better understand this tutorial, you should know following C# programming topic:... » read more
In this article, I will discuss the type of iterators that are supported by C# and VB.NET. .NET Framework usually supports two different kinds of the iterator: External and Internal External iterator: It is the statement where we should specify every single step for completing the task. You can consider the below code: C# List<string>... » read more
In this article, I will help you to understand how to create a Repository Pattern that is mainly used for large enterprise application. The Repository pattern divides the application’s UI, components of data access and business logic into several layers which are easy to test and maintain. A Employees application will be created which will... » read more
Check-boxes are quite common and find their place in almost any form that needs to be submitted on websites. They provide a more comfortable way to capture user data without a requirement of typing things. We might be wondering ways to forward the CheckBox data to controller from our view using ASP.Net MVC Razor framework.... » read more
Below is an example of how to create a system tray icon in a Windows Application (WinForms) using c# and vb.NET. Here are the steps to follow to complete this tutorial. Step 1 Create a windows form application Step 2 Add a NotifyIcon to the main form Step 3 Add an icon to the NotifyIcon... » read more
ExecuteNonQuery is a method from the SQlCommand Class in the System.Data.SqlClient namespace. It executes a T-SQL query and returns the number of rows affected. Below are examples of how to run an Insert, Delete, and Update statements using the ExecuteNonQuery method in both C# and VB.NET. Required namespaces C# using System.Data; using System.Data.SqlClient; VB.NET Imports... » read more
Charts are popular and can help to visualize the data in a WinForm application. This tutorial will focus on how to create and bind charts using C# and Linq. To better understand this tutorial, you should know the following C# programming area: C# ‘for’ Loop Here are the steps to proceed with the tutorial: 1- Create... » read more
Below is an example of how to export data from SQL Server database table in ASP.NET using C#. Let’s create a table in the SQL server database as shown below: Design View Now add few records to that table: Data View Now create a new Web Application using C#. Then add a button to the... » read more
Below is an example of how to populate a DataTable using a DataReader in C#. First, let’s create the database table as showing below: Design View SQL CREATE TABLE [dbo].[ProgrammingLanguage] ( [ID] INT NOT NULL, [LanguageName] NVARCHAR (50) NULL, PRIMARY KEY CLUSTERED ([ID] ASC) ); Then add a few records to that table: Now create... » read more
This tutorial will teach you how to bind a ListBox in C#. First, open Visual Studio, create a C# windows application project and then add a ListBox to the main form of that application. Create the table in Microsoft SQL Server as shown below. SQL Code USE [TutorialsPanel] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER... » read more
Use the Static method Dns.GetHostAddresses to get a list of computer IP Addresses. First, you need to to get the Computer name. Then pass it as a parameter to the Dns.GetHostAddresses method. Required Namespace: System.Net C# String ComputerName= Dns.GetHostName(); IPAddresses[] localIPs = Dns.GetHostAddresses(ComputerName);
This tutorial will explain how to connect to a host machine, and then send data via TCP Socket. First, we need to add the namespaces: using System.Net; using System.Net.Sockets; And the function: public static void SendData(string data, Int32 port, string ips) { IPAddress host = IPAddress.Parse(ips);// IPEndPoint ipendpoint = new IPEndPoint(host, port); // assign host... » read more
Below is a function that returns a DataTable using in C#. DataTables are derived from the namespace System.Data. We will also use a DataAdapter in this example. The DataAdapter Fills the DataTable from a SQL Database based on a SQL Query which is defined in a SQLCommand. Database C# protected DataTable GetAllRecords() { SqlConnection sqlconn... » read more