Inkpicture control with SQL datatype

[James Chang]

I was trying to create a form that can store inkpicture control data (which
will be user signature) into SQL database field but no luck. I declared the
database field as image data type in SQL but long data type such as image,
text, and etc is not supported in InfoPath. Anyone has any idea?

I searched on Google and someone said it is doable but didn't mention how.
Please help! Thanks

 

[AbhishekK_India]

hi

the inkpicture is stored as base64 encoded content in the XML that gets
generated by the Infopath. You did fine by defining the SQL column as image
/ text data type. you could further use ADO.NET to stream content into that
column.

Natively, the ADO data adapter doesn't support submitting data for datatypes
like image, text etc..

regards
Abhishek