public static string xmlServiceType()
            {
                string path;
                path = Convert.ToString(HttpContext.Current.Server.MapPat h("~/App_Data/xml1.xml"));
                return path;
            }
           // convert string into xml
            public static string getReportBackUp(string MailID)
            {

                XmlDocument doc = new XmlDocument();
                doc.Load(xmlServiceType());
                XmlElement newElem = doc.CreateElement("Mail");
                XmlAttribute MailTo = doc.CreateAttribute("MailTo");
                MailTo.Value = MailID;

                newElem.Attributes.Append(MailTo);
                // doc.DocumentElement.AppendChild(newElem);

                doc.DocumentElement.AppendChild(newElem);
                string s = Convert.ToString(MailID);

                doc.Save(xmlServiceType());
                //string s = newElem.ToString();
                return s;

            }
 This code is in c# which convert String to XML & write it in xml file & database.
I am fired string from TextBox. But in XML file multiple Email ID come at single line
I want 1 Email ID at 1 Line next at next line if nos od Email ID is fired
plese send me code if any one know

my xml look like this
<Mail MailTo="[email protected],prafullaborade@rediff mail.com" />
  <Mail MailTo="[email protected],prafullaborade@rediff mail.com" />
  <Mail MailTo="[email protected],[email protected] om" />


i want it in this format

<Mail MailTO="[email protected]"/>
<<Mail MailTo="[email protected]" />

even if nos of Email ID is fired at a time from textbox

Well you'll need to split the MailID then and loop through the resulting strings, creating a new element for each one.

/- Sam Judson : Wrox Technical Editor -/

I am using COALESCE for search criteria my query is like this where
Report_Mailed_To is xml datatype

SELECT Report.tbl_Report_Info.ReportName,tbl_ReportSentDe tails.Report_ID, Report.tbl_Report_Info.ReportPath, Report.tbl_ReportSentDetails.Report_MailedBy,
                                Report.tbl_ReportSentDetails.Report_Mailed_Date FROM Report.tbl_Report_Info INNER JOIN
                                Report.tbl_ReportSentDetails ON Report.tbl_Report_Info.ReportID = Report.tbl_ReportSentDetails.Report_ID
                                where (ReportName LIKE COALESCE(null, ReportName))AND
                                (Report_Mailed_To LIKE COALESCE (null,Report_Mailed_To))




it gives me this error
Argument data type xml is invalid for argument 1 of like function.

pls tell me how to use COALESCE with xml datatype

I am using COALESCE for search criteria my query is like this where
Report_Mailed_To is xml datatype

SELECT Report.tbl_Report_Info.ReportName,tbl_ReportSentDe tails.Report_ID, Report.tbl_Report_Info.ReportPath, Report.tbl_ReportSentDetails.Report_MailedBy,
                               Report.tbl_ReportSentDetails.Report_Mailed_Date FROM Report.tbl_Report_Info INNER JOIN
                               Report.tbl_ReportSentDetails ON Report.tbl_Report_Info.ReportID = Report.tbl_ReportSentDetails.Report_ID
                               where (ReportName LIKE COALESCE(null, ReportName))AND
                               (Report_Mailed_To LIKE COALESCE (null,Report_Mailed_To))




it gives me this error
Argument data type xml is invalid for argument 1 of like function.

pls tell me how to use COALESCE with xml datatype

COALESCE returns the first non-null value passed in, so COALESCE(null, X) will simply return X. Therefore your WHERE statement reads:

which makes no sense.

Also, the LIKE docs state that match expression (i.e. the argument before the like) must be a expression of character type. XML is not a character type.

http://msdn.microsoft.com/en-us/library/ms179859.aspx

/- Sam Judson : Wrox Technical Editor -/

Please - this goes for everyone - if you are asking questions on this forum that are about products rather than about the XML standards, then tell us what products you are using. I can tell this is asking about a relational database with XML extensions, but there are lots of those around.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

I am using COALESCE for search criteria my query is like this where
Report_Mailed_To is xml datatype

SELECT Report.tbl_Report_Info.ReportName,tbl_ReportSentDe tails.Report_ID, Report.tbl_Report_Info.ReportPath, Report.tbl_ReportSentDetails.Report_MailedBy,
                               Report.tbl_ReportSentDetails.Report_Mailed_Date FROM Report.tbl_Report_Info INNER JOIN
                               Report.tbl_ReportSentDetails ON Report.tbl_Report_Info.ReportID = Report.tbl_ReportSentDetails.Report_ID
                               where (ReportName LIKE COALESCE(null, ReportName))AND
                               (Report_Mailed_To LIKE COALESCE (null,Report_Mailed_To))




it gives me this error
Argument data type xml is invalid for argument 1 of like function.

pls tell me how to use COALESCE with xml datatype

here we are searching nos of entry from database. Mailed to is 1 search criteria from three then it is shown in datagrid

You've just repeated the previous post with no new information.

Please read both mine and Michael's posts again more thoroughly before responding.

/- Sam Judson : Wrox Technical Editor -/