Sorting rows in a data table C#

Create a new DataTable from a DataView that you create from your original DataTable. 
Apply whatever sorts and/or filters you want on the DataView and then create a new DataTable from the DataView using the DataView.ToTable method

 DataView dv = ft.DefaultView;  
 dv.Sort = "occr desc";  
 DataTable sortedDT = dv.ToTable();  

How to stop IIS asking authentication for default website on localhost

IIS uses Integrated Authentication and by default IE has the ability to use your windows user account...but don't worry, so does Firefox but you'll have to make a quick configuration change.

1) Open up Firefox and type in about:config as the url

2) In the Filter Type in ntlm

3) Double click "network.automatic-ntlm-auth.trusted-uris" and type in localhost and hit enter

How to find all the dependencies of a table in sql server

Following are the way can check the depedencies

Method 1: Using sp_depends

 sp_depends 'dbo.First'  
 GO  

Method 2: Using information_schema.routines

 SELECT *   
  FROM information_schema.routines ISR   
  WHERE CHARINDEX('dbo.First', ISR.ROUTINE_DEFINITION) > 0   
  GO  

Method 3: Using DMV sys.dm_sql_referencing_entities

 SELECT referencing_schema_name, referencing_entity_name, referencing_id, 
 referencing_class_desc, is_caller_dependent FROM sys.dm_sql_referencing_entities
 ('dbo.First', 'OBJECT'); GO referencing_id, referencing_class_desc, is_caller_dependent  
 FROM sys.dm_sql_referencing_entities ('dbo.First', 'OBJECT');  
 GO  

Insert value from one table to another in SQL Server

Example

 INSERT INTO new_table (Col1, Col2, Col3, Coln)  
 SELECT Value1, Value2, Value3, Valuen
 FROM initial_table  
 -- optionally WHERE / JOINS ...