I built a small SmartObject using two fields. One is a text field and the other is an attachment. Both are fields in an InfoPath form. When I open the SmartObject Activity the text field is the only item that shows up. I need to map the file attachment as well. Has anyone else seen this or know something?  

Have you tried using the SmartObject Event Wizard in the toolbox?  From your code example, I believe you could you could use the event to accomplish the same thing with no code.  If you do really need to use code, you might try pulling the ''SmartObject Server'' entry from the string table for the connection string.

Currently i'm doing something like this:         public string runSPGetEmailSmartObject(string userName, string connString)         {             string userMail = ...

Hi Alex, I've not attempted this with SQL Views, but you could try: SELECT * INTO YourNewTableName FROM YourExistingViewName as this will create a table from your view. If you want, you can get SQL Server Agent to run a job to recreate this table every hour or something with a TSQL statement like:   use ...

Hi Aasianov, try retrieving the SmartObject field containing the attachment as an InfoPath 'attachment' control. If this works, then you can use some code to retrieve the unicode attachment and display it in another control type, such as image or document.... I believe this is possible. See: http://blog.mgallen.com/?p=94 for code to get the ...

Have anyone started playing around with BlackPearl and Visual Studio 2008, SQL 2008 & .Net 3.5? Using Ado.net Entity Datamodel Framework and SmartObjects together? Using the new SQL Filestream to save files to the filesystem, Pushing Workflow tasks to users using the RSS2.0 Feed Formatter? instead of just emailing the tasks to the ...

I am posing the question of how to use Smart Objects the 'right' way in an overall architecture design.  I am starting to think of Smart Objects as Classes and using them accordingly but then I quickly start running into issues.  For example, we are writing a system where a user places an 'Order' to start a workflow process - there are ...

Feels like a dumb question here, but for whatever reason I'm just not getting it... I have a smart object that I am creating in an activity (via the smart object's 'Create' event) and I would like to pass this smart object to my InfoPath form to display some of the data within it.  How do I go about tying an existing smart object to an ...

I have a Smart Object that is retrieving a set of data from a SQL table. This table has a 1 to many relationship with another table, which also has a 1 to many relationship with another table. I'm not sure what is the best way of being able to pull back all this information. I want to be able to select a row from the first table, and retrieve all ...

I need some smart objects to retrieve some lookup values from SQL. Each smart object will have two methods, 1 to return a list of ID's and values, and 1 to return a specific value matching a given ID. It seems to me that the idea behind smart objects would be for me to have 4 different objects to handle the 4 different lookups I need to ...