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 RepliesI'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.
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 RepliesI 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.
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 RepliesIs 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 Replieshow to create calculated column using boundfield in gridview?
i want to create a new column using the existing records?
how to create calculated column with gridview boundfield?
View 2 Repliesi am trying to combine two boundfields into one calculated column to display in Gridview like:
[code]....
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...?
I have a GridView, and I want Column1 to be equal to datatable data (filled by a SqlDataAdapter). Then I have two other fields by the SqlDataAdapter (first name, last name), and I want to have those two fields combined to form Column2. I have a TemplateField for my GridView that combines the first name and last name with Eval()'s, but the GridView places this combined field TemplateField and puts it as the first column.
How can I do this so that TemplateField can go in between fields that are databound?
I have seen a number of posts on this, but none that quite serve my needs. I have a GridView with template fields. I use postback because when a value is entered in one field a calculation is done to supply the value in another field. I simply loop through all the rows after each postback (there are not many so it is fast). I do not use a select command or button to select a row. After postback I do not know how to return the focus to the row that was being used. I can return the focus to the first row just by using gridview1.focus.
View 11 RepliesSplit 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?
Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
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]....
although i had to take the table that has my calculated column and make a view (so i could filter) and then bind the gridview to the view.
My question is as this.
1.) in order to get my calculated field i had to load my data into a table (as suggested)
2.)Add a column to the table and perform calculations
3.)make a dataview from the tables because i could not get the Gridview.datasource= ds.tables("loads").select("Deadhead <= " & sngRadius
4.)the largest of the 3 tables my query is based on contains about 7000 records. The way i have the logic & programming now everytime a new "truck location" is put in the textbox1 and "find loads/button1" is clicked. It calculates the deadhead miles of all 7000 records before filtering. I am filtering based on the deadhead miles.
Does anyone have any recomendation about how to speed this up a bit.
Also in order to get paging to work i had to rebind/filter the data again ... means looping through all 7000 records each time paging is called. This seems terribly ineffecient as i am already forced to use access instead of SQL.
Would i see a performance increase if i installed SQL or mySQL and create linked tables to the ones i use in access. or would access still be the bottleneck?
I don't know if the performance increase would be negligible as i still ultimately be getting the data from Access.
I have posted the entire code for the page below. When i originally started i didn't think there would be to much code so i left it all on one page instead of using code-behind. Would i gain anything by swapping to code-behind now?
[Code]....
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 Repliesare below all 3 points the same?
1)<boundfield>
<asp:button ....>
</boundfield> [code].....
I have a Gridview showing the data on one of my tables, and when I try to edit the data in one of the columns after I click update, rather than updating the record with the new value I typed in, the rows become null as in, everything in the row I just edited disappears. This inmediatly makes my application crash because one of the fields in my table (IssueDescription) doesn't allows null values.
This is the code, which is actually 100% auto-generated from when I created the GridView control and specified in the options to implement update, delete, edit options.
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="ticketNum"
DataSourceID="SqlDataSource1" [code].....
What is making the rows turn into null after the update? I did some research and tried to define the Update behaviour myself using RowUpdating function. After hours of learning how to use it I got it to "work", but because the Update turns everything to null when it updates, the sqlconnection command I use to do the query sends null anyways. I can paste the C# code if you'd like to see it, though I'd rather not use it if the auto-generated by asp above can be fixed instead.
I have a web page with an object data source that is connect to an object access layer which retrirevs an Id, Name_En and Name_Local from some table, the object data source is connected to a GirdView, In the girdview i have a template control with a label inside it, i want to change the binding expression for the label depending on the current states of localization so for example if the page is arabic the label should bind to "Name_Local", if it's english then it should bind to "Name_En"
View 1 RepliesI've got a gridiew with I've bound data to using a linq query as a datasource.The issue I have now is that I'm not sure how i can go about adjusting the appearance of the results in the fields.For example, if I want to turn the results in field 1 into a hyperlink (per record, e.g. record 1's hyperlink would point to url "x" and record's hyperlink 2 would point to url "y") which points to a location determined by a db query based on the record's value, how can I do that?And how would I go about adding columns that aren't present in the results, like a checkbox for each record?I suppose the stumbling block for me is that when using a linq query as a datasource, I am not presented with a layout of any kind in the aspx page, unless I use a linqtoSQL datasource (Which I would rather not use as I can't use complex queries with it....can I?
View 7 RepliesI have a gridview with a template field in it.How can i do paging in a gridview with template fields?
View 3 Repliesi want my gridview to be
1 - validate entries
2- check neccesary fields
before insertion or updation ?
I have a datatable with the following column names
ProviceID, ProvinceName, Year,
TPM, PM 10, PM 2.5, B(a)p
I'm trying to display data from this table in a gridview using template fields. Here's an example of a label in my item template
[Code]....
When i bind data to this grid view, i get an error saying column "PM 2" was not found. For some reason, the program is dropping the .5 from the column name. I am exploring the possibility of replacing the number with alphabets only but this may not be possible as the end user may not find it user friendly. Is there a way for me to get around this problem? I get a similar problem with B(a)p, it drops everything after the B. Any ideas on how to get the gridview to bind column names with special chars in it?
I am using gridview to display some columns with autogenerate column as 'true' and not added boundfields,headers.
And i am used stored preocedure for data source in gridview and i used dataset for gridview databind.
The gridview columns comes dynamically for each time.