Forms Data Controls :: Formatting Text In A Gridview?
Apr 30, 2010
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
I want if the header of a particular column contains a word "S", the header and row turns red. I used following code to make header red and it works fine. How to make it such that the rows also turn red if condition is met ? I cannot hardcode in columns since the Gridview is autogenerate colums as data structure keeps changing.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs)Dim HeaderRow As GridViewRow = GridView1.HeaderRowFor Each c As TableCell In HeaderRow.CellsIf c.Text.EndsWith("S") Then c.BackColor = Drawing.Color.OrangeRed End If Next End Sub
I have a listview control qith a datapager. I'm using a linkbutton for next and previous. I have a css class that makes the text Arial, and bold. It also sets the size to 10px. When I run the page, the link button is Arial and bold, but I can't change the size of the text. I've tried setting it to 10px, 8px, even 5px, 10pt, and xx-small. Nothing changes the font size. My customer wants the next and previous buttons to look a certain way. I'll have to manage paging manually if I can't get this figured out.
I'm using ASP .NET C# 3.5. I have a multiline textbox on my web form that allows for the input of up to 5,000 characters from the end-user. This text is a basic description of a training course. I need to display it out in a clearly formatted way. For example, I need there to be bullets and bold text.
What I did was I chose certain (not often used) characters and then used the .Replace method when displaying the text in an <asp:Label>. If the text in the database contains the character '~' then I replace that with a line break <br />. If it contains '`' I replace that with <b> and if it contains '^' I replace that with </b>.
Is there a better way of doing this? It is working properly, and I'm displaying the text properly, but I know the end-user is going to hate typing text like this for formatting. I do want this all to stay database driven as well
I have a long text in SQL and passing it to a gridview. I am trying to make the gridview result display in a multiline scroll. I have tried the following code but to no avail. Additionally, the text in the gridview result is not in the same format as where it came from, eg. Word. That is the format such as bullet points and multiple spaces are removed. So what is left is a lenghty long string.
I have a series of textboxes on a FormView. There is a textbox for entering a percent for a deposit amount and next to that a corresponding textbox for entering a dollar value for a deposit amount. There are 3 sets of these.
If a user changes a percent textbox, I update the dollar value textbox based on the percent times the project's total cost. If a user changes the dollar value textbox, the percent textbox gets updated as a percent of that dollar amount divided by the project's total cost.
I have the percent textboxes formatted as "{0:0%}" and the dollar value textboxes as "{0:C}".
When a user types into the textbox, the formatting goes away and we get raw numbers but I don't want those raw numbers to remain as such after they tab or click out of the field. I added a TextChanged event to reset the formatting. This works fine on reformatting the percent textbox but the currency one remains as just a raw numeric value.
Here is the markup (ignore the lack of validation for numeric input only...it will be added):
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
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.
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?
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#
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?
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.
specially 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.
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" ?
I have a Gridview which is autocolumngenerated so the column can be numeric or text depending on what the datasource returns.I want to format it such that :If the cell/column is numeric, then format it into sth like 3,331.How to write code to detect this and do the job ?
I have a Gridview with autogenerated columns since the query structure keeps changing depending the dropdown list.
However for Jan-10 etc column I want to format it to #,##0 etc. I use Dataformatstring when hard code the column but for autogenerated column, what can I do ?
I know one way is in script databound event make it that format whenever header = Jan-10 etc. What should be the code?
I have parentGridView and childGridView. ChildGridView opens in ParentGridView cell. But it expands the cell and makes all the parents cells out of formatting look and feel.1 ) How can i use colspan property to expand the childGirdView? 2) i am using find control in codebehind, i dont want to disturb that hierarchy as well
I am trying to change GridView Row formatting based on cell value. I am using GridView's Rowbound event. It works when Caching on SQL datasourceis disabled but when caching is enabled it doesn't seem to work.
I finally managed to export a gridview to an excel sheet.
Next, how can I remove the column width and alternatingrowstyle color (or all formatting if it is easier) "programatically" before exporting it to excel?
