using (SqlCommand cmd = SqlConn.CreateCommand())
{
	cmd.CommandText = "dbo.usp_search_charge_details";
	cmd.CommandType = CommandType.StoredProcedure;

	cmd.Parameters.AddWithValue("@TimeKeeperBillingId", "BB538805B");

	SqlDataReader rdr = cmd.ExecuteReader();
}


using (SqlCommand cmd = SqlConn.CreateCommand())
{
	cmd.CommandText = "dbo.usp_search_charge_details";
	cmd.CommandType = CommandType.StoredProcedure;

	cmd.Parameters.AddWithValue("@SortDirection", "desc");
	cmd.Parameters.AddWithValue("@TimeKeeperFullName", "Smith, John");

	SqlDataReader rdr = cmd.ExecuteReader();
}