datatable select
This is a discussion on datatable select within the SQL Server forums, part of the Microsoft SQL Server category; --> how to uppercase a table columen in datatable select //dt is a Datatable i Need to uppercase control.text and ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
09-16-2008, 12:13 PM
| ||||
| ||||
 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 } DaveL      |
|
09-16-2008, 12:13 PM
| |||
| |||
| 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 |
 |
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trying to set Column width for datatable(h:dataTable) usingcolumnclassess | rathaiah.jammula@hhsc.state.tx.us | Websphere Portal Server | 0 | 06-06-2008 08:19 AM |
| Sorting in <hx:datatable> in JSF Portlets | sruthi | Websphere Portal Server | 0 | 06-06-2008 07:45 AM |
| Re: jsf datatable row selection | yurykats | Websphere Portal Server | 4 | 06-06-2008 06:40 AM |
| jsf datatable row selection | Websphere Portal Server | 4 | 06-06-2008 06:40 AM | |
| Stored Procedures on SQL 2000 compared to dotnet's Datatable.select | nandan | SQL Server | 3 | 02-29-2008 04:48 AM |
All times are GMT. The time now is 05:08 PM.
