如何将数据集值传递给Mail.Body [英] How to pass dataset value to Mail.Body

问题描述

朋友，

我正在尝试发送邮件.我在其中输入密码的地方是一个查询示例从Rakesh中选择产品名称然后在我的数据集中ds = new Datset();
Ds Conatin我的输出.直到没有问题为止.

现在告诉我，如果Mail.Body = ds是否将作为收件箱中的输出，我将使用System.Dataset.
我选择了Wriiteen格式的输出.就像在我的文章中，它应该具有我从从Rakesh选择产品名称 .. plz help中获取的值.

Hi Friends ,

I am Trying to Send mail .Where What i Dod is Passwd a Query Example Select PRoduct name From Rakesh Then In My data set ds= new Datset();
Ds Conatin my Output . Til tere no iSsue .

Now Tell me if Mail.Body=ds if i will do As output in my inbox I am getting Using System.Dataset.
I neeed the Output in a Wriiteen Format . Like In my mAil it should have the value i have fetched from Select PRoduct name From Rakesh..plz help .

推荐答案

嘿，Rakesh，

数据集支持一种称为writexml的方法.

Hey Rakesh,

Dataset supports a method called writexml.

StringWriter sw = new StringWriter();
ds.WriteXml(sw);
string result = sw.ToString();

现在，您可以根据需要的数据定义XSL.

您可以使用以下方法使用xsl将xml转换为html:

Now you can define a XSL the way you want data.

You can use the following method to transform xml to html using xsl:

public static string TransformXMLToHTML(string inputXml, string xsltString)
{
    XslCompiledTransform transform = new XslCompiledTransform();
    using(XmlReader reader = XmlReader.Create(new StringReader(xsltString))) {
        transform.Load(reader);
    }
    StringWriter results = new StringWriter();
    using(XmlReader reader = XmlReader.Create(new StringReader(inputXml))) {
        transform.Transform(reader, null, results);
    }
    return results.ToString();
}

希望这个引用对您有帮助: http://msdn.microsoft.com/zh-CN -us/library/8fd7xytc(v = vs.100).aspx [

May this ref help you: http://msdn.microsoft.com/en-us/library/8fd7xytc(v=vs.100).aspx[^]

Thanks,

Kuthuparakkal

你好rakesh，

您正在尝试将数据集结果分配给邮件正文，
但是邮件正文仅接受字符串值，因此您必须以字符串形式获取结果，然后将其分配给邮件正文，

可能会起作用..

hello rakesh,

you are trying to assign the data set result to mail body,
but mail body accepts only the string values, so you have to fetch the result in a string, and then assign to mail body,

may be it will work..

这篇关于如何将数据集值传递给Mail.Body的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！