467,915 Members | 1,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

datatable select

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
  • viewed: 4851
2 Replies
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

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.

Similar topics

4 posts views Thread by Kris Rudin | last post: by
reply views Thread by Chris Ericoli | last post: by
7 posts views Thread by wk6pack | last post: by
6 posts views Thread by Pete Wittig | last post: by
6 posts views Thread by fniles | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.