how to highlight particular row in datagrid

[priyamsc]

I have used datagrid.in that i would like to hightlight the particular rows based on the select query.... The particular row should be highlighed when the page gets loaded base on the select query(using where status='e')
so can u help me to do this....

HTML CODINGS
===========

<asp:DataGrid ID="DataGrid2"
runat="server" AutoGenerateColumns="False" CellPadding="4"
Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" ForeColor="#333333" GridLines="None" Height="70px" PageSize="5"
Width="867px" OnItemCommand="changestatus" OnPageIndexChanged="DataGrid2_PageIndexChanged1">
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<EditItemStyle BackColor="#7C6F57" />
<SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#E3EAEB" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundColumn DataField="callno" HeaderText="Call No"></asp:BoundColumn>
<asp:BoundColumn DataField="block" HeaderText="Block"></asp:BoundColumn>
<asp:BoundColumn DataField="location" HeaderText="Location"></asp:BoundColumn>
<asp:BoundColumn DataField="department" HeaderText="Department"></asp:BoundColumn>
<asp:BoundColumn DataField="pblmtype" HeaderText="Problem type"></asp:BoundColumn>
<asp:BoundColumn DataField="problem" HeaderText="Problem"></asp:BoundColumn>
<asp:BoundColumn DataField="curdate" HeaderText="Date&amp;time"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="user name">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSource="<%#poplist()%>"
DataTextField="uname" DataValueField="uname" Width="99px">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Call Allocation">
<ItemTemplate>
<asp:LinkButton ID="changebutton" runat="server" CommandName ="change" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"callno")%>' Text="Allocate"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>&nbsp;<br />


the coding is
=========

protected void changestatus(object source, DataGridCommandEventArgs e)
{
int key = 0;
if (e.CommandName == "change")
{
//DataGrid2.SelectedIndex = e.Item.ItemIndex;
key = Convert.ToInt32(e.CommandArgument.ToString());
// cmd = new SqlCommand("update swiftresult set status='a'where status='x' and callno=" + key + "", con);
// cmd.ExecuteNonQuery();
// DataGrid2.DataSource = cmd.ExecuteReader();
//DataGrid2.DataBind();
DataGrid2.EditItemIndex = -1;
string ddl1 = ((DropDownList)(e.Item.FindControl("DropDownList1"))).SelectedItem.Text;
loaddata();
userdata(key,ddl1);
}
}
public void userdata(int cno, string name)
{
con = new SqlConnection("server=SOFTWARE4;uid=sa;pwd=;database=helpdesk1");
con.Open();
SqlDataReader dr = null;
SqlCommand cmd1 = new SqlCommand("select blkid,locid,deptid,pblmtype,problem,curdate from swiftresult where callno=" + cno + "", con);
try
{
dr = cmd1.ExecuteReader();
if (dr.Read())
{
string blk = (string)dr["blkid"].ToString();
string loc = (string)dr["locid"].ToString();
string dept = (string)dr["deptid"].ToString();
string pbltype = (string)dr["pblmtype"].ToString();
string pblm = (string)dr["problem"].ToString();
string cdate=(string)dr["curdate"].ToString();
string sql = "update swiftresult set allocated='" + name + "',status='a',allocatedby='"+p.ToString()+"' where callno="+cno;
//string sql = "insert into allocatecalls values(" + cno + ",'" + blk + "','" + loc + "','" + dept + "','" + pbltype + "','" + pblm + "','" + cdate + "','" + name + "',null)";
SqlConnection con1 = new SqlConnection("server=SOFTWARE4;uid=sa;pwd=;database=helpdesk1");
con1.Open();
SqlCommand cmd2 = new SqlCommand(sql, con1);
//SqlTransaction trans = con1.BeginTransaction(IsolationLevel.ReadCommitted);
// cmd2.Transaction = trans;
try
{
cmd2.ExecuteNonQuery();
//trans.Commit();
loaddata();
}
finally
{
con1.Close();
}
}
}
finally
{
if (dr != null)
{
// dr.Close();
}
if (cmd1 != null)
{
//cmd1.clos
}



so pls suggest me where have to write the highlight codings pls....

[pra123]

Hi priya,
Try to use datagrid.row[index].select

[priyamsc]

thank you for reply... but can u tel me how to use that row[index]...i was trying a lot but couldn't get ...

[pra123]

Use something like

protected int GetSelectedRecord( )
{
int shipperID = -1;
int index = GridView1.SelectedIndex;
if (index != -1)
{
DataKey key = GridView1.DataKeys[index];
shipperID = (int)key.Value;
}
return shipperID;
}