Color to list view at databind or at runtime...

Sample code
 

foreach (ListViewItem Item in listView1.Items)
{
if (Item.Index % 2 == 0)
{
Item.BackColor = System.Drawing.Color.Red;
}
else
{
Item.BackColor = System.Drawing.Color.Gold;
}
}

tahnks for your reply but in listview how I do color to particular row


hgere is my source code:



  con.Open();
            

 cmd = new SqlCommand("exec_search_details @varSub_category='" + txtmat.Text + "', @varCity_name = '" + ddcity.SelectedItem.Text + "' , @varareaname = '" + txtarea.Text + "'", con);
        da = new SqlDataAdapter(cmd);
        ds = new DataSet();
        da.Fill(ds);

        ListView1.DataSource = ds;
        ListView1.DataBind();

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            if (ds.Tables[0].Rows[i]["varType"].ToString().Contains("Gold"))
            {
            HtmlTable tbl = (HtmlTable)ListView1.FindControl("tbllayout");
                tbl.Rows[0].BgColor = "#FFFFFF";

            }
        }
            else if (ds.Tables[0].Rows[i]["varType"].ToString().Contains("Free"))
            {
                HtmlTable tbl = (HtmlTable)ListView1.FindControl("tbllayout");
                tbl.Rows[0].BgColor = "#FFFF33";
            }
            else if (ds.Tables[0].Rows[i]["varType"].ToString().Contains("Platinum"))
            {
                HtmlTable tbl = (HtmlTable)ListView1.FindControl("tbllayout");

                tbl.Rows[0].BgColor = "#999ccc";
            }
        }

please give me example of it..

Get the data from your database.
Find the index associated with the one you get and color it