By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

datatable select

P: n/a
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("loginname='"+this.txLoginName.Text.ToU pper()+"'").Length>)
// Do Somthing

Sep 15 '08 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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

Plamen Ratchev
Sep 15 '08 #2

P: n/a

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

dt.CaseSensitive = false

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


Philipp Post
Sep 19 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.