Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Stored Procedure View modes: 
User avatar
Member
Member
qqayumi-qq - 8/15/2011 5:11:37 AM
   
Stored Procedure
Hello,

I try to passing the parameter to stored procedure and bind the results with repeater, but it seem that the repeater is not updated. Is it any error with the following code?


object[,] parameters = new object[1, 3];
parameters[0, 0] = "@ID";
parameters[0, 1] = 1;

//execute stored procedure
GeneralConnection gn = ConnectionHelper.GetConnection();
DataSet ds = gn.ExecuteQuery("test_sp", parameters, CMS.IDataConnectionLibrary.QueryTypeEnum.StoredProcedure, false);

repItems.DataSource = ds;
repItems.DataBind();
repItems.ReloadData(true);