I have a very long sql in my asp.net markup like this. What line continuation character do I use? The compiler says "if this attribute value is enclosed in quotation marks, the quotation marks must match."
<asp:SqlDataSource ID="sdsBonuses" runat="server"
ConnectionString="<%$ ConnectionStrings:AdHocReportingConnectionString %>"
SelectCommand = "select approved_denied_by=case when b.bonus_status = 'Denied' then denied_by when b.bonus_status = 'Approved' then approved_by else null end,
approved_denied_date=case when b.bonus_status = 'Denied' then denied_date when b.bonus_status = 'Approved' then approved_date else null end, b.*,rtrim(p.first_name)+' '+rtrim(p.last_name) Name,rtrim(ps.first_name)+' '+rtrim(ps.last_name) submitter_name
from bonus_local b, people p , people ps
where ps.network_account = b.created_by and p.employee_id = b.employee_id and b.is_deleted=0 and b.bonus_status in ('Pending Approval','Denied','Approved')
/* and employee_status<>'terminated' */
and case b.bonus_status when 'Denied' then datediff(dd,denied_date,getdate())
when 'Approved' then datediff(dd,approved_date,getdate())
else 0 end < 1
and p.charge_to_location in
select distinct location_num
from role_location a, gldm_location b
where scheme_cd ='PRO' and role_cd <>'spprt'
and employee_id = (select employee_id from people where network_account = '" + Session["uid"].ToString() + @"')
a.location_cd_prefixed = 'div0'+rtrim(b.division_num)
a.location_cd_prefixed = 'com0'+rtrim(b.company_num)
a.location_cd_prefixed = 'OPE0'+rtrim(b.operation_num)
a.location_cd_prefixed = 'BUS0'+rtrim(b.business_unit_num)
a.location_cd_prefixed = 'TER0'+rtrim(b.territory_num)
a.location_cd_prefixed = 'MAR0'+rtrim(b.market_num)
a.location_cd_prefixed = 'ARE0'+rtrim(b.market_num)
a.location_cd_prefixed = 'Meg0'+rtrim(b.mega_location_num)
a.location_cd_prefixed = location_num
order by rtrim(p.first_name)+' '+rtrim(p.last_name) "