DOTNET ACE

Querying a simple XML file using LINQ

2011-01-10T00:52:00.000-08:00

The below demo shows how to query a simple xml file using LINQ.

First create an xml file as below and name it as Countries.xml

<?xml version="1.0" encoding="utf-8" ?>

<Countries>

  <Country Id ="1">

    India

  </Country>

  <Country Id ="2">

    U.S.A

  </Country>

  <Country Id ="3">

    China

  </Country>

  <Country Id ="4">

    U.K

  </Country>

</Countries>

Then write the code as below to query xml

using System;

using System.Linq;

using System.Xml.Linq;

public partial class Linq_QueryXMLUsingLINQ : System.Web.UI.Page

{

  protected void Page_Load(object sender, EventArgs e)

  {

    XElement xEle = XElement.Load(@"D:\Countries.xml");

    var list = from l in xEle.Elements("Country")

               where ((string)l.Element("Name")).Trim() == "India"

               select l.Element("Name");

    foreach (var item in list)

    {

      Response.Write(item);

    }

  }

}

Hello LINQ

2011-01-09T23:24:00.000-08:00

Below is a simple demo of LINQ which prints all the items in the string array.

using System;

using System.Linq;

public partial class Linq_HelloLinq : System.Web.UI.Page

{

  protected void Page_Load(object sender, EventArgs e)

  {

    string[] greetings = { "Hello World", "Hello LINQ", "Hello" };

    var greetingsList = from l in greetings select l;

    foreach (var greeting in greetingsList)

    {

      Response.Write(greeting + "<br>");

    }

  }

}

Important things to note are:
1. using System.Linq;
2. var greetingsList = from l in greetings select l;

Rest all is pretty straight forward.

After you are done with doing the above, try adding a where condition to it as below.

using System;

using System.Linq;

public partial class Linq_HelloLinq : System.Web.UI.Page

{

  protected void Page_Load(object sender, EventArgs e)

  {

    string[] greetings = { "Hello World", "Hello LINQ", "Hello" };

    var greetingsList = from l in greetings where l.EndsWith("World") select l;

    foreach (var greeting in greetingsList)

    {

      Response.Write(greeting + "<br>");

    }

  }

}

Thats it here ends our simple linq demo.

SqlHelper

2011-01-07T02:00:00.000-08:00

//===============================================================================

// Author: Arun Kumar Endapally

// Created on: 14th June 2010

// Description: Util class to perform repetitive database operations

//===============================================================================

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.Text;

namespace Util

{

    public class SqlHelper

    {

        // Gets the connection string from web.config or app.config settings value.

        private string connectionString = ConfigurationManager.AppSettings["conString"];

        // Property which can be used to get/set the connection string.

        public string ConnectionString 

        { 

            get { return connectionString; } 

            set { connectionString = value; } 

        }

        // Sql connection

        private SqlConnection connection;

        public SqlConnection Connection 

        {

            get { return connection; } 

            set { connection = value; } 

        }

        // Sql transaction

        private SqlCommand command;

        // Sql transaction

        private SqlTransaction transaction;

        #region Private methods

        // Sends an email to admin when any error occurs.

        private static void SendMailOnError(Exception ex)

        {

            //TODO: Write code to send email when exception occurs.

        }

        /// <summary>

        /// Writes the error occured into the log file.

        /// </summary>

        /// <param name="ex">Exception object which has all the information about the exception</param>

        private static void WriteErrorLog(Exception ex)

        {

            try

            {

                // creates a folder with name "ErrorLogs" in the base directory of the application. 

                //string folder = AppDomain.CurrentDomain.BaseDirectory + "ErrorLogs\\";

                // creates a folder with name "ErrorLogs" in a location specified as settings value in web.config or app.config.

                string folder = ConfigurationManager.AppSettings["sqlErrorLogLocation"] + "ErrorLogs\\";

                DirectoryInfo dir = new DirectoryInfo(folder);

                // check if the directory exists

                if (!dir.Exists)

                {

                    // creates the directory

                    dir.Create();

                }

                // appending all the error info to error string builder.

                StringBuilder error = new StringBuilder();

                error.Append("Error Time: ").Append(DateTime.Now.Hour).Append(":").Append(DateTime.Now.Minute).Append(Environment.NewLine);

                error.Append("Error Message: ").Append(ex.Message).Append(Environment.NewLine);

                error.Append("Stack Trace: ").Append(Environment.NewLine).Append(ex.StackTrace).Append(Environment.NewLine);

                error.Append("------------------------------------------------------------------------------").Append(Environment.NewLine).Append(Environment.NewLine);

                // Get the current date in dd-MMM-yyyy format and use it as the error log text file name.

                string sErrorTime = DateTime.Now.ToString("dd-MMM-yyyy");

                // intialize stream writer with path and setting not to overwrite.

                StreamWriter sw = new StreamWriter(folder + sErrorTime + ".txt", true);

                sw.WriteLine(error.ToString());

                sw.Flush();

                sw.Close();

            }

            catch (Exception exc)

            {

                throw exc;

            }

            throw ex;

        }

        /// <summary>

        /// Attaches array of SqlParameter to the SqlCommand object

        /// if the value of the SqlParameter is null then it will replace the value with DBNull.Value

        /// </summary>

        /// <param name="command">SqlCommand object to which we attach parameters</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        private void AttachParameters(SqlParameter[] commandParameters)

        {

            try

            {

                // picking each parameter from the parameters array.

                foreach (SqlParameter p in commandParameters)

                {

                    // check if parameter value is null.

          if (p.Value == null || p.Value == "")

                    {

                        // if the parameter value is null then replace it with DBNull.Value.

                        p.Value = DBNull.Value;

                    }

                    // adding the parameters to command object.

                    command.Parameters.Add(p);

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// prepares the command for execution.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        private void PrepareCommand(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)

        {

            try

            {

                // check if connection exists and opened.

                if (connection != null && connection.State == ConnectionState.Open)

                {

                    // create a command object.

                    command = new SqlCommand();

                    // set connection.

                    command.Connection = connection;

                    // set command text.

                    command.CommandText = commandText;

                    // set command type.

                    command.CommandType = cmdType;

                    // check if transaction exists.

                    if (transaction != null)

                    {

                        // set transaction.

                        command.Transaction = transaction;

                    }

                    // check if command parameters exists.

                    if (commandParameters != null)

                    {

                        // attach the parameters to command object.

                        AttachParameters(commandParameters);

                    }

                }

                else

                {

                    // exception is thrown if connection is not created or not open.

                    throw new Exception("Connection is not created/open");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        #endregion

        #region Public Methods

        /// <summary>

        /// To open the database connection for performing any database operation.

        /// </summary>

        public void OpenConnection()

        {

            try

            {

                // created new connection object with the connection string retrieved from settings.

                connection = new SqlConnection(connectionString);

                // check if the connection is already open.

                if (connection.State != ConnectionState.Open)

                {

                    // connection is opened

                    connection.Open();

                }

                else

                {

                    // expception is thrown if the connection is already opened.

                    throw new Exception("Connection is already open.");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// To close the database connection after performing the database operations.

        /// </summary>

        public void CloseConnection()

        {

            try

            {

                // check if connection exists and opened.

                if (connection != null && connection.State == ConnectionState.Open)

                {

                    // close the connection.

                    connection.Close();

                    // set the connection object to null i.e. clear.

                    connection = null;

                }

                else

                {

                    // exception is thrown if connection is not created or not open.

                    throw new Exception("Connection is not created/open");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// begins a transaction for performing series of database operations.

        /// </summary>

        public void BeginTransaction()

        {

            try

            {

                // check if connection exists and opened.

                if (connection != null && connection.State == ConnectionState.Open)

                {

                    // check if transaction does not exists.

                    if (transaction == null)

                    {

                        // begin transaction.

                        transaction = connection.BeginTransaction();

                    }

                    else

                    {

                        // exception is thrown if transaction ha.s already begin/exists.

                        throw new Exception("Transaction has already begin");

                    }

                }

                else

                {

                    // exception is thrown if connection does not exists or not opened.

                    throw new Exception("Connection is not created/open");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// commits a transaction after performing series of database operations.

        /// </summary>

        public void CommitTransaction()

        {

            try

            {

                // check if connection exists and opened.

                if (connection != null && connection.State == ConnectionState.Open)

                {

                    // check if transaction exists

                    if (transaction != null)

                    {

                        // commiting the transaction

                        transaction.Commit();

                        transaction = null;

                    }

                    else

                    {

                        // exception is thrown if transaction does not exists or not begined.

                        throw new Exception("Transaction has not begin");

                    }

                }

                else

                {

                    // exception is thrown if connection does not exists or not opened.

                    throw new Exception("Connection is not created/open");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// roll backs transaction if any error occurs any where in performing series of database operations.

        /// </summary>

        public void RollbackTransaction()

        {

            try

            {

                // check if connection exists and opened.

                if (connection != null && connection.State == ConnectionState.Open)

                {

                    // check if transaction exists.

                    if (transaction != null)

                    {

                        // roll back the transaction.

                        transaction.Rollback();

                        transaction = null;

                    }

                    else

                    {

                        // exception is thrown if transaction does not exists or not begined.

                        throw new Exception("Transaction has not begin");

                    }

                }

                else

                {

                    // exception is thrown if connection does not exists or not opened.

                    throw new Exception("Connection is not created/open");

                }

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

        }

        /// <summary>

        /// Executes command, takes no SqlParameters and returns the number of rows affected.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <returns>returns number of row(s) affected</returns>

        public int ExecuteNonQuery(string commandText, CommandType cmdType)

        {

            // calling the overloaded method with null in place of SqlParameter array.

            return ExecuteNonQuery(commandText, cmdType, (SqlParameter[])null);

        }

        /// <summary>

        /// Executes command with parameters and returns the number of rows affected.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        /// <returns>returns number of row(s) affected</returns>

        public int ExecuteNonQuery(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)

        {

            try

            {

                int result = 0;

                // prepare the command for execution

                PrepareCommand(commandText, cmdType, commandParameters);

                result = command.ExecuteNonQuery();

                command.Parameters.Clear();

                return result;

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

            return 0;

        }

        /// <summary>

        /// Executes command, takes no SqlParameters and returns dataset.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <returns>returns dataset</returns>

        public DataSet ExecuteDataSet(string commandText, CommandType cmdType)

        {

            // calling the overloaded method with null in place of SqlParameter array.

            return ExecuteDataSet(commandText, cmdType, (SqlParameter[])null);

        }

        /// <summary>

        /// Executes command with parameters and returns dataset.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        /// <returns>returns dataset</returns>

        public DataSet ExecuteDataSet(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)

        {

            try

            {

                // prepare the command for execution

                PrepareCommand(commandText, cmdType, commandParameters);

                DataSet ds = new DataSet();

                SqlDataAdapter da = new SqlDataAdapter(command);

                da.Fill(ds);

                command.Parameters.Clear();

                return ds;

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

            return null;

        }

        /// <summary>

        /// Executes command, takes no SqlParameters and returns datatable.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <returns>returns datatable</returns>

        public DataTable ExecuteDataTable(string commandText, CommandType cmdType)

        {

            // calling the overloaded method with null in place of SqlParameter array.

            return ExecuteDataTable(commandText, cmdType, (SqlParameter[])null);

        }

        /// <summary>

        /// Executes command with parameters and returns datatable.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        /// <returns>returns datatable</returns>

        public DataTable ExecuteDataTable(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)

        {

            try

            {

                DataSet ds = new DataSet();

                // get the dataset

                ds = ExecuteDataSet(commandText, cmdType, commandParameters);

                DataTable dt = new DataTable();

                if (ds != null && ds.Tables.Count > 0)

                {

                    // set the datatable with the datatable in the dataset

                    dt = ds.Tables[0];

                }

                command.Parameters.Clear();

                return dt;

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

            return null;

        }

        /// <summary>

        /// Executes command, takes no SqlParameters and returns object.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <returns>returns object</returns>

        public object ExecuteScalar(string commandText, CommandType cmdType)

        {

            // calling the overloaded method with null in place of SqlParameter array.

            return ExecuteScalar(commandText, cmdType, (SqlParameter[])null);

        }

        /// <summary>

        /// Executes command, takes no SqlParameters and returns object.

        /// </summary>

        /// <param name="commandText">command text, can be a text query ex: "SELECT * FROM DemoTable" 

        /// or name of the stored procedure ex: "SPGetDetails".</param>

        /// <param name="cmdType">command type, specifying whether command text is text query or stored procedure name 

        /// ex: CommandType.Text or CommandType.StoredProcedure</param>

        /// <param name="commandParameters">array of parameters to attach to SqlCommand object</param>

        /// <returns>returns object</returns>

        public object ExecuteScalar(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)

        {

            try

            {

                object result = null;

                // prepare the command for execution

                PrepareCommand(commandText, cmdType, commandParameters);

                result = command.ExecuteScalar();

                command.Parameters.Clear();

                return result;

            }

            catch (Exception ex)

            {

                // write a log regarding the exception.

                WriteErrorLog(ex);

            }

            return null;

        }

        #endregion

    }

}
 
Wiki for SqlHelper
 
What is SqlHelper? 
SqlHelper is a utility class which contains public methods ExecuteNonQuery, ExecuteDataSet, ExecuteDataTable and ExecuteScalar. Using those methods we can perform database operations like insert, delete, update and select.

What is the advantage of using SqlHelper?
By using SqlHelper we can perform a database operation by writing minimum lines of code.

How to set connection string?
You can follow either of the below two steps:
1. You can simply add app setting with key “conString” in web.config
<configuration>
<appSettings>
<add key="conString" value="Data Source=<servername>;Initial Catalog=<databasename>;User Id=<userid>;Password=<password>"/>
</appSettings>
</configuration>
Internally SqlHelper will fetch the connection string from the app settings as the below line of code is written inside it.
private string connectionString = ConfigurationManager.AppSettings["conString"];
2. Or by setting the property ConnectionString.
SqlHelper sqlHelper = new SqlHelper();
sqlHelper.ConnectionString = "Data Source=<servername>;Initial Catalog=<databasename>;User Id=<userid>;Password=<password>";

How to open and close connection?
SqlHelper sqlHelper = new SqlHelper();
sqlHelper.OpenConnection();
// Perform database operations.
sqlHelper.CloseConnection();

About ExecuteNonQuery method
ExecuteNonQuery is used to perform database operations like insert or update or delete. There are two overloaded methods for ExecuteNonQuery, they are:
1. public int ExecuteNonQuery(string commandText, CommandType cmdType)
2. public int ExecuteNonQuery(string commandText, CommandType cmdType, params SqlParameter[] commandParameters)
The second overloaded method accepts array of parameters to attach to SqlCommand object.
ExecuteNonQuery returns number of rows affected. 
Parameter “commandText” can be a text query ex: "DELETE FROM DemoTable WHERE Id = @Id" or name of the stored procedure ex: "spDelDemoTable". 
Parameter “cmdType” is to specify whether command text is text query or stored procedure name i.e. CommandType.Text or CommandType.StoredProcedure. 
Parameter “commandParameters” are array of parameters to attach to SqlCommand object.
 Example:

// inline query
string query = "DELETE FROM DemoTable WHERE Id = @Id";
// stored procedure name
// string spName =  "spDelDemoTable";
// create an instance of SqlParameter with paramerter name and its value
SqlParameter parId = new SqlParameter("@Id", "19");
// create an instance of SqlHelper
SqlHelper sqlHelper = new SqlHelper();
// open the connection
sqlHelper.OpenConnection();
// call ExecuteNonQuery and specify parameters command text, command type and sql parameter 
int result = sqlHelper.ExecuteNonQuery(query, CommandType.Text, parId);
// int result = sqlHelper.ExecuteNonQuery(spName, CommandType.StoredProcedure, parId);
// close the connection
sqlHelper.CloseConnection();
In the above example, a row is deleted from DemoTable with specific Id. We can use either inline query or stored procedure name as command text and specify the command type accordingly.
ExecuteNonQuery returns an integer i.e. number of rows affected.

About ExecuteDataSet method
ExecuteDataSet is used to retrieve data from database, it returns a DataSet. There are two overloaded methods for ExecuteDataSet, they are:
1. public DataSet ExecuteDataSet (string commandText, CommandType cmdType)
2. public DataSet ExecuteDataSet (string commandText, CommandType cmdType, params SqlParameter[] commandParameters) 
The second overloaded method accepts array of parameters to attach to SqlCommand object. 
Parameter “commandText” can be a text query ex: "SELECT * FROM DemoTable" or name of the stored procedure ex: "spGetDemoTable". 
Parameter “cmdType” is to specify whether command text is text query or stored procedure name i.e. CommandType.Text or CommandType.StoredProcedure. 
Parameter “commandParameters” are array of parameters to attach to SqlCommand object.
Example:
// inline query
string query = "SELECT * FROM DemoTable";
// stored procedure name
// string spName =  "spGetDemoTable";
// create an instance of SqlHelper
SqlHelper sqlHelper = new SqlHelper();
// open the connection
sqlHelper.OpenConnection();
// call ExecuteDataSet and specify parameters command text, command type
DataSet dsResult = sqlHelper.ExecuteDataSet (query, CommandType.Text);
// DataSet dsResult = sqlHelper.ExecuteDataSet (spName, CommandType.StoredProcedure);
// close the connection
sqlHelper.CloseConnection();
In the above example, all the rows are retrieved from DemoTable. We can use either inline query or stored procedure name as command text and specify the command type accordingly.
ExecuteDataSet returns a DataSet which can be used to set as datasource for repeater, gridview, etc.

About ExecuteDataTable method
Same as ExecuteDataSet method,  ExecuteDataSet returns a DataSet but ExecuteDataTable returns a DataTable.

About ExecuteScalar method
ExecuteScalar is used to retrieve a single value from database, it returns an object. There are two overloaded methods for ExecuteScalar, they are:
1. public object ExecuteScalar (string commandText, CommandType cmdType)
2. public object ExecuteScalar (string commandText, CommandType cmdType, params SqlParameter[] commandParameters)
The second overloaded method accepts array of parameters to attach to SqlCommand object. 
Parameter “commandText” can be a text query ex: "SELECT COUNT(*) FROM DemoTable" or name of the stored procedure ex: "spGetRecCount". 
Parameter “cmdType” is to specify whether command text is text query or stored procedure name i.e. CommandType.Text or CommandType.StoredProcedure. 
Parameter “commandParameters” are array of parameters to attach to SqlCommand object.
Example:
// inline query
string query = " SELECT COUNT(*) FROM DemoTable";
// stored procedure name
// string spName =  "spGetRecCount";
// create an instance of SqlHelper
SqlHelper sqlHelper = new SqlHelper();
// open the connection
sqlHelper.OpenConnection();
// call ExecuteScalar and specify parameters command text, command type
object result = sqlHelper.ExecuteScalar (query, CommandType.Text);
// object result = sqlHelper.ExecuteScalar (spName, CommandType.StoredProcedure);
// close the connection
sqlHelper.CloseConnection();
In the above example, number of rows in DemoTable is retrieved. We can use either inline query or stored procedure name as command text and specify the command type accordingly.
ExecuteScalar returns an object which can be converted to int or string or to any other datatype and used accordingly.

Coding Standards

2011-01-07T01:48:00.000-08:00

Naming conventions

1. Private fields (_camelCase)

private int _empSalary;

2. Public/Protected fields (camelCase)

public int empSalary;

protected int empSalary;

3. Property (PascalCase)

public int EmpSalary

{

get { return _empSalary; }

set { _empSalary = value; }

}

4. Method (PascalCase)

public int SomeMethod ()

{

return 1;

}

5. Method arguments and local variables (camelCase)

public int SomeMethod (int empSalary)

{

int empSalaryTemp = empSalary;

return empSalaryTemp;

}

6. NameSpace and Class (PascalCase)

namespace Employee

{

public class EmpPay

{

}

7. Page name (lowercase with hyphen (‘-’) as seperator)

employee-details.aspx

8. Prefix the id of control accordingly

btn for button ex: btnSubmit

rbn for radiobutton ex: rbnSelect

chk for checkbox ex: chkSelect

grv for gridview ex: grvData

txt for textbox ex: txtName

ddl for dropdown ex: ddlCountry

Coding best pratices

1. Should write comments where every required.

2. Do not have more than one class in a file.

3. Do not exceed more than 50 lines in a method, if needed write it as a separate method and call it in the main method.

4. Always use try catch finally blocks to handle exceptions.

5. Use StringBuilder instead of string where you have to concatenate.

string str = “A”;

str += “B”;

str += “C”;

str += “D”;

Instead of the above we can write as below

StringBuilder sb = new StringBuilder();

sb.Append(“A”);

sb.Append(“B”);

sb.Append(“C”);

sb.Append(“D”);

6. We can reduce the number of lines but writing if else as follows i.e.

instead of writing it as

bool result;

if (x > 1)

{

result = true;

}

else

{

result = false;

}

we can write as

bool result = ((x > 1 ) ? true : false);

7. Use transaction when you are executing more than one related database operations.

8. Use public access modifier only when required.

9. Avoid declaring methods with more parameters i.e.

instead of declaring as

private bool SomeMethod (int empId, string empName, decimal empName, int empAge, DateTime dob)

{

return true;

}

we can write as

private bool SomeMethod (Employee emp)

{

}

Where Employee class contains the fields empId, empName, empName, empAge, dob.

10. Use method overloading to reuse the code.

Fibonacci Series c#

2011-01-07T01:35:00.001-08:00

  protected void Page_Load(object sender, EventArgs e)

  {

    int newNum = 0;

    int nextNum = 1;

    int prevNum = -1;

    for (int j = 0; j <= 20; j++)

    {

      newNum = nextNum + prevNum;

      prevNum = nextNum;

      nextNum = newNum;

      Response.Write(newNum + ", ");

    }

  }

Binding Enum To Repeater

2011-01-07T01:23:00.000-08:00

The below goes into the aspx page

<body>

  <form id="form1" runat="server">

  <div>

    <asp:Repeater ID="rptrData" runat="server">

      <ItemTemplate>

        <%#DataBinder.GetDataItem(Container) %>

      </ItemTemplate>

    </asp:Repeater>

  </div>

  </form>

</body>

The below goes into the aspx.cs page

using System;

public partial class BindEnumToRepeater_BindEnumToRepeater : System.Web.UI.Page

{

  protected void Page_Load(object sender, EventArgs e)

  {

    rptrData.DataSource = Enum.GetNames(typeof(EFruits));

    rptrData.DataBind();

  }

}

public enum EFruits

{

  Apple,

  Orange,

  Pinapple

}

JavaScript - Trim spaces, remove leading and trailing spaces in a text box

2011-01-04T03:19:00.000-08:00

Trim spaces and validating a text box in a page without master page using javascript

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title>JS Trim Without Master Page</title>

  <script type="text/javascript">

    function trim(textBoxValue) {

      return textBoxValue.replace(/^\s+|\s+$/g, '');

    }

    function ValidateData() {

      var txtName = document.getElementById("txtName");

      txtName.value = trim(txtName.value);

      if (txtName.value == "") {

        alert("Please enter text in Name");

        txtName.focus();

        return false;

      }

      return true;

    }

  </script>

</head>

<body>

    <form id="form1" runat="server">

    <div>

      Name: <asp:TextBox ID="txtName" runat="server"></asp:TextBox>

      <br />

      <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClientClick="return ValidateData();" />

    </div>

    </form>

</body>

</html>

Trim spaces and validating a text box in a page with master page using javascript

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">

  <script type="text/javascript">

    function trim(textBoxValue) {

      return textBoxValue.replace(/^\s+|\s+$/g, '');

    }

    function ValidateData() {

      // when we use a masterpage, to get the id we should use "<%= txtName.ClientID %>" instead of "txtName"

      var txtName = document.getElementById("<%= txtName.ClientID %>"); 

      txtName.value = trim(txtName.value);

      if (txtName.value == "") {

        alert("Please enter text in Name");

        txtName.focus();

        return false;

      }

      return true;

    }

  </script>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

  Name:

  <asp:TextBox ID="txtName" runat="server"></asp:TextBox>

  <br />

  <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClientClick="return ValidateData();" />

</asp:Content>

How to create a stored procedure

2011-01-03T05:27:00.000-08:00

Stored procedure without parameters

CREATE PROCEDURE SPGetEMP
AS
SELECT Id, Name , Salary
FROM Emp
RETURN

Stored procedure with parameters

CREATE PROCEDURE SPGetEMPByID
@ID int
AS
SELECT Id, Name , Salary
FROM Emp WHERE Id = @ID
RETURN

AUTOCOMPLETE="OFF"

2011-01-03T05:07:00.000-08:00

For a form set autocomplete attribute to off for not allowing user to remember password and remember values in the textboxes.

 <form  autocomplete="off" id="frmData">

HTML Character Map / HTML Character Codes / HTML Equivalent Symbols

2010-12-30T08:58:00.000-08:00

HTML	Symbol
&#33	!
&#34	"
&#35	#
&#36	$
&#37	%
&#38	&
&#39	'
&#40	(
&#41	)
&#42	*
&#43	+
&#44	,
&#45	-
&#46	.
&#47	/
&#48	0
&#49	1
&#50	2
&#51	3
&#52	4
&#53	5
&#54	6
&#55	7
&#56	8
&#57	9
&#58	:
&#59	;
&#60	<
&#61	=
&#62	>
&#63	?
&#64	@
&#65	A
&#66	B
&#67	C
&#68	D
&#69	E
&#70	F
&#71	G
&#72	H
&#73	I
&#74	J
&#75	K
&#76	L
&#77	M
&#78	N
&#79	O
&#80	P
&#81	Q
&#82	R
&#83	S
&#84	T
&#85	U
&#86	V
&#87	W
&#88	X

HTML	Symbol
&#89	Y
&#90	Z
&#91	[
&#92	\
&#93	]
&#94	^
&#95	_
&#96	`
&#97	a
&#98	b
&#99	c
&#100	d
&#101	e
&#102	f
&#103	g
&#104	h
&#105	i
&#106	j
&#107	k
&#108	l
&#109	m
&#110	n
&#111	o
&#112	p
&#113	q
&#114	r
&#115	s
&#116	t
&#117	u
&#118	v
&#119	w
&#120	x
&#121	y
&#122	z
&#123	{
&#124	\|
&#125	}
&#126	~
&#183	·
&#128	€
&#185	¹
&#130	‚
&#131	ƒ
&#132	„
&#133	…
&#134	†
&#135	‡
&#136	ˆ
&#137	‰
&#138	Š
&#139	‹
&#140	Œ
&#197	Å
&#142	Ž
&#199	Ç
&#200	È

HTML	Symbol
&#145	‘
&#146	’
&#147	“
&#148	”
&#149	•
&#150	–
&#151	—
&#152	˜
&#153	™
&#154	š
&#155	›
&#156	œ
&#213	Õ
&#158	ž
&#159	Ÿ
&#160
&#161	¡
&#162	¢
&#163	£
&#164	¤
&#165	¥
&#166	¦
&#167	§
&#168	¨
&#169	©
&#170	ª
&#171	«
&#172	¬
&#173
&#174	®
&#175	¯
&#176	°
&#177	±
&#178	²
&#179	³
&#180	´
&#181	µ
&#182	¶
&#239	ï
&#184	¸
&#241	ñ
&#186	º
&#187	»
&#188	¼
&#189	½
&#190	¾
&#191	¿
&#192	À
&#193	Á
&#194	Â
&#195	Ã
&#196	Ä
&#253	ý
&#198	Æ
&#255	ÿ
	(Space)

HTML	Symbol
&#201	É
&#202	Ê
&#203	Ë
&#204	Ì
&#205	Í
&#206	Î
&#207	Ï
&#208	Ð
&#209	Ñ
&#210	Ò
&#211	Ó
&#212	Ô
&#214	Ö
&#215	×
&#216	Ø
&#217	Ù
&#218	Ú
&#219	Û
&#220	Ü
&#221	Ý
&#222	Þ
&#223	ß
&#224	à
&#225	á
&#226	â
&#227	ã
&#228	ä
&#229	å
&#230	æ
&#231	ç
&#232	è
&#233	é
&#234	ê
&#235	ë
&#236	ì
&#237	í
&#238	î
&#240	ð
&#242	ò
&#243	ó
&#244	ô
&#245	õ
&#246	ö
&#247	÷
&#248	ø
&#249	ù
&#250	ú
&#251	û
&#252	ü
&#254	þ