Return DataTable From Webservice

Question

0.00/5 (No votes)

See more:

i am returning datatable from the webservice in my code . while doing R&D , i just return the dataset from the webservice but now its giving the error invalid xml .Please review the code and guide me how to solve more ...here is my code :

C#

 [WebMethod]
   public DataSet GetAllExhibitionList()
   {

       DALSearch objdal = new DALSearch();

       return objdal.GetAllExhibitionDetail();
   }


public DataSet GetAllExhibitionDetail()
       {

           try
           {
               SqlCommand cmd = new SqlCommand();
               cmd.CommandText = "proc_getAllExhibitionList";
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.Connection = con;
               SqlDataAdapter da = new SqlDataAdapter(cmd);

               da.Fill(dtexhibitiondetail1);
           }
           catch (Exception ex)
           {
               throw ex;
           }
           finally
           {

           }
           return dtexhibitiondetail1;
       }

JavaScript

<script type="text/javascript">
    $(function () {
        debugger;
        $.ajax({
      
            type: 'post',
            url: 'WebServices/DataLoading.asmx/GetAllExhibitionList',
            data: {},
            contentType: 'application:JSON;charset:UTF-8',
            success: OnSuccess,
            failure: function (response) {
                alert(response.d);
            },
            error: function (response) {
                alert(response.d);
            }

        });


    });
    function OnSuccess(response) {
        $("[id*=dlallexhibitation]").attr("border", "1");
        var xmlDoc = $.parseXML(response.d);
        alert(xmlDoc);
        var xml = $(xmlDoc);
        var customers = xml.find("Table");
        var row = $("[id*=dlallexhibitation] tr:last-child").clone(true);
        $("[id*=dlallexhibitation] tr:last-child").remove();
        $.each(customers, function () {
            var customer = $(this);
            $("#lblMsg", row).html($(this).find("#lblMsg").text());
            $(".mainRow", row).attr('indusid');
            $(".mainRow", row).attr('cid');
            $(".mainRow", row).attr('coid');
            $(".mainRow", row).attr('mid');
            $(".mainRow", row).attr('yid');
            $(".in_venues_des2_mn", row).find('.in_ven_hd2 a').html($(this).find(".in_ven_hd2").text());
            $(".in_venues_des2_mn", row).find('.sub_in_venues_des2_mn').text();
            $(".dates", row).find('.sub_dates').text();
            $(".dates", row).find('.filter_dates').text();
            $(".in_venues_des3", row).text();
            $(".img_thumb2", row).find('img').attr('src');
            $('.in_venues_des6').text();
            $('in_ven_navs2').find('.in_ven_more').find('a').attr('href');
            $('in_ven_navs2').find('.in_ven_more').find('a').attr('exhibitionid');
            $('in_ven_navs2').find('.in_nav3').attr('exhibitionid');           
            $('in_ven_navs2').find('.in_nav3').find('a').attr('href');
            $("[id*=dlallexhibitation]").append(row);
            row = $("[id*=dlallexhibitation] tr:last-child").clone(true);
        });
    }

</script>

Posted 4-May-14 21:08pm

Naina2

Updated 4-May-14 23:41pm

King Fisher

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

win75 · Answer 1 · 2014-05-04T21:22:00

translate you backed code to json:

StringBuilder JsonString = new StringBuilder();
            //Exception Handling        
            if (dt != null && dt.Rows.Count > 0)
            {
                JsonString.Append("{ ");
                JsonString.Append("\"T_blog\":[ ");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    JsonString.Append("{ ");
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        if (j < dt.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\",");
                        }
                        else if (j == dt.Columns.Count - 1)
                        {
                            JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + "\"" + dt.Rows[i][j].ToString() + "\"");
                        }
                    }
                    /**//**/
                    /**//*end Of String*/
                    if (i == dt.Rows.Count - 1)
                    {
                        JsonString.Append("} ");
                    }
                    else
                    {
                        JsonString.Append("}, ");
                    }
                }
                JsonString.Append("]}");
                return JsonString.ToString();
            }
            else
            {
                return null;
            }

DamithSL · Answer 2 · 2014-05-04T21:22:00

Solution 1

you can return string of DataSet XML

C#

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Xml)]
public DataSet GetAllExhibitionList()
{
    DALSearch objdal = new DALSearch();
    return objdal.GetAllExhibitionDetail().GetXml();         
}

JavaScript

<script type="text/javascript">
$(function () {
    debugger;

    $.ajax({
        type: 'post',
        url: 'WebServices/DataLoading.asmx/GetAllExhibitionList',
        data: {},
        contentType: 'application:JSON;charset:UTF-8',
        success: OnSuccess,
        failure: function (response) {
            alert(response.d);
        },
        error: function (response) {
            alert(response.d);
        }
    });

});
function OnSuccess(response) {
    $(response).find('Table').each(function () {
      alert($(this).find("Column1").text());
    });
}
</script>

Posted 4-May-14 21:22pm

DamithSL

Updated 4-May-14 23:09pm

v4

Comments

Naina2 5-May-14 3:37am

DamithSL : it is showing error like this :

uncaught exception: Invalid XML: undefined

Naina2 5-May-14 4:37am

now it is not showing error but the result is not showing also.. it is not displaying anything

DamithSL 5-May-14 5:06am

what are the column names in the table?

Naina2 5-May-14 5:11am

basically there is a procedure , i m using for retrieving the data ..and there are joins in the same .. so what would be the benefit of having column names

DamithSL 5-May-14 5:15am

you are searching for #lblMsg in datatable records, that's why I'm asking. if you have column called lblMsg, then you can get value like alert($(this).find("lblMsg").text());

Naina2 5-May-14 5:19am

no its not a column

DamithSL 5-May-14 5:30am

invalid xml error is fixed, you may have other issues in your application. please open another question if you have trouble.

Naina2 5-May-14 5:46am

my xml string is showing the data .. but in a very weird manner ...it is showing like this :

<string xmlns="http://tempuri.org/"><NewDataSet>
<Table>
<rank1>1</rank1>
<edate>2013-09-22T00:00:00+05:30</edate>
<exhibition_name>BBC Symphony Orchestra</exhibition_name>
<country>United Kingdom</country>
<exhibition_image_path>888.jpg</exhibition_image_path>
<smonth>9,9,</smonth>
<syear>2013,2013,</syear>
<coid>1</coid>
<cityid>1</cityid>
<city>London</city>
<exhibitionid>888</exhibitionid>
<exhibition_desc><span style="font-family: Arial, Verdana; font-size: small;">BBC Symphony Orchestra is central to English musical culture. And BBC brings you Symphony Orchestra performance, where highly talented players will play for the audience. Join the multitude of crowd joining this big event at Barbican. Follow the schedule to find out who will be performing when. Barbican is committed to bringing you the best of this genre in sheer passion. It will host 20th century to contemporary music on various dates, by different performers. Learn about the last 80 years of orchestra’s history, and see how it has grown ever since that time. You can book a stay with one of the <a href="http://www.exhibitioncentrehotels.com/hotel-booking/hotels-near-barbican-centre.aspx">hotels near Barbican Centre in London</a>, and easily walk down to the venue. Exhibitioncentrehotels has a collection of accommodations available to suit any requirement.</span></exhibition_desc>
<industryid>17</industryid>
<country_id>1</country_id>
<industry_name>Entertainment</industry_name>
<industry_page_name>industry/entertainment.aspx</industry_page_name>
<venue_id>7</venue_id>
<page_name>exhibitions/bbc-symphony-orchestra.aspx</page_name>
<venue_name>Barbican Centre</venue_name>
<exhibition_dates>22-Sep-2013 to 25-May-2014,22-Sep-2013 to 25-May-2014</exhibition_dates>
</Table>
<Table>
<rank1>1</rank1>
<edate>2014-02-13T00:00:00+05:30</edate>
<exhibition_name>United Visual Artists: Momentum</exhibition_name>
<country>United Kingdom</country>
<exhibition_image_path>1455.jpg</exhibition_image_path>
<smonth>2,</smonth>
<syear>2014,</syear>
<coid>1</coid>
<cityid>1</cityid>
<city>London</city>
<exhibitionid>1455</exhibitionid>
<exhibition_desc><font face="Arial, Verdana" size="2">United Visual Artists presents Momentum, a brand new sound and light installation at Barbican Centre in London. Explore some unique designs and sculptures made with changing pattern of light &amp; sound along with a series of pendulum forms. Experience the change whilst moving through the gallery at your own pace. These changing compositions will represent an internal model of space, movement and mass. If reaching from distant countries and regions, secure a stay with one of the <a href="http://www.exhibitioncentrehotels.com/hotel-booking/hotels-near-barbican-centre.aspx">finest accommodations near Barbican Centre</a>. Select from a wide array of lodging options available in vicinity of United Visual Artists.</exhibition_desc>
<industryid>41</industryid>
<country_id>1</country_id>
<industry_name>Telecommunications</industry_name>
<industry_page_name>industry/telecommunications.aspx</industry_page_name>
<venue_id>7</venue_id>
<page_name>exhibiti

DamithSL 5-May-14 5:55am

that's fine, try something like alert($(this).find("exhibition_name").text()); you can check each exhibition_name in return values

Naina2 5-May-14 5:59am

but exhibition name is a column name and you are alerting the same ....is it rite?

DamithSL 5-May-14 6:03am

I'm alerting the content of exhibition_name element. find("exhibition_name") will return the element and .text() will get the element value. haven't you try yourself?

Naina2 5-May-14 6:05am

as u can see my code i have done the same , the values i m getting but its having some layout problem there.. thts y not showing anythng