I am using a column named "bk_End_Date" in my gridview.I want to change the row color based on a condition.i.e. if the date value is within one week of today's date (upcomming days only), it's color should be red.I tried following method in RowDataBound Event of C#
//if (DateTime.Parse(e.Row.Cells[5].Text) <= DateTime.Today.AddDays(7))
//{
// e.Row.BackColor.Equals(Color.FromName("Red"));
[code]...
I have the following VB code that is trying to change colors based on the values. The first condition works but the second does not.
[Code]....
I have the following code:
[Code]....
I need to add a check for a checkbox column in the grid. Something like:If CDate(e.Row.Cells(6).Text) < Date.Now and 'checkbox is checked' Then make another colorHow do I check for the value of the checkbox?
I have a gridview on my aspx page. I know we can format gridview row in rowdatabound() of gridview. But my problem is bit different.
In my gridview, i have a column customer code, a single code can repeat more than once successively. I want for one customer code, row color should be blue and as soon as code changes colour should be yellow for that code. Similarly when code changes again color should be blue again.
In this way color of my gridview rows should be blue and yellow alternately based on my customer code.I have arranged customer code in order by using sql order by clause.
I have a gridview containing serial-numbers.
I would like to format the background each data-row that contains a duplicate serial-number value.
I'm planning to do this using a DataBound event handler.
So, in English:
Set background colour of THIS_ROW to red where the Serial_Number of THIS_ROW is the same as the Serial_Number of ANY_OTHER_ROW.
All rows with duplicate serial-numbers would be red.
I'm not sure how to write the code for this event.
The gridview is bound to a SQL datasource. Getting the dupes in SQL is easy:
SELECT Serial
FROM Table
GROUP BY Serial
HAVING (COUNT(Serial) > 1)
In my repeater I am attempting to set the label format based on a value from my datasource. The following line from my repeater is straightforward enough but now how would I modify it if I wanted the "C2" statement in the ToString to pull from a field in my datasource named "MyFormat" which would contain either the C2 or N0 value? Basically switching the formatting for that label between currency and a double?
<asp:Label runat="server" ID="lblValue1" Text='<%# Convert.ToDouble(Eval("MyValue")).ToString("C2") %>'></asp:Label>
I've attempted to simply insert a statement such as Eval("MyFormat") in place of the "C2" statement but to no avail.
I want to have a listview with conditional formatting on its edit and delete button.So, in nutshell, I want to check if the writer of post is equal to session("memberid"), then the edit and delete button will be appeared, else, it will show hidden.
[Code]....
roughly, i want and plan it to be sort of like that (as i found it at [URL]But I do not have any idea on how to make it whatsoever.So, if you guys have any idea (same as method above or different method), please show me the way.I have seen another forum, but I don't get it.
This might be confusing but ill try to explain the best as i can. I have a gridview that get the data from datatable. This is simulation my grid view.
key data
1 data1
2 data2
2. data2
2. data2
3. data3
3. data3
what i want is make some conditional statement, when value "key" is changed i want to add empty row. so its suppose to be looks like this as result.
key data
1 data1
EMPTY ROW
2 data2
2. data2
2. data2
EMPTY ROW
3. data3
3. data3
complete error msg[rsCompilerErrorInExpression] The Value expression for the textbox 'COUNT' contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
View 1 RepliesI have a conditional Eval statement in a Gridview that returns a boolean result to display an image if two datafields(strings) are identical:
Visible='<%# Eval("customerA").Equals(Eval("customerB")) %>'
Works great except I don't want the image to display if both datafields are empty. How can I add that logic into this Eval stmt?
Conditional GridView Rowstyle with CssClass Asp.net forum,
View 7 RepliesI have a gridview with a select link (Not auto created) One of my columns is a date column Another column is essentially a 'group code' For rows that have the same group code I want to disable or make the link button not visible for all but the most recent row. I wasn't sure how to go about doing this.
[Code]....
I did some search but nothing is really useful in my case.
I want to inherit the DataControlField (System.Web.UI.WebControls) to be able to carry two label controls and then I want to color the two labels to get some sort of conditional formatting, I've got the conditional formatting part but how can I customize this class?
Where in my class should I define the two label controls?
How would I override the CreateField method?
P.S: I know I can accomplish this, in XHTML Markup, but I have so many columns that it would not be appropriate to include those markups in the page markup. Therefore I'm doing that in the CodeBehind page.
EDIT:
public class MyField : DataControlField
{
public MyField()
{
}
protected override DataControlField CreateField()
{
// What to put here?
}
protected override void CopyProperties(DataControlField newField)
{
((CalendarField)newField).DataField = this.DataField;
((CalendarField)newField).DataFormatString = this.DataFormatString;
((CalendarField)newField).ReadOnly = this.ReadOnly;
base.CopyProperties(newField);
}
public override void InitializeCell(DataControlFieldCell cell, DataControlCellType cellType, DataControlRowState rowState, int rowIndex)
{
// Call the base method
base.InitializeCell(cell, cellType, rowState, rowIndex);
// Initialize the contents of the cell quitting if it is a header/footer
if (cellType == DataControlCellType.DataCell)
InitializeDataCell(cell, rowState);
}
protected virtual void InitializeDataCell(DataControlFieldCell cell, DataControlRowState rowState)
{
}
}
This is what I have - it works:
<asp:GridView ID="GridView10" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource10"
<asp:TemplateField HeaderText="File Photo" SortExpression="Pic_Number">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# (Eval("Pic_Number", "http://.../images/{0}.jpg")) %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Item_Count" HeaderText="Stock" SortExpression="Item_Count" InsertVisible="False" ReadOnly="True" >
Conceptually what I want: (item count is a BoundField called in the GridView )
<asp:GridView ID="GridView10" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource10"
<asp:TemplateField HeaderText="File Photo" SortExpression="Pic_Number">
<ItemTemplate>
( IF "Item_Count" > 50 )
<asp:Image ID="Image1" runat="server" ImageUrl='<%# (Eval("Pic_Number", "http://.../images/{0}.jpg")) %>' />
( IF "Item_Count" < 50 )
onmouseout : <asp:Image ID="Image1" runat="server" ImageUrl='<%# (Eval("Pic_Number", "http://.../images/StockLow.jpg")) %>' />
onmouseover: <asp:Image ID="Image1" runat="server" ImageUrl='<%# (Eval("Pic_Number", "http://.../images/{0}.jpg")) %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Item_Count" HeaderText="Stock" SortExpression="Item_Count" InsertVisible="False" ReadOnly="True" >
formatting a gridview where I have some numbers that show up with the minus sign on top of the number.Ideally I'd like to set the negative numbers to be red if you know how to do that.I'd also just like more control over the width of the columns.some of my formatting code is below. The If - Endif stuff fails with a null reference exception, but the forecolor and backcolor and align code works
[Code]....
I'm trying to get numbers converted to the proper look I prefer. But, it doesn't seem to be working.
I'd like the number to read 1,092, but instead it's listing it as 1092.0000000
Below is my EVAL as well as the code behind for this.
For the eval, I had to add the Convert.ToString to handle DBNULL items.
[Code]....
HUsing C# to develop a web application. Have a gridview to display data from the a sql table.The headers of the gridview is achieve using a table. Need to format the header cells to align with the columns of the gridview.Currently I'm using a trial an error method to set the width of the header to align with the gridview columns. Can I align the Table header to concide with the gird view column width progarmatically?
Here is my ASPX code
<div id="ProjectTableHeader" runat="server"
style="background-color: #993300; height: 40px; width: 300; margin: 0; padding: 0">
<table cellspacing="0" cellpadding="0" rules="all" border="1" id="tblHeader" style="font-family: Arial;font-size: 10pt; width:[code].....
I have the following code on a web page and would like to have the amount formatted as a currency value:
<ItemTemplate>
<%#
(Convert.ToDouble(Eval("Quantity"))
* Convert.ToDouble(Eval("UnitPrice")))%>
</ItemTemplate>
I have tried a number of things but nothing seems to work.
I've got a Gridview in which I have a column that shows percentages. I use the 0:P2 to format the percentage into readable format. However when the user 'edits' the particular row the percentage sign % still shows up in the textbox. When the user tries to save/update their change I throw an error on the % sign.
Is there a way to show the % only when the row isn't in an editable state?
[Code]....
I'm displaynig plain text in a Gridview and the format is not the one I'm looking for here's what's happening. The data in the database (SQL) is store as sample1
Sample 1:
Please do the following:
1. text here and more text
2. blah blah blah
3. more text, etc
However in the Grid view is displayed like this:
Sample 2:
Please do the following: 1. text here and more text 2. blah blah blah 3. more text, etc
How can I fotmatted it to llok like Sample 1 ??
Here's my code:
<Fields>
<asp:BoundField
DataField="Solutions"
HeaderText="Solutions"
ReadOnly="True" HtmlEncode="False"
ShowHeader="False"
SortExpression="Solutions">
<ItemStyle
BorderStyle="None"
VerticalAlign="Top"
Wrap="True"
/>
</asp:BoundField>
</Fields>
I have a Gridview with certain columns header in form of dates (coz the datasource is with column field from a date field in a cross tab query). What will be the code of databound event that convert col labels from like 6/1/2010 to Jun-10 in the header text.
View 1 Repliesspecially VB code behind pages.I am writing an app with a colleague and I am stuck on something.he app is a holiday booking calendar. I have a gridview that shows the total number of days booked for each month of the year. When you click the cell for say January another gridview is populated below showing each day of january.My problem is that I want to change the formatting of the cells in the second gridview depending upon if any of the cells have a 1 or a 0.
View 3 RepliesI have a gridview populated by the code below:
[Code]....
This will create multiple fields in the gridview with some values.
Say i have this field called "Sold" and it has the value "1234.5600"
How can i display it like "1,234.56" ?
[Code]....
I am trying to format currency in a GridView cell so that a zero value displays blank, but otherwise the amount in currency is shown.
Is there a more simple way than this?
[Code]....
I have a Gridview and I want to format 2nd column of it to {0:dd-MMM-yy}
If it is not autogeneratedcolumn Gridview I would have used DataFormatString="{0:dd-MMM-yy}"
However, this time it is a autogeneratedcolumn Gridview so I cannot use the above code anymore.
So can I set that column format programmatically ?
I tried
GridView1.Columns(1).
But then there is nothing close to dataformat pops up from intellisense.