SQL Database Integration

Re: SQL access through managed code

Patrick Halstead — Sun, 30 Jan 2005 05:38:50 GMT

Good idea! We use Web services a lot for this kind of thing.

Re: SQL access through managed code

Elliot Rodriguez — Wed, 26 Jan 2005 13:28:17 GMT

Patrick:

Thanks for your reply.

By traditional, I mean using the DataBind method on a control that exposes a bindable interface... I've extended the MS Data Access blocks, and most of the methods return a DataSet or a DataReader. Using something like: somecontrol.DataBind() throws errors.

I've gone the WebService route, though, so this should be a suitable workaround...

Re: SQL access through managed code

Patrick Halstead — Wed, 26 Jan 2005 08:46:31 GMT

What do you mean by "traditional web/winform binding methods to InfoPath controls"? You can call SQL via code (.NET) and populate dropdown boxes directly. You will need to load the resulting dataset into an XML DOM. That's not terribly difficult but it requires some time.

SQL access through managed code

Elliot Rodriguez — Tue, 25 Jan 2005 19:45:47 GMT

I was hoping that I could access SQL Server data to populate dropdown boxes and text boxes using the native .net provider, as opposed to using a DSN or Web Service, but it doesnt appear that I can use traditional web/winform binding methods to Infopath controls.

Does this limit my binding options to just DSN, XML files, or Web Services?