private void Bind()
{
//------------------------------------------------------------------
string sql = string.Format(@"
select AddressSimple=isnull(AddressSimple,address),LessorBankName=isnull(LessorBankName,LessorName),a.*,b.*
FROM OA_LeaseContract a
inner join
(
select LTID,sum(Pay_Price),sum(Pay_Price2)
from OA_LeaseContract_Finance b
{0}
group by b.LTID
) b on a.LTID=b.LTID
{1}
order by a.LTID desc,b.lfid"
, sqlPartFinance()
, sqlPartHT());
//绑定数据
DataGrid1.DataSource = WebLibrary.CsDB.GetTable(PubFunc.ConnectionString, sql).DefaultView;
DataGrid1.DataBind();
//-----------------------------------------------------------------------------------------------
}
这段代码,连接表那里有问题,总会报下面这个图中的错误。。。不知哪里写错了