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
In this tutorial, I will explain how to integrate Google Maps within your MVC application using vb.net and C#. As an example we will use three US cities as an example: Nashville, TN Detroit, MI Los Angeles, CA So let’s get started by creating the Database table as shown below. DesignView SQL CREATE TABLE [dbo].[Locations]... » 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 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
Here is an example of sending an email in ASP.NET using the SMTP server. First, add the namespace. using System.Web.Mail; And the function. C# private bool SendMail(String SendTo, String sendToCC, string SendFrom, string Subject, string msg) { bool bSuccess; try { MailMessage mail = new MailMessage(); mail.To = SendTo; mail.Cc = sendToCC; // to send... » read more
GridView.RowDataBound is an event in GridView controls in ASP.NET. It occurs when a data row is bound to data in the GridView. Below are examples of how to use this even when binding data to the GridView using C# and VB.NET. First, let’s create a Visual Studio ASP.NET Application C#. Note: We will show the code... » 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
Below is how to get the computer name using VB.NET in WinForms application. Dim strComputerName As String = Environment.MachineName.ToString() Happy Coding!
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);
Below is a simple function that takes one string argument and returns the word count in that string. In this function, we will use the following VB.NET built-in function: UBound: a function that returns the highest subscript for the indicated dimension of an array. Split: a function that splits strings. It extracts the substrings from... » read more
In PHP, ereg_replace is used to remove unwanted characters from a string. The code snippet below will remove all characters, such as @ and ! from a string. PHP <?php $string = "Remove unwanted %% !character% from my string 2018&&"; $clean_string= ereg_replace("[^A-Za-z0-9]", "", $string); echo $clean_string ?> Run the code; the output should look like:... » read more
This tutorial will teach you how to create an auto-complete ComboBox in a WinForm application. Auto-complete ComboBox is very useful when there are too many items in it. Auto-complete ComboBox using VB.NET First, we need to create a SQL Server database: Design View Data View Related Auto-Complete ComboBox Using C# Now open visual studio and... » read more
