How to bind a stored procedure to Grid

Not Answered This post has 0 verified answers | 1 Reply | 2 Followers Thread's RSS feed.

Linija
Points 110
Replied On: Fri, Aug 11 2017 6:31 AM Reply

I would like to bind a stored procedure with input parameters to a Grid control .How can i do it ?

  • Post Points: 20

All Replies

Sahaja Kokkalagadda
Points 4,995
Infragistics Employee
Replied On: Fri, Aug 11 2017 4:12 PM Reply

Hello Linija,

There is possibility of populating an UltrGrid with the values read from database using a stored procedure by implementing the below steps.

1. Use a stored procedure to populate a DataSet. Refer to this link on how to receive input parameters using stored procedure.
2. Assign the relative DataTable from this DataSet to the UltraGrid using its DataSource property. You can refer to this KB article on how to achieve this.

However, using a stored procedure to populate the DataSet is done using ADO.net API and I suggest you to contact Microsoft support for further assistance regarding this matter.

I hope this information is helpful.

Sincerely,
Sahaja Kokkalagadda
Associate Software Developer

  • Post Points: 5
Page 1 of 1 (2 items) | RSS