468,272 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

Changing the color of a cell in a datalist

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

<asp:DataList 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>
</asp:DataList></asp:Panel>


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;
}
}
Jan 11 '07 #1
2 1317
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/subscripti...ult.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/subscripti...t/default.aspx.

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

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

Jan 11 '07 #2
Thanks Steven,

worked perfectly...
"Steven Cheng[MSFT]" <st*****@online.microsoft.comwrote in message
news:Sr**************@TK2MSFTNGHUB02.phx.gbl...
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/subscripti...ult.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/subscripti...t/default.aspx.

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

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

Jan 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Eric | last post: by
reply views Thread by Sonny Sablan | last post: by
1 post views Thread by Paul Say | last post: by
reply views Thread by Alan Silver | last post: by
2 posts views Thread by mj.redfox.mj | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.