C#

private void btnSearchPartNumber_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput = txtPartNumber.Text;<br />
			int partNumber = Convert.ToInt32(strPartNumberInput);<br />
			string SQLString = "Select * FROM Costs c INNER JOIN Parts p ON c.PartID = p.Id where p.PartNumber = @PartID"; <br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", partNumber);<br />
			//BindGrid (strConnectSQL, SQLString, DataGrid1 );<br />
			BindGrid (strConnectSQL, cmd, DataGrid1);<br />
		}

BindGrid(cmd, DataGrid1);

private void BindGrid (SqlCommand cmd, System.Web.UI.WebControls.DataGrid DGrid)
{
    // create data adapter
    SqlDataAdapter adapter = new SqlDataAdapter(command);
 
    // create and fill dataset 
    DataSet ds = new DataSet();
    adapter.Fill(ds);
 
    // fill and bind data to Datagrid
    DGrid.DataSource = ds;
    DGrid.DataBind();

    // Close Connection
    conn.Close();
}

leckey wrote:

Since 'conn' is not in BindGrid, I'm not sure what to close

rcwoods wrote:

In my CustomerTabPage class, acustomer.Name brings back a null value.

protected override void OnPaint(System.Windows.Forms.PaintEventArgs e)<br />
{<br />
 lasttimeexecuted = DateTime.Now;<br />
 base.OnPaint(e);<br />
}

3Dizard wrote:

I might get you wrong, too, but why don't you just add your own method to the event handler, which for example saves the time when it was executed in a variable, that you can check in your code.