Click here to Skip to main content
15,880,796 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi, please help me.

I have a task:
I need to show a list of the ordered details,some thing like this

Number of request| Author| Date| comment| Actions

1 Alvil Smith 29/09/2010 My first Order Delete/Modify

I have a web service, which call stored procedure and return this data(Number,Author,date,comment) in xml.

I want to show it in table on page,and when wee have a new request, to column actions adds a button to delete and modify

My webmethod:

C#
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Data;
using System.Web.Configuration;
using System.Xml;
 

namespace usingparameterwebservice
{
    /// <summary>
    /// Summary description for mywebservice
    /// </summary>
    [WebService(Namespace = "create_request")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
    // [System.Web.Script.Services.ScriptService]
    public class Service1 : System.Web.Services.WebService
    {
        string constring = WebConfigurationManager.ConnectionStrings["Name"].ToString();
        SqlConnection conn;
        SqlCommand comm;


[WebMethod(Description = "Просмотр всех заявок")]
        public XmlElement Selectall()
        {

            SqlConnection myConn = new SqlConnection(constring);
            SqlDataAdapter myData = new SqlDataAdapter("allreq", myConn);
            myData.SelectCommand.CommandType = CommandType.StoredProcedure;
                        DataSet ds = new DataSet();
            myData.Fill(ds);
            ds.Tables[0].TableName = "requests";
            XmlDataDocument xmldata = new XmlDataDocument(ds);
            XmlElement xmlElement = xmldata.DocumentElement;
            return xmlElement;
        }

      
    }
}


Then i add web reference, and how a cann call web service and add xslt..

Thanks
Posted

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900