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

Re: DataTable.Select by Miha

Miha
Wed Oct 26 16:37:35 CDT 2005

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" <Baren@discussions.microsoft.com> wrote in message
news:8E7FCC58-EE8C-43AD-A7EF-AB8872ECC53B@microsoft.com...
> 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



Re: DataTable.Select by Baren

Baren
Thu Oct 27 04:53:06 CDT 2005

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 [MVP C#]" wrote:

> 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" <Baren@discussions.microsoft.com> wrote in message
> news:8E7FCC58-EE8C-43AD-A7EF-AB8872ECC53B@microsoft.com...
> > 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
>
>
>

Re: DataTable.Select by Miha

Miha
Thu Oct 27 05:32:40 CDT 2005

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" <Baren@discussions.microsoft.com> wrote in message
news:CF2FD9AF-04CD-42B1-9FD4-A91DE7A72FEC@microsoft.com...
> 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 [MVP C#]" wrote:
>
>> 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" <Baren@discussions.microsoft.com> wrote in message
>> news:8E7FCC58-EE8C-43AD-A7EF-AB8872ECC53B@microsoft.com...
>> > 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
>>
>>
>>



Re: DataTable.Select by Baren

Baren
Thu Oct 27 07:30:03 CDT 2005

Its a Integer column

Baren

"Miha Markic [MVP C#]" wrote:

> 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" <Baren@discussions.microsoft.com> wrote in message
> news:CF2FD9AF-04CD-42B1-9FD4-A91DE7A72FEC@microsoft.com...
> > 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 [MVP C#]" wrote:
> >
> >> 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" <Baren@discussions.microsoft.com> wrote in message
> >> news:8E7FCC58-EE8C-43AD-A7EF-AB8872ECC53B@microsoft.com...
> >> > 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
> >>
> >>
> >>
>
>
>