Changing the color of a cell in a datalist

[sck10]

Hello,

I am populating a DataList with data from a stored procedure. What I am
trying to do is change the color based on the one of the values that the
stored procedure sends.

When I try to use the method "protected void
dlstTransformation_ItemDataBound(object sender, DataListItemEventArgs e)",
I get the error: System.Data.Common.DbDataRecord' to type
'System.Data.DataRowView'.

Any help with this would be appreciated.

sck10

<aspataList id="dlstTransformation" Runat="Server"
OnItemDataBound="dlstTransformation_ItemDataBound"
GridLines="Both"
CellPadding="1"
CellSpacing="3"
RepeatColumns="4"
RepeatDirection="Horizontal">
<ItemTemplate>
<asp:Label ID="lblTransformation" runat="server" Text='<%#
Eval("ServiceLink") %>' />
</ItemTemplate>
</aspataList></aspanel>




protected void Transformation(string str00, string str01, string str02,
string str03, string str04)
{
string strCatchName = "Transformation";

try
{
//'Open connection to database
using(SqlConnection cnnSearch = new
SqlConnection(strConnSQLFundTrack))
{
cnnSearch.Open();

SqlCommand cmdSearch = new SqlCommand(str00, cnnSearch);
cmdSearch.CommandType = CommandType.StoredProcedure;

//'Declare Parameters
cmdSearch.Parameters.AddWithValue("@strParm01", str01);
cmdSearch.Parameters.AddWithValue("@strParm02", str02);
cmdSearch.Parameters.AddWithValue("@strParm03", str03);
cmdSearch.Parameters.AddWithValue("@strParm04", str04);

SqlDataReader sdrSearch = cmdSearch.ExecuteReader();
dlstTransformation.DataSource = sdrSearch;
dlstTransformation.DataBind();

//To re-read the data, close Reader and re-open
sdrSearch.Close();
sdrSearch = cmdSearch.ExecuteReader();
if(sdrSearch.HasRows)
{
this.pnlTransformation.Visible = true;
this.lblTransformation.Text = strCatchName;
//this.lblServiceDscr.Text =
this.lblServiceDscr.Text.Replace("\r\n", "<br/>").Trim();
} //Loop


} // end using

} // end try

catch(Exception ex)
{
this.AppCodeHidePanels();
this.pnlMessage.Visible = true;
this.lblMessageTitle.Text = "Stored Procedure Error";
this.lblMessageText.Text =
"<span class=BlkB>Problems with stored procedure:</span> " +
"<span class=BlkB>" + strCatchName + "</span><br />" +
ex.Message.ToString();
}

finally
{
// can place something here that will always be fire.
}

} // end void


protected void dlstTransformation_ItemDataBound(object sender,
DataListItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)
{
System.Data.DataRowView drv = (DataRowView)(e.Item.DataItem);
string strBackColor = drv.Row["StatusColor"].ToString();
e.Item.BackColor = System.Drawing.Color.Black;
}
}

 

[Steven Cheng[MSFT]]

Hello Steve,

For your scenario, since you bind the DataReader to the DataList rather
than a Dataset/DataTable, you can not convert each DataItem(in
ItemDataBound event) to DataRowview. DataRowView is only available in
DataView(which is generated from DataTable).

In your ItemDataBound code, you can convert the DataItem to "IDataRecord"
interface and retrive column value from it. e.g.

===============
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs
e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==
ListItemType.AlternatingItem)
{
IDataRecord record = e.Item.DataItem as IDataRecord;

int id = (int)record["CategoryID"];
string name = (string)record["CategoryName"];

Response.Write("<br/>id: " + id + ", name: " + name);
}
}
=====================

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

 

[sck10]

Thanks Steven,

worked perfectly...