Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Linija
110
How to bind a stored procedure to Grid
posted

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

  • 6120
    Offline posted

    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