Sending text format email using SmtpMail

Discussion in 'ASP .Net' started by =?Utf-8?B?amFrdWIuYmF1ZXI=?=, Sep 14, 2005.

  1. Hi,

    I have a table with in MS SQL database. A table consist a list of items
    bought by a customer with, item prices, item nubers etc. I would like to send
    an email with a list of items in the order in a text format file (not html
    format using BodyFormat = MailFormat.Html). I am using stored procedure to
    get data to a datagrid on a web page. But do not know how to format a result
    from a stored procedure to a text string.

    Somebody can help me?
     
    =?Utf-8?B?amFrdWIuYmF1ZXI=?=, Sep 14, 2005
    #1
    1. Advertising

  2. use a repeater perhaps, or just loop through the returning DS and manually
    write out the values (for i=0 to DS.Tables(0).Rows.Count)

    --
    Curt Christianson
    site: http://www.darkfalz.com
    blog: http://blog.darkfalz.com



    "jakub.bauer" wrote:

    > Hi,
    >
    > I have a table with in MS SQL database. A table consist a list of items
    > bought by a customer with, item prices, item nubers etc. I would like to send
    > an email with a list of items in the order in a text format file (not html
    > format using BodyFormat = MailFormat.Html). I am using stored procedure to
    > get data to a datagrid on a web page. But do not know how to format a result
    > from a stored procedure to a text string.
    >
    > Somebody can help me?
     
    =?Utf-8?B?Q3VydF9DIFtNVlBd?=, Sep 14, 2005
    #2
    1. Advertising

  3. Thanks a lot. It almost works :) >> should be DS.Tables(0).Rows.Count - 1

    I appreciate your help!

    Jakub Bauer


    "Curt_C [MVP]" wrote:

    > use a repeater perhaps, or just loop through the returning DS and manually
    > write out the values (for i=0 to DS.Tables(0).Rows.Count)
    >
    > --
    > Curt Christianson
    > site: http://www.darkfalz.com
    > blog: http://blog.darkfalz.com
    >
    >
    >
    > "jakub.bauer" wrote:
    >
    > > Hi,
    > >
    > > I have a table with in MS SQL database. A table consist a list of items
    > > bought by a customer with, item prices, item nubers etc. I would like to send
    > > an email with a list of items in the order in a text format file (not html
    > > format using BodyFormat = MailFormat.Html). I am using stored procedure to
    > > get data to a datagrid on a web page. But do not know how to format a result
    > > from a stored procedure to a text string.
    > >
    > > Somebody can help me?
     
    =?Utf-8?B?amFrdWIuYmF1ZXI=?=, Sep 14, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Stewart
    Replies:
    0
    Views:
    444
    Stewart
    Dec 5, 2003
  2. Robert Pettersson
    Replies:
    6
    Views:
    859
    Robert Pettersson
    Sep 15, 2004
  3. Bazza Formez
    Replies:
    1
    Views:
    366
    Jason Brown [MSFT]
    Jan 28, 2005
  4. supz
    Replies:
    14
    Views:
    820
    =?Utf-8?B?U2hhaGlk?=
    Mar 1, 2006
  5. rote
    Replies:
    8
    Views:
    796
Loading...

Share This Page