Not sure of the Method's exact syntax if you use the
Stringbuilder class: here is something I saved off of
this list for trailing commas:
s = s.TrimEnd( new char[] { ',' } );
If you are using SQL Server you can use
"RightTrim(LeftTrim(yourfield)) As WhateverName" in
your SQL code.
If you are using MS Access you can use
Trim(yourFieldName) As WhateverName in your SQL code.
Not sure about MySQL or Oracle.
--- imane elfechtani <[EMAIL PROTECTED]>
wrote:
>
> Thank you for your reply. I never used trip, do you
> know how I can use it?
>
> Thanks
>
> Imane
>
> Karen Kungowski <[EMAIL PROTECTED]> wrote:
> Could it be that your table stucture has fixed width
> fields and your display is correct? You could run
> your
> table results through Trim or something like that.
>
>
> --- imane elfechtani <[EMAIL PROTECTED]>
> wrote:
> >
> >
> > Hello,
> >
> > I am filling a dataset from a dataset from a table
> > in a database, When I get to see the dataset
> > displayed, I see the results separated by huge
> > spaces int he page. as if the page size is fixed
> and
> > what is not filled with results is filled with
> > spaces..I am using paging also..
> >
> > Thank you for your help. Please find below the
> > source code:
> >
> >
> > //DataBind the DataList
> >
> > MyDataList.DataSource =
> > ds.Tables["VM_PROPERTY"].DefaultView;
> >
> > MyDataList.DataBind();
> >
> > MyDataList.DataSource = ds;
> >
> > MyDataList.DataBind();
> >
> >
> >
> > //count the number of rows if the result search
> >
> > string strSql1= "SELECT ..............;
> >
> > ds1 =SqlHelper.ExecuteDataset(strConn,
> > CommandType.Text, strSql1);
> >
> >
> >
> > //get the number of results in the dataList
> >
> > foreach(DataTable rowCount in ds1.Tables)
> >
> > {
> >
> > counter= rowCount.Rows.Count.ToString();
> >
> > }
> >
> > Imane
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new resources
> site!
> >
> >
> > [Non-text portions of this message have been
> > removed]
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
> >
> >
> > [EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
> Yahoo! Groups SponsorADVERTISEMENT
>
>
> ---------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
> Yahoo! Groups Links
>
> http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
