Visual Basic - Page 4

Return the HTML code generated by the input ASP.NET server control Note: the function only works with server side controls that don't generate postbacks and that can be declared outside a server-side form Example: TextBox1.Text = GetControlHtml(DataGrid1)

Return a comma delimited list of items selected in a List control (e.g. ListBox, CheckBoxList) Example: Dim selections As String = GetListSelections(CheckBoxList1)

Return whether a file uploader control has posted a file to the server

When the TextMode property of a TextBox control is set to Password, the value you assign to the Text property (either declaratively or programmatically) isn't actually displayed at runtime, not even in masked mode (with the * chars). This is of course done for security reasons, because even if ...

Select the specified items (passed as a comma delimited list) in the input List control (e.g. ListBox, CheckBoxList) Example: SetListSelections(CheckBoxList1, "item 3, item 5, item 6")

Show a client-side message box at the next page load Example: ShowMessageBox(Me, "Order successfully submitted!")

A generic routine that takes an object, an event name, and a list of potential delegates to event handlers, and selects the first delegate that matches the expected signature of the event handler. Example: AddHandlerByName(da, "RowUpdated", _ New OleDbRowUpdatedEventHandler(AddressOf ...

Reusable routine that save a BLOB field to a file Requires Imports for System.Data and System.Data.Common Example: BlobToFile(dr, 2, "c:\xxxx.bmp")

Create a suitable connection object for a given connection string. Requires Imports for System.Data, System.Data.Common, System.Data.OleDb, System.Data.SqlClient and System.Data.Odbc Example: Dim cn As IDbConnection = CreateConnection(connStr)

Create a suitable DataAdapter object for a given connection object. Example: Dim da As DbDataAdapter = CreateDataAdapter(cn, "SELECT * FROM Titles")

Create a suitable DataAdapter object for a given connection object. Requires Imports for System.Data, System.Data.Common, System.Data.OleDb, System.Data.SqlClient, System.Data.Odbc and System.Data.OracleClient Example: Dim da As DbDataAdapter = CreateDataAdapter("SELECT * FROM Titles", cn)

Reusable routine that loads a file into a SQL Server's BLOB. Requires Imports for System.Data and System.Data.SqlClient (It supports only tables with one key field.) Example: FileToBlob(cn, "pub_info", "logo", "pub_id", "0877", "c:\Example.bmp")

Return a reference to the control that caused the last postback, even from the Page_Load event! It requires in input a reference to the posted-back page (this is necessary if you want to be able to move this function in a separate class instead of in a page's codebehind class Example:

While VB6's Clipboard object has a Clear method, VB.NET class does not have such functionality. Here's a good workaround.

Do the check spelling on the input text Returns the input text with the corrections applied from the Word's check-spelling dialog Note: it requires a reference to the MS Word 9.0 library Example: MsgBox (CheckSpelling("This sentence iss far from being correcta"))