I found a plug from Microsoft outlook which reduces these emails. This is a free plug-in available for users of Microsoft Outlook 2007, 2010 and 2013 which you can download from here.
After installing it, and restarting Outlook, you will be able to report Junk by right-clicking the email and selecting Junk à Report Junk
The software will do the rest for you.
Hope this helps!!
Here is how you can hide validation summary using the below JavaScript. Call this in your aspx page. This should do trick for you.
function HideValidationSummary(){
if (typeof(Page_ValidationSummaries)!= "undefined"){ //hide the validation summaries
for (sums = 0; sums < Page_ValidationSummaries.length; sums++) {
summary = Page_ValidationSummaries[sums];
summary.style.display = "none";
}
}
}
Recently I ran into this issue as all of a sudden my Skype microphone stopped working. I tried to re install it and that doesn’t work for me. Later I realized that I have recently updated my iPad to iOS 7 which could cause some privacy settings.
So I looked into settings and found that my micro phone setting for Skype were blocked. Here is how we can un block it again
Go to Settings > Privacy > Microphone > Skype
Hope this helps for users like me..
| Data Type | Syntax | Explanation (if applicable) |
|---|---|---|
| integer | integer | |
| smallint | smallint | |
| numeric | numeric(p,s) | Where p is a precision value; s is a scale value. For example, numeric(6,2) is a number that has 4 digits before the decimal and 2 digits after the decimal. |
| decimal | decimal(p,s) | Where p is a precision value; s is a scale value. |
| real | real | Single-precision floating point number |
| double precision | double precision | Double-precision floating point number |
| float | float(p) | Where p is a precision value. |
| character | char(x) | Where x is the number of characters to store. This data type is space padded to fill the number of characters specified. |
| character varying | varchar2(x) | Where x is the number of characters to store. This data type does NOT space pad. |
| bit | bit(x) | Where x is the number of bits to store. |
| bit varying | bit varying(x) | Where x is the number of bits to store. The length can vary up to x. |
| date | date | Stores year, month, and day values. |
| time | time | Stores the hour, minute, and second values. |
| timestamp | timestamp | Stores year, month, day, hour, minute, and second values. |
| time with time zone | time with time zone | Exactly the same as time, but also stores an offset from UTC of the time specified. |
| timestamp with time zone | timestamp with time zone | Exactly the same as timestamp, but also stores an offset from UTC of the time specified. |
| year-month interval | Contains a year value, a month value, or both. | |
| day-time interval | Contains a day value, an hour value, a minute value, and/or a second value. |
Apart from bug fixes and beautiful new design here are few new features that are part of iOS 7 release.
PS: Some features may not be available for all countries or all areas.
Here is how you can strip all special characters from a column. Here I need to remove all special characters from a column before inserting into database. I wrote this function to reuse this in different places.
CREATE FUNCTION dbo.usfStripSpecailCharactersHope this is useful!!
(
@str VARCHAR(255)
)
RETURNS VARCHAR(255)
AS
BEGIN
WHILE PATINDEX( '%[~,@,#,$,%,&,*,(,),.,]%', @str ) > 0
SET @str = Replace(REPLACE( @str,
SUBSTRING( @str, PATINDEX( '%[~,@,#,$,%,&,*,(,),.,]%', @str ), 1 ),''),'-','')
RETURN @str
END
GO
-- Use this function and pass your string to remove special characters
SELECT dbo.usfStripSpecailCharacters('test#se3#$%#@-32402');
Here is a way you can get time in desired military format. I need this to be in 0000 format.
For example If the current time is 12:35 AM, I need to be display this in 1235 in integer format or if you want with 12:35 you can use the following to fulfill your requirement.
DECLARE @time TABLE (
id INT IDENTITY(1, 1),
dt DATETIME)
INSERT INTO @time
VALUES ('7:34:00 PM')
-- time in 24 hour military format
SELECT CONVERT(VARCHAR(5), dt, 114) AS FormatedDT
FROM @time
-- time without colon in military format
SELECT REPLACE(CONVERT(VARCHAR(5), dt, 114),':','') AS FormatedDT
FROM @time
Recently I lost few of my icons went missing from Send to folder when we right click on any item or folder. I frequently use Mail Recipient in this. Here is how we can restore this back from default profile
1. Go to following path for default profile setting to capture
"C:\Users\Default\AppData\Roaming\Microsoft\Windows\SendTo" or any other profiles which you have access to from below locations
"C:\Windows\ServiceProfiles\LocalService\AppData\Roaming\Microsoft\Windows\SendTo"
"C:\Windows\ServiceProfiles\NetworkService\AppData\Roaming\Microsoft\Windows\SendTo"
2. Now go to run command or type in start-search box and type shell:sendto to access your own profile.
3. Copy missing files from your default profile to your own profile. If you want you can add your own short cuts for quick access.
You are good to go now. Hope this helps!!
Here is how you can convert get date in different formats
SELECT
GETDATE() AS GetDate,
CONVERT(VARCHAR,GETDATE(),0) AS '0',
CONVERT(VARCHAR,GETDATE(),100) AS '100',
CONVERT(VARCHAR,GETDATE(),1) AS '1',
CONVERT(VARCHAR,GETDATE(),101) AS '101',
CONVERT(VARCHAR,GETDATE(),7) AS '7',
CONVERT(VARCHAR,GETDATE(),107) AS '107',
CONVERT(VARCHAR,GETDATE(),108) AS '108',
CONVERT(VARCHAR,GETDATE(),108) AS '108',
CONVERT(VARCHAR,GETDATE(),10) AS '10',
CONVERT(VARCHAR,GETDATE(),110) AS '110',
CONVERT(VARCHAR,GETDATE(),12) AS '12',
CONVERT(VARCHAR,GETDATE(),112) AS '112',
CONVERT(VARCHAR,GETDATE(),14) AS '14',
CONVERT(VARCHAR,GETDATE(),114) AS '114'
You can refer this URL for other formatting options or follow below URL
Find more help http://www.sql-server-helper.com/tips/date-formats.aspx
We can use sp_depends, sp_depends displays information about database object dependencies, such as the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure
But some times sp_depends does not always return accurate results.
Here is how you can get accurate results by using this query’s below
SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%TableName%'
Now open your query window and write you query and execute. On the results window right click and select "save results as" and then save to CSV file which I can open in excel. Some times you might want to know what are the triggers available across your database. Here is how you can know by using the below query.
-- Displays all Triggers in a Database
SELECT
[Table] = OBJECT_NAME(o.parent_obj),
[Trigger] = o.[name],
[Type] = CASE WHEN
(
SELECT cmptlevel
FROM master.dbo.sysdatabases
WHERE [name] = DB_NAME()
) = 80 THEN
CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsInsteadOfTrigger') = 1 THEN
'Instead Of'
ELSE
'After'
END
ELSE
'After'
END,
[Insert] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsInsertTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Update] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsUpdateTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Delete] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsDeleteTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Enabled?] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsTriggerDisabled') = 0 THEN
'Enabled'
ELSE
'Disabled'
END
FROM sysobjects o
WHERE OBJECTPROPERTY(o.[id], 'IsTrigger') = 1
-- Comment out the following clause if you need to
-- include system triggers, e.g. those in MSDB
AND OBJECTPROPERTY(o.[id], 'IsMSShipped') = 0
ORDER BY 1,2
It is believed that lord Krishna possesses 64 kinds of arts called "Chausath Kalas". Kala means performing an art. Here are the list of 64 అర్ట్స్
Disclaimer : The above details are sent on behalf of IRCTC to their customers. I have coped the same email in this blog to make it available for all the public whom it might be useful for quick reference.
Here is sample code snippet that I have used to get username from the email address. You can use MailAddress Class to get few built in properties for our use.
1: string FromEmail = ConfigurationManager.AppSettings["NotifyEmail"].ToString();
2: MailAddress FromAddress = new MailAddress(FromEmail);
3: objEmail.From = FromAddress; 4: 5: NetworkCredential NetworkCredential = new NetworkCredential(FromAddress.Address, "XXXXXXX");
6: smtpclient.Credentials = NetworkCredential; 7: 8: // Alternately you want you can try few different properties from MailAddress class.
9: 10: Debug.WriteLine("DisplayName: " + FromAddress.DisplayName);
11: Debug.WriteLine("Host: " + FromAddress.Host);
This worked for my scenario. Happy coding.
Many of us tend to forget our own mother tongue with growing globalization or with the dominance of English being more used as communication medium. Here is what I thought should be useful for at least people like me to remember our own alphabets during the course of time.
I have captured from one of Facebook page where I thought sharing would help few of us
Here are the Telugu alphabets
PS: I have copied this for the sake of my own repository. No offence or what so ever.
Microsoft has announced its most awaited version of SQL SERVER 2014 for Community Preview. The availability of the first public Community Technology Preview (CTP) of SQL Server 2014.
Here are key features of SQL Server 2014:
You can find more information from Microsoft blog here.
Are you working on SQL Server 2005 or 2008 servers. Here is SQL Server 2012 Express version for download
Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
Here is the sample code snippet which I wrote to do date validation for a particular format and culture.
1: Private Function validateDateFormat(ByVal strDate As String) As Boolean
2: Dim isValid As Boolean = True
3: Dim provider As CultureInfo = CultureInfo.GetCultureInfo("en-us")
4: Dim formats As String = "d" '"MM/dd/yyyy"
5: Dim dateValue As DateTime
6: Try
7: If DateTime.TryParseExact(strDate, formats, provider, DateTimeStyles.None, dateValue) Then
8: isValid = True
9: Else
10: isValid = False
11: End If
12: Catch ex As Exception
13: 14: End Try
15: Return isValid
16: End Function
You can change the formats and CultureInfo to your own custom information. Here is my pervious blog which describes how formatting date time can be done using string object.
Private Sub KillExcellProcess(ByVal excelCaption As String)
Dim proc As System.Diagnostics.Process
For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")
If (proc.MainWindowTitle = excelCaption) Then
proc.Kill()
End If
Next
End Sub
Dim xlApp As Excel.Application
Dim xlBook As Excel.WorkbookClass
xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
xlApp.Visible = False
xlApp.DisplayAlerts = False
' Once done with excel stuff and when you want
' to kill excel use the below lines of code
Dim sCaption As String
sCaption = xlApp.Caption
KillExcellProcess(sCaption)
<Runtime.InteropServices.DllImport("user32.dll")> _
Private Shared Function EndTask(ByVal hWnd As System.IntPtr) As Integer
End Function
<Runtime.InteropServices.DllImport("user32.dll")> _
Private Shared Function FindWindow(ByVal lpClassName As String, ByVal lpWindowName As String) As IntPtr
End Function
<Runtime.InteropServices.DllImport("kernel32.dll")> _
Private Shared Function SetLastError(ByVal dwErrCode As Integer) As IntPtr
End Function
<Runtime.InteropServices.DllImport("user32.dll", SetLastError:=True)> _
Private Shared Function GetWindowThreadProcessId(ByVal hWnd As System.IntPtr, ByRef lpdwProcessId As Integer) As Integer
End Function
Public Sub EnsureProcessKilled(ByVal MainWindowHandle As System.IntPtr, ByVal Caption As String)
SetLastError(0)
' for Excel versions <10, this won't be set yet
If System.IntPtr.Equals(MainWindowHandle, System.IntPtr.Zero) Then
MainWindowHandle = FindWindow(Nothing, Caption)
End If
If System.IntPtr.Equals(MainWindowHandle, System.IntPtr.Zero) Then
Return
End If
' at this point, presume the window has been closed.
Dim iRes As Integer = 0
Dim iProcID As Integer = 0
iRes = GetWindowThreadProcessId(MainWindowHandle, iProcID)
' can?t get Process ID
If iProcID = 0 Then
If EndTask(MainWindowHandle) <> 0 Then
Return
End If
' success
Throw New ApplicationException("Failed to close.")
End If
Dim proc As System.Diagnostics.Process = Nothing
proc = System.Diagnostics.Process.GetProcessById(iProcID)
proc.CloseMainWindow()
proc.Refresh()
If proc.HasExited Then
Return
End If
proc.Kill()
End Sub
Dim sVer As String
sVer = xlApp.Version
Dim iHandle As IntPtr = IntPtr.Zero
If Val(Convert.ToDouble(sVer)) >= 10.0 Then
iHandle = New IntPtr(CType(xlApp.Parent.Hwnd, Integer))
End If
'To kill process created by this job by process id
EnsureProcessKilled(iHandle, xlApp.Caption)
I have a scenario where I need to create a folder on fly with current date in YYYYMMDD format.
Here is simple solution how we can achieve using Expression Builder in SSIS packages. Pick the variable that’s needs to be configured.
Go to properties of the variable you want to configure and click expression.
A Popup window will appear where you can select the variable you want to configure
Select the property you want to override. For me its Destination path property of the Source folder variable I am using in my package.
C:\Development\XXXXX\XXXXX\20130516\
Here is code that needs to append to the variable. So here is what I have used to get this in below format. (DT_STR,4,1252)DATEPART( "yyyy" , getdate() ) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)
Hope this helps!!!
You can download the eBook in PDF format here: http://go.microsoft.com/FWLink/?Linkid=270056 (17.9 MB)
EPUB format is here: http://go.microsoft.com/FWLink/?Linkid=272592 (37.3 MB)
MOBI format is here: http://go.microsoft.com/FWLink/?Linkid=272591 (69.5 MB)
Happy programming!!
Here is how we can achieve this from codebhind in c#. Here is the sample code snippet I am here removing CssSytle from DIV but I works for any Control
1: // Removing Div class when we have only transaction details
2: divTransactionSummary.Attributes.Add("class", divTransactionSummary.Attributes["class"].ToString().Replace("prodiv", ""));
3: Here “prodiv” is the class of div I have used in my aspx page for this DIV
Hope this helps!!
I got my first iPad and I am trying to know about that are the Video formats that are supported by iPad devices.
Here is the list
I found this information via google. Thought this worth sharing.
This error occurs due to lock down of default mail server (127.0.0.1) by web hosting companies due to SPAM or what ever other security reasons. But if you use “localhost” or default server “127.0.0.1” on your local machine it should not be an issue. But if you have a situation where you need to relay e-mail to a remote mail server that is secured you get this exception.
So you need to handle well using built in classes provided by .NET. This is take care by NetworkCredential Class. This class provides credentials for password-based authentication schemes such as basic, digest, NTLM, and Kerberos authentication.
Here is a fully working quick code sample that you can use to get started on your own SMTP-Authentication supporting e-mail code.
1: try
2: {3: SmtpClient smtpclient = new SmtpClient();
4: NetworkCredential NetworkCredential = new NetworkCredential(smtpUserName, smtpPassword);
5: smtpclient.Credentials = NetworkCredential;6: string MailServer = ConfigurationManager.AppSettings["SMTPServer"].ToString();
7: MailMessage objEmail = new MailMessage();
8: 9: string FromEmail = ConfigurationManager.AppSettings["ErrorReportEmailFrom"].ToString();
10: if (FromEmail.IndexOf(";") > 0)
11: {12: FromEmail = FromEmail.Replace(";", ",");
13: }14: MailAddress FromAddress = new MailAddress(FromEmail);
15: objEmail.From = FromAddress; 16: 17: string ToEmail = ConfigurationManager.AppSettings["ErrorReportEmailTo"].ToString();
18: if (ToEmail.IndexOf(";") > 0)
19: {20: ToEmail = ToEmail.Replace(";", ",");
21: } 22: objEmail.To.Add(ToEmail); 23: 24: string CcEmail = ConfigurationManager.AppSettings["CcEmail"].ToString();
25: if (CcEmail.IndexOf(";") > 0)
26: {27: CcEmail = CcEmail.Replace(";", ",");
28: } 29: objEmail.CC.Add(CcEmail); 30: 31: string BccEmail = ConfigurationManager.AppSettings["BccEmail"].ToString();
32: if (BccEmail.IndexOf(";") > 0)
33: {34: BccEmail = BccEmail.Replace(";", ",");
35: } 36: objEmail.Bcc.Add(BccEmail); 37: 38: objEmail.Subject = strSubject;39: try
40: { 41: objEmail.Body = strBody;42: objEmail.IsBodyHtml = true;
43: smtpclient.Host = MailServer; 44: smtpclient.Send(objEmail); 45: }46: catch (Exception ex)
47: {48: throw ex;
49: }50: finally
51: { 52: objEmail.Dispose(); 53: } 54: }55: catch (Exception ex)
56: { 57: 58: }Enjoy coding!!