Forms Data Controls :: Adding Calculated Fields To A Databound Control?
Oct 14, 2010
I need a form that displays three columns drawn directly from a database (no problems here) as well as two fields that require some complex calculations. Not only am I lost as to how to incorporate the calculations into the control, I don't know exactly how to write the calculations. I am working in Visual Web Developer 2008 with Vb.NET.
The first of the two fields should take the sum of all payments made by a given customer and divide it by a DailyMembershipRate, returning a DaysPaid variable. It should take this variable and a CustomerSince field for that particular customer and calculate a PaidThrough field.
The second of the two columns similarly requires the DaysPaid variable described above. It should subtract the CustomerSince field from the current date and return the value in days, giving a MembershipDays variable. Finally, it should subtract MembershipDays from the DaysPaid variable, again returning a value in days, and then multiply this by the DailyRate value for a Credit/Deficit field.
I realize this is a lot, but I haven't been able to find any documentation either online or in VWD or ASP.NET texts on this topic. I could really use some fellow user input.
View 4 Replies
Similar Messages:
Oct 19, 2010
I'm using a gridview to extract a set of records. I need to add another field to the gridview, which can calculate the difference between a date associated with each record and the current date.
View 6 Replies
Jul 27, 2010
I'm a college intern at a small software company. I'm a novice when it comes to ASP.net and Expression Web, so sorry if these are obvious questions.
1. After figuring out how to get fields calculated before they get displayed (did this with SQL), I need to find a way to put certain characters before the output in the fields. I'm fairly certain this is done with a template field, but I have no idea how to touch those without making them blow up.
2. I would also like to have color in the GridViews rows or cells depending on a value returned from the database. Again, I think this would be done with template fields.
3. Thirdly, I need to be able to limit the characters in a few cells. I've searched and found some answers with this, but still Template fields go right over my head.
View 7 Replies
Jul 21, 2010
My gridview displays fields from a table and allows for edit, delete and insert. I need to add a column with a derived field which will be calculated every time the user is either entering a new row or editing the value of the weight field which is one of the fields of the gridview. This calculation is done in the fly and won't be saved in the database.
View 8 Replies
Aug 18, 2010
I am using TempleteFields for all columns in my GridView. In that columns I am using only some fields for customization but not all.
Is there any performance issue with Databound Fields vs Templete Fields in a GridView...?
Do I need to replace the remaining columns with Databound Columns instead of TempletField columns...?
View 4 Replies
Jun 22, 2010
I have a GridView bound to an ObjectDataSource. Most of the columns are directly databound, however one column is not - it's value is determined in code. The value is being calculated correctly at the RowDataBound event, however when there is more than one data row in the GridView, the calculated fields for all of the rows is blank, but the top row displays the bottom row's calculated field
View 2 Replies
Jul 28, 2010
I am binding a string to a datagrid.
I want to add text around the values coming up on the datagrid..
for example
DataGrid1.DataSource = mystring;
DataGrid1.DataBind();
is the current code
but i'd like
DataGrid1.DataSource = mystring;
DataGrid1.DataBind("the result is: "mystring". thanks for looking");
View 11 Replies
Mar 5, 2010
I have started creating a DAL and have successfully bound my adaptor and the query within the adaptor to a gridview.
In lots of the intranet type apps I code in regular ASP for myself I often have a few columns with little icons in that do various things for that rows identity, such as drill down to more details, overlay a graph, text the person via an ajax call, send em an email via ajax and so on.
I think Ive got the hang of styling elements of each row depending on the data but Im completely at a loss as how to add a column which would have an icon whos url link properties would be dependant on the data.
EG
ROW1 | Name | Email Address | ICONFOR EMAIL(with a querystring id matching the row id) | ICON FOR MORE DETAILS (with a querystring id matching the row id)
I realise I am probably looking at this the wrong way but its difficult when you are almost on autopilot doing these things in classic ASP.
View 1 Replies
Feb 28, 2010
I have a Repeater and an update button inside the repeater
[Code]....
When I run this databound control to wire a javascript function it clears the viewstate and I don't get itemcommands. When I remove the button attributes command it works.
[Code]....
Obviously I can find a more creative way to add the javascript function, but this was the clearest way. Can anyone determine why adding an OnClientClick even in the ItemCreated would cause viewstate to fail?
View 4 Replies
Sep 30, 2010
I have a datagridview that has a column which displays a ref value from another unbound table, but during an edit of a gridview entry i want a dropdownlistbox to list all the available ref values from the other unbound table source, then to insert the selected value into the bound table
View 1 Replies
Feb 24, 2011
are below all 3 points the same?
1)<boundfield>
<asp:button ....>
</boundfield> [code].....
View 10 Replies
Feb 17, 2010
For example when using a gridview. When you specify the columns
BoundField for example won't work if you are binding it to a field instead of a property.
I guess this is so because when the gridview is looking for the DataField property it looks for a property and not a field. Now the question is how can i change this behavior to make it possible to use fields. I know i have to inherit from the gridview, but i don't know where to go from there.
View 2 Replies
May 21, 2010
i am developing a tree view component which should be data driven and amendable instead default layout provided by .net can we change that proper hierarchial structure like organization chart is there any chance to provide with an hyperlink to redirect other page or content view control below to display the content related to it.
i am trying to use silverlight with c#.
View 2 Replies
Dec 7, 2010
I want to render something like this (with ASP.Net Controls in the codebehind):
<ul>
<li class="first"><h1>This is a caption</h1></li>
<li><a href="#" title="" target="_self">Foo</a></li>
<li><a href="#" title="" target="_self">Foo1</a></li>
<li><a href="#" title="" target="_self">Foo2</a></li>
<li><a href="#" title="" target="_self">Foo3</a></li>
<li><a href="#" title="" target="_self">Foo4</a></li>
</ul>
<ul>
<li class="first"><h1>This is a another caption</h1></li>
<li><a href="#" title="" target="_self">Foo5</a></li>
<li><a href="#" title="" target="_self">Foo6</a></li>
<li><a href="#" title="" target="_self">Foo7</a></li>
<li><a href="#" title="" target="_self">Foo8</a></li>
<li><a href="#" title="" target="_self">Foo9</a></li>
<li><a href="#" title="" target="_self">Foo10</a></li>
<li><a href="#" title="" target="_self">Foo11</a></li>
</ul>
The amount of li elements that will be rendered into each ul is determined at runtime. Each link in a li belongs to into a specific ul (the one containing a specific caption. Imagine this as a kind of a treeview with nodes and subnodes) During the bind Event I need access to an ASP:HyperLink that will be rendered into the a-element. Which databound ASP.Net control should I pick for this? Looks like a repeater in a repeater, which should make the databinding process ugly. I'm thinking about creating this HTML-Output with StringWriters myself.
View 1 Replies
Jan 6, 2010
I have an AJAX tab container with 2 panels within aspx page. Each panel hosts an ascx control. Each control contains GridView and FormView that are databound - 1st control to the parent table and 2nd - to the child. The 2nd control/tab contains standard DropDownList that is bound to the parent values so the user can select a parent to create "child" for. everything works fine except when the parent (on the 1st tab control) is created/updates the ObjectDataSource on the 2nd tab does not getting refreshed. Only after refreshing the hole page I can see the new "parent" value in the ddl on "child" page. I use strongly typed dataset. How I can programmatically refresh the DataSource? Simple rebinding didn't make a dent. Do I need to refresh page, the tab container, tab panel?
<asp:Content
ID="Content1"
ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
[Code]....
View 1 Replies
Sep 8, 2010
I have a repeater I've databound with a generic arraylist from a LINQ query (.ToList() ) in the code behind.
I was using
<%# Bind("FirstName")%> but noticed
<%# Eval("FirstName")%> works just as well.
Is it better to use Eval or Bind? or does it depend on the situation?
View 3 Replies
Feb 24, 2011
I have DataList control and I want to assign to it's edititemtemplate some User Control. The problem is I can't find when I should databound UserControl to data, as my UserControl doesn't have static look (it renders different depending on some property values and datasource).
I was try to simply set my user control in edititemtemplate
<EditItemTemplate>
<uc:MyUserControl id="myUserControl1" runat="server" />
</EditItemTemplate>
and then bind it to data in ItemDataBound event handler, but it remains empty
if(e.Item.ItemType == ListItemType.EditItem)
{
var p = (Pair)DataBinder.GetPropertyValue(e.Item.DataItem, "Key");
((AnnouncementUserControl) e.Item.FindControl("userControl1")).RepeaterDataSource =
_templateWorker.ReturnTemplateByAnnouncementId(Convert.ToInt32(p.First), true);
}
how can I databound my control, or another approach which will make me avoid this problem?
View 2 Replies
Mar 22, 2010
I'm working on a website to showcase some of my bird photography, using ASP.NET 2.0 and C# with a SQLServerExpress backend.What I have right now is a ListBox bound to my database that displays a list of common names of birds and when the user clicks on an item in the listbox the main image on the page is changed to the image for that bird. For style reasons I want the listbox to always be a fixed size and because I specify the size (using CSS) a vertical scrollbar appears. My problem is that I want to provide my own images of arrows that go above and below the box such that when the user hovers over an arrow the box scrolls slowly and when the user clicks an arow the box scrolls quickly. Finally, my main problem is that I want to get rid of the ugly default vertical scrollbar that comes with ListBox.
Can you guys help me figure out how to do this? I don't mind using a different control other than ListBox as long as it is available in ASP.NET 2.0 and as long as it can be bound to my db. I also don't mind using JavaScript (which I'm sure I'll end up doing for the hover effects). Right now I'm fooling around with subclassing the ListBox control but I've never subclassed a control before so I'm somewhat clueless.
View 3 Replies
Mar 30, 2010
In my asp.net web page i have a dropdown box. Say like i have to bind EmployeeName to this dropdown box to show up as items.
I am using a dataTable to bind to this grid by having two columns in DataTable (EmployeeId and EmployeeName). But i am only binding the EmployeeName to the dropdown list box.
In the UI, after the user selects an Employee, I need to pass that employee's id to a function. Is there any way, i can directly pass the underlying data (EmployeeID in the DataTable attached to this dropdown), when the user selects the EmployeeName from the dropdown. Or i will have to make a roundtrip to the database and get the selected Employee's Id and then pass it to the function.
View 2 Replies
Mar 9, 2010
I have a big problem...I have made a page has a Data FormView controland the insert template of this Formview control has DropDownList to allow the user to choose section (SectionsDDList)..and there's also another DropDownList allow the user to choose a teacher (TeachersDDList)...more infothe SectionsDDList get the section list from SqlDataSource control which the "Select Command" of is:"SELECT section_id,section_id FROM sections"the TeachersDDList get the teachers list from another SqlDataSource control which the "Select Command" of is:"SELECT teacher_id,teacher_name FROM teachers WHERE (section_id = @section_id)"finallyI want the TeachersDDList to be filled with teachers according to the selected section from the SectionsDDList...So,I enable the Auto postBack function of the SectionsDDListand add the next code for the SectionsDDList_SelectedIndexChanged event:TeachersDataSource.SelectParameters["section_id"].DefaultValue = ((DropDownList)sender).SelectedValue;be aware that both of the SectionsDDList & TeachersDDList have been Bounding to a column...and the problem I have faced is that:Exception Details: System.InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.maybe you want to know the Stack Trace:[InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.]
System.Web.UI.Page.GetDataItem() +93
System.Web.UI.TemplateControl.Eval(String expression) +33
ASP.cpanel_managecourses_aspx.__DataBinding__control82(Object sender, EventArgs e) in
[code]...
View 8 Replies
Dec 1, 2010
Split off from http://forums.asp.net/t/1595139.aspx:
I have an additional column called 'KPI %' in my gridview that calculates the percentage of two template fields and thus I cannot use the sortexpression on it. How can I sort the contents of the 'KPI %' column in ASC or DESC format?
View 1 Replies
Jul 7, 2010
I have 2 amount columns (Amount and TotAmount) in my gridview. In Amount column data comes from database. I want to display the total of amounts in Amount column in my TotAmount column (So there would be just one value in TotAmount column irrespective of the number of columns in Amount column). How can I do this.
View 18 Replies
Mar 17, 2010
I want to create a user registration form, I used the CreateUserWizard control, and i intend to add more filed with the wizard interface, the fields were firstname,lastname, telephone all these with the textBox control and sex-male or female with a radioButton control, and upload photo with the FileUpload control.
After a successfull submit to the sql database, i should be able to retrieve all this informtion inluding the photo uploaded in another aspx page using any of the data control in y toolbox and resizein the photo to be 100/100 pixel size. pls could you write out the code (step by step details) to follow to implement all this in my asp.net 3.5 c# website. I have already created a table in my database, using userId as my ForeignKey.
View 1 Replies
May 25, 2010
Is there a way to Sort a Gridview by a Calculated Column? I have a gridview with template fields using lablels and a linq datasource. Those columns sort just fine. I can not get the Calculated column to sort, because there is no sort expression to use...
View 4 Replies
Sep 28, 2010
I have tried several different approaches .SOMEONE PLEASE sow me how to sort on template field with a calculated value.Basically i have half the data i need in the DB and the other half comes from textbox1.textI take the text in textbox1 and pass it along with a value from the DB (Orig) to a function that returns miles.
[Code]....
Whit the above method everything displays correctly but i cannot sort on that column .I also tried using the miles() function in my select statement for my datasource but that was a nightmare and couldn't get that to work i either got "undeclared function "miles()" or when i fixed that i got "orig" not declared.Sorry code is so jumbled , entire code is below:
[Code]....
View 15 Replies
