Monthly Archives: December 2012

Maintaining Data Integrity Easily With SQL Server Relationship Cascade Delete & Update Rule

Maintaining Data Integrity Easily With SQL Server Relationship Cascade Delete & Update Rule

SQL Server provides relationship functionality that can be used to maintain data integrity.
Data Integrity means that all related tables data must have correct key value.
Take example of Header & Line tables. Header & Line have one to many relation with the key is Header ID. So each Header ID can have one or more records in Line table.
Please see screen shots:
tb_header Design:

tb_line Design:

Every header ID value inside Line table must exist in Header table. If there is header ID in Line table that does not exist in Header table then that data is junk.
Continue reading

Asp.Net Nested Grid View Example And Ajax PopUp & Calendar Extender


Nested Grid View is useful to show parent child relationship table. This blog post contains example to build Nested Grid View with Asp.Net.
The Parent Grid View content can be Edited and its Child Grid View loads on the fly if user clicks on parent grid view row.

I use Northwind Sample Database to produce nested Grid View. Also I use DropDownList, TextBox with Ajax PopUp and TextBox with Ajax Calendar to filter database query.
I already have example about Ajax Popup & Calendar in this Url Making Flexible User Input With Asp.Net Ajax PopUp & Calendar Extender Toolkit Controls .

So this blog contains miscelanous example. This might be useful for web internal application that contains complex user input & data layout.
Continue reading