//====================================================
namespace WebServicesDemo
{
public class Student
{
public int ID { get; set; }
public string Name { get; set; }
}
}
//==========================================================
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
namespace WebServicesDemo
{
[WebService(Namespace = "http://stdpoint.co/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
[System.Web.Script.Services.ScriptService] //enable javascript callable
public class StudentService : System.Web.Services.WebService
{
[WebMethod]
public Student GetStudentByID(int ID)
{
Student student = new Student(); ;
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using(SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spGetStudentByID", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter("@ID", ID);
cmd.Parameters.Add(parameter);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
student.ID = Convert.ToInt32(reader["ID"]);
student.Name = reader["Name"].ToString();
}
}
return student;
}
//=======================================================
</html> tags in WebForm1.aspx
<head runat="server">
<title></title>
<script type="text/javascript" language="javascript">
function GetStudentById()
{
var id = document.getElementById("txtStudentId").value;
WebServicesDemo.StudentService.GetStudentByID(id,
GetStudentByIdSuccessCallback, GetStudentByIdFailedCallback);
}
// GetStudentByIdSuccessCallback call when GetStudentByID is Success
//GetStudentByIdFailedCallback call when GetStudentByID is Failed
function GetStudentByIdSuccessCallback(result)
{
document.getElementById("txtName").value = result["Name"];;
}
function GetStudentByIdFailedCallback(errors)
{
alert(errors.get_message());
}
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/StudentService.asmx" />
</Services>
</asp:ScriptManager>
<table style="font-family:Arial; border:1px solid black">
<tr>
<td><b>ID</b></td>
<td>
<asp:TextBox ID="txtStudentId" runat="server"></asp:TextBox>
<input id="Button1" type="button" value="Get Student" onclick="GetStudentById()" />
</td>
</tr>
<tr>
<td><b>Name</b></td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
</td>
</tr>
<td>
<asp:TextBox ID="txtTotalMarks" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</body>
No comments:
Post a Comment