Find a spesific row in a dataview
-
hello : I am new to vb.net and I am trying to get a specific row in a data view based on a user choice of one of my app. combo boxs here is my code blocked_emp_view.Table = DataSet11.Tables("EMPLOYEE_BLOCKING") Dim EmPCriteria As String If Sender = 1 Then EmPCriteria = CType(ComboBox2.Items(ComboBox2.SelectedIndex), DataRowView).Row.ItemArray(0) Else EmPCriteria = CType(ComboBox2.Items(ComboBox3.SelectedIndex), DataRowView).Row.ItemArray(0) End If DataSet11.Tables("EMPLOYEE_BLOCKING").DefaultView.RowFilter = "EMP_NO =" & EmPCriteria blocked_emp_view.Sort = ("BLOCKING_DATE DESC") blocked_emp_view.RowFilter = "EMP_NO ='" & EmPCriteria & "'" I keep getting the same record each time although I change my selection any idea what is wrongthanks Dalia:(
-
hello : I am new to vb.net and I am trying to get a specific row in a data view based on a user choice of one of my app. combo boxs here is my code blocked_emp_view.Table = DataSet11.Tables("EMPLOYEE_BLOCKING") Dim EmPCriteria As String If Sender = 1 Then EmPCriteria = CType(ComboBox2.Items(ComboBox2.SelectedIndex), DataRowView).Row.ItemArray(0) Else EmPCriteria = CType(ComboBox2.Items(ComboBox3.SelectedIndex), DataRowView).Row.ItemArray(0) End If DataSet11.Tables("EMPLOYEE_BLOCKING").DefaultView.RowFilter = "EMP_NO =" & EmPCriteria blocked_emp_view.Sort = ("BLOCKING_DATE DESC") blocked_emp_view.RowFilter = "EMP_NO ='" & EmPCriteria & "'" I keep getting the same record each time although I change my selection any idea what is wrongthanks Dalia:(
please ask in the appropriate forum[^] The lounge is for non-programming banter, like Saddam vs. Bush, and Tippel vs. 7about9.
If you go to war, you will destroy a great country a stoned greek chick to the richest man of the world
[sighist] | [Agile Programming] [doxygen] -
hello : I am new to vb.net and I am trying to get a specific row in a data view based on a user choice of one of my app. combo boxs here is my code blocked_emp_view.Table = DataSet11.Tables("EMPLOYEE_BLOCKING") Dim EmPCriteria As String If Sender = 1 Then EmPCriteria = CType(ComboBox2.Items(ComboBox2.SelectedIndex), DataRowView).Row.ItemArray(0) Else EmPCriteria = CType(ComboBox2.Items(ComboBox3.SelectedIndex), DataRowView).Row.ItemArray(0) End If DataSet11.Tables("EMPLOYEE_BLOCKING").DefaultView.RowFilter = "EMP_NO =" & EmPCriteria blocked_emp_view.Sort = ("BLOCKING_DATE DESC") blocked_emp_view.RowFilter = "EMP_NO ='" & EmPCriteria & "'" I keep getting the same record each time although I change my selection any idea what is wrongthanks Dalia:(
-
OK sorry for the mistake but i am new here sorry again so do germans support Bush in his dream of destroying the world
Samer12 wrote: so do germans support Bush in his dream of destroying the world :cool: Oooh, good come back after a wrong forum posting. Well done. All is forgiven! :-D Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
-
OK sorry for the mistake but i am new here sorry again so do germans support Bush in his dream of destroying the world
-
Samer12 wrote: so do germans support Bush in his dream of destroying the world :cool: Oooh, good come back after a wrong forum posting. Well done. All is forgiven! :-D Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
wah, that beach looks nice (picture 2). Where is it? Jase :rose:
-
please ask in the appropriate forum[^] The lounge is for non-programming banter, like Saddam vs. Bush, and Tippel vs. 7about9.
If you go to war, you will destroy a great country a stoned greek chick to the richest man of the world
[sighist] | [Agile Programming] [doxygen]peterchen wrote: 7about9. I prefer 7ontopof9 ;) *sigh* I will never be able to look at Tippel or 7ontopof9 again seriously. Everytime I watch ST I will snigger and undermine their credibility.
Paul Watson
Bluegrass
Cape Town, South AfricaMacbeth muttered: I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er Want a job?
-
Samer12 wrote: so do germans support Bush in his dream of destroying the world :cool: Oooh, good come back after a wrong forum posting. Well done. All is forgiven! :-D Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
SimonS wrote: (latest pic 1) (latest pic 2) I hope you saved that whale Simon! :-D Nice photos, wouldn't mind being there right now. :)
Paul Watson
Bluegrass
Cape Town, South AfricaMacbeth muttered: I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er Want a job?
-
wah, that beach looks nice (picture 2). Where is it? Jase :rose:
Thanks, mate. :cool: It's Look Out Beach in Pletterberg Bay, South Africa. Here[^]'s a cool animated gif that shows you where that is. Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
-
SimonS wrote: (latest pic 1) (latest pic 2) I hope you saved that whale Simon! :-D Nice photos, wouldn't mind being there right now. :)
Paul Watson
Bluegrass
Cape Town, South AfricaMacbeth muttered: I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er Want a job?
Paul Watson wrote: I hope you saved that whale Simon It's all a bit ironic, because Plett was a whaling station-type village in the past. Paul Watson wrote: wouldn't mind being there right now damn straight. :cool: Horrific news, even worse than the impending 3rd world war: my camera's on the (serious) blink. It goes into camera hospital later this week. Hold thumbs. :wtf: Cheers, Simon Save the whale; harpoon a fat chick :~ animation mechanics in SVG (latest pic 1) (latest pic 2)
-
Thanks, mate. :cool: It's Look Out Beach in Pletterberg Bay, South Africa. Here[^]'s a cool animated gif that shows you where that is. Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
Top work. Looks good for safe surfing. I am about to move back home to Cornwall after my latest punishment duty at Sitel finishes. Hooray! The gif was cool. jase :rose:
-
peterchen wrote: 7about9. I prefer 7ontopof9 ;) *sigh* I will never be able to look at Tippel or 7ontopof9 again seriously. Everytime I watch ST I will snigger and undermine their credibility.
Paul Watson
Bluegrass
Cape Town, South AfricaMacbeth muttered: I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er Want a job?
I have no idea what you guys are talking about... I vaguely remember from my back-from-school-oh-look-star-trek-is-on days someone who used to in in the borg (?) called 7of9 (?) in that series with Janeway in it, but 7about9? 7ontopof9? 7cup9, Tippel? Sounds like the cast to a cheap pr0n flick (anyway shouldn't that be 6ontopof9? ;))
David Wulff
-
Paul Watson wrote: I hope you saved that whale Simon It's all a bit ironic, because Plett was a whaling station-type village in the past. Paul Watson wrote: wouldn't mind being there right now damn straight. :cool: Horrific news, even worse than the impending 3rd world war: my camera's on the (serious) blink. It goes into camera hospital later this week. Hold thumbs. :wtf: Cheers, Simon Save the whale; harpoon a fat chick :~ animation mechanics in SVG (latest pic 1) (latest pic 2)
Funnily enough, when I used to go surfing with my old mate Gavin, we'd be lieing there in the water, and he would shout 'Harpoon the fat whale' whilst throwing his surf board at me. Much fun, oh how we laughed! I wasn't even fat then. Jase :rose:
-
I have no idea what you guys are talking about... I vaguely remember from my back-from-school-oh-look-star-trek-is-on days someone who used to in in the borg (?) called 7of9 (?) in that series with Janeway in it, but 7about9? 7ontopof9? 7cup9, Tippel? Sounds like the cast to a cheap pr0n flick (anyway shouldn't that be 6ontopof9? ;))
David Wulff
They mean T'pol in the Enterprise, the latest spinoff. You can tell when they are thinking about her or Geri Ryan (7 of 9) by the excessive drool gathering on their keyboards X| Elaine The tigress is here :-D
-
I'm only a kitchen psychologist, not a dream reader ;)
If you go to war, you will destroy a great country a stoned greek chick to the richest man of the world
[sighist] | [Agile Programming] [doxygen]So, lie down on the couch and tell me more about the psychological problems kitchens suffer from ;P Elaine The tigress is here :-D
-
wah, that beach looks nice (picture 2). Where is it? Jase :rose:
I agree, but didn't know whales could leap that high ! The tigress is here :-D
-
They mean T'pol in the Enterprise, the latest spinoff. You can tell when they are thinking about her or Geri Ryan (7 of 9) by the excessive drool gathering on their keyboards X| Elaine The tigress is here :-D
Trollslayer wrote: They mean T'pol in the Enterprise, the latest spinoff Ah ha, well I've never seen that, I thought it was just another sexist name for 7 of 9. :-O Trollslayer wrote: You can tell when they are thinking about her or Geri Ryan (7 of 9) by the excessive drool gathering on their keyboards Men are sick. X| ;)
David Wulff
-
Samer12 wrote: so do germans support Bush in his dream of destroying the world :cool: Oooh, good come back after a wrong forum posting. Well done. All is forgiven! :-D Cheers, Simon "The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter. animation mechanics in SVG (latest pic 1) (latest pic 2)
SimonS wrote: Oooh, good come back after a wrong forum posting. My thoughts exactly. I think that deserves some kind of prize for getting out a of a sticky situation. In a way, I'm almost tempted to...redirect him to the soap box. :-D Quote from a clever bloke : "I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones." - Albert Einstein
-
OK sorry for the mistake but i am new here sorry again so do germans support Bush in his dream of destroying the world
Samer12 wrote: so do germans support Bush in his dream of destroying the world Please post questions like this is the soapbox : http://www.codeproject.com/script/comments/forums.asp?forumid=2605[^] :-D As Simon said, nice comback. Quote from a clever bloke : "I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones." - Albert Einstein
-
Trollslayer wrote: They mean T'pol in the Enterprise, the latest spinoff Ah ha, well I've never seen that, I thought it was just another sexist name for 7 of 9. :-O Trollslayer wrote: You can tell when they are thinking about her or Geri Ryan (7 of 9) by the excessive drool gathering on their keyboards Men are sick. X| ;)
David Wulff
David Wulff wrote: Men are sick. And they enjoy it :eek: The tigress is here :-D
