See the classes in the SqlClient namespace for examples of how to execute an sql statement. There is no difference between executing sql commands inside of an event handler or inside a method of the page class.

The results of your sql statement will normally return a rowset (similar to an ADO recordset). The database name will already be specified in your connection string, or in the sql statement that you are executing. For field names, you can use an SqlDataAdapter to retrieve the rowset as a DataTable or a DataSet that contains DataTables. The DataTable will contain a DataColumn for each field in the rowset that can be accessed by column name or index position. To dynamically determine the names of the columns, use a For..Next statement to examine the ColumnName property of the DataTable.Columns collection.