Valdating data in Dataset

• Validating data is the process of confirming that the values being entered into data objects conform to the constraints within a dataset's schema, as well as the rules established for your application.
• Validating data prior to sending updates to the underlying database is a good practice that reduces errors as well as the potential number of round trips between an application and the database.
• You can confirm that data being written to a dataset is valid by building validation checks into the dataset itself.
• The dataset can check the data no matter how the update is being performed — whether directly by controls in a form, within a component, or in some other way. Because the dataset is part of your application, it is a logical place to build application-specific validation (unlike building the same checks into the database backend).

TableAdapter in Windows Application

TableAdapter Overview:

1. TableAdapters provide communication between your application and a database.
2. TableAdapters are also used to send updated data from your application back to the database.
3. ADO.NET Data Adapters were used for communicating between an application and a       database.
4. TableAdapters typically contain Fill and Update methods to fetch and update data in a database.
5. TableAdapters are created with the Dataset Designer inside of strongly typed datasets. 

Fill a dataset with data

• The phrase "filling a dataset with data" refers to loading data into the individual DataTable objects that make up the dataset.
• You fill the data tables by executing TableAdapter queries or by executing data adapter (for example, SqlDataAdapter) commands.

Local Temp Table vs Global Temp Table

Local Temp Table vs Global Temp Table

S.No	Particulars	Local Temp Table	Global Temp Table
1	Available	SQL Server session or connection (means single user)	all SQL Server sessions or connections (means all the user).
2	deleted	These are automatically deleted when the session that created the tables has been closed	These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed.
3	stared with sign	Local temporary table name is stared with single hash ("#") sign.	Global temporary table name is stared with double hash ("##") sign.

Object Oriented vs Object based Language

Object Oriented vs Object based Language

S.No	Particulars	OOL[Object Oriented Language]	OBL[Object Based Language]
1	Support	All Features of OOPS	All feature of OOPS
2	Built Object	No	Yes
3	Languages	C,C#,Java	VB,Javascripts

ASP.Net Web API vs ASP.NET MVC

ASP.Net Web API vs ASP.NET MVC

S.No	Particulars	ASP.NET WebAPI	ASP.NET MVC
1	Create Web App	create full blown HTTP services with easy and simple way that returns only data not view.	returns both views and data
2	support content-negotiation	Yes	No
3	returning data	JSON,XML or any other based upon the Accept header in the request and you don't worry about that.	JSON format using JsonResult.
4	request are mapped	actions based on HTTP verbs	mapped to actions name.
5	assembly	System.Web.Http	System.Web.Mvc
6	mixed MVC and Web API controller	Web API since boths are different.	implement the authorization then you have to create two filters one for MVC

Split Web Page Extention using C#.Net

Split Web Page Extention using C#.Net
using System.Text.RegularExpressions;

string  splitWebPageExtension(string webPage, string extension,int idx)
        {

            Regex Splitter = new Regex(extension);
            String[] Parts = Splitter.Split(webPage);
            string st = Parts[idx];
            return st;
        }
     string webPage = "http://dotnettechrocks.blogspot.in/ ";
     string str = splitWebPageExtension(webPage, ".in", 0);
     MessageBox.Show(str);

Result :http://dotnettechrocks.blogspot

Cluster vs NON-Cluster Index

Cluster vs NON-Cluster Index

S.No	Particulars	Cluster	NON-Cluster
1	data rows	sort and store the data rows in the table or view based on their key values.	have a structure separate from the data rows.
2	Read	Faster to read than NON-Cluster
3	Store	Physically, Store Index Order
4	Faster Insert/Update		Qucikly Insert and Update Data than a Cluster Index.
5	Table	Only One Per Table	can be used many time per Table
6	Order	Data is in Physical Order	Logical Order

Function vs Methods

Function vs Methods

S.No	Particulars	Funciton	Methods
1	independent existence	they can be defined outside of the class	they are always defined with in class
2	languages	Structure languages	object oriented languages
3	independently	called independently.	called using instance or object.
4		Functions are self describing unit of code.	Methods are used to manipuate instance variable of a class

Web Services vs WCF

Web Services vs WCF

S.No	Particulars	Web services	WCF
1	Support SOAP	Yes	Yes
2	Support	HTTP	TCP, HTTP, HTTPS, Named Pipes, MSMQ.
3	Return Data	XML	XML
4	Open Source	No, can be consumed by any client that understands xml.	No, can be consumed by any client that understands xml.
5	Host	only IIS	IIS or Windows Services