Forms Data Controls :: How To Change The Boundfield Data Properties For Currency
Nov 3, 2010Probably a Q more suited for a SQL forum, but I guess it comes up a fair bit in ASP.net web site design?
View 5 RepliesProbably a Q more suited for a SQL forum, but I guess it comes up a fair bit in ASP.net web site design?
View 5 RepliesI have a gridview that I am populating with data for the folks in accounting and they want me to format currency values so that they display without $'s, with commas separating digits and with negative numbers surrounded by ( )
e.g.:
12345.67 = 12,345.67
-12345.67 = (12,345.67)
I have found lots of examples around the interwebs that get me close but there is either no ( ) around negatives or there is a $ included.
I have Gridview with boundfield and one of the fields is weblink in data likewww.yahoo.comI want in Gridview display it shows up as hyperlinks in row.How should I modify the code for the Gridview boundfield for this field ?
View 5 RepliesI am wondering if its possibl to change the DataField value of the asp:BoundField in the code behind.aspx page:
[Code]....
I would like to change DataField="From" to DataField="To" before I call the GridView.DataBind.Please let me know if this is possible and if so how can I do it.
I was hoping this is simple but i have problems.
Basically i was only able to set the string color with itemstyle-Forecolor.
But how do i set the background of a column and also set height,width.Ok height may not work because i have an itemtemplate with predefined height.
Can this be done in a simple boundfield or must i have all my datafields in itemtemplates?
What i do for one column:
[Code]....
In my asp.net+vb we+access DB. i have a field named DOB which is date of birth. i displays the data in grid view whose DOB+90 is less than ot equl to current date
DOB+90<=now()
and it works currect. but when i try to used vb code to change the row colour as per data it works for this one.
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
If (e.Row.DataItem("DOR") <= Now()) Then
e.Row.ForeColor = Drawing.Color.Red
End If
But i want three diffrent conditions
1. Â whose DOB=current month
2. Â whose DOB comes in next month
3. whose DOB comes in month after next month
The font colour should be diffrent
I want to access the header text of bound fields programatically. suppose i have GridView1 with following bound fields:
<asp:BoundField Visible="false" DataField="ID" HeaderText="ID" />Â Â Â Â Â Â Â Â Â Â Â Â Â <asp:BoundField DataField="Title" HeaderText="Title" />Â Â Â Â Â Â Â Â Â Â Â Â Â <asp:BoundField Visible="false" DataField="Description" HeaderText="Description" />
how can I access their header text programmatically ( display it(either using response.write or any label)
I have the code below, it all works if the BoundField is set to Visible = "true", but if i change it to "false" then my conditions are not being met and page logic doesnt work.
What am i doing wrong?
[Code]....
How could I change (programmatically) a couple of properties in a grdiview template ? For instance, the CalendarExtender6.enabled and the textbox, Duetext.readonly.
[Code].....
I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?
I have to add some columns which is not in the table and assign the values from code behind to that particular column
I'm trying to change a Label's text property and colour properties depending if an event occurs on the page behind file.
Does anyone have a similar issue?
if (((Label)FindControl("Label1")).Text != null) - //getting Object reference not set to an instance of an object.
{
Label Labelmerchantid = (Label)FindControl("Label1");
Labelmerchantid.Visible = true;
Labelmerchantid.ForeColor = System.Drawing.Color.Red;
}
I need to access a control inside a repeater and change its properties. To enable it or not. I got an erorr message Object reference not set to an instance of an object. Here is my code inside a method. protected void
rptCAP_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
LinkButton lnDel = (LinkButton)rptCap.FindControl("lnkDelete");
lnkDel.Enabled = false; //<<<<< this is where the error occur
}
The name of the repeater control is id="rptCAP"
i have an datatable called orders. One of the columns is "OrderAmount" In the aspx, page I have a datalist and am using the {0:c} in the item template but it is not showing the £ symbol or the amount in correct number format.
In my datatable I am not sure if I need to use Int or Float.
the amount I want to enter is £21,316.56. I have tried entering 2131651 but it does not display correctly in data list.
I use ObjectDataSource and DetailsView for Updating records . my Bll input parameter method is an Object instead of regular parameter . So i though i could make my own ObjectParameter in ItemUpdating event of DetailsView and i need some modifiation on the data that user input on boudfield in detailsView . I don't know how to access BoundFiled data from ItemUpdating Method of DetailsView.
View 1 RepliesI am tring to write some custom filters for a gridview and want to base the filters available based on the datatype of the Columns in the GridView. How would I go about determining the datatype of each column?
View 1 Repliesin my gridview i have a list of names that are bound.
in my aspx i have a list of names that i can select from.
i want to see if each selected name is already in the grid.
something like
if (li.Value == row.FindControl("Name").ToString())
in currency format like 00,00,00,000.00 format in Bound Field in gridview?
View 12 Repliesis it possible to convert a Currency value $100.00 to a decimal value of 100.00?
View 1 RepliesHow can I autoincrement the value of a boundfield column in a gridview ?
View 2 RepliesIn vb.net how can I get the value of a gridview's boundfield value? I'm basically putting a value in that boundfield that I need to access in the RowDeleting event so I can pass that into a stored procedure. I'd be open to also trying to get the value of a control from a template column too if that's a better method?
View 4 RepliesI wonder why asp.net wont allow accessing property of contained class on Gridview's Boundfields while it work in ItemTemplates..
Class User
{
Diagnosis diagnosis { get; set; } // Contained class
}
Class Diagnosis
{
string DiagnosisCode { get; set; }
}
gridview.datasource =
new List<User>() {
new User() {
diagnosis = new Diagnosis() { DiagnosisCode = "MALARIA" }} }
<boundfield datafield='<#% User.diagnosis.DiagnosisCode %>' />
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 number 2879068. I want to display it in currency format as like 28,79,068 in C#
View 4 Repliesin my below post there is a solution of currency format of a textbox and it is working fine.http://forums.asp.net/p/1544844/3779841.aspx#3779841but when i try it textbox within Gridview then it is working only "Empty Temlate" textbox.but not working within "Footer Template ".my code is like below
<asp:TemplateField HeaderText="Pay Amount">
<EditItemTemplate>
<asp:TextBox ID="txtEdtclgPayAmnt" runat="server" CssClass="smalltextbox" TabIndex="10" Text='<%#BIND
[code]...
how to put three rows of one table data in gridview one coloumn
 how to add text1,text2,text3 rows data in upper as i write but the proper code
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_SHOWNAMETEXT1" HeaderText = "SHOW NAME"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_TEXTTYPE" HeaderText = "TEXT TYPE"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "text1,text2,tex3 " HeaderText = "TEXT"/>
[Code].....