Retrieving specified fields from NAV tables using Web Servic

SivaMohanYerramsetty
Member Posts: 26
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?
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?
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(); }
Shiv
0
Comments
-
Oops Never mind.0
-
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.0
-
Have you tried to create a new page with only the fields you want to display.0
-
Thanks for ur replay,
I'll work on this.Shiv0 -
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?Shiv0 -
still one unknown key
??? Can you be more specific?0 -
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;49920Shiv0 -
Yes, it is. This key must be part of the dataset to be able to identify the record...0
-
Then, how can I display the data with out this key in Web Page?
any suggestions?Shiv0 -
Define which columns you want to dsiplay, displaying all data you read is not the correct way for any web application...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions