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
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.
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 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'm trying to use the DetailsView to make Updates. The problem is that it can't handle empty fields even though the underlying table field allows nulls.
I get a message like this if I change the "State" field to blank when doing an update
The parameterized query '(@Cust_ID int,@Cust_DL nvarchar(7),@DL_State nvarchar(2),@Last_N' expects the parameter '@State', which was not supplied.I'm using an object data source control which is calling the EditCustomer method in my Customer Class. I'm not sure how to fix this.
[Code]....
I found code [URL] that allows multiple-row inserts, and tried to convert it to vb.net. I can't get the blank grid with 5 rows to show up -- for some reason the datasource won't bind.
[Code]....
Code gridview:
[Code]....
I am having problem with calculated columns in the following code
[Code]....
orderDT is the DataTable. When "Extra" column has nothing (I am NOT using Default), "Total" comes out to be blank? "Price" will have a value (always) "Extra" may not have any value
i hav a gridview ... now i need to add certain number of rows... say 5 rows .... which would b blank .. the rows consist of itemtemplate of textboxes.. here is the grid ...
[Code]....
now i am binding this gridview with certain data say :
[Code]....
now the problem is if the row contains 2 data originally ... then it alwz shows up with only two rows with binded data... but what i want is 2 (databinded rows ) + 5 (empty rows with textbox ) = 7 grid view rows .... now how to do it ... after i hav binded the textbox with data already....with some empty columns corresponding to the above code ?
While uploading excelsheet to datatable and bind it to gridview it will check blank data in excel sheet and when it will bind to gridview,the row in which blank present that row will be in red background color and the other row will occur in normal back color.
View 1 RepliesI have created DetailsView in designer page with SqlDataSource, Details view is with autoGenerateRows="false" i.e. I have declared my own fields. it is fine there, but what if I want to add these fields dynamically from codebehind with select & edit commands. I want to to use Details View in designer page and want to add fields from codebehind
View 1 RepliesIn my asp.net+vb web in a gridview i am using this code to change font colour...
If e.Row.DataItem("OutDetails") Is System.DBNull.Value <> True Then
e.Row.ForeColor = Drawing.Color.Green
End If
Can i count and display in a label whose OutDetails are not blank...
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI've been using the FilterExpression for the building of my GridView. I've built with this ability before, normally for searching for the name of an individual. However, the new project I'm working on has a small problem. I'm using an AND statement to filter the name via textbox and I'm also checking if the form was completely finished and if the form is reviewed via radio buttons.
Below is the code, but the problem is this. If any of the fields are blank (text field is left blank or the "both" is selected from the radio buttons) the form doesn't process my filter.
Is there an easy way to apply all three filters in a mix and match fashion (like no name, completed, not reviewed or any combination thereof)?
[Code]....
I have a GridView (BulkEditGridView), that has 10 rows from the datasource. I Add a TemplateField "Insert Row" button to insert 1 blank row at selected row using Rows.AddAt.First time i press "Insert Row", it works as expected, the row inserted at selected row. now i press another "Insert Row", the row is inserted, however the row (in first time inserted) now move to the last row. and so on.
View 7 RepliesI am exporting ASP.net filed values to Ms-Word using following code without any hurdels .I have around 70 fileds on my webform, all the fields are not filed with values some are blank.when i am taking the print out blank fields should not get printed.How can i modify following code.
[Code]....
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?
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 RepliesI 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]....
When I Login the page using username and password and then click the logout button and after again click Login button without entering username and password it will be login,I want to show error
View 1 RepliesHow can i stop of adding blank emply rows on my table, every time i click on the button to add row on one table of sqlserver?
View 7 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'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
