From this post, we will be talking about the way of populating dataTables using the DataReader in VB.NET. In this example, we’ll be using the SQLDataReader which is available in the SQLClient library. What is a DataReader? DataReader is an object that is used to fetch the data from any data source in a high-performance... » read more
In this article, we are going to talk about the chart controls in VB.NET and how it can be bound with data using LINQ. As we all know, charts are used to interpret the data in a more understandable way, where everyone can easily grasp the information that we are representing. Bing a chart control... » read more
In this article, we are going to talk about the different types of methods that can be used to convert a string with date type format into Date format in VB.NET. There are several inbuilt methods available in the Convert() class of the System package and Date class. Listed below are some of the methods... » read more
In vb.NET, it is possible to control the port of windows, by editing the values in the local registry. Below are two functions that can be used to block and unblock USB ports using VB.NET. First, you need to import namespace below: Imports Microsoft.Win32 Disable/Block USB Port using VB.NET Private Sub BlockUSPPort() Dim regKey As... » read more
In this article I will shed some light on the most used methods in VB.NET for file handling. File handling is important when it comes to storing and retrieving data using the file system. These functions and methods are in the IO namespace: System.IO Different and most used methods for handling file in VB.NET are... » read more
The .NET Framework has too many numeric functions that can be used out of the box for numeric manipulation. This article is to learn about the most common ones that each developer should know. The Numeric Functions in VB.NET All numeric functions that are available VB.NET are implemented as the constant and static methods of Math... » read more
The function below is to calculate the difference between two days. The result will be in days, and it can be zero if the two days are the same. VB.NET Function calculateDiffDates(ByVal StartDate As DateTime, ByVal EndDate As DateTime) As Integer Dim diff As Integer diff = (EndDate - StartDate).TotalDays Return diff End Function
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
Below is a simple snippet which will return a computer name using vb.NET VB.NET Dim strComputerName As String = Environment.MachineName.ToString()
Below is a sample code for how to add a column to a DataTable using vb.NET. A Column will be added dynamically and will contain the yearly salary of each employee in an employee’s table. First, let’s create the tables in SQL Server as shown below. DesignView SQL CREATE TABLE [dbo].[Employee] ( [Id] INT NOT NULL,... » read more
Below is how to get the computer name using VB.NET in WinForms application. Dim strComputerName As String = Environment.MachineName.ToString() Happy Coding!