I have the DataKey value, I want to use that to get the GridViewRow and retrieve information from various columns - I see lots on information on how to get the datakey from a gridview row, but not the reverse.
My head aches from beating it against the wall for so long. I have a gridview that is populated from a code behind table. The gridview has 3 bound lables, a checkbox (unbound) and another label (unbound). All fields are in template fields. I have coded a vb sub with one command: beep. It fires perfectly every time a user checks the gridview ckeckbox. Here are the columns of the gridview:
1. Player - bound label
2. Description- bound label
3. Amount- bound label
4. ToPay - ckeckbox
5. AmountToPay - unbound label
When a gridviewrow's checkbox is checked (or unchecked) the code determines the check status. If it is checked then the AmountToPay label is to display the same value of the third label (Amount) or it will clear it's text value if the checkbox is unchecking the box. Here is my code:
The gridview:
[Code]....
Here is the vb code that does beep():
[Code]....
I have tried about a dozen ways of reading the checked property of the checkbox but nothing works (sender, e, gridview, rows, items, cells, findcontrol, adnauseum). I want to work the code like this somehow:
If row.Checkbox.checkproperty=true then set lblToBePaid.Text = the lblAmount.Text Else lblToBePaid.Text = "" EndIf
I would like that ID of subcontrol generated from the GridViewRow (NamingContainer) be named including database unique ID.
Exemple :
Suppose in the first colum of my GridView I have a Label displaying the name of an item fetch from a database table.
SQL Database table definition
SQLTable
- UniqueID - Name
In this table I have the following records
- 1956 Hello - 3013 World - ... ...
Suppose I have a GridView having a label (id="lbName") in the first column template.
Now I'm binding GridView using this query : SELECT UniqueID, Name FROM SQLTable
After binding, the HTML result will be :
myGridView_ctl101_lbName
But I would like that NamingContainer names sub items like this :
myGridView_ctl1956_lbName
So I have tried in the RowDataBound event of the GridView : e.Row.NamingContainer.ID = (DataRowView)e.Row.DataItem)["UniqueID"].ToString()At first look it output exactly what I need but after that I can't get working Edit mode, it seem to break DataKeys or something else.
Is there an easier way to erase the data from all controls in a gridviewrow than my current approach (code below)?
The problem: When a new type of control is added to the grid, like a radiobutton, it would not get handled here without adding to the code. The tests for type of control can get long and monotonous.
The solution I am seeking: Test the control once for "is WebControl". If it is a web control, cast it and call a single command that would erase its data. Does such a concept exist in ASP.NET 2.0/C#? I know I can do other things on the WebControl level, like set backcolor, but would like to do the same for erasing data.
I tried translating this from vb but getting the error on e.Row.DataItem("CustomerID").ToString i tried varios things but no gooddbSrc.SelectCommand = "SELECT * FROM Orders WHERE CustomerID = '" + e.Row.DataItem("CustomerID").ToString + "' ORDER BY OrderDate";
Which is pretty much eaxactly what I was after! . I have been trying to alter the edit functionality instead of actually having to click on an edit button the user can click anywhere on a selected row to bring up the edit popup window. I have been trying to figure this out for a couple of days and cannot find a way to get it going.
I've got a gridview with a few textboxes in each row which I want to insert into a database, after a user clicks a submit button (thats outside of the gridview)
This is my code for the gridview
[Code]....
And this is my code for the button
[Code]....
But when I click the button it gives me this error
"Multiple controls with the same ID 'Label12' were found. FindControl requires that controls have unique IDs."
How do I give the controls unique IDs if they are in a gridview and the rows are database driven?
I am using a datalist to display data from a database.Except for 1 column all the other column values are getting repeated so I am hiding all the other column values when the datalist repeats itself.However, the unique column value is not getting rendered properly because there are many line breaks in between.I am not using any web control to display the static text and I am not sure if that would help.I just want to improve the final display so that the datalist looks consistent.I am attaching my code.
using vb.net/asp.net 2005 and SQL Server 2005.I had similar issue yesterday: I created a unique index on a table to prevent duplicates when user tries to edit existing records in a gridview.This works fine and I am seeing the "cannot insert duplicate key row message...." however I need to catch the exception because I do not want to display the table and column names.I have this set up but its not catching the exception, the exception is displaying but not my version, does anyone know in what gridview event and how I can catch and customize this exception? what i have now (but not working ) is:
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
I currently designed a school result portal. If the students want to view their result, they input their student school number in a text box to search out their result. But this is not secured because anybody can look up any students result if you have the number which is even written on their school uniform for identification.
I have being trying to secure this result by trying to generate or code special numbers that the students will input with their school number. The special numbers will be random numbers and may be from 10 and above, it might even contain letters. How do I code this. I believe this is the best asp.net forum. I want the students to be inputing this special unique numbers and their student numbers so that there result will be avaliable to them.