App_Code/Servece1.cs
using
System;
using
System.Web;
using
System.Web.Services;
using
System.Web.Services.Protocols;
using
System.Xml;
using
System.Configuration;
using
System.Data;
using
System.Data.OleDb;
[WebService(Namespace
= "http://tempuri.org/")]
[WebServiceBinding(ConformsTo
= WsiProfiles.None)]
public
class Service :
System.Web.Services.WebService
{
ConnClass conn = new
ConnClass(); //
connction class
public Service () {
}
[WebMethod]
public XmlElement
GetUserDetails(string userName)
{
string con = conn.GetConnection();
// connection method
OleDbConnection connect =
new OleDbConnection(con);
string qry = "select
* from AuthorDetails where AuthName like '"+userName+"%'";
OleDbCommand cmd = new
OleDbCommand(qry, connect);
connect.Open();
OleDbDataAdapter sda =
new OleDbDataAdapter(cmd);
DataSet ds = new
DataSet();
sda.Fill(ds);
XmlDataDocument xmldata =
new XmlDataDocument(ds);
XmlElement xmlElement = xmldata.DocumentElement;
return xmlElement;
}
[WebMethod(MessageName
= "You Have Greeting")]
public XmlElement
GetUserDetails(string AutherName,
string BookName
{
string con = conn.GetConnection();
OleDbConnection connect =
new OleDbConnection(con);
string qry = "select
* from AuthorDetails where AuthNam\
e like'" + AutherName +
"%' and BookTitle like '" + BookName +
"%'";
OleDbCommand cmd = new
OleDbCommand(qry, connect);
OleDbDataAdapter oda =
new OleDbDataAdapter(cmd);
DataSet ds = new
DataSet();
oda.Fill(ds);
XmlDataDocument xdoc =
new XmlDataDocument(ds);
XmlElement XmlElem = xdoc.DocumentElement;
return XmlElem;
}
}
Calling the Web Service into my UI Application
Default.aspx
<%@
Page Language="C#"
AutoEventWireup="true"
CodeFile="Default.aspx.cs"
Inherits="_Default"
%>
<!DOCTYPE
html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml"
>
<head
runat="server">
<title>Untitled
Page</title>
</head>
<body>
<form
id="form1"
runat="server">
<div>
<asp:TextBox
ID="txtUserName"
runat="server"></asp:TextBox>
<asp:Button
ID="btnSubmit"
runat="server"
Text="Button"
OnClick="btnSubmit_Click1"
/>
</div>
<asp:GridView
ID="gvUserDetails"
runat="server">
</asp:GridView>
</form>
</body>
</html>
Default.aspx.cs
using
System;
using
System.Data;
using
System.Configuration;
sing
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
System.Data.OleDb;
using
System.Xml;
public
partial class
_Default : System.Web.UI.Page
{
protected void
Page_Load(object sender,
EventArgs e)
{
if(!IsPostBack)
{
}
}
protected void
btnSubmit_Click1(object sender,
EventArgs e)
{
BindUserDetails();
}
private void
BindUserDetails()
{
string UName = txtUserName.Text; //Textbox to
read the values
localhost.Service objService =
new localhost.Service();
//webservice
aliase name with object
DataSet ds = new
DataSet();
XmlElement elem =
objService.GetUserDetails(UName);
if (elem != null)
{
XmlNodeReader nodereader =
new XmlNodeReader(elem);
ds.ReadXml(nodereader, XmlReadMode.Auto);
gvUserDetails.DataSource = ds;
gvUserDetails.DataBind();
}
else
{
gvUserDetails.DataSource = null;
gvUserDetails.DataBind();
}
}
}
Default2.aspx
<%@
Page Language="C#"
AutoEventWireup="true"
CodeFile="Default2.aspx.cs"
Inherits="Default2"
%>
<!DOCTYPE
html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html
xmlns="http://www.w3.org/1999/xhtml"
>
<head
runat="server">
<title>Untitled
Page</title>
</head>
<body>
<form
id="form1"
runat="server">
<asp:Label
ID="Label1"
runat="server"
Text="Author Name"></asp:Label>
<asp:TextBox
ID="TextBox1"
runat="server"></asp:TextBox>
<br
/>
<asp:Label
ID="Label2"
runat="server"
Text="Book Name"></asp:Label>
<asp:TextBox
ID="TextBox2"
runat="server"></asp:TextBox>
<br
/>
<asp:Button
ID="Button1"
runat="server"
Text="Search"
OnClick="Button1_Click"
/>
<div>
</div>
</form>
</body>
</html>
Default2.aspx.cs
using
System;
using
System.Data;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
System.Xml;
using
System.Data.OleDb;
public
partial class
Default2 : System.Web.UI.Page
{
protected void
Page_Load(object sender,
EventArgs e)
{
}
protected
void Button1_Click(object
sender, EventArgs e)
{
findAuthBookDeta();
}
private void
findAuthBookDeta()
{
string AName = TextBox1.Text;
//read the value from textbox for I/P
string BName = TextBox2.Text;
localhost.Service objService =
new localhost.Service();
DataSet ds = new
DataSet();
XmlElement elem =
objService.GetUserDetails(AName, BName); //call the
web service method
if (elem != null)
{
XmlNodeReader nodereader =
new XmlNodeReader(elem);
ds.ReadXml(nodereader, XmlReadMode.Auto);
gvUserDetails.DataSource = ds;
gvUserDetails.DataBind();
}
else
{
gvUserDetails.DataSource = null;
gvUserDetails.DataBind();
}
}
}