New Additions
Here Mudassar Ahmed Khan has explained with an example, how to dynamically add (insert) Columns (DataColumn) to DataTable at runtime using C# and VB.Net.
First a dynamic DataTable object is created and its schema (Table structure and Columns) is defined programmatically. Once the columns are defined, then rows (records) are added to the dynamically generated DataTable.
Here Mudassar Ahmed Khan has explained an example, how to insert value for Time Datatype in SQL Server.
1. Use the SQL Server Time Data Type and define its columns in Tables.
2. Understanding the precision in Time Data Type.
3. Get Current System Time.
4. How to insert Time Values using SQL Query into Tables.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Column with Default Value to DataTable in C# and VB.Net.
When Column is specified a Default Value then if its value is not passed i.e. if the value is NULL or Nothing then in such scenario the Default Value is set for that column.
Here Mudassar Ahmed Khan has explained with an example, how to convert System.Drawing.Image object to Array of Bytes or Byte Array using C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to get the Server Current Date and Time in ASP.Net using C# and VB.Net.
ASP.Net is Client Server architecture and hence to get the Server Current Date and Time, AJAX and ScriptManager will be used.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Serial Number / Row Number / Sequence Number column to DataTable in C# and VB.Net.
There is concept of Identity column in SQL Server Database, in similar way .Net allows us to add a Serial Number / Row Number / Sequence Number column to DataTable in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Primary Key column i.e. column with Unique values to DataTable in C# and VB.Net.
There is concept of Primary Key column in SQL Server Database, in similar way .Net allows us to add a Primary Key column i.e. column with Unique values to DataTable in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Identity i.e. AutoIncrement (Auto Number) column to DataTable in C# and VB.Net.
There is concept of Identity column i.e. AutoIncrement (Auto Number) column in SQL Server Database, in similar way .Net allows us to add an Identity column i.e. AutoIncrement (Auto Number) column to DataTable in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Identity i.e. AutoIncrement (Auto Number) column to DataTable in C# and VB.Net.
There is concept of Identity column i.e. AutoIncrement (Auto Number) column in SQL Server Database, in similar way .Net allows us to add an Identity column i.e. AutoIncrement (Auto Number) column to DataTable in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to implement multiple TextBox Email validation in JavaScript.
Here Mudassar Ahmed Khan has explained with an example, how to validate multiple Email Addresses using JavaScript and Regular Expressions.
Here Mudassar Ahmed Khan has explained with an example, how to use the Windows Forms (WinForms) OpenFileDialog Box control in C# and VB.Net.
In Windows Forms (WinForms) applications, the OpenFileDialog Box is used to select single or multiple files from the Windows Folders or Directories.
Here Mudassar Ahmed Khan has explained with an example, how to scroll to the first error or to the first Validator that has raised the error when validation fails in ASP.Net using JavaScript.
In a long form it becomes difficult for users to find out which validation has failed and hence this feature enhances the user experience by scrolling the page and setting focus to the control where the validation is failed.
Here Mudassar Ahmed Khan has explained with an example, the AutoPostBack property in ASP.Net, what it is, how it works, its significance and also its example in C# and VB.Net languages.
AutoPostBack property allows controls which cannot submit the Form (PostBack) on their own and hence ASP.Net has provided a feature using which controls like DropDownList, CheckBoxList, RadioButtonList, etc. can perform PostBack.
Here Mudassar Ahmed Khan has explained with an example, how to use the ASP.Net Login Control example with Database using C# and VB.Net.
The Login control makes use of Forms Authentication implemented using database in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, the difference between DataReader, DataSet, DataAdapter and DataTable in C# and VB.Net.
Here Mudassar Ahmed Khan has provided solution to the error (exception): - Multiple controls with the same ID were found. FindControl requires that controls have unique IDs.
The above error occurs while creating dynamic controls in ASP.Net using C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to display (show) XML string (data) on HTML page in Table format using JavaScript and jQuery.
The XML string will be read into an XML document which will be later used to populate the HTML Table using JavaScript and jQuery.
Here Mudassar Ahmed Khan has explained with an example, how to consume (call) JSON Web Service in ASP.Net using C# and VB.Net.
This article will illustrate consuming (calling) JSON Web Service in ASP.Net by making call to a Weather Web Service.
Here Mudassar Ahmed Khan has explained with an example, the difference between AutoPostBack True and AutoPostBack False in ASP.Net.
AutoPostBack property allows controls which cannot submit the Form (PostBack) on their own and hence ASP.Net has provided a feature using which controls like DropDownList, CheckBoxList, RadioButtonList, etc. can perform PostBack.
Here Mudassar Ahmed Khan has explained with an example, how to access Previous Page controls in ASP.Net using C# and VB.Net.
Previous Page controls can be accessed on Current Page using the Cross Page PostBack technique in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to use the SelectedIndexChanged event of ASP.Net DropDownList in C# and VB.Net.
The SelectedIndexChanged event of will work / fire / trigger only when the AutoPostBack property of the ASP.Net DropDownList is set to True.
Here Mudassar Ahmed Khan has explained a tutorial with example on how to use ASP.Net Login control with database in C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to use the RowUpdating event of ASP.Net GridView control using C# and VB.Net.
In order to illustrate this concept I will make use an ASP.Net GridView control on which I’ll perform Edit and Update operations and the save the updated data with the temporary DataTable.
Here Mudassar Ahmed Khan has explained with examples, how to use ADO.Net SqlCommand ExecuteNonQuery method in C# and VB.Net to perform Insert, Update and Delete operations.