I know its very annoying and hard to get the data out of the data controls (gridview in this case), but there are other things you can do to make it easier.
Visible = True Catch ex As Exception Track Projects. Close() End Using Hi Lite Rows() End Sub Private Sub Hi Lite Rows() 'THE FOLLOWING CODE THAT INDICATES SPECIFIC COLUMN NUMBERS IS DETERMINED 'BY THE HTML ASPX CODE THAT DETERMINES HOW THE GRIDVIEW LOOKS Dim i Col Date As Integer = 7, i Row As Integer, i Col Proj Stat As Integer = 9 ' Msg Box(Track Projects.
To String) ' & vb Cr Lf & vb Cr Lf 'Val(CDate(Track Projects.
There must be something fundamentally wrong that some of us are doing that is causing this and the fact that it's not happening to others, and they don't know the solution. this only works when the databind happends after the updating. My suggestion to you would be to either subclass gridview, and expose the Extract Row Values though a public method or stick everything you need in Data Keynames. Extract Values From Cell(dict Values, dcfc Cell, gv Row. Row State, True) End If Next control Dim return Values = New Dictionary (Of String, Object )() For Each de As Dictionary Entry In values return Values(CStr(de. Value Next de Return return Values End Function I appreciate your quick and prompt reply, which I looked at from home last night, but was not able to test it until just now, and really the only different was adding the Try Cast. You're trying to extract the values from the edit row right?
It'd be great if you could provide some sample code here. I am using the Row Updating event to programmatically update my database, but the new values are already gone by the time the Row Updating event is fired. I have found several forum postings detailing this but no one has posted their solution. Another way to get values out of the gridview is to put the interesting fields in Data Key Names, which can be a very ugly solution because the viewstate grows as a result of this.
Append("SELECT Project ID, Pcb Pn, Pcb Pn Rev, Change Number, Design Names, ECADdesigner Names, Pwb Engineer Names, Pwb Request Date, ECADstart Date, Due Date, Project Status, Job Charge Number, Percent Complete, Completion Date, Actual Start Date, Schematic Number, Schem Num Revision, Schem Ready Date, Layer Count, PCBtechnology, Stack Up, Thickness, Lead Free, Requester Comments, Product Manager") str SQL. Append(" WHERE" & str Params & " ORDER BY Due Date ASC") 'This is a subtitute for Private Sub Populate Publishers Grid View() from example code 'found at View Sorting Dim str My Conn As String = Configuration Manager.
Selected Value Case 8 str Params = "(" & str Params & ") AND ((" & _ "(Right(Completion Date,4) '2005'))" & _ "OR (Completion Date is NULL))" Case 7 str Params = "(" & str Params & ") AND (Right(Completion Date,4) = '2007')" Case 6 str Params = "(" & str Params & ") AND (Right(Completion Date,4) = '2006')" Case 5 str Params = "(" & str Params & ") AND (Right(Completion Date,4) = '2005')" End Select str SQL.
Eureka, and phoooey....yeah, that was the problem, but now I have to solve another problem.
I have a whole host of filters that do not work now since they rely on the auto postback feature in check boxes and drop down lists that I have. To String(), "ecylkows") = 1 Then i Col = i Chx 1 Track Projects.
Find Control("lbl Project Status"), Label) Try If In Str(lbl Text.
Then there are a couple more steps to make it to where you adding the selected value in the update) Yes, you are correct, I am not using any datasources for the gridview, but in the Itemtemplate and the Edit Item Template the Text parameter is set equal to a bind statement as follows (see the example further down where i ref a datasource for the ddl): Or in the case of the drop down list I am binding with the Selected Value parameter, but of course you can see I lied and am pointing to a different datasource completely for my list.
Auto Generate Edit Button = True Then i Col Date = 8 i Col Proj Stat = 10 End If Dim lbl Text As Label For i Row = 0 To Track Projects.