|
|
-
|
|
Often in Silverlight applications, while consuming services, we will receive these errors like "This could be due to attempting to access a service in a cross-domain way without a proper cross-domain policy in place". Though it’s a generic error, first ......
|
|
-
|
|
Today I had a requirement of finding the details of mails that sent using Database Mail feature. "sysmail_allitems" catalog view will contains the details like subject,body,recipients,CC,BCC,status,send date,file attachment etc. check out following quer......
|
|
-
|
|
Its Chrismas and New Year holiday time. Both Google & Microsoft seems to be playing same "Let it snow" competition.
1. Go to google.com and search for "Let it snow". Press enter.
2. Go to below URL.
http://ie.microsoft.com/testdrive/p......
|
|
-
13 Liked
| 10 Learned
| 3 Comments
|
|
Today I learned an tip from my colleague about finding the last executed statement for a process in SQL Server.
[code]
DBCC INPUTBUFFER (52)
[/code]
Here 52 is the SPID, that we want to check last executed statement......
|
|
-
|
|
Today I faced an error "String[]; The size property has an invalid size of 0." This error is little bit confusing initially only to found later that, it is mandatory to mention the size for output parameters of varchar type.
If we use any output para......
|
|
-
|
|
99.99% of the time, we write our code with zero indexed arrays. However, C# allows us to create non zero based (single or multi dimensional arrays). CreateInstance is a static method available in Array class. To understand the concept in a simple way, l......
|
|
-
11 Liked
| 12 Learned
| 1 Comments
|
|
SQL Server History
[code]
Version Year Release Name Codename
--------------- -------- ----------------------------------- --------------------
1.0 (OS/2) 1989 SQL Server 1.0 (16bit) -
1.1 (OS......
|
|
-
11 Liked
| 11 Learned
| 3 Comments
|
|
I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query.
[code]
USE MSDB
GO
Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@s......
|
|
-
|
|
If we have a lot of items in combo box/list box, its difficult to find and select that item. Now silverlight 5 provides type ahead support, When user selects some text, it automatically scrolls to items that starts with typed text.
[code]
<ListBo......
|
|
-
|
|
I have seen & worked on datagrids in winform applications as well webform applications (ASP Dot Net) but, while watching training video for WPF i found a very good feature for WPF Datagrid that is multisort.
Generally when we click on a column, it so......
|
|