Retrieving specified fields from NAV tables using Web Servic

SivaMohanYerramsetty · **Posted:** Wed Feb 18, 2009 3:51 pm

Hi everyone,

Using web services, I am displaying Customer (accessing NAV data) details in ASP.Net application using GridView control. Here problem is I don’t want to display all fields from Customer table. I can put filters on customer data. But, I am unable to retrieve specified fields from customer table.
Can anyone tell the solution for this issue?

Code: Select all

protected void Button1_Click(object sender, EventArgs e)
    {
        CustWS.CustomerPage_Service CustServices = new CustomerPage_Service();
        CustServices.UseDefaultCredentials = true;
        CustServices.Url = "http://b2bxpprof247:7047/DynamicsNAV/WS/CRONUS_India_Ltd./Page/CustomerPage";
        CustWS.CustomerPage CustRec = new CustomerPage();

        List<CustomerPage_Filter> filterArray = new List<CustomerPage_Filter>();
        CustomerPage_Filter CustFilter = new CustomerPage_Filter();
        CustFilter.Field = CustomerPage_Fields.Name;
        CustFilter.Criteria = "@s*";
        filterArray.Add(CustFilter);
        GridView1.DataSource = CustServices.ReadMultiple(filterArray.ToArray(), null, 100);
        GridView1.DataBind();

    }

ara3n · **Posted:** Wed Feb 18, 2009 4:35 pm

Oops Never mind.

kine · **Posted:** Wed Feb 18, 2009 7:08 pm

If you mean something like "dynamic" WebService which will return you just somehow selected fields, you will need to use some codeunit and programming. You cannot do it only by publishing page.

ara3n · **Posted:** Wed Feb 18, 2009 7:42 pm

Have you tried to create a new page with only the fields you want to display.

SivaMohanYerramsetty · **Posted:** Thu Feb 19, 2009 7:03 am

Thanks for ur replay,
I'll work on this.

SivaMohanYerramsetty · **Posted:** Thu Feb 19, 2009 12:16 pm

Hi Rashed,
I have created one page with specified fields from customer table. By using this page am getting the same fields in my application but, still one unknown key it’s displaying.
How can I restrict this?

kine · **Posted:** Thu Feb 19, 2009 1:29 pm

Quote:

still one unknown key

??? Can you be more specific?

SivaMohanYerramsetty · **Posted:** Fri Feb 20, 2009 6:14 am

What I feel, this key (Unique identifier) is might be generating by Web service for getting current record from NAV database.

The key is like : 300;EgAAAACJDAxEyAAAAAAAAAAAAAAAAA……….AAAAAAAAAA=4;49920

kine · **Posted:** Fri Feb 20, 2009 7:26 am

Yes, it is. This key must be part of the dataset to be able to identify the record...

SivaMohanYerramsetty · **Posted:** Fri Feb 20, 2009 8:41 am

Then, how can I display the data with out this key in Web Page?
any suggestions?

kine · **Posted:** Fri Feb 20, 2009 9:25 am

Define which columns you want to dsiplay, displaying all data you read is not the correct way for any web application...

mibuso.com

Retrieving specified fields from NAV tables using Web Servic

Who is online