How can I get a value from a cell in the gridview for further calculation.I have a gridview with the following fieldsRecord ID, user ID, and worked hours.now I want to use the UserID shown in the gridview to query the cost per hour for the specified user in the gridview.I want to use this value in the code behind file, any tips on how to accomplish this? I use Linq2SQL.
View 4 RepliesI want to hyperlink from a field in one gridview to a field in another gridview based on id. I've tried many ways but haven't seen success.
View 20 RepliesI have 2 fields in my gridview one called ScriptType the other BagNo, when a user click the edit button, I would like the BagNo filed to be disabled if the ScriptType field is = "TTA" and enabled otherwise. How can I do this?..something along these lines see below..I am using VB..
[code]...
I have a grid view, and I add new column as a hyper link field, I want the navigationURL for this field to be Pageexample.aspx?ID=other field value like this
[code]...
is that possible ?
I have a gridView where i have to show the follow the following details
InvoiceNo InvDate PendingSince InvAmt
Inv1 01/01/2010 (Current Date - InvDate) 12000
Inv2 15/01/2010 (Current Date - InvDate) 20000
Can anyone tell me how do we get the highlighted field in a GridView. The other 3 fields are bounded fields. also tell me whether the highlighted field is a bounded or template filed.
I have a Gridview with ID "GVSeasonsOfResort" which has selectable rows.
One of the fields in that gridview is RSLinkID which is an ID field of the table from which ths SQLDataSource driving the gridview gets its data.
I have a textbox outside the gridview with ID TxtBxRSLinkID and when I select a row of the Gridview, I want to assign the value of the RSLinkID field of the selected row to the TxtBxRSLinkID.
[code]....
i am implementing a update query module.i am displaying all fields from a table for a term searched. well now i am implementing update option for the record which are displayed, i have like 70 columns in my table, and i want to know how to restrict some selected fields to be only read only while the form can be updated ?Like if user select to update a record then some selected field such as "Timestamp, UID etc some selected fields" remains READ ONLY !
View 1 RepliesI have a gridview that is dynamically created based off a csv file I'm importing.
Since I don't know what the column names are ahead of time, I can't pre format the gridview and use the "findcontrol" method to get the text value of the labels that are populated b/c I don't know the column names.
I know I can get the row index like this by iterating through the gridview...
[Code]....
but I'm not sure how to get the text value of the first column label? Not sure of the syntax?
I have the following grid on an asp page:
[Code]....
how to hide a field in a grid view which has been databound by code in the code behind file.
View 7 RepliesIs it possible to make it so that a particular field in my gridview is made mandatory based on a session variable and the value of a dropdwnlist located outside of the grid itself...so
If Session("location") = "HOME" and DropDownList3.SelectedValue = ("5") then
"fieldinmygridview" cannot be null (i.e is required)
end if
I have loaded up a gridview object with data. I have turned on Edit on the grid. It lets me edit the data, but I also want to put some code to check for correct data in each field. I tried to assign a requiredfieldvalitor, comparevaliditor but they don't work. Is there an event I can capture to fire up some code before the grid sves my data?
View 3 RepliesI have two tables
Employee Table : ( EmployeeID,EmployeeName,... Etc )
Bonus Table : ( BonusID,EmployeeID,BonusDate,Bonus Reason,... Etc )
I wanted to list the bonuses in a gridview, so i made a query to return list of bonus records and my data access object returns the result set as Bonus business object ( generic collections of bonus BO ). i have bind my gridview with the bonus collection.
now my problem is that collection has the property "EmployeeID" and it will be displayed but instead of showing EmployeeID, i wanted to show Employee Name in that grid. I have a gridview where i want to list the bonus records ( bonus ID, bonus date, bonus description, employee ID) ,
I want to delete data using boung field value inside grid view, I am doing this...but it is not finding bound field value
[code]....
I just wrote something small up with a GridView databound to the products table of the northwind database to play around with the control. I added a template field and put a checkbox in it, ProductID, ProductName, and UnitCost. I can successfully loop through the GridView and find the rows that have the checkbox checked, and can get ProductName for each row, but keep erroring out on ProductID and UnitCost. It's probably something small, but I just cannot figure it out.Here is what I have so far:
[Code]....
My code behind, where I handle a button click event to get all values in rows w/ selected checkboxes:
[Code]....
Can I not use row.Cells[i]? The only thing Intellisense gives me that makes any sense is 'rows.Cells[i].Text'... not sure what else to do.
my gridview binds to a datatable and i added a template field to the columns the template field contains a link button. i bind the command argument of this link button to a field from my data table. on the row command event i allow the user to activate his product according to a condition. what i want is how to add a javascript alert if the condition doesn't match. in other words i can't call the hyperlink in the templatefield in order to add a javascript to its OnClientClick attribute.
View 8 RepliesI have a gridview based on a sqldatasource that has some colums from which two colums showing the data of two fields: field1 and field2. field1 is an ID which should not be updated and therefore it is readonly=true. The sql-query from the sqldatasource is:
SelectCommand="SELECT field1, field2 from anyView"
What I want is, that when a row is updated, then the value from field1 should be copied to field2 The update-query is:
UpdateCommand="UPDATE myTable SET field2=@field2 WHERE field1=@field1"
My idea was, that the @field2 paramter gets the value from the query string out of field1:
<UpdateParameters>
<asp:QueryStringParameter Name="field2" QueryStringField="field1" Type="Int32" />
</UpdateParameters>
But this does not work. Is there an easy way to copy the data from field1 to field2 when updating the row? In addition, is this possible, even if field2 ist not shown in the gridview (i.e. field2 is selected in the query but is not a field in the gridview but should be updated with value of field1).
I have a Gridview with a hyperlink field. The hyperlink will open a pdf file from a folder in the root of the web if there is a corresponding file. My problem is that there may or may not be a corresponding file and if there isn't a file then a browser window opens up and the contents of the folder are displayed. This folder will be maintenanced from day to day adding and removing files. coding something that will either disable the hyperlink were there is no corresponding data or just pop up a message that there is no corresponding data to view.
View 7 Replies I have a gridview which I have databinded via the quick config facility, but I need to databind one column to a completely different sql table data field - how do I do this?
If I go into Gridview tasks and select the column and edit the data binding parameter but what is the format for a table outside the source definition for the the rest of the gridview?
I have seen several Web Sites that use GridViews that have lookup fields with different Value and Text Fields (as in drop down lists) but I can't seem to figure it out how to display the Text Field in the Item Template when the Text Field is not in the datasource. .
Here's what I have. I have a Gridview whose datasource is a Linq to SQL Invoice table, e.g.
InvoiceID
CustomerID
InvoiceNumber
THe Customer table is related to the Invoice Table thru the CustomerID. The relationship is defined in SQL Server and is displayed in the DBML.
I have created a template field for the CustomerID field in the Gridview. I would like to display the CustomerName when the Item Template is displayed and a DropDownList in the Edit Template. The DropDownList works great, but I cannot seem to figure out how to display the CustomerName in then Item Template.
I seem to remember seeing in some video that you can simply drag the CustomerName into the CustomerID Item Template Field. But I can't seem to find the customerName field. The DataSource includes the Customer Table because of the relationship, but no fields are displayed.
I suspect this is real simple, but I cannot seem to find an article or video that explains how to do this.
I've got a Gridview which has a datasource to a particular database.
I've got a DetailsView which has a datasource to a table in another database.
when I select a Gridview row, I need to populate a field in the DetailsView with the Primary Key field (showing in the Gridview) from the Gridview.
Can this be done (if so, how?)?
Also (but not as important) :
If there's no field related in the second table, I'd like it to come up in Insert Mode - if there is a field related, I need it to come up in Edit mode
I have a Timer and a GridView who pulls info from the database every X seconds.Every time I query the database the field 'Comments' is replaced with whatever is on the database (since it's bound to it). I'd like to keep my previous value and keep adding into my Label the subsequent values queried from the database.
For instance, first time I query I get a value of "1" in the Gridview. Now someone changes the database row and next time I query it I have a value of "2". Well, I would like to concatenate the last value queried with the previous one and so on.
So at this point the GridView should show "1" and "2". Here is the piece of code I am talking about:
<asp:TemplateField HeaderText="Comments" SortExpression="Comments">
<ItemTemplate>
<asp:Label ID="lblComments" runat="server" Text='<%# Bind("Comments") %>' />
</ItemTemplate>
</asp:TemplateField>
How do I achieve this goal?
i am using the required field validation and Reqularexpressioncontrol in gridview. Fields are in the gridview are in template, but only the edit button it is not templeted, this edit buton is of type Imagebutton and same goes with canel and update.
1_ Do i have to use the Templeted fields for edit/cancel/ and update as well in order to use the validation?
2_Validaiotn should only work when user clicks on the Update button, it should not trigger when cancel button fired.
I have added a Command Field in a Gridview Dynamically. And I have added the OnClick Attribute in the
RowDataBound event
[code]...
and ProceedAction() function have confirmation message. When i click the Delete button, the confirmation message is shown. But the Row Command is not fired (even if i click Ok/ cancel in the confirmation message).
I have analysised Little bit. If i have '\' or '{, }' or '*' in the javascript function, the behavior is improper (as i said above). If i remove it, it is working fine.
Since i need to ask two confirmation, i need to put '{, }' in my javascript. So how can i resolve the above issue.
I have a gridview populated by the code below:
[Code]....
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" ?
[Code]....