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

[Plamen Ratchev]

Re: datatable select

If you mean to make the value of a column uppercase, then that is done
via the UPPER function, like UPPER(loginname ). However, unless you have
case sensitive collation, there is no need to do that to compare column
values.

--
Plamen Ratchev

http://www.SQLStudio.com

[Philipp Post]

Re: datatable select

Dave,

If you are facing casing issues with the DataTable.Selec t in .NET, you
should check that you have set

dt.CaseSensitiv e = false

what should be the default as far as I am aware.

brgds

Philipp Post