DataTable Select

[DaveL]

how to uppercase a table columen in datatable select
//dt is a Datatable
i Need to uppercase control.text and table column data
i dont know how to set loginname to upper case
if (dt.Select("log inname='"+this. txLoginName.Tex t.ToUpper()+"'" ).Length>)
{
// Do Somthing
}

DaveL

[rustylee]

On Sep 15, 11:21*am, "DaveL" <dvs_...@sbcglo bal.netwrote:

how to uppercase a table columen in datatable select
//dt is a Datatable
i Need to uppercase control.text and table column data
i dont know how to set loginname to upper case
if (dt.Select("log inname='"+this. txLoginName.Tex t.ToUpper()+"'" ).Length>)
{
* * // Do Somthing

}

DaveL

The Select method returns an array of DataRows. It won't work in your
'if' statement.

-Rusty

[DaveL]

it works just fine in my if statement
I Reference the Returned array length at the end of the if

example works just fine

if (dtRows.Select( "Name <>'"+txName.Tex t.Trim().ToUppe r()+"'").Length >
0)
{
Console.WriteLi ne("Found");
}
else
{
Console.WriteLi ne("Not Found");
}
Console.ReadKey ();
I still dont know how to upperCase the Name Column in the Select
DaveL


"rustylee" <ru************ @gmail.comwrote in message
news:bb******** *************** ***********@b30 g2000prf.google groups.com...
On Sep 15, 11:21 am, "DaveL" <dvs_...@sbcglo bal.netwrote:

how to uppercase a table columen in datatable select
//dt is a Datatable
i Need to uppercase control.text and table column data
i dont know how to set loginname to upper case
if (dt.Select("log inname='"+this. txLoginName.Tex t.ToUpper()+"'" ).Length>)
{
// Do Somthing

}

DaveL

The Select method returns an array of DataRows. It won't work in your
'if' statement.

-Rusty

[rustylee]

On Sep 15, 12:10*pm, "DaveL" <dvs_...@sbcglo bal.netwrote:

it works just fine in my if statement
I Reference the Returned array length at the end of the if

example works just fine

* * if (dtRows.Select( "Name <>'"+txName.Tex t.Trim().ToUppe r()+"'").Length >
0)
* * * * * * {
* * * * * * * * Console.WriteLi ne("Found");
* * * * * * }
* * * * * * else
* * * * * * {
* * * * * * * * Console.WriteLi ne("Not Found");
* * * * * * }
* * * * * * Console.ReadKey ();

I still dont know how to upperCase the Name Column in the Select
DaveL

"rustylee" <rusty.lee.2... @gmail.comwrote in message

news:bb******** *************** ***********@b30 g2000prf.google groups.com...
On Sep 15, 11:21 am, "DaveL" <dvs_...@sbcglo bal.netwrote:

how to uppercase a table columen in datatable select
//dt is a Datatable
i Need to uppercase control.text and table column data
i dont know how to set loginname to upper case
if (dt.Select("log inname='"+this. txLoginName.Tex t.ToUpper()+"'" ).Length>)
{
// Do Somthing

}

DaveL

The Select method returns an array of DataRows. *It won't work in your
'if' statement.

-Rusty

Sorry, somehow the formattting on my display tricked my eyes. Please
accept my humble apologies.

I will assume you are querying against a database. Would it be
possible to construct the query in your code to perform the
"uppercasin g" in the query:

string commandText = "SELECT UPPER(Name)...F ROM..."

-Rusty

[DaveL]

Thats what i'll have to do, if i can't figure out how to
uppercase the column in the Datatable object

Making a trip back to the database is prob a better idea

Thanks
DaveL
Ps. No worries , i see stuff not there or there all the time
thanks again

"rustylee" <ru************ @gmail.comwrote in message
news:64******** *************** ***********@i20 g2000prf.google groups.com...
On Sep 15, 12:10 pm, "DaveL" <dvs_...@sbcglo bal.netwrote:

it works just fine in my if statement
I Reference the Returned array length at the end of the if

example works just fine

if (dtRows.Select( "Name <>'"+txName.Tex t.Trim().ToUppe r()+"'").Length >
0)
{
Console.WriteLi ne("Found");
}
else
{
Console.WriteLi ne("Not Found");
}
Console.ReadKey ();

I still dont know how to upperCase the Name Column in the Select
DaveL

"rustylee" <rusty.lee.2... @gmail.comwrote in message

news:bb******** *************** ***********@b30 g2000prf.google groups.com...
On Sep 15, 11:21 am, "DaveL" <dvs_...@sbcglo bal.netwrote:

how to uppercase a table columen in datatable select
//dt is a Datatable
i Need to uppercase control.text and table column data
i dont know how to set loginname to upper case
if
(dt.Select("log inname='"+this. txLoginName.Tex t.ToUpper()+"'" ).Length>)
{
// Do Somthing

}

DaveL

The Select method returns an array of DataRows. It won't work in your
'if' statement.

-Rusty

Sorry, somehow the formattting on my display tricked my eyes. Please
accept my humble apologies.

I will assume you are querying against a database. Would it be
possible to construct the query in your code to perform the
"uppercasin g" in the query:

string commandText = "SELECT UPPER(Name)...F ROM..."

-Rusty