The Weird and The Wonderful

<br />
ALTER procedure [dbo].[ily_products_search_keyword]<br />
	(@sWhere varchar(2000) )<br />
as<br />
<br />
set nocount on<br />
<br />
declare @sql varchar(8000)<br />
<br />
select  @sql = 'SELECT products.product_id,products.product_name,products.file_url, '<br />
select  @sql = @sql + 'products.print_url,  products.product_desc '<br />
select  @sql = @sql + ' FROM products '<br />
select  @sql = @sql + ' WHERE products.active = 1 '<br />
select  @sql = @sql + @sWhere<br />
select  @sql = @sql + ' ORDER BY products.product_name '<br />
<br />
exec(@sql)<br />

bool bool_report_progress = false;

private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
...
if (bool_report_progress)
backgroundWorker1.ReportProgress(x, listbox1_Search.Items.Count + " items were found so far.");
}

private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e)
{
lable_reported_progress.Text = e.UserState.ToString();
}

private void checkbox1_report_progress_CheckedChanged(object sender, EventArgs e)
{
<font color=#00ee00>bool_report_progress = lbl_reported_progress.Visible = checkbox1_report_progress.Checked;</font>
}

Private Sub Page_Load(blah, blah) Handles Page.OnLoad

   ' create some objects, initialize some variables

   If Page.IsPostBack
      ' validate the user input
      ValidateInput()
      ' save the user input to the database
      SaveInput()
   End If

End Sub

Private Sub Submit_Click(obj, args) Handles btnSubmit.OnClick

   ' direct the user to the new page
   Response.Redirect(page.aspx)

End Sub