How to insert values in table on click of submit button on form and retrieve the same on a grid

(0) Share

Report

Posted on by Community Member

Hi Team

I am new to MS Dynamics AX, I have creates a SalesOrderTable with three fields ordeno, orderdate, productname, quantity. I have created a form on which these fields I have drag and dropped. now I want to add the values into these fields and store it in data base. and retrieve it on a grid for this I have created another form can some one help me to understand how to do it.

Thanks

Mohammed Abdul Haleem

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

If you are a new student of AX, let me tell you something, in Dynamics AX you don't need to write anything like connection string or add/delete queries to interact with database.

kindly go through next URL to know how to create a new form

msdn.microsoft.com/.../gg879955.aspx

moreover, if you can have access to customer or partner source, you may download development manual-1 for study, which can be helpful

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am able to create a new form with blank input fields and a submit button. now I just want to insert the inputed fields data into SalesOrderTable and retrieve it on a grid. Please Help... Thanks

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

can you explain little more on "blank input fields"

Moreover, please answer below questions as well

1) have you Dragged table under datasource node of form

2) are you using a grid or some other way to handle User Interface

Was this reply helpful? Yes No
Suggested answer

Iulian Cordobin 8,201 on at

Like (0)

Report

Add a CommandButton on your initial form and set it's Command property to Save.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank Bhai for quick answer

I have dragged the table under data source

I have created a second form with grid, where I have created a commandbutton with property save.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks lulian ,

I have added a command button and set the property to save. after this am able to insert the record into table but again if I want to insert the next record the form is prepopulated with previous record. and I got end up replacing the first record with next record. please let me know how to insert the values dynamically in X++

Was this reply helpful? Yes No
Iulian Cordobin 8,201 on at

Like (0)

Report

You can add a new CommandButton and set its command to New.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

but why the values are getting pre populated instead of getting the blank fields in the first form when I have opened the first form.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

do I need to write any code explicitly to override the clicked() ?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

if you can show details with some images etc. may be someone can understand that better, than theoretical discussion

Was this reply helpful? Yes No