Click here to Skip to main content
15,914,010 members
Home / Discussions / C#
   

C#

 
AnswerRe: String and forms Pin
Bigdeak19-Jun-10 2:30
Bigdeak19-Jun-10 2:30 
AnswerRe: String and forms Pin
DaveyM6919-Jun-10 5:53
professionalDaveyM6919-Jun-10 5:53 
AnswerRe: String and forms Pin
meilixueshan20-Jun-10 19:18
meilixueshan20-Jun-10 19:18 
GeneralRe: String and forms Pin
SRJ9221-Jun-10 12:51
SRJ9221-Jun-10 12:51 
QuestionControl Horizontal Scrollbar of DataGridView Pin
M Nasir Uddin19-Jun-10 1:01
M Nasir Uddin19-Jun-10 1:01 
AnswerRe: Control Horizontal Scrollbar of DataGridView Pin
Luc Pattyn19-Jun-10 1:16
sitebuilderLuc Pattyn19-Jun-10 1:16 
QuestionTrim Column value access Interbase Pin
P.T.R.K19-Jun-10 0:53
P.T.R.K19-Jun-10 0:53 
AnswerRe: Trim Column value access Interbase Pin
I Believe In GOD19-Jun-10 10:01
I Believe In GOD19-Jun-10 10:01 
Strange the SQL TRIM would not work

How ever , I will give you another solution , with code :
MyDataTable = New DataTable ();
SqlConnect con = new SqlConnection ("connection string goes here ") ;
SqlDataAdapter SqlDa = new SqlDataAdapter ("SELECT * FROM myTable", conn);
SqlDa.Fill(myDataTable);

foreach ( DataRow dr in MyDataTable.Rows)
{
     dr["ColumnName"] = dr["ColumnName"].toString().Trim();
}



Hope This Help ,



------------ Rose | [Rose] Please Increase the hit's of my website by 1 :Rose | [Rose] -----------
www.smart-arab.com
I know nothing , I know nothing ...

GeneralRe: Trim Column value access Interbase Pin
P.T.R.K19-Jun-10 11:51
P.T.R.K19-Jun-10 11:51 
GeneralRe: Trim Column value access Interbase Pin
I Believe In GOD19-Jun-10 12:24
I Believe In GOD19-Jun-10 12:24 
GeneralRe: Trim Column value access Interbase Pin
P.T.R.K20-Jun-10 18:21
P.T.R.K20-Jun-10 18:21 
GeneralRe: Trim Column value access Interbase Pin
P.T.R.K20-Jun-10 19:04
P.T.R.K20-Jun-10 19:04 
GeneralRe: Trim Column value access Interbase Pin
P.T.R.K20-Jun-10 19:19
P.T.R.K20-Jun-10 19:19 
QuestionSplitting HTML pages as Metafile without text break using MSHTML in C# [modified] Pin
Parthi2788718-Jun-10 21:33
Parthi2788718-Jun-10 21:33 
AnswerRe: Splitting HTML pages as Metafile without text break using MSHTML in C# Pin
Garth J Lancaster18-Jun-10 21:52
professionalGarth J Lancaster18-Jun-10 21:52 
QuestionDisable login prompt for crystal reports Pin
sudheesh kumar s18-Jun-10 18:56
sudheesh kumar s18-Jun-10 18:56 
AnswerRe: Disable login prompt for crystal reports Pin
Dave Kreskowiak19-Jun-10 5:13
mveDave Kreskowiak19-Jun-10 5:13 
QuestionAccessing class properties using foreach or any iteration method Pin
venugopalachary18-Jun-10 17:26
venugopalachary18-Jun-10 17:26 
AnswerRe: Accessing class properties using foreach or any iteration method Pin
Berlus18-Jun-10 18:15
Berlus18-Jun-10 18:15 
AnswerRe: Accessing class properties using foreach or any iteration method Pin
Luc Pattyn19-Jun-10 0:33
sitebuilderLuc Pattyn19-Jun-10 0:33 
AnswerRe: Accessing class properties using foreach or any iteration method Pin
MrWhiteboard22-Jun-10 14:23
MrWhiteboard22-Jun-10 14:23 
QuestionCreat a slideshow program Pin
kienhv_8718-Jun-10 15:48
kienhv_8718-Jun-10 15:48 
AnswerRe: Creat a slideshow program Pin
Roger Wright18-Jun-10 16:00
professionalRoger Wright18-Jun-10 16:00 
AnswerRe: Creat a slideshow program Pin
Richard Andrew x6418-Jun-10 16:17
professionalRichard Andrew x6418-Jun-10 16:17 
AnswerRe: Creat a slideshow program Pin
Luc Pattyn18-Jun-10 16:55
sitebuilderLuc Pattyn18-Jun-10 16:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.