Programming Articles

Ado.Net - Setting-up Foreign Key Relation

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:30:28 PDT

1. Introduction to Ado.net Foreign Key In “Relational Databases” like Oracle and SQL Server, a “Foreign Key” always refers to a Primary Key in a table. This establishes a relationship between two tables which is called as “Referential Integrity”. We know that a table can have only one Primary Key and can have one or more Unique Keys. In Ado.Net a Foreign Key is not restricted to refer only to

SQL 2005 - Creating and Using Full-Text Index

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:30:25 PDT

1. Introduction – Full Text Search Queries The Full Text Search Queries can be enabled in Microsoft SQL 2005 and later versions. Lets us consider an online shopping web site storing products in their database. Let us also assume that the ProdDetails column can store texts of 1000 Words. Now, when user searches for a specific product details, the query will end up applying a string search on

C# - Update Text Boxes from Task Threads

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:30:22 PDT

1. Update UI From Threads Updating a User Interface from a thread is not straight-forward. Say for instance, let us consider a form-based application which spawns a thread. The thread wants to report the progress to the progress bar control in the form. If we try that (Updating the progress from worker thread), we will be getting an error which mentions that thread is not the owner of the

Ado.Net - Unique and PrimaryKey Constraint behavior of DataTable and DataSet

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:34 PDT

1. About ADO.Net Constraints We know that “Relational Databases” support “Database Constrains” which helps in maintaining the “Data Integrity” within the database. The same way the constraints can be enforced from the ado.net front end itself. In this article we are going to examine how Unique Constraint and Primary Key constraint can be applied to DataTable. Then we will study the behavior

SQL 2005 - Creating And Using CLR Trigger using C#

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:30 PDT

1. SQL CLR Trigger In the last article, we saw creating a SQL CLR Function. I would suggest reading that article first before reading this one. The article is here. Like CLR function, one can write SQL Trigger also in the C-Sharp. In this article, we will learn to create the SQL CLR Trigger and executes that in SQL Server Management studio. 2. Prepare Table for Trigger Target In

Ado.net - Populate DataGridControl using DataTable and DataAdapter

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:26 PDT

1. Introduction In this Article, we will see an example which pulls data from the database and displays that in the form using “DataTable”, “DataAdapter” and “DataGridControl”. 1.1 Ado.net DataAdapter A DataAdapter can hold one or more SQLCommand(s) as well as connection information to the database. Also, it can fill the DataTable or Dataset with the data pulled from the database. It

Asp.Net - Filter DataGridControl records based on DropDownList selected item

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:22 PDT

1. Introduction A DataGrid is a column and row based table like control. We can use this control to display data that needs to be organised in the form of rows and columns. In this article, we will explore using the Data Grid control with a combo box. OK, let us start. 2. About the example Have a look at the below-given screenshot: Fig 1. DataGrid Control and SqlDataSource

C# - Declarative and Imperative techniques for security actions

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:19 PDT

1. Introduction In the previous article, we looked into “Assembly level security”. In this article, we are going to explore method level security actions with the help of permission to access environment variable. In windows operating system, permissions are first monitored by the Operating system through its user account and role(s). For Example, a user account that belongs to

SQL 2005 - Creating a SQLCLR Function in C-Sharp

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:16 PDT

1. Introduction One can write a function or procedure in SQL server to perform a task. However, writing those in SQL has very limited scope as the SQL deals with restricted number of in-built functions, targeting mainly towards the financial area. In Contrast, the dot.net framework has big scope and one can write nearly any kind of function and/or procedure. We claim a function as “SQL-CLR”

Ado.net - Accessing Stored Procedures from Ado.net C# Application front-end

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:29:12 PDT

1. Ado.net and stored procedure In ado.net, just like returning data from the table, data can be retrieved by executing the stored procedure also. A stored procedure can return data to the caller in many forms. They are: Stored procedure returning data in the form of table Stored procedure returning data through output parameter Stored procedure returning data through return statement.

ASP.Net - Understanding Navigation Controls SiteMapPath, Menu, TreeView

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:27:11 PDT

1. Introduction The "Navigation Controls" are useful for maintaining the page hierarchy as well as the page navigation. There are three navigation controls that can be used in ASP.Net 2.0 and above. These controls are: SiteMapPath Menu TreeView The above controls are grouped under “Navigation” in your toolbox and this is shown in the below picture: <!--[if gte vml 1]>

C# - Code Access Security and Security Action Examples

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:27:06 PDT

1. Introduction In dot net framework, security to the application is applied through the dot net supplied Security Framework. The topic of interest is shortly called as “CAS (Code Access Security)”. The code access security at top most level can be seen through the “Dot net configuration” utility which can be accessed through the administrative tools as shown in the below screenshot: <!--[if

SQL 2005 - Creating and using Table-Valued Functions

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:27:03 PDT

1. Introduction In the previous article we saw creating a simple scalar- valued function. Now, here in this article we will look at creating the Table-Valued function. Unlike the scalar-valued function a table-valued function returns a table to the caller. There are two kinds of table valued functions that we can write. Those are: 1) In-Line Table-Valued functions 2) Multi-line table valued

SQL 2005 - Creating and using Scalar-Valued function in SQL Server

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:26:59 PDT

1. Introduction Stored Procedure and function in SQL server are the compiled unit of SQL Program which performs a specific task. Unlike a stored procedure, a user defined function in SQL server can participate on the SQL Select Queries. In this article, I will show creating and using the “Scalar-Valued Function” (UDF) in the SQL Server. The Examples in this article are created using

ADO.Net - Retrieve Table Schema Information using CommandBehavior.SchemaOnly

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:26:55 PDT

1. Introduction When you are working on Ado.net sometimes you need to get the table schema information like Column name and data type of that column. In this example article, I will show getting the table schema information. Have a look at the below screenshot: Fig1. Table Schema for Pubs.Discounts Here, we are going to display the table schema marked as 2 for the table “discounts”

C# - Creating Custom Debugger Visualizer

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:26:52 PDT

1. Introduction "Debugger Visualizers" are visual studio IDE’s debugging component. These components represent the variables and class objects in meaningful form so that it can be easily visualised. Say; for example, you have class ABC to store the “Passport Size” photo of a person and using the visualizer you can see the photo of the person while debugging the object of ABC. The below video

C# - Debugger Attributes Explained with Examples

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:26:47 PDT

1. Introduction In the last article, we saw about Logging and getting function call stack information. In this article, we will see “Debugger Attributes” which controls debugging ability and provide a rich experience to the debugging user. An "Attribute" is a Tag defined over the elements like Class, Functions, assemblies etc. These tags determine how the elements should behave at run time. Let

C# - Using Debugger Break, Log and getting Stack Trace

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:25:19 PDT

1. Introduction The "Debugger Class" is availble under System.Diagnostics name space which will help us in easy diagnostics of the application. In this article we will examine the usage of the debugger class and using that we will see breaking through the code, logging and dynamically taking the snap-shot of the call stack. 2. About the example The screenshot of the sample application is

ASP.Net - Designing Master and content pages using ContentPlaceHolder control

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:25:15 PDT

1. Introduction Master pages help in providing the consistently laid-out pages. When we switch between different pages constant look and feel is achieved throughout the websites. Microsoft provides Master page support from ASP.net 2.0 onwards. The master page is used to provide the outer skeleton structure of the websites and this outer skeleton can be seen as web page header, footer and

C# - Creating and using Custom Performance Monitor Counter

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:25:12 PDT

1. Introduction to Application Performance Monitor Performance Monitor is a windows tool and it is useful monitor “System” and “Application performance” by measuring various parameters and plotting it as a graph. The measuring parameter is called “Performance Counter”. In this article, we are going to add our own performance counter that measures a UI activity in our sample application. Before

SQL 2005 - SQL Trigger dealing with multiple rows

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:25:08 PDT

1. SQL Triggers A “Trigger” is a compiled unit of SQL server procedure, which can run automatically when an event occurs on the database objects. For example, you can write a piece of SQL Script (the trigger), which can be called whenever an insert (the event) happens on a specific table. There are different type of triggers available in SQL Server. The two important types are: 1) DDL

C# - Spawning a process & get notification on Completion

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:25:03 PDT

1. Introduction A "Program" is an executable stored in the physical disc. Say for example Notepad.exe stored in windows System32 folder is called as "Notepad Program". When the program in secondary storage (Disc) loads into primary storage for the execution of instructions set in it, we call it as "Process". Windows has the capability of spawning multiple processes at a time and we call

Ado.Net - Processing Multiple result set using SqlDataReader

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:24:59 PDT

1. Introduction In this short article, we will see packing multiple SQL statements in SqlCommand and process it through the SqlDataReader object. The previous article on ado.net already made you familiar with Connection, Command and Reader objects. Hence, we will concentrate on processing multiple results. Have a look at the below picture. There are three result sets returned by the

ASP.Net - Dynamically applying web themes

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:24:55 PDT

1. Introduction A theme allows setting the properties of server-side controls and by making use of themes one can provide consistency in the format of the entire website. That means, all the controls maintain some uniformity; Say for example all the buttons in the website appears with a red border around it. A theme should have at least one skin file in it. A website can have one or more

SQL 2005 - Sql server stored procedure examples

noreply@blogger.com (Sirama) — Tue, 04 Sep 2018 19:24:50 PDT

1. Introduction A "Stored Procedure" in Sqlserver is an executable program unit that can be stored in the database as objects. These stored procedures can be executed from client application programs to get good performance. The stored procedure can be called from other scripting or even from some other stored procedures. The communication between SqlServer Stored procedure and client