Category Archives: For Developer

Here all C# library file, dll, MS SQL Procedure, function, built in code will be found..

Error and Solution MS SQL

Cannot ALTER TABLE in MS SQL 2008/SQL2008 R2/SQL2012

1 May, 2013 – 5:45 pm

Cannot ALTER TABLE in MS SQL After installing ms sql 2008/2012 you may face new problem which may protect you to alter any table. Something like following There is a new option added in SQL Server 2008/2012 for modifying tables while using the Table Designed in Management Studio which will prevent saving any changes to read more »

Tags | Comment (0)
MS Access MS SQL

Calculate Execution and Cpu Time in SQL 2005

26 June, 2011 – 10:36 am

SET STATISTICS TIME ON Select * from TableName — Or Any Query SET STATISTICS TIME OFF It Results: =============== SQL Server parse and compile time: CPU time = 31 ms, elapsed time = 141 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms.

Tags , | Comment (1)
MS SQL

Selecting Record from XML Valued Column in MS SQL

15 April, 2011 – 3:27 pm

Just Consider we have following records in a object named CR_NonDPC_ConfigDTO PCName : PC MotherBoard : ASROK 945 GCM Processor : Pantium HDD : HDD 160 GB RAM : DDR-2 1 GB Cassing : NULL ExtraConfig : CD ROM ASUS Now we shall convert it to XML (for converting Object to XML you can check read more »

Tags | Comment (0)
.Net Framework C# MS SQL

Executing *.sql file form C#

22 March, 2011 – 5:25 am

Sometimes we need to run *.sql script from our application for installing data base. SqlCommand is not right for running installation script because installation script consists of DDL and GO command. Here we use smo library for executing *.sql script. For doing above operation we need to add following references

Tags , | Comment (0)
.Net Framework C# For Developer

Sending Email using C# (with HTML body & Attachment )

29 December, 2010 – 8:05 am

Introduction This article is provide a basic idea how we can send Emails from a C# Windows Application. Here I have described how we can send mail with Attachment and HTML body. Description If we want to send mail then we need to know following things 1. SMTP Server address 2. Port No Here I read more »

Tags , , | Comment (0)
.Net Framework C# For Developer

Converting List to DataTable in C#

28 December, 2010 – 11:37 am

There is no built in method for converting list to data table in C#. So we can implement following method for converting List to DataTable in C#. public DataTable ToDataTable(IList data) { PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(t)); DataTable table = new DataTable(); for (int i = 0; i < props.Count; i++) { PropertyDescriptor prop = props[i]; read more »

Tags , | Comment (1)
MS Access

Filter data by date time in MS access, Select only date without selecting time from date time field in MS Access

2 October, 2010 – 4:37 pm

Select * from TransactionInfo where CDate(Int([CreatedDate])) between #2010-05-04# and #2010-05-05# —————– it will return date like —————– 23-May-2010 Select * from TransactionInfo where [CreatedDate] between #2010-05-04# and #2010-05-05# —————– it will return —————–

Tags | Comment (0)
For Developer MS SQL MS SQL MS SQL functions

Split in MS SQL SERVER

5 August, 2010 – 3:46 pm

Here I shall describe about split in MS SQL. There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL. Split function 1: This function returns table that’s why we can say it table valued function. –select * from fnSplit(’1,22,333,444,,5555,666′, ‘,’) read more »

Tags , | Comments (3)
For Developer MS SQL

STUFF IN MS SQL, Getting data from table in a single row separated by comma or other sign

3 August, 2010 – 1:43 pm

Consider following SQL statement for MS SQL Select UserName from UserInfo It will return UserName Anis Hasibul If you want to get these record in following way

Comment (1)
Page 1 of 11