I would like to bind a stored procedure with input parameters to a Grid control .How can i do it ?
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 KokkalagaddaAssociate Software Developer