Intersoft Community - WebInput - How to bind WebInput to SQL Server database?

How to bind WebInput to SQL Server database?

yudi — Thu, 11 Mar 2010 22:21:16 GMT

WebInput.NET support both Bound and Unbound mode only. Control-level bound mode data binding is not supported because the data proceed is a simple data (not a list) and hence does not expose DataSource and DataMember property.

To set data in the WebInput.NET control, set the Value properties to a valid data field’s value (a string, datetime, or numeric data type).

The text property contains value data that is formatted, masked, edited, and validated. For those who want to bind data to WebInput.NET, use .NET data binding mechanism such as <%# … %> Expression or assign the Value property in code behind. For more details about .NET data binding, please refer to the .NET Framework documentation.

Please do not use properties other than the Value property under DataBinding to bind the control’s value. For example, although it is possible to bind the Text property to a field, the result will not be the same as binding the Value property.

I enclosed one simple sample that shows how to bind WebInput.NET to SQL Server database. The simple sample binds WebInput.NET to Shippers table of Northwind database. For more detail information, please check the sample.

Hope this helps.

*edited reason: add and attach sample

How to bind WebInput to SQL Server database?

pennwhite@hotmail.com — Wed, 10 Mar 2010 11:18:04 GMT

Getting closer. I just upgraded to SP1 and found several DataBinding to Form samples. I don't understand them yet but I feel like I'm making progress. Now if I can just find a tutorial...

BTW, most of these will crash unless you run Refresh Schema on the DataSet.

How to bind WebInput to SQL Server database?

pennwhite@hotmail.com — Tue, 09 Mar 2010 21:19:37 GMT

This must be a stupid question because I have been struggling with it for 2 days and still can't figure it out.

I have looked at the DataBinding.aspx but that was written for binding to an XML datasource. I have looked at the LINQ to SQL solution for WebGrid and I have done countless searches in the forums, walkthroughs, FAQs and How-tos and I'm still lost. I have a connection string that should be able to be used somehow.

All I want to do is to bind fields (lke FirstName, LastName, Phone, etc.) to my database so users can edit them from a webform. It is so easy using the standard textbox in VS.

What am I missing??