DataTable.Select

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I am using the following code in my vb.net application.. its working fine on
windows 2000 professional and XP Professional, but its not giving me
appropriate result when running on a Windows 2003 Server.

Dim tblFileList As DataTable
Dim drCORows As DataRow()
Dim strExFileName As String

strExFileName = ConfigurationSettings.AppSettings("ExOthForm")
tblFileList = dsFileList.Tables(0)
strSort = "FormSequence ASC"
drCORows = tblFileList.Select("CopyTo='CO' AND FilePath NOT
IN (" + strExFileName + ")", strSort)

Please help

Thanks,
Baren
 
Hi!

The error is the sort order which i am specifying is not working.. its not
getting that data "strSort = "FormSequence ASC""

Thanks,
Baren

Miha Markic said:
What is the error?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Baren said:
Hi!

I am using the following code in my vb.net application.. its working fine
on
windows 2000 professional and XP Professional, but its not giving me
appropriate result when running on a Windows 2003 Server.

Dim tblFileList As DataTable
Dim drCORows As DataRow()
Dim strExFileName As String

strExFileName = ConfigurationSettings.AppSettings("ExOthForm")
tblFileList = dsFileList.Tables(0)
strSort = "FormSequence ASC"
drCORows = tblFileList.Select("CopyTo='CO' AND FilePath NOT
IN (" + strExFileName + ")", strSort)

Please help

Thanks,
Baren
Click to expand...
Click to expand...
 
So, you don't get any error, just the order is invalid?
What type is FormSequence column in datatable?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Baren said:
Hi!

The error is the sort order which i am specifying is not working.. its
not
getting that data "strSort = "FormSequence ASC""

Thanks,
Baren

Miha Markic said:
What is the error?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Baren said:
Hi!

I am using the following code in my vb.net application.. its working
fine
on
windows 2000 professional and XP Professional, but its not giving me
appropriate result when running on a Windows 2003 Server.

Dim tblFileList As DataTable
Dim drCORows As DataRow()
Dim strExFileName As String

strExFileName = ConfigurationSettings.AppSettings("ExOthForm")
tblFileList = dsFileList.Tables(0)
strSort = "FormSequence ASC"
drCORows = tblFileList.Select("CopyTo='CO' AND FilePath
NOT
IN (" + strExFileName + ")", strSort)

Please help

Thanks,
Baren
Click to expand...
Click to expand...
Click to expand...
 
Its a Integer column

Baren

Miha Markic said:
So, you don't get any error, just the order is invalid?
What type is FormSequence column in datatable?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Baren said:
Hi!

The error is the sort order which i am specifying is not working.. its
not
getting that data "strSort = "FormSequence ASC""

Thanks,
Baren

Miha Markic said:
What is the error?

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Hi!

I am using the following code in my vb.net application.. its working
fine
on
windows 2000 professional and XP Professional, but its not giving me
appropriate result when running on a Windows 2003 Server.

Dim tblFileList As DataTable
Dim drCORows As DataRow()
Dim strExFileName As String

strExFileName = ConfigurationSettings.AppSettings("ExOthForm")
tblFileList = dsFileList.Tables(0)
strSort = "FormSequence ASC"
drCORows = tblFileList.Select("CopyTo='CO' AND FilePath
NOT
IN (" + strExFileName + ")", strSort)

Please help

Thanks,
Baren
Click to expand...
Click to expand...
Click to expand...
 
Back
Top