ASP.NET

Elizabeth Rani wrote:

this code works fine

You have created a service.

To test this service, you will need to create a client and use it to call the service. You can do this using the svcutil.exe tool from the command line with the following syntax:


svcutil.exe http://development.co.in/DWebServices/CDataService.svc?wsdl

This will generate a configuration file and a code file that contains the client class. Add the two files to your client application and use the generated client class to call the Service. For example:

C#

class Test
{
    static void Main()
    {
        CDataServiceClient client = new CDataServiceClient();

        // Use the 'client' variable to call operations on the service.

        // Always close the client.
        client.Close();
    }
}

Visual Basic

Class Test
    Shared Sub Main()
        Dim client As CDataServiceClient = New CDataServiceClient()
        ' Use the 'client' variable to call operations on the service.

        ' Always close the client.
        client.Close()
    End Sub
End Class

DataTable dtData= YourClass.GetDataTable("select * from yourtableName");

if(dtData.Columns.Count==0){return;}
if(dtData.Rows.Count ==0){return;}