> public DataSet getPurchases(int iContactId) > { > > String cConnectionString = this.DataAccessObject.ConnectionString; > SqlConnection sqlConn = new SqlConnection(cConnectionString); > System.Data.SqlClient.SqlCommand cmdPurchasesForContact = new SqlCommand("dbo.getPurchasesForContact", sqlConn); > cmdPurchasesForContact.CommandType = System.Data.CommandType.StoredProcedure; > cmdPurchasesForContact.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] { > new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((byte)(0)), ((byte)(0)), "", System.Data.DataRowVersion.Current, null), > new System.Data.SqlClient.SqlParameter("@iContactId", System.Data.SqlDbType.Int, 0, "iContactId")}); > > > DataSet ds = new DataSet(); > SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(); > da.SelectCommand = cmdPurchasesForContact; > da.Fill(ds, "crsPurchases"); > return ds; > } >>