|
So there could be one of two situations for you to create a new web service. Follow the one match your situation. Either you are creating it as independent new project or you are creating it in an existing Project.
(a) Create a web service in as a new Project
- Create a new Project using Visual Studio or Visual Web Developer and Name it “DatabaseWebservice”
Create a new web service project
- If you dock the Solution Explorer you will be able to see two files. i.e. “Service.asmx” in the Root Directory and “Service.cs” in the “App_code” Directory.
- The code which the environment spit out will look like this:
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld() {
return "Hello World";
}
}
(b) Create a web service in an existing Project
- Create the web service in an existing Project and name it “DatabaseWebservice”
Create a Web Service in an existing Project
- You will have “DatabaseWebservice.asmx” in the root Directory and “DatabaseWebservice.cs” in the “App_code”
-
The code which the environment spit out would look like this:
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
///
/// Summary description for DatabaseWebservice
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class DatabaseWebservice : System.Web.Services.WebService {
public DatabaseWebservice () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld() {
return "Hello World";
}
}
(c) Add a web method to the Service
So you noticed that the only difference is how the Environment will name your service.
Now add a new method to the above code.
[WebMethod]
public DataSet GetLatestCsharp()
{
using (SqlConnection connection = new SqlConnection(
ConfigurationManager.ConnectionStrings["MyConnStr"].ConnectionString))
{
string Query = @"SELECT TOP 5 * FROM [Articles]
WHERE ([Branch] = @Branch) ORDER BY [DateAdded] DESC";
SqlCommand command = new SqlCommand(Query, connection);
command.CommandType = CommandType.Text;
command.Parameters.Add(
"@Branch", SqlDbType.NVarChar).Value = "CS";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
DataTable myTable = new DataTable("myTable");
myTable.Columns.Add("Article Title", typeof(string));
myTable.Columns.Add("Authour", typeof(string));
myTable.Columns.Add("Link", typeof(string));
while (reader.Read())
{
myTable.Rows.Add(
new object[] reader["Title"].ToString(),
reader["AuthourName"].ToString(),
"dotnet-friends.com/"+
reader["Link"].ToString()});
}
myTable.AcceptChanges();
DataSet ds = new DataSet();
ds.Tables.Add(myTable);
ds.AcceptChanges();
return ds;
}
}
You see that we are using ConfigurationManager and SQL Data Objects. So don’t forget to include the related following references to your service header:
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
Now the Complete code will look like this:
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{
public Service () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string HelloWorld() {
return "Hello World";
}
///
/// Get Latest 5 Articles/Tutorial in C-Sharp catagory
///
///
[WebMethod(Description = "Get latest Five Articles and Tutorials of C#, It returns Untyped Dataset")]
public DataSet GetLatestCsharp()
{
using (SqlConnection connection = new SqlConnection(
ConfigurationManager.ConnectionStrings["MyConnStr "].ConnectionString))
{
string Query = @"SELECT TOP 5 * FROM [Articles] WHERE
([Branch] = @Branch) ORDER BY [DateAdded] DESC";
SqlCommand command = new SqlCommand(Query, connection);
command.CommandType = CommandType.Text;
command.Parameters.Add(
"@Branch", SqlDbType.NVarChar).Value = "CS";
connection.Open();
SqlDataReader reader = command.ExecuteReader();
DataTable myTable = new DataTable("myTable");
myTable.Columns.Add("Title", typeof(string));
myTable.Columns.Add("Authour", typeof(string));
myTable.Columns.Add("Link", typeof(string));
while (reader.Read())
{
myTable.Rows.Add(
new object[] reader["Title"].ToString(),
reader["AuthourName"].ToString(),
"https://dotnet-friends.com/"+ reader["Link"].ToString()});
}
myTable.AcceptChanges();
DataSet ds = new DataSet();
ds.Tables.Add(myTable);
ds.AcceptChanges();
return ds;
}
}
}
So how are you going to access the service now? For this purpose You have to create a web service client.
In the following Tutorial you will get to know that how can we create a Webservice Client:
>> Creating a Web Service Client in .NET 3.0 using C#
Download the code: Download Project: DatabaseService.zip
|