If there are references to legacy publications within replication monitor, despite them not showing up under sql replication publication folder, you need to re-create each publisher with the exact same name and then delete it for the leagcy references to get deleted.

This issue can arrise when sql server is setup to perform log-shipping between 2 servers under a fail-over plan with replication setup. Legacy replication references can still be present under replication monitor which impacts the ability to re-create the real replication setup after a fail over.

GridView - A very powerful control that provides an easy interface to add, update, delete, and
display data.

Sometimes we may need to manipulate the text, cells, and rows to fit our needs.

GridView is great for very simple tables. Sometimes we need to specify the format of the data, and the way it is rendered in the table, more exactly.

DataList could be used but doesn't have all the features such as paging and sorting that are commonly required.

If you need to use the GridView, but also need more control on the way that the table is rendered, you can use the GridView events and properties.

RowDataBound - The most common event used. This event is fired every time a row is bound to data. Whenever this event is fired, we will have access to the current row and all of its data, so we can manipulate the table, row, cells, and or controls of the table accordingly.

Other important events are the DataBound and the Load event.

Load event - fires when the GridView is loaded and has not been attached to any data yet. In this event the user can set properties such as the color of the border, themes, or any other rendering options that are not dependent on the data itself.

DataBound - is similar to the RowDataBound in that both are fired after a bound event has happened. The difference is that DataBound is fired once after the entire Grid has been bound; while the RowDataBound is fired every time a row is bound, meaning it will almost always be fired more than once. So you can use the DataBound to manipulate the table based on the data contained in it.

Thanks to http://www.simple-talk.com/dotnet/asp.net/take-row-level-control-of-your-gridview/ Visit the link for a full breakdown.

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<ContentTemplate>

<asp:GridView

OnRowDataBound="gvComorbidities_RowDataBound"

DataKeyNames="comorbidityID"

runat="server"

ID="gvComorbidities"

AutoGenerateColumns="false">

<Columns>

    <asp:TemplateField>

        <HeaderTemplate>

            <p>Date Reported</p>

        </HeaderTemplate>

        <ItemTemplate>

            <table>

                <tr>

                    <td><a href='<%# String.Format("Comorbidities.aspx?comorbidityID={0}&Patient_ID={1}&OperationID={2}",DataBinder.Eval(Container.DataItem,"comorbidityid"),DataBinder.Eval(Container.DataItem,"patient_id"),DataBinder.Eval(Container.DataItem,"operationid")) %>'><%# DataBinder.Eval(Container.DataItem, "dateoffirstsymptoms", "{0:d}")%></a></td>

                </tr>

            </table>

        </ItemTemplate>

    </asp:TemplateField>

</Columns>

</asp:GridView>

 protected void gvComorbidities_RowDataBound(object sender, GridViewRowEventArgs e)

    {

        // Look for data items      

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            string comorbidityid = gvComorbidities.DataKeys[e.Row.DataItemIndex].Value.ToString();

            string qscomorbidityid = Request.QueryString["comorbidityid"].ToString();
            if (comorbidityid == qscomorbidityid)

            {

                e.Row.BackColor = System.Drawing.Color.LightGray;

            }

        }

    }

When setting up site in webmaster tools, ensure you set the preferred domain to www.bla.com and not otherwise site strength is split between bla.com and www.bla.com

In order to get this setup in webmaster tools, you need to add both sites as there is currently a bug in google. you need to setup www.bla.com and bla.com. verify both sites and then delete the one you don't need.

In addition to this, if google has indexed pages that related to the incorrect version of your site, i.e. bla.com/page1 instead of www.bla.com/page 1, you will need to setup a 301 redirect with your htacess file. If you don't have access to this, get your host to do it for you.

See for more information.
http://www.a3webtech.com/index.php/gwt-preferred-domain-bug-fix.html

Step 1: Dump the database either through PHPMyAdmin’s export form or through mysqldump. Note (mysqldump -h -u -p

if you ommit the -h switch it will default to “localhost”). After you enter the command below and press enter, you will be prompted for a password because you did not enter the password after the -p switch.
$ mysqldump -u -p >> somedatabasetable.sql

Step 2: Once you have the sql file, log into mysql and create a database or “use” an existing database – again, ommiting the -h will default to localhost and you will be prompted for a password if you don’t enter a password after the -p switch.
$ mysql -u -p

Step 3: After logging in, you will need to either create a new database and select the database for use with the import, or use an existing database. For this example, we’ll create a new database. Remember to use backticks and not apostrophe’s to create your new MySQL database.
mysql> create database `somedb`

Step 5: Remember where you put the SQL file and issue a “source” command:
mysql> source somedatabasetable.sql
The query is executed and if you didn’t mess around with the SQL produced by mysqldump, it should run things flawlessly.

Jquery mobile apps are themed using swatches :

- Reference the main jquery-mobile.min.js file

- Create a new swatch file by copying an existing jquery mobile.css file non-min version. Delete all swatches apart from Swatch A. Now Replace Swatch A with your own letter.

- Save swatch to something like jquery.swatch-m.css

- Reference this file inside your html pages and use data-them="m" to use the new swatch.

In order to use jquery mobile icons, you must copy the images folder that comes part of the jquery mobile download when hosting your own files into the same folder where jquery-mobile.css file is located.