For example purpose I have used connection strings and queries in same file but for you, you need to retrieve it from web.config file and also use stored procedures.

How do I easily add Html Encoding to output this way? NET 2.0 project, so I'm using the newer data binding shortcuts (e.g. Text" that grabs the value back out from where it was bound. NET has to parse Bind() statements, two-way databinding doesn’t support anything other than Bind().

For example, the following syntax is invalid because it tries to invoke arbitrary code and use Bind() at the same time: The only formats supported in two-way databinding are Bind("field") and Bind("field", "format string ").

The code sample below demonstrates how you can programmatically bind a grid control to a Data Table.