Datasets from SQL data
-
I was wondering if there was something simpler to do When you create a dataset from reading in SQL database for string values you obtain a column with th full lenght of the SQL column, thus when you bind to a Textbox you do have spaces at the right end of the data. I can use RTRIM(data) in the SQL statetment of course but is there an easier way to trim I don't know about ? :confused:
-
I was wondering if there was something simpler to do When you create a dataset from reading in SQL database for string values you obtain a column with th full lenght of the SQL column, thus when you bind to a Textbox you do have spaces at the right end of the data. I can use RTRIM(data) in the SQL statetment of course but is there an easier way to trim I don't know about ? :confused:
Use nvarchar, then there's no padding.
Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert