Need Help in Binding ResultSet with Grid in Axapta

(0) Share

Report

Posted on by M.Azwar Alam

I have the following code in which i am getting ResultSet from Access Database but i dnt know how to bind it with Grid. I write this method in Form Init and i have two StringEdit Fields username and password. Anyone knows how to bind it ?

public void init()
{

loginProperty loginProperty = new LoginProperty();
ODBCConnection odbcConnection;
Statement sql;
ResultSet result;

;
super();
loginProperty.setDSN('NewDSN');
//loginProperty.setUsername('');
//loginProperty.setPassword('');
odbcConnection = new ODBCConnection(loginProperty);
if (odbcConnection)
{
sql = odbcConnection.createStatement();
result = sql.executeQuery("select * from myTestTable");

while (result.next())
{

}
}

}

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

I believe that the best way is insert data into tmp table and then associate the tmp table to datasource.

Was this reply helpful? Yes No