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:
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
{
[WebService(Namespace = "create_request")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
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