SMTP Server Error: Bad sequence of commands. The server response was: you must authenticate first (#5.5.1)

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!!

Select all user defined tables from database – SQL SERVER

There are different ways to select all User defined tables from databases

Option 1: Using Object Catalog view

   1: SELECT sobjects.name 

   2: FROM sysobjects sobjects

   3: WHERE sobjects.xtype = 'U'

   4: order by sobjects.name

Alternatively here is a list of other object types you can search for as well:

C: Check constraint
D: Default constraint
F: Foreign Key constraint
L: Log
P: Stored procedure
PK: Primary Key constraint
RF: Replication Filter stored procedure
S: System table
TR: Trigger
U: User table
UQ: Unique constraint
V: View
X: Extended stored procedure

Option 2: Using Information schema view

   1: SELECT * FROM INFORMATION_SCHEMA.TABLES 

   2: WHERE TABLE_TYPE = 'BASE TABLE'

Here is something you can do as well

   1: select * from sys.tables

Suppose you might need to get all tables from your SQL SERVER Instance. Here is what you can do

   1: --for all databases

   2: sp_msforeachdb 'select "?" AS db, * from [?].sys.tables'

How to Set default button from C# to a Content Page

Here is how we can use default button property of the form to set Default Button for a content page from Code behind using C#

 

// Setting default button
this.Master.Page.Form.DefaultButton = this.btnSubmit.UniqueID;

 

Here is how we can set default button for the page which doesn’t have Master Page

// Setting Default Button           
this.Page.Form.DefaultButton = btnSubmit.UniqueID; 

 

Hope this helps!!

File Handling by Source Control

What are the files that needs to be check in VSS for better handling of files when we do development. There are many file types and are stored and updated internally for each developer based on their own settings. So in other words these files doesn’t need to be part of Source control system. Here are the list of file types that we might need to look in as developer

You can add the following files to Visual Studio source control:

• Solution files (*.sln).

• Project files, for example, *.csproj, *.vbproj files.

• Application configuration files, based on XML, used to control run-time behavior of a Visual Studio project.

But the Files that you cannot add to source control include the following:

• Solution user option files (*.suo).

• Project user option files, for example, *.csproj.user, *.vbproj.user files.

• Web information files, for example, *.csproj.webinfo, *.vbproj.webinfo, that control the virtual root location of a Web project.

• Build output files, for example, *.dll and *.exe files.

For more information

How to get Line break in a button using HTML and CSS

Some times there are some scenarios where we might put some line breaks in buttons while doing HTML code your pages. There are few different ways that you can achieve this using HTML and CSS.

Here are few code snippets

   1: <!-- Method 1 -->

   2: <input type='submit' value='my \n button'>

   3: <!-- Method 2 Using HTML break-->

   4: <input type='submit' value='my &lt;br> button'> 

   5: <!-- Method 3: Using CSS -->

   6: <input type="submit" value="My button" style="white-space:normal"/>

Hope this helps!!