[asp.net c#] มาตามคำขอ ajax control toolkit ว่าด้วยเรื่อง autocomplete extender

<add tagPrefix="ajax" namespace="AjaxControlToolkit" assembly="AjaxControlToolkit"/>

<pages>
   <controls>
      ....
      ....
   </controls>
</pages>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using System.Data;
using System.Data.SqlClient;
using System.Globalization;
using System.IO;
using System.Text.RegularExpressions;
using System.Web.Configuration;

#region ========== Class SqlDatabaseManager ==========
/// <summary>
/// Summary description for SqlDatabase
/// </summary>
public abstract class SqlDatabaseManager
{
    #region ========== Field ==========
    private SqlConnection sqlConnection;
    private SqlCommand sqlCommand;
    private SqlTransaction sqlTransaction;
    private List<string> errorCommand;

    private string sqlConnectionString = string.Empty;
    private string sqlConnectionKeyName = string.Empty;
    private string sqlCommandString = string.Empty;
    private string commandMessage = "You must execute command.";
    private bool commandSuccess = false;
    private bool transaction = false;
    private int rowsAffected = 0;
    #endregion

    #region ========= Constructor ==========
    /// <summary>
    /// Use sql connection string from web.config configulation.
    /// </summary>
    public SqlDatabaseManager()
    {
        if (WebConfigurationManager.ConnectionStrings["SqlConnectionString"] != null)
        {
            //สำหรับ web.config ที่มีการ add connection string ชื่อ SqlConnectionString เอาไว้
            //
            //ตัวอย่างใน web.config
            //<connectionStrings>
            //    <add name="SqlConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=SqlDatabase;Integrated Security=True;" providerName="System.Data.SqlClient"/>
            //</connectionStrings>

            sqlConnectionKeyName = "SqlConnectionString";
            sqlConnectionString = WebConfigurationManager.ConnectionStrings["SqlConnectionString"].ToString();
            sqlConnection = new SqlConnection(sqlConnectionString);
        }
        else
        {
            sqlConnection = new SqlConnection();        
        }
    }

    /// <summary>
    /// Use sql connection string from web.config configulation by key name.
    /// </summary>
    public SqlDatabaseManager(string SqlConnectionKeyName)
    {
        sqlConnectionKeyName = SqlConnectionKeyName;
        sqlConnectionString = WebConfigurationManager.ConnectionStrings[sqlConnectionKeyName].ToString();
        sqlConnection = new SqlConnection(sqlConnectionString);
    }

    /// <summary>
    /// Use sql connection string by user define.
    /// </summary>
    public SqlDatabaseManager(string SqlConnectionKeyName, string SqlConnectionString)
    {
        sqlConnectionKeyName = SqlConnectionKeyName;
        sqlConnectionString = SqlConnectionString;
        sqlConnection = new SqlConnection(sqlConnectionString);
    }    
    #endregion

    #region ========== Property ==========
    /// <summary>
    /// Gets or sets Sql connection key name from web.config.
    /// </summary>
    protected virtual string ConnectionKeyName
    {
        get { return sqlConnectionKeyName; }
        set
        {
            sqlConnectionKeyName = value;
            sqlConnectionString = WebConfigurationManager.ConnectionStrings[sqlConnectionKeyName].ToString();
            sqlConnection = new SqlConnection(sqlConnectionString);   
        }
    }

    /// <summary>
    /// Gets or sets Sql connection.
    /// </summary>
    protected virtual string ConnectionString
    {
        get { return sqlConnectionString; }
        set 
        {
            sqlConnectionString = value;
            sqlConnection = new SqlConnection(sqlConnectionString);
        }
    }

    /// <summary>
    /// Gets or sets Sql command.
    /// </summary>
    protected virtual string CommandString
    {
        get { return sqlCommandString; }
        set
        {
            sqlCommandString = ConvertDateCommand(value);
            sqlCommand = new SqlCommand(sqlCommandString, sqlConnection);

            commandMessage = "You must execute command.";
            commandSuccess = false;
            rowsAffected = 0;

            if (transaction)
                sqlCommand.Transaction = sqlTransaction;
        }
    }

    /// <summary>
    /// Check for Sql command.
    /// </summary>
    protected virtual bool IsSuccess
    {
        get { return commandSuccess; }
    }

    /// <summary>
    /// Gets message from Sql command.
    /// </summary>
    protected virtual string Message
    {
        get { return commandMessage; }
    }

    /// <summary>
    /// Gets Number of rows affected.
    /// </summary>
    protected virtual int RowsAffected
    {
        get { return rowsAffected; }
    }
    #endregion

    #region ========== Method ==========
    /// <summary>
    /// Add the parameter value to the sql command.
    /// </summary>
    /// <param name="ParameterName">The name of Parameter.</param>
    /// <param name="ParameterValue">The value to be added.</param>
    protected virtual void AddParameter(string ParameterName, object ParameterValue)
    {
        sqlCommand.Parameters.AddWithValue(ParameterName, ParameterValue);
    }

    /// <summary>
    /// Add the parameter value to the sql command.
    /// </summary>
    ///<param name="ParameterName">The name of the parameter.</param>
    ///<param name="SqlDataType">One of the SqlDbType  values.</param>
    ///<param name="Size">The column length.</param>
    ///<param name="ColumnName">The name of the source column.</param>
    protected virtual void AddParameter(string ParameterName, SqlDbType SqlDataType, int Size, string ColumnName)
    {
        sqlCommand.Parameters.Add(ParameterName, SqlDataType, Size, ColumnName);
    }

    /// <summary>
    /// Start Sql Transaction.
    /// </summary>
    protected virtual void TransactionStart()
    {
        transaction = true;
        errorCommand = new List<string>();

        if (sqlConnection.State != ConnectionState.Open)
            sqlConnection.Open();

        sqlTransaction = sqlConnection.BeginTransaction(IsolationLevel.ReadCommitted);    
    }

    /// <summary>
    /// Insert the DataTable to database.
    /// </summary>
    /// <param name="DataSource">The name of the DataTable. </param>
    /// <returns>Result of command.</returns>
    protected virtual bool Insert(DataTable DataSource)
    {
        bool result = false;

        try
        {
            SqlDataAdapter sqlAdapter = new SqlDataAdapter();
            sqlAdapter.InsertCommand = sqlCommand;
            rowsAffected = sqlAdapter.Update(DataSource);

            commandMessage = "Command is successfully.";
            commandSuccess = true;
            result = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
        }

        return result;
    }

    /// <summary>
    /// Update the database by DataTeble.
    /// </summary>
    /// <param name="DataSource">The name of the DataTable. </param>
    /// <returns>Result of command.</returns>
    protected virtual bool Update(DataTable DataSource)
    {
        bool result = false;

        try
        {
            SqlDataAdapter sqlAdapter = new SqlDataAdapter();
            sqlAdapter.UpdateCommand = sqlCommand;
            rowsAffected = sqlAdapter.Update(DataSource);

            commandMessage = "Command is successfully.";
            commandSuccess = true;
            result = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
        }

        return result;
    }

    /// <summary>
    /// Delete the database by DataTeble.
    /// </summary>
    /// <param name="DataSource">The name of the DataTable. </param>
    /// <returns>Result of command.</returns>
    protected virtual bool Delete(DataTable DataSource)
    {
        bool result = false;

        try
        {
            SqlDataAdapter sqlAdapter = new SqlDataAdapter();
            sqlAdapter.DeleteCommand = sqlCommand;
            rowsAffected = sqlAdapter.Update(DataSource);

            commandMessage = "Command is successfully.";
            commandSuccess = true;
            result = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
        }

        return result;
    }
    
    /// <summary>
    /// Execute Sql Transaction.
    /// </summary>
    /// <returns>Result of transaction.</returns>
    protected virtual bool ExecuteTransaction()
    {
        transaction = false;

        if (errorCommand.Count == 0)
        {
            sqlTransaction.Commit();

            commandMessage = "All command is successfully. <font color=\"darkgreen\">Transaction Commited.</font>";
            commandSuccess = true;
        }
        else
        {
            sqlTransaction.Rollback();

            string ErrorText = "Some command has error. <font color=\"red\">Transaction Rollback.</font><br />Error in: <br />";

            foreach (string aErrorSqlCommand in errorCommand)
            {
                ErrorText += aErrorSqlCommand + "<br />";
            }

            commandMessage = ErrorText;
            commandSuccess = false;
        }

        errorCommand.Clear();

        if (sqlConnection.State == ConnectionState.Open)
            sqlConnection.Close();

        return commandSuccess;
    }

    /// <summary>
    /// Execute Query Sql command.
    /// </summary>
    /// <returns>Query data in DataTable.</returns>
    protected virtual DataTable ExecuteQuery()
    {
        DataTable dataTable = new DataTable();

        try
        {
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
            sqlDataAdapter.Fill(dataTable);
            sqlDataAdapter.Dispose();

            commandMessage = "Command is successfully.";
            commandSuccess = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
        }

        rowsAffected = dataTable.Rows.Count;

        return dataTable;
    }

    /// <summary>
    /// Execute Scalar Sql command.
    /// </summary>
    /// <returns>Object of value.</returns>
    protected virtual object ExecuteScalar()
    {
        object Result = 0;

        try
        {
            if (transaction)
            {
                Result = sqlCommand.ExecuteScalar();
            }
            else
            {
                if (sqlConnection.State != ConnectionState.Open)
                    sqlConnection.Open();

                Result = sqlCommand.ExecuteScalar();
                sqlConnection.Close();
            }

            commandMessage = "Command is successfully.";
            commandSuccess = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
            if (transaction) AddErrorCommand(sqlCommandString, ex.Message);
        }

        return Result;
    }

    /// <summary>
    /// Execute Non Query Sql command.
    /// </summary>
    /// <returns>Result of execute command.</returns>
    protected virtual bool ExecuteNonQuery()
    {
        rowsAffected = 0;

        try
        {
            if (transaction)
            {
                rowsAffected = sqlCommand.ExecuteNonQuery();
            }
            else
            {
                if (sqlConnection.State != ConnectionState.Open)
                    sqlConnection.Open();

                rowsAffected = sqlCommand.ExecuteNonQuery();
                sqlConnection.Close();
            }

            commandMessage = "Command is successfully.";
            commandSuccess = true;
        }
        catch (Exception ex)
        {
            commandMessage = ErrorMessage(ex.Message);
            commandSuccess = false;
            if (transaction) AddErrorCommand(sqlCommandString, ex.Message);
        }

        return commandSuccess;
    }

    /// <summary>
    /// Build error message.
    /// </summary>
    /// <param name="Message">Message string.</param>
    /// <returns>Error message string.</returns>
    protected virtual string ErrorMessage(string MessageString)
    {
        return "<font color=\"red\">Command error.</font> " + MessageString;
    }

    /// <summary>
    /// Add error sql command to string collections.
    /// </summary>
    /// <param name="commandString">The sql command.</param>
    /// <param name="errorMessage">The error message.</param>
    protected virtual void AddErrorCommand(string commandString, string errorMessage)
    {
        errorCommand.Add(commandString + " <font color=\"red\">[Error message: " + errorMessage + "]</font>");
    }

    /// <summary>
    /// Convert native command to sql command.
    /// </summary>
    /// <param name="commandString">The native sql command.</param>
    /// <returns>The standard sql command.</returns>
    protected virtual string ConvertDateCommand(string commandString)
    {
        string SmallDateTimePattern = "[sS][mM][aA][lL][lL][dD][aA][tT][eE][tT][iI][mM][eE]\\([@][0-9a-zA-Z\\s]{1,}\\)";
        Regex SmallDateTimeRgx = new Regex(SmallDateTimePattern);

        foreach (Match SmallDateTimeMatchCase in SmallDateTimeRgx.Matches(commandString))
        {
            string MatchCasePattern = "^[sS][mM][aA][lL][lL][dD][aA][tT][eE][tT][iI][mM][eE]";
            Regex MatchCaseRgx = new Regex(MatchCasePattern);
            Match RemoveMatch = MatchCaseRgx.Match(SmallDateTimeMatchCase.Value);
            string TempMatchCase = SmallDateTimeMatchCase.Value.Replace(RemoveMatch.Value, "");

            commandString = commandString.Replace(SmallDateTimeMatchCase.Value, TempMatchCase.Replace("(", "Convert(SmallDateTime, ").Replace(")", ", 103)"));
        }

        string DateTimePattern = "[dD][aA][tT][eE][tT][iI][mM][eE]\\([@][0-9a-zA-Z\\s]{1,}\\)";
        Regex DateTimeRgx = new Regex(DateTimePattern);

        foreach (Match DateTimeMatchCase in DateTimeRgx.Matches(commandString))
        {
            string MatchCasePattern = "^[dD][aA][tT][eE][tT][iI][mM][eE]";
            Regex MatchCaseRgx = new Regex(MatchCasePattern);
            Match RemoveMatch = MatchCaseRgx.Match(DateTimeMatchCase.Value);
            string TempMatchCase = DateTimeMatchCase.Value.Replace(RemoveMatch.Value, "");

            commandString = commandString.Replace(DateTimeMatchCase.Value, TempMatchCase.Replace("(", "Convert(DateTime, ").Replace(")", ", 103)"));
        }

        return commandString;
    }
    #endregion
}
#endregion

#region ========== Class SqlConvert ==========
/// <summary>
/// Summary description for SqlConvert
/// </summary>
public sealed class SqlConvert
{
    /// <summary>
    /// Convert to byte[].
    /// </summary>
    /// <param name="BinaryStream">File upload binary stream.</param>
    /// <param name="StreamLength">Lenght of File upload binary stream.</param>
    /// <returns>Byte[] of binary stream.</returns>
    public static byte[] ToVarBinary(Stream BinaryStream, int StreamLength)
    {
        BinaryReader BinaryRead = new BinaryReader(BinaryStream);
        byte[] binaryData = BinaryRead.ReadBytes(StreamLength);

        return binaryData;
    }

    /// <summary>
    /// Convert to DataTime DataType with d/M/yyyy format.
    /// </summary>
    /// <param name="DateString">DateTime sring.</param>
    /// <returns>Datetime Type.</returns>
    public static DateTime ToDateTime(string DateString)
    {
        //ควรกำหนด culture ใน web.config เป็น th
        //
        //ตัวอย่างใน web.config
        //<globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="th-TH" uiCulture="th-TH"/>

        return DateTime.ParseExact(DateString, "d/M/yyyy", CultureInfo.InvariantCulture);
    }

    /// <summary>
    /// Convert to DataTime DataType with user define format.
    /// </summary>
    /// <param name="DateString">DateTime sring.</param>
    /// <param name="DateFormat">DateTime Format</param>
    /// <returns>Datetime Type.</returns>
    public static DateTime ToDateTime(string DateString, string DateFormat)
    {
        //ควรกำหนด culture ใน web.config เป็น th
        //
        //ตัวอย่างใน web.config
        //<globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="th-TH" uiCulture="th-TH"/>

        return DateTime.ParseExact(DateString, DateFormat, CultureInfo.InvariantCulture);
    }
}
#endregion

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using System.Data;
using System.Data.SqlClient;
using System.Net;
using System.Text;
using System.Text.RegularExpressions;

/// <summary>
/// Summary description for PokedexData
/// </summary>
public class PokedexData : SqlDatabaseManager
{
	public PokedexData()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public void CreatePokedexTable()
    {
        DataTable PokedexTable = new DataTable();

        if (!TableExist("PokedexTable"))
        {
            string RequestedPokedex = RequestHtmlData("http://pokemondb.net/pokedex/all");
            PokedexTable = GetPokedexData(RequestedPokedex);

            CreateTable("PokedexTable");
            FillPokedexData(PokedexTable);
        }

        PokedexTable.Dispose();
    }

    public void DeletePokedexTable()
    {
        if (TableExist("PokedexTable"))
            DropTable("PokedexTable");
    }

    private string RequestHtmlData(string Url)
    {
        WebClient objWebClient = new WebClient();

        byte[] byteRequestedHtml = objWebClient.DownloadData(Url);
        UTF8Encoding objUtf8 = new UTF8Encoding();

        return objUtf8.GetString(byteRequestedHtml);
    }

    private bool TableExist(string TableName)
    {
        base.CommandString = string.Format("If Object_ID('{0}', 'U') Is Not Null Select 'true' Else Select 'false'", TableName);

        return Convert.ToBoolean(base.ExecuteScalar());
    }

    private bool DropTable(string TableName)
    {
        base.CommandString = string.Format("Drop Table [{0}]", TableName);

        return base.ExecuteNonQuery();
    }

    private bool CreateTable(string TableName)
    {
        base.CommandString = string.Format("Create Table [{0}] ([PokemonID] int Identity(1,1) Primary Key Clustered, [PokemonCode] nvarchar(50), [PokemonName] nvarchar(50), [PokemonHp] int, [PokemonAttack] int, [PokemonDefense] int, [PokemonSpAttack] int, [PokemonSpDef] int, [PokemonSpeed] int, [PokemonIcon] varbinary(MAX), [PokemonArtwork] varbinary(MAX))", TableName);

        return base.ExecuteNonQuery();
    }

    private bool FillPokedexData(DataTable PokemonData)
    {
        base.CommandString = "Insert Into [PokedexTable] ([PokemonCode], [PokemonName], [PokemonHp], [PokemonAttack], [PokemonDefense], [PokemonSpAttack], [PokemonSpDef], [PokemonSpeed], [PokemonIcon], [PokemonArtwork]) Values (@PokemonCode, @PokemonName, @PokemonHp, @PokemonAttack, @PokemonDefense, @PokemonSpAttack, @PokemonSpDef, @PokemonSpeed, @PokemonIcon, @PokemonArtwork)";
        base.AddParameter("@PokemonCode", SqlDbType.NVarChar, 50, "PokemonCode");
        base.AddParameter("@PokemonName", SqlDbType.NVarChar, 50, "PokemonName");
        base.AddParameter("@PokemonHp", SqlDbType.Int, 4, "PokemonHp");
        base.AddParameter("@PokemonAttack", SqlDbType.Int, 4, "PokemonAttack");
        base.AddParameter("@PokemonDefense", SqlDbType.Int, 4, "PokemonDefense");
        base.AddParameter("@PokemonSpAttack", SqlDbType.Int, 4, "PokemonSpAttack");
        base.AddParameter("@PokemonSpDef", SqlDbType.Int, 4, "PokemonSpDef");
        base.AddParameter("@PokemonSpeed", SqlDbType.Int, 4, "PokemonSpeed");
        base.AddParameter("@PokemonIcon", SqlDbType.VarBinary, -1, "PokemonIcon"); // -1 is Max Length
        base.AddParameter("@PokemonArtwork", SqlDbType.VarBinary, -1, "PokemonArtwork"); // -1 is Max Length

        return base.Insert(PokemonData);
    }

    private DataTable GetPokedexData(string RequestHtml)
    {
        string[] TextArray = RequestHtml.Split(new char[] { '\n' });

        DataTable PokedexTable = new DataTable();
        PokedexTable.Columns.Add(new DataColumn("PokemonCode", typeof(string)));
        PokedexTable.Columns.Add(new DataColumn("PokemonName", typeof(string)));
        PokedexTable.Columns.Add(new DataColumn("PokemonHp", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonAttack", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonDefense", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonSpAttack", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonSpDef", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonSpeed", typeof(int)));
        PokedexTable.Columns.Add(new DataColumn("PokemonIcon", typeof(byte[])));
        PokedexTable.Columns.Add(new DataColumn("PokemonArtwork", typeof(byte[])));

        bool start = false;
        string code = string.Empty;
        string name = string.Empty;
        int hp = 0;
        int attack = 0;
        int defense = 0;
        int spAtt = 0;
        int spDef = 0;
        int speed = 0;

        foreach (string aString in TextArray)
        {
            string PokedexStartPattern = "<tdclass=\"numeric\"id=\"[\\D]{1,}\"><spanclass=\"pkIcon[\\D]{1,}\"></span>[0-9]{3}</td>";
            Regex PokedexStartRgx = new Regex(PokedexStartPattern);
            string PokedexStartMatch = (PokedexStartRgx.Match(aString.Trim().Replace(" ", string.Empty)) != null) ? PokedexStartRgx.Match(aString.Trim().Replace(" ", string.Empty)).Value : string.Empty;

            string PokedexEndPattern = "<tdclass=\"numerictotal\">[0-9]{1,}</td>";
            Regex PokedexEndRgx = new Regex(PokedexEndPattern);
            string PokedexEndMatch = (PokedexEndRgx.Match(aString.Trim().Replace(" ", string.Empty)) != null) ? PokedexEndRgx.Match(aString.Trim().Replace(" ", string.Empty)).Value : string.Empty;

            if (PokedexStartMatch != string.Empty)
            {
                start = true;

                string[] pokemonText = PokedexStartMatch.Replace("<tdclass=\"numeric\"id=\"", string.Empty).Replace("\"><spanclass=\"pkIcon", ",").Replace("\"></span>", ",").Replace("</td>", string.Empty).Split(new char[] { ',' });
                code = pokemonText[2];
                name = pokemonText[0];
            }

            if (start && PokedexStartMatch.Trim() == string.Empty && PokedexEndMatch.Trim() == string.Empty)
            {
                string PokedexPattern = "<tdclass=\"numeric\">[0-9]{1,}</td>";
                Regex PokedexRgx = new Regex(PokedexPattern);

                if (PokedexRgx.Match(aString.Trim().Replace(" ", string.Empty)).Value != string.Empty)
                {
                    string aValue = PokedexRgx.Match(aString.Trim().Replace(" ", string.Empty)).Value.Replace("<tdclass=\"numeric\">", string.Empty).Replace("</td>", string.Empty);

                    if (hp == 0)
                        hp = int.Parse(aValue);
                    else if (attack == 0)
                        attack = int.Parse(aValue);
                    else if (defense == 0)
                        defense = int.Parse(aValue);
                    else if (spAtt == 0)
                        spAtt = int.Parse(aValue);
                    else if (spDef == 0)
                        spDef = int.Parse(aValue);
                    else if (speed == 0)
                        speed = int.Parse(aValue);
                }
            }

            if (start && PokedexEndMatch != string.Empty)
            {
                if (code != string.Empty)
                {
                    WebClient objWebClient = new WebClient();

                    string icon = string.Empty;
                    string artwork = string.Empty;

                    switch (name)
                    {
                        case "unown-a":
                            name = "unown";
                            icon = "unown-a";
                            artwork = "unown";
                            break;
                        case "burmy-plant":
                            name = "burmy";
                            icon = "burmy-plant";
                            artwork = "burmy";
                            break;
                        case "shellos-east":
                            name = "shellos";
                            icon = "shellos-east";
                            artwork = "shellos";
                            break;
                        case "gastrodon-east":
                            name = "gastrodon";
                            icon = "gastrodon-east";
                            artwork = "gastrodon";
                            break;
                        case "rotom-normal":
                            name = "rotom";
                            icon = "rotom";
                            artwork = "rotom";
                            break;
                        case "giratina-altered":
                            name = "giratina";
                            icon = "giratina";
                            artwork = "giratina";
                            break;
                        case "shaymin-land":
                            name = "shaymin";
                            icon = "shaymin";
                            artwork = "shaymin";
                            break;
                        default:
                            icon = name;
                            artwork = name;
                            break;
                    }

                    DataRow Dr = PokedexTable.NewRow();
                    Dr["PokemonCode"] = code;
                    Dr["PokemonName"] = name;
                    Dr["PokemonHp"] = hp;
                    Dr["PokemonAttack"] = attack;
                    Dr["PokemonDefense"] = defense;
                    Dr["PokemonSpAttack"] = spAtt;
                    Dr["PokemonSpDef"] = spDef;
                    Dr["PokemonSpeed"] = speed;
                    Dr["PokemonIcon"] = objWebClient.DownloadData(string.Format("http://pokemondb.net/images/sprites/diamond-pearl/icon/{0}.png", icon));
                    Dr["PokemonArtwork"] = objWebClient.DownloadData(string.Format("http://pokemondb.net/images/artwork/{0}.png", artwork));
                    PokedexTable.Rows.Add(Dr);
                }

                start = false;

                code = string.Empty;
                name = string.Empty;
                hp = 0;
                attack = 0;
                defense = 0;
                spAtt = 0;
                spDef = 0;
                speed = 0;
            }
        }

        DataView PokedexTableView = PokedexTable.DefaultView;
        PokedexTableView.Sort = "PokemonCode ASC";

        return PokedexTableView.ToTable();
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using System.Data;

/// <summary>
/// Summary description for PokedexTable
/// </summary>
public class PokedexTable : SqlDatabaseManager
{
	public PokedexTable()
	{
		//
		// TODO: Add constructor logic here
		//
        PokedexData pokemon = new PokedexData();
        pokemon.CreatePokedexTable();
	}

    public DataTable GetAllPokedex()
    {
        base.CommandString = "Select [PokemonCode], [PokemonName], [PokemonHp], [PokemonAttack], [PokemonDefense], [PokemonSpAttack], [PokemonSpDef], [PokemonSpeed] From [PokedexTable]";
        
        return base.ExecuteQuery();
    }

    public byte[] GetPokemonIcon(string PokemonCode)
    {
        base.CommandString = "Select [PokemonIcon] From [PokedexTable] Where [PokemonCode]=@Code";
        base.AddParameter("@Code", PokemonCode);

        return (byte[])base.ExecuteQuery().Rows[0]["PokemonIcon"];
    }

    public byte[] GetPokemonArtwork(string PokemonCode)
    {
        base.CommandString = "Select [PokemonArtwork] From [PokedexTable] Where [PokemonCode]=@Code";
        base.AddParameter("@Code", PokemonCode);

        return (byte[])base.ExecuteQuery().Rows[0]["PokemonArtwork"];
    }

    public DataTable SearchPokemon(string Keyword)
    {
        base.CommandString = "Select [PokemonCode], [PokemonName], [PokemonHp], [PokemonAttack], [PokemonDefense], [PokemonSpAttack], [PokemonSpDef], [PokemonSpeed] From [PokedexTable] Where [PokemonName] Like @keyword";
        base.AddParameter("@keyword", string.Format("%{0}%", Keyword));

        return base.ExecuteQuery();
    }

    public bool IsPokemon(string PokemonName)
    {
        base.CommandString = "Select Count(*) As [Pokemon] From [PokedexTable] Where [PokemonName]=@keyword";
        base.AddParameter("@keyword", PokemonName);

        return ((int)base.ExecuteScalar() > 0) ? true : false;
    }

    public string GetPokemonCode(string PokemonName)
    {
        base.CommandString = "Select [PokemonCode] From [PokedexTable] Where [PokemonName]=@keyword";
        base.AddParameter("@keyword", PokemonName);

        DataTable Dt = base.ExecuteQuery();

        return (Dt.Rows.Count > 0) ? Dt.Rows[0]["PokemonCode"].ToString() : "0";
    }

    public DataTable GetPokemonData(string PokemonCode)
    {
        base.CommandString = "Select [PokemonCode], [PokemonName], [PokemonHp], [PokemonAttack], [PokemonDefense], [PokemonSpAttack], [PokemonSpDef], [PokemonSpeed] From [PokedexTable] Where [PokemonCode]=@Code";
        base.AddParameter("@Code", PokemonCode);

        return base.ExecuteQuery();
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="PokemonImage.aspx.cs" Inherits="PokemonImage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class PokemonImage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["type"] != null && Request.QueryString["code"] != null)
        { 
            Page.Controls.Clear();

            PokedexTable pokemon = new PokedexTable();

            Response.ContentType = "image/png";

            switch (Request.QueryString["type"].ToString().ToLower())
            {
                case "icon":
                    Response.BinaryWrite(pokemon.GetPokemonIcon(Request.QueryString["code"].ToString()));
                    break;
                case "artwork":
                    Response.BinaryWrite(pokemon.GetPokemonArtwork(Request.QueryString["code"].ToString()));
                    break;
            }
        }
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GetPokemon.aspx.cs" Inherits="GetPokemon" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class GetPokemon : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BoundField Icon = new BoundField();
            Icon.HeaderText = "Icon";

            BoundField Code = new BoundField();
            Code.HeaderText = "Code";
            Code.DataField = "PokemonCode";

            BoundField Name = new BoundField();
            Name.HeaderText = "Pokemon";
            Name.DataField = "PokemonName";

            BoundField Pic = new BoundField();
            Pic.HeaderText = "Picture";

            GridView1.Columns.Add(Icon);
            GridView1.Columns.Add(Code);
            GridView1.Columns.Add(Name);
            GridView1.Columns.Add(Pic);
        }

        PokedexTable pokemon = new PokedexTable();

        GridView1.AutoGenerateColumns = false;
        GridView1.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
        GridView1.DataSource = pokemon.GetAllPokedex();
        GridView1.DataBind();
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Image Icon = new Image();
            Icon.ImageUrl = string.Format("~/PokemonImage.aspx?type=icon&code={0}", e.Row.Cells[1].Text);
            e.Row.Cells[0].Controls.Add(Icon);

            Image Pic = new Image();
            Pic.ImageUrl = string.Format("~/PokemonImage.aspx?type=artwork&code={0}", e.Row.Cells[1].Text);
            e.Row.Cells[3].Controls.Add(Pic);
        }
    }
}

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="Pokemon.master.cs" Inherits="Pokemon" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Pokemon</title>
    <link href="PokemonAutoComplete.css" rel="stylesheet" type="text/css" />
    <link href="Pokemon.css" rel="stylesheet" type="text/css" />
    <asp:ContentPlaceHolder id="head" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body onload="javascript:document.getElementById('<%=SearchTextBox.ClientID %>').focus();">
    <form id="form1" runat="server">
    <div>
        <ajax:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
            <Services>
                <asp:ServiceReference Path="~/PokemonAutoComplete.asmx" />
            </Services>
        </ajax:ToolkitScriptManager>

        <div style="padding: 25px 20px 25px 20px; border: 1px; border-bottom-style: solid; background-color: #36295e">
            <asp:TextBox runat="server" ID="SearchTextBox" Width="350" autocomplete="off" />
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="*" ControlToValidate="SearchTextBox"></asp:RequiredFieldValidator>
            <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="*" ControlToValidate="SearchTextBox" ValidationExpression="^[\D\S\.]{2,}"></asp:RegularExpressionValidator>
            <ajax:AutoCompleteExtender
                runat="server" 
                ID="autoComplete1" 
                TargetControlID="SearchTextBox"
                ServicePath="~/PokemonAutoComplete.asmx" 
                ServiceMethod="GetCompletionList"
                MinimumPrefixLength="2" 
                CompletionInterval="100"
                EnableCaching="true"
                CompletionListCssClass="autocomplete_completionListElement" 
                CompletionListItemCssClass="autocomplete_listItem" 
                CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem"
                CompletionSetCount="12">
            </ajax:AutoCompleteExtender>
            <asp:Button ID="SearchButton" runat="server" Text="Pokemon" />        
        </div>
        <div style="padding: 10px 10px 10px 10px;">
            <asp:ContentPlaceHolder id="ContentPlaceHolder1" runat="server">
        
            </asp:ContentPlaceHolder>    
        </div>
    </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Pokemon : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SearchButton.Click += new EventHandler(SearchButton_Click);
    }

    protected void SearchButton_Click(object sender, EventArgs e)
    {
        PokedexTable pokemon = new PokedexTable();

        if (pokemon.IsPokemon(SearchTextBox.Text.Trim()))
        {
            Response.Redirect(string.Format("~/pokemondata.aspx?code={0}", pokemon.GetPokemonCode(SearchTextBox.Text.Trim())));
        }
        else
        {
            Response.Redirect(string.Format("~/pokemon.aspx?keyword={0}", SearchTextBox.Text));
        }
    }
}

/*AutoComplete flyout */

.autocomplete_completionListElement 
{  
	margin : 0px!important;
	background-color : inherit;
	color : windowtext;
	border : buttonshadow;
	border-width : 1px;
	border-style : solid;
	cursor : default;
	overflow : auto;
    text-align : left; 
    list-style-type : none;
    padding-left: 0px;
}

/* AutoComplete highlighted item */

.autocomplete_highlightedListItem
{
	background-color: #87CEEB;
	color: black;
	padding: 1px;
}

/* AutoComplete item */

.autocomplete_listItem 
{
	background-color : window;
	color : windowtext;
	padding : 1px;
}
        
.ajax__tab_header 
{
    font-size: 12px;
    font-family: Tahoma, Sans-Serif;
}
        
/* Pager */
        
.pager:hover
{
    border: solid 2px #87CEEB;
    /* background-color: #FFFACD; */
}
        
.pager
{
    border: solid 2px #f0f0f0;            
}

body{
    background: #babdb6 url("/images/pokemonbg.gif");
    margin: 0px;
    padding: 0;
}

body,th,td,input,select,textarea{
    font-family:"verdana","dejavu sans",sans-serif;
    font-size:13px;line-height:1.33;
    text-align:left;
}

h1,h2,h3,h4{
    font-family:"georgia",serif;font-weight:normal;
}

h1{
    margin:0 0 0 0;
    color:#ce5c00;
    font-size:260%;
}

h1 em{
    color:#f57900;
}

h2{
    margin:0 0 0 0;
    font-size:200%;
    color:#2e3436;
}

table.base-stats th{
    color:#888a85;
    font-size:8pt;
    font-weight:normal;
    text-align:right;
    text-transform:uppercase;
    white-space:nowrap;
}

td.numeric{
    text-align:right;
}

td.total{
    font-weight:bold!important;
    font-size:108%!important;
    color:#555753!important;
}

td.graph{
    width:250px;
}

div.barchart{
    height:18px;
    background:#81b6e7 url("/images/bar-bg.gif") repeat-x;
}

div.barchart img.left{
    width:4px;
    height:18px;
    float:left;
}

div.barchart img.right{
    width:4px;
    height:18px;
    float:right;
}

<%@ Page Title="" Language="C#" MasterPageFile="~/Pokemon.master" AutoEventWireup="true" CodeFile="Pokemon.aspx.cs" Inherits="Pokemon" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="background: #ffffff; padding: 10px; border: 1px solid black;">
        <asp:Label ID="Label1" runat="server" Text="Pokedex"></asp:Label>
        <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" 
            GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        </asp:GridView>
    </div>
</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Pokemon : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["keyword"] != null)
        {
            Label1.Visible = false;

            if (!IsPostBack)
            {
                ((TextBox)Page.Master.FindControl("SearchTextBox")).Text = Request.QueryString["keyword"].ToString();

                BoundField Icon = new BoundField();
                Icon.HeaderStyle.Width = Unit.Parse("20px");

                BoundField Code = new BoundField();
                Code.HeaderText = "Code";
                Code.HeaderStyle.Width = Unit.Parse("50px");
                Code.DataField = "PokemonCode";

                BoundField Name = new BoundField();
                Name.HeaderText = "Pokemon";
                Name.HeaderStyle.Width = Unit.Parse("120px");
                Name.DataField = "PokemonName";

                BoundField Hp = new BoundField();
                Hp.HeaderText = "Hp";
                Hp.HeaderStyle.Width = Unit.Parse("60px");
                Hp.DataField = "PokemonHp";

                BoundField Attack = new BoundField();
                Attack.HeaderText = "Attack";
                Attack.HeaderStyle.Width = Unit.Parse("60px");
                Attack.DataField = "PokemonAttack";                   
                
                BoundField Defense = new BoundField();
                Defense.HeaderText = "Defense";
                Defense.HeaderStyle.Width = Unit.Parse("60px");
                Defense.DataField = "PokemonDefense";            

                BoundField SpAttack = new BoundField();
                SpAttack.HeaderText = "Sp.Att";
                SpAttack.HeaderStyle.Width = Unit.Parse("60px");
                SpAttack.DataField = "PokemonSpAttack";    
 
                BoundField SpDef = new BoundField();
                SpDef.HeaderText = "Sp.Def";
                SpDef.HeaderStyle.Width = Unit.Parse("60px");
                SpDef.DataField = "PokemonSpDef";

                BoundField Speed = new BoundField();
                Speed.HeaderText = "Speed";
                Speed.HeaderStyle.Width = Unit.Parse("60px");
                Speed.DataField = "PokemonSpeed";

                BoundField Total = new BoundField();
                Total.HeaderText = "Total";
                Total.HeaderStyle.Width = Unit.Parse("60px");

                GridView1.Columns.Add(Icon);
                GridView1.Columns.Add(Code);
                GridView1.Columns.Add(Name);
                GridView1.Columns.Add(Hp);
                GridView1.Columns.Add(Attack);
                GridView1.Columns.Add(Defense);
                GridView1.Columns.Add(SpAttack);
                GridView1.Columns.Add(SpDef);
                GridView1.Columns.Add(Speed);
                GridView1.Columns.Add(Total);
            }

            PokedexTable pokemon = new PokedexTable();
            GridView1.AutoGenerateColumns = false;
            GridView1.DataSource = pokemon.SearchPokemon(Request.QueryString["keyword"].ToString());
            GridView1.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
            GridView1.DataBind();
        }
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Image Icon = new Image();
            Icon.ImageUrl = string.Format("~/PokemonImage.aspx?type=icon&code={0}", e.Row.Cells[1].Text);
            e.Row.Cells[0].Controls.Add(Icon);

            HyperLink NameLink = new HyperLink();
            NameLink.Text = string.Format("<strong>{0}</strong>", e.Row.Cells[2].Text);
            NameLink.NavigateUrl = string.Format("~/pokemondata.aspx?code={0}", e.Row.Cells[1].Text);
            e.Row.Cells[2].Controls.Add(NameLink);

            e.Row.Cells[9].Text = string.Format("<strong>{0}</strong>", (int.Parse(e.Row.Cells[3].Text) + int.Parse(e.Row.Cells[4].Text) + int.Parse(e.Row.Cells[5].Text) + int.Parse(e.Row.Cells[6].Text) + int.Parse(e.Row.Cells[7].Text) + int.Parse(e.Row.Cells[8].Text)).ToString());
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;

