Web Services in ASP.NET

-
A Web Service is programmable application logic accessible via standard Web protocols. One of these Web protocols is the Simple Object Access Protocol (SOAP). SOAP is a W3C submitted note (as of May 2000) that uses standards based technologies (XML for data description and HTTP for transport) to encode and transmit application data.
Consumers of a Web Service do not need to know anything about the platform, object model, or programming language used to implement the service; they only need to understand how to send and receive SOAP messages (HTTP and XML).

Try simple code :

ASPX :->


<html xmlns="http://www.w3.org/1999/xhtml">
<
head runat="server"><title></title></
head><
body><form id="form1" runat="server"><div><asp:GridView ID="GridView1" runat="server"><Columns><asp:BoundField DataField="id" HeaderText="ID" /><asp:BoundField DataField="f_name" HeaderText="Firts name" /><asp:BoundField DataField="adds" HeaderText="ADDS" /></Columns></asp:GridView><asp:Button ID="Button1" runat="server" Text="Click" onclick="Button1_Click" /></div></form></
body></
html>

CS ->

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using webServiceTrial;namespace webServiceTrial{

public partial class _Default : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){
}

protected void Button1_Click(object sender, EventArgs e){
webServiceTrial.
WebService1 wrr = new webServiceTrial.WebService1();GridView1.DataSource = wrr.getDetails();
GridView1.DataBind();
}
}
}


WebService asmx :-?


using System.Web.Services;using System.Data;using System.Data.Sql;using System.Data.SqlClient;namespace webServiceTrial{

/// <summary>/// Summary description for WebService1/// </summary>[WebService(Namespace = "http://tempuri.org/")][
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 WebService1 : System.Web.Services.WebService{
[WebMethod]
public string HelloWorld(){

return "Hello World";}
[
WebMethod]
public DataSet getDetails(){

SqlConnection conn;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
const string cmdString = "Select * From Info";conn =
new SqlConnection("Data Source=ADS;Initial Catalog=TestApp;Persist Security Info=True;User ID=Nihar.Kulkarni;Password=bflmcd");myDataAdapter =
new SqlDataAdapter(cmdString, conn);myDataSet =
new DataSet();myDataAdapter.Fill(myDataSet,
"Info");
return myDataSet;
}
}
}

Comments

Post a Comment

Popular posts from this blog

File operations in C# (.net)

-
Here we are performing some basic file operations which widely needed in applications. ASPX :     <div>         <asp:Button ID="Button1" runat="server" Text="CLick" onclick="Button1_Click" />         <asp:FileUpload ID="FileUpload1" runat="server" /><br /><br />          </div> C# :        using System.IO;        using System.Text;         protected void Button1_Click(object sender, EventArgs e)         {             string path = @"E:\MVC Application Demos\ABC.txt";            // File Path taken             string name = FileUpload1.FileName.ToString();                // Here we get File Name only             string pa...
Read more

Add Serial no in crystal report without coding

-
Image
Adding a serial number in grouping without any code. I have placed the step by step screenshots which will explain easily how to do it.   1) Add a new field in Running Total Fields in Field Explorer   Give a proper name to your Running total name. For example I have choosen here RTotal0. Now categorize based on which field in database you want to summarize it. Next is as we want serial number select count. If you want your serial number to start again from the start when the value in the group changes then select on change of group and specify the grouping name else keep the default value.   Smaple Preview of the Design View of Report where I Have added SRNo column at the start in grouping section.  
Read more

How to get top " n " number of rows from table

-
Suppose you want top n values from table , so execute following query with replacement of following item as mention below : 1 )  Replace your our tablename with [table_name] 2 )  Replace your "n" with row numbers  (how many rows you want ) [ Note :  You can do multiply and division operations also ] Query for Top rows : SELECT MainSQL .* FROM ( SELECT t .*, ROW_NUMBER () OVER ( ORDER BY 1 ) Row_Number , COUNT ( 1 ) OVER ( ORDER BY 1 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) Row_Count FROM (SELECT * FROM [table_name] )  t ORDER BY 1 ) MainSQL WHERE Row_Number >= 1 AND Row_Number < ( 1 + 2 ) ORDER BY Row_Number ; Query for Bottom  rows : SELECT MainSQL .* FROM ( SELECT t .*, ROW_NUMBER () OVER ( ORDER BY 1 ) Row_Number , COUNT ( 1 ) OVER ( ORDER BY 1 RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) Row_C...
Read more