DataView Sort Bug

[Mike Kline]

Hi All!

I've this strange DataView sort bug and i can't do any sorting
activities! Below is my code...

---VB.NET Code---

dvFinal = New DataView(objDat aSet.Tables(CON _FinalTable))

Dim strSort As String = drpOrderBy.Text & " " & drpOrderStyle.T ext
dvFinal.Sort = strSort

Response.Write( strSort)

---End VB.NET Code---

And I got the following error...

---Error Message---

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column ASC

---End Error Message---

I don't know why DataView is treating sort expression "ASC" as the
column name!!!

Please help!!!

Thank you all in advance!!!
MK

[Alvin Bruney [MVP]]

Have you eliminated the possibility that drpOrderBy.Text is empty?
So that what actually gets passed in is " ASC" instead of "columname ASC"

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
----------------------------------------------------------
"Mike Kline" <mk@nnnnnnnnnzz zzzzzzzzzzzzzzz zzzzz.zero> wrote in message
news:Ox******** ******@TK2MSFTN GP10.phx.gbl...

Hi All!

I've this strange DataView sort bug and i can't do any sorting activities!
Below is my code...

---VB.NET Code---

dvFinal = New DataView(objDat aSet.Tables(CON _FinalTable))

Dim strSort As String = drpOrderBy.Text & " " & drpOrderStyle.T ext
dvFinal.Sort = strSort

Response.Write( strSort)

---End VB.NET Code---

And I got the following error...

---Error Message---

Exception Details: System.IndexOut OfRangeExceptio n: Cannot find column ASC

---End Error Message---

I don't know why DataView is treating sort expression "ASC" as the column
name!!!

Please help!!!

Thank you all in advance!!!
MK

[Mike Kline]

Alvin Bruney [MVP] wrote:

Have you eliminated the possibility that drpOrderBy.Text is empty?
So that what actually gets passed in is " ASC" instead of "columname ASC"

Hi Alvin,

Thanks for the reply! Yes, I've eliminated that. You can see the
following code in my previous post...

Response.Write( strSort)

which indicates that I've been madly testing the value of strSort and
tried setting the dvFinal.Sort property again and again :)

Any other ideas?

Thank you!
MK

[Mike Kline]

Hi Norman,

Thanks for the reply.

I've tested for example...

dvFinal.Sort="C ustomerCount ASC" and it worked fine. Only when I do
through the variable.

Also drpOrderStyle is not a DropDownList, it is a Textbox. It was named
using drp* prefix because it WAS a DropDownList but now I'm using the
TextBox. I just continued to use the same name so I don't have to change
the code while I'm in the testing phase.

Furthermore, I'm not the only one experiecing this problem (or bug???),
for example...

http://groups.google.co.nz/groups?hl...%2522DESC%2522

The thing is that I can say Response.Write( strSort) and I can see the
"CustomerCo unt ASC" appearing on the ASPX page. So why doesn't DataView
is not accepting this? Why is it treating ASC or DESC commands as column
names ?!?!?!

Thank you!

MK

Norman Yuan wrote:

Why do you hard code the column name in your code to test if it is a "bug"
(very unlikely, I bet, though), like

dvFinal.Sort="T heColumn ASC" ''TheColumn is the column you know it is
there.

Just curious: are drpOrderBy and drpOrderStyle DropDownLists in
System.Web.UI.W ebControls namespace? The way you name them indicates they
are DropDownList, but DropDownList does not have property "Text". May it be
the cause of your problem?

"Mike Kline" <mk@nnnnnnnnnzz zzzzzzzzzzzzzzz zzzzz.zero> wrote in message
news:eH******** ******@TK2MSFTN GP15.phx.gbl...

Alvin Bruney [MVP] wrote:

Have you eliminated the possibility that drpOrderBy.Text is empty?
So that what actually gets passed in is " ASC" instead of "columname

ASC"

Hi Alvin,

Thanks for the reply! Yes, I've eliminated that. You can see the
following code in my previous post...

Response.Writ e(strSort)

which indicates that I've been madly testing the value of strSort and
tried setting the dvFinal.Sort property again and again :)

Any other ideas?

Thank you!
MK

[Norman Yuan]

Why do you hard code the column name in your code to test if it is a "bug"
(very unlikely, I bet, though), like

dvFinal.Sort="T heColumn ASC" ''TheColumn is the column you know it is
there.

Just curious: are drpOrderBy and drpOrderStyle DropDownLists in
System.Web.UI.W ebControls namespace? The way you name them indicates they
are DropDownList, but DropDownList does not have property "Text". May it be
the cause of your problem?

"Mike Kline" <mk@nnnnnnnnnzz zzzzzzzzzzzzzzz zzzzz.zero> wrote in message
news:eH******** ******@TK2MSFTN GP15.phx.gbl...

Alvin Bruney [MVP] wrote:

Have you eliminated the possibility that drpOrderBy.Text is empty?
So that what actually gets passed in is " ASC" instead of "columname ASC"

Hi Alvin,

Thanks for the reply! Yes, I've eliminated that. You can see the
following code in my previous post...

Response.Write( strSort)

which indicates that I've been madly testing the value of strSort and
tried setting the dvFinal.Sort property again and again :)

Any other ideas?

Thank you!
MK

[Mike Kline]

Problem solved. It was just my stupid coding error.

Thank you all for your time!!!

Cheers,
MK

Norman Yuan wrote:

Why do you hard code the column name in your code to test if it is a "bug"
(very unlikely, I bet, though), like

dvFinal.Sort="T heColumn ASC" ''TheColumn is the column you know it is
there.

Just curious: are drpOrderBy and drpOrderStyle DropDownLists in
System.Web.UI.W ebControls namespace? The way you name them indicates they
are DropDownList, but DropDownList does not have property "Text". May it be
the cause of your problem?

"Mike Kline" <mk@nnnnnnnnnzz zzzzzzzzzzzzzzz zzzzz.zero> wrote in message
news:eH******** ******@TK2MSFTN GP15.phx.gbl...

Alvin Bruney [MVP] wrote:

Have you eliminated the possibility that drpOrderBy.Text is empty?
So that what actually gets passed in is " ASC" instead of "columname

ASC"

Hi Alvin,

Thanks for the reply! Yes, I've eliminated that. You can see the
following code in my previous post...

Response.Writ e(strSort)

which indicates that I've been madly testing the value of strSort and
tried setting the dvFinal.Sort property again and again :)

Any other ideas?

Thank you!
MK