using System.Data;

/// <summary>
/// Summary description for PokemonAutoComplete
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
[System.Web.Script.Services.ScriptService] // *** สำหรับสคริปเซอร์วิส ***
public class PokemonAutoComplete : System.Web.Services.WebService {

    public PokemonAutoComplete () {

        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }

    [WebMethod]
    public string[] GetCompletionList(string prefixText)
    {
        int count = 0;
        PokedexTable pokemon = new PokedexTable();
        DataTable DtPokemon = new DataTable();
        DtPokemon = pokemon.SearchPokemon(prefixText.Trim());

        if (DtPokemon.Rows.Count > 12)
        {
            count = 12;
        }
        else
        {
            count = DtPokemon.Rows.Count;
        }

        List<string> items = new List<string>(count);
        for (int i = 0; i < count; i++)
        {
            items.Add(DtPokemon.Rows[i]["PokemonName"].ToString());
        }

        return items.ToArray();
    }
}

<%@ Page Title="" Language="C#" MasterPageFile="~/Pokemon.master" AutoEventWireup="true" CodeFile="PokemonData.aspx.cs" Inherits="PokemonData" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="background: #ffffff; padding: 10px; border: 1px solid black;">
        <table border="0" width="750" cellpadding="5" cellspacing="0">
            <tr valign="top">
                <td rowspan="9" style="width: 300px; text-align: left;">
                    <asp:Image ID="PokemonImage" runat="server" />
                </td>
                <td style="width: 450px;">
                    <asp:Label ID="NameLabel" runat="server" Text="Label"></asp:Label>
                </td>
            </tr>
            <tr valign="top">
                <td><h2>Base stats</h2></td>
            </tr>
            <tr>
                <td>
                	<table class="base-stats">
	                <tbody>
	                <tr>
		                <th>HP</th>
		                <td class="numeric">
                            <asp:Label ID="HpLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="HpPanel" CssClass="barchart" runat="server">
                                <asp:Image ID="HpBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="HpBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                <tr>
		                <th>Attack</th>
		                <td class="numeric">
                            <asp:Label ID="AttackLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="AttackPanel" CssClass="barchart" runat="server">
                                <asp:Image ID="AttackBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="AttackBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                <tr>
		                <th>Defense</th>
		                <td class="numeric">
                            <asp:Label ID="DefenseLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="DefensePanel" CssClass="barchart" runat="server">
                                <asp:Image ID="DefenseBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="DefenseBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                <tr>
		                <th>Sp. Atk</th>
		                <td class="numeric">
                            <asp:Label ID="SpAttLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="SpAttPanel" CssClass="barchart" runat="server">
                                <asp:Image ID="SpAttBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="SpAttBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                <tr>
		                <th>Sp. Def</th>
		                <td class="numeric">
                            <asp:Label ID="SpDefLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="SpDefPanel" CssClass="barchart" runat="server">
                                <asp:Image ID="SpDefBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="SpDefBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                <tr>
		                <th>Speed</th>
		                <td class="numeric">
                            <asp:Label ID="SpeedLabel" runat="server" Text="Label"></asp:Label>
                        </td>
		                <td class="graph">
                            <asp:Panel ID="SpeedPanel" CssClass="barchart" runat="server">
                                <asp:Image ID="SpeedBarLeft" ImageUrl="~/Images/bar-left.gif" CssClass="left" runat="server" />
                                <asp:Image ID="SpeedBarRight" ImageUrl="~/Images/bar-right.gif" CssClass="right" runat="server" />
                            </asp:Panel>
		                </td>
	                </tr>
	                </tbody>
	                <tbody>
	                <tr>
		                <th>Total</th>
		                <td class="total">
                            <asp:Label ID="TotalLabel" runat="server" Text="Label"></asp:Label>
                        </td>
	                </tr>
	                </tbody>
	                </table>
                </td>

            </tr>
        </table>
    </div>
</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Data;

public partial class PokemonData : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["code"] != null)
        {
            PokedexTable pokemon = new PokedexTable();
            DataRow DrPokemon = pokemon.GetPokemonData(Request.QueryString["code"].ToString()).Rows[0];

            PokemonImage.ImageUrl = string.Format("~/PokemonImage.aspx?type=artwork&code={0}", Request.QueryString["code"].ToString());
            
            NameLabel.Text = string.Format("<h1><em>{0}</em>", DrPokemon["PokemonName"].ToString());
            
            HpLabel.Text = DrPokemon["PokemonHp"].ToString();
            HpPanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonHp"].ToString()) + 8).ToString()));

            AttackLabel.Text = DrPokemon["PokemonAttack"].ToString();
            AttackPanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonAttack"].ToString()) + 8).ToString()));

            DefenseLabel.Text = DrPokemon["PokemonDefense"].ToString();
            DefensePanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonDefense"].ToString()) + 8).ToString()));

            SpAttLabel.Text = DrPokemon["PokemonSpAttack"].ToString();
            SpAttPanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonSpAttack"].ToString()) + 8).ToString()));

            SpDefLabel.Text = DrPokemon["PokemonSpDef"].ToString();
            SpDefPanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonSpDef"].ToString()) + 8).ToString()));

            SpeedLabel.Text = DrPokemon["PokemonSpeed"].ToString();
            SpeedPanel.Attributes.Add("Style", string.Format("width: {0}px;", (int.Parse(DrPokemon["PokemonSpeed"].ToString()) + 8).ToString()));

            TotalLabel.Text = string.Format("<strong>{0}</strong>", (int.Parse(DrPokemon["PokemonHp"].ToString()) + int.Parse(DrPokemon["PokemonAttack"].ToString()) + int.Parse(DrPokemon["PokemonDefense"].ToString()) + int.Parse(DrPokemon["PokemonSpAttack"].ToString()) + int.Parse(DrPokemon["PokemonSpDef"].ToString()) + int.Parse(DrPokemon["PokemonSpeed"].ToString())).ToString());

            if (!IsPostBack)
                ((TextBox)Page.Master.FindControl("SearchTextBox")).Text = DrPokemon["PokemonName"].ToString();
        }
    }
}