none
Problem put xml output in tableadapter RRS feed

  • Question

  • Hello,

    i got a little problem. I made a store procedure and this sp just got an xml output and i want to put that output in a column of my table adapter.

    i create a table adapter and i m able to collect like 1/10 of the xml output. Why i cannot get the entire output ?

    ok i already check the data type of my column in table adapter and it s  a string,
    and the length is 1073741823 so it's long enought

    So how can i get the entire output and why i can get it but only like 1/10 of the entire output

    thx a lot

    David
    • Moved by Chris Robinson- MSFT Monday, June 15, 2009 8:50 PM Moving to Providers as this seems to be a stored procedure issue (From:ADO.NET DataSet)
    Monday, June 15, 2009 8:38 PM

All replies

  • Could you post a code example?   In general the XML type in SQL is unlimited in length you can in theory send a really huge XML response (> 4GB even).

    Tuesday, June 16, 2009 6:01 AM
    Moderator
  • Yes here is when i fill the ds

    public
    merlin.fondation.Reports.EventsType GetEventTypeReport(string p_eventTypeID, string p_contactID, string p_locationID,  string p_languageID, DateTime p_startDate, DateTime p_endDate)
    {
    merlin.fondation.Reports.
    EventsType ds = new merlin.fondation.Reports.EventsType();
    ds.EnforceConstraints =
    false;

     

    using (SqlConnection dbConn = utils.dbConn)
    {
    merlin.fondation.Reports.EventsTypeTableAdapters.
    GetEventReportTableAdapter tab = new merlin.fondation.Reports.EventsTypeTableAdapters.GetEventReportTableAdapter();
    tab.Connection = dbConn;
    tab.FillEventsType(ds.GetEventReport,
       new Guid(p_eventTypeID)/*eventTypeID*/,
       new Guid(p_contactID)/*contactID*/,
       new Guid(p_locationID)/*locationID*/,
       new Guid(p_languageID)/*languageID*/,
       p_startDate
    /*startDate*/,
       p_endDate
    /*endDate*/);
    }

     

    return ds;
    }

    and that's the output that i got from the dataset

      <row eventTypeID="ECDE3F57-2405-466C-A8BA-A1257445B9C1" nbEventTypes="1" description="Communication avec le détecteur a échoué." />

    and that's the entire output

    <NewDataSet>
      <row eventID="5E830CFD-085D-4FDF-8771-FBD6823CD493" alertID="EBB87F6C-2609-CC62-15BA-A1F9A8E6A7AD"      
       type
    ="Communication avec le détecteur a échoué." description="No packet from transmitter." startDate="2009-06-15
        23:00:00
    " endDate="2009-06-15 23:00:00" createdBy="TMS Pro Store" objectID="E3FFBC79-9CF1-42BA-A339-
        EDCA2F90562C
    " objectSourceID="00000000-0000-0000-0000-000000000002" eventTypeID="ECDE3F57-2405-466C-A8BA
        A1257445B9C1
    " /> 
    </NewDataSet>


     

    Tuesday, June 16, 2009 1:11 PM