ASP.NET

HTTP/1.1 200 OK
Content-Type: application/json; odata.metadata=minimal; odata.streaming=true
OData-Version: 4.0
Date: Sat, 28 Jun 2014 00:44:07 GMT
Content-Length: 85

{
  "@odata.context":"http://localhost:38479/$metadata#Edm.Decimal","value":50.00
}

"@odata.context":"http://localhost:38479/$metadata#Edm.Decimal",
"value":50.00

Public Class DataModel

   [Serializable()]
    Public Class HardwareOrder

        Public Class ResponseSet

            Public Property TpxID As String
            Public Property ResponseHeader As List(Of ResponseHeaderRow)

        End Class

    End Class

    [Serializable()]
    Public Class ProduceOrder

        Public Class ResponseSet

            Public Property StaffID As String
            Public Property ResponseHeader As List(Of ResponseHeaderRow)

        End Class

    End Class

    [Serializable()]
    Public Class ResponseHeaderRow

        Public Property TransactSucceed As Boolean
        Public Property TransactCode As String
        Public Property TransactDescription As String
        Public Property TransactionReference As String

    End Class

End Class

[Serializable()]
    Public Class Order

        Public Property Id As String
        Public Property TransactSucceed As Boolean
        Public Property TransactCode As String
        Public Property TransactDescription As String
        Public Property TransactionReference As String

    End Class

<WebMethod()>
    Public Function SubmitHardwareOrder(<XmlElement("Parameters", Namespace:="http://MyTest.com/HardwareOrder.Parameters")> Parameters As DataModel.HardwareOrder.Parameters) As XmlElement("ResponseSet", Namespace:="http://MyTest.com/HardwareOrder.ResponseSet")> DataModel.HardwareOrder.ResponseSet
	'other code logic here
	End Function
	
	<WebMethod()>
    Public Function SubmitProduceOrder(<XmlElement("Parameters", Namespace:="http://MyTest.com/ProduceOrder.Parameters")> Parameters As DataModel.ProduceOrder.Parameters) As XmlElement("ResponseSet", Namespace:="http://MyTest.com/ProduceOrder.ResponseSet")> DataModel.ProduceOrder.ResponseSet
	'other code logic here
	End Function

<WebMethod(EnableSession:=True)>
    Public Function customers_load(
ByVal CustomerRequest As ws_customers_Request) As ws_customers_Response

        Dim customer As New ws_customers_Response
        Dim customerList As List(Of ws_customers_list) = Nothing

        Dim dwXCode As Integer = crm_ef_login.administrator_Login(
    CustomerRequest.Credentials_Key,
    CustomerRequest.Credentials_Password
)

        If (0 = dwXCode) Then

            If CustomerRequest.PageIndex = 0 Then CustomerRequest.PageIndex = 1
            If CustomerRequest.PageSize = 0 Then CustomerRequest.PageSize = 25

            Dim m_count As Integer = crm_ws_ef_customers.customers_Load(
        CustomerRequest.PageIndex,
        CustomerRequest.PageSize,
        customerList
    )

            If (m_count > 0) Then

                customer.response_Code = "OK"
                customer.response_Text = m_count & " subscribers have loaded successfully"
                customer.customerList = customerList

            Else

                customer.response_Code = "E001"
                customer.response_Text = "No subscribers exist in the database"
                customer.customerList = customerList

            End If

        Else

            customer.response_Code = "E000"
            customer.response_Text = "Failed Authentication"
            customer.customerList = Nothing

        End If

        Return customer

    End Function

<Serializable()>
Public Class ws_customers_Response

    Private m_response_Code As String
    Private m_response_Text As String
    Private m_customerList As List(Of ws_customers_list)

    Public Property response_Code As String
        Get
            Return m_response_Code
        End Get
        Set(value As String)
            m_response_Code = value
        End Set

    End Property

    Public Property response_Text As String
        Get
            Return m_response_Text
        End Get
        Set(value As String)
            m_response_Text = value
        End Set

    End Property

    Public Property customerList As List(Of ws_customers_list)
        Get
            Return m_customerList
        End Get
        Set(value As List(Of ws_customers_list))
            m_customerList = value
        End Set

    End Property

End Class

<Serializable()>
Public Class ws_customers_list

    Private m_CustomerID As Integer
    Private m_FirstName As String
    Private m_LastName As String
    Private m_EmailAddress As String

    Public Property CustomerID As Integer
        Get
            Return m_CustomerID
        End Get
        Set(value As Integer)
            m_CustomerID = value
        End Set

    End Property

    Public Property FirstName As String
        Get
            Return m_FirstName
        End Get
        Set(value As String)
            m_FirstName = value
        End Set

    End Property

    Public Property LastName As String
        Get
            Return m_LastName
        End Get
        Set(value As String)
            m_LastName = value
        End Set

    End Property

    Public Property EmailAddress As String
        Get
            Return m_EmailAddress
        End Get
        Set(value As String)
            m_EmailAddress = value
        End Set

    End Property

End Class

public class Example {
  public string Name { get; set; }
  public DateTime Expires { get; set; }
}

var examples = getExamples();
for each example in examples {
  example.Expires.AddDays(30);
}

FetchDetails

public DataTable FetchDetails()
{
    con.Open();
    DataTable dt = new DataTable();
    using(SqlCommand cmd = new SqlCommand("spfetchdetail", con))
    {
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@pid", pid);
        
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        sda.Fill(dt);
    }
    return dt.Table[0];
}

public DataTable fetchdetail()
{
    return dll.FetchDetails(); // Call to your DAL returning Datatable
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    string pid = ""; string pname = ""; string pcid = ""; string sdesc = ""; string desc = ""; string qty = ""; string prce = ""; string len = "";
    DataTable dt = bll.fetchdetail(); // Call to BAL and reveice datatable
    // extract the data from this datatable now to populate your variables now
    HiddenField1.Value = pid;
    txt_proName.Text = pname;
    ddl_category.SelectedValue = pcid;
    txt_sdesc.Text = sdesc;
    txt_ldesc.Text = desc;
    txt_qnty.Text = qty;
    txt_price.Text = prce;
    txt_len.Text = len; 
}