Create two web services

sajid ali

11y1.1kVisual Basic .NET

¢Create two web services:

1.Fetch list of students (registration #, name) from database table

2.Insert a student registration # and name in the database table.

¢Then create a client application which should use both web services.

¢Constraint: Web service and client application should be on separate computers.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

sajid ali11y ago
How can i consume the web service using client Application Any one please help ?
0

sajid ali11y ago

while inserting i i get this error on browser !!!

System.ArgumentException: No mapping exists from object type System.Data.SqlClient.SqlConnection to a known managed provider native type.    at System.Data.SqlClient.MetaType.GetMetaTypeFromValue(Type dataType, Object value, Boolean inferLen, Boolean streamAllowed)    at System.Data.SqlClient.SqlParameter.GetMetaTypeOnly()    at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)    at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters)    at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc)    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()    at Assignment4Web.StudentService.RegisterStudent(String Name, String Gender, Int32 Marks) in c:\users\sajid\documents\visual studio 2010\Projects\Assignment4Web\Assignment4Web\StudentService.asmx.cs:line 73

sajid ali11y ago
sir how to make client Appli that consume the services ???
0

Ravi Patel11y ago

create two web method one for insertion and one for retrival

it just demo not exact code

this for retrival

[WebMethod]

public XmlElement AllRegisteruser()

{

SqlConnection con = newSqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());

con.Open();

SqlCommand cmd = new SqlCommand("select * from UserInformation'", con);

cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);

// Create an instance of DataSet.

DataSet ds = new DataSet();

da.Fill(ds);

con.Close();

// Return the DataSet as an XmlElement.

XmlDataDocument xmldata = new XmlDataDocument(ds);

XmlElement xmlElement = xmldata.DocumentElement;

return xmlElement;

}

for insertion

[WebMethod]

public int RegisterNewUser(string Name,string Gender) // pass other parameter

{

//write is insert query

int result = cmd.executenonquery();

return result ;

}

deploye this web sevcice in local iis

step 2 create client application which consume the web services. // first read the the article

if you stuck then let me know

sajid ali11y ago
sir i just develop a web service using c# with ID,Name,Gender and Marks and also its reterive data from database now i make an insert which insert the data in database how i can do that sir ??
0
Ravi Patel11y ago
Hi,
in the begining of article they discuss about webservice in the last demo is given i request you first read the article, if you understand the what is wsdl,web method then you can easly create the web service.
0
sajid ali11y ago
sir i m quite confused will you provide some demo please so i can understand
0
Ravi Patel11y ago
Hi,

go through following references
http://www.aspdotnet-suresh.com/2014/11/web-service-example-in-aspnet-using-csharp-net.html
0
sajid ali11y ago
okay i will check
0
Saineshwar Bageri11y ago
I will provide some link this will sure help you.

http://www.c-sharpcorner.com/UploadFile/4d9083/sending-list-from-webservice-and-consume-it-in-application/

http://www.c-sharpcorner.com/UploadFile/4d9083/how-to-consume-basic-http-binding-in-windows-application/
0