传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。RPC 名无效。解决办法
传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。RPC 名无效。
我在执行SQL的时候提示:传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。RPC 名无效。
DB类如下:
SQL如下:
我在执行SQL的时候提示:传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。RPC 名无效。
DB类如下:
/// <summary>
/// 执行SQL语句,返回执行SQL语句之后的一张表。
/// </summary>
/// <param name="sql">执行的SQL语句,也可以是存储过程名称</param>
/// <param name="values">存储过程的参数值</param>
/// <returns></returns>
public static DataTable GetDataTable(string sql, params SqlParameter[] values)
{
using (SqlConnection con = Connection)
{
SqlCommand cmd = new SqlCommand(sql, con);
DataSet ds = new DataSet();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(values);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds); //这里提示 :传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。RPC 名无效
return ds.Tables[0];
}
}
SQL如下:
select @total=count(1) from ( select d.NAME fc,c.NAME wc,b.NAME failname,a.ROUTE_STEP_ID id,a.check_status,
rtrim(ltrim(a.NAME)) name,a.SKILL,a.DESCRIPTION [desc],a.deleted,a.Yellow_Warning YellowWaming,a.Red_Warning RedWaming,
a.FAIL_STEP_ID fid,e.NAME fail_route_step_name,a.minstaytime staytime,a.type opt
from dbo.QS_ROUTE_STEPS a left join dbo.QS_ROUTE_STEPS b
on a.FAIL_STEP_ID=b.ROUTE_STEP_ID left join dbo.CT_WORK_CENTERS c on
a.STATION_ID=c.WORK_CENTER_ID left join dbo.CT_FACTORIES d on c.FACTORY_ID=
d.FACTORY_ID left join dbo.QS_ROUTE_STEPS e on a.FAIL_STEP_ID=e.ROUTE_STEP_ID where a.deleted=@status ) l ;select * from (select row_number() over(order by name,wc,fc) rowindex,* from( select d.NAME fc,c.NAME wc,b.NAME failname,a.ROUTE_STEP_ID id,a.check_status,
rtrim(ltrim(a.NAME)) name,a.SKILL,a.DESCRIPTION [desc],a.deleted,a.Yellow_Warning YellowWaming,a.Red_Warning RedWaming,
a.FAIL_STEP_ID fid,e.NAME fail_route_step_name,a.minstaytime staytime,a.type opt
from dbo.QS_ROUTE_STEPS a left join dbo.QS_ROUTE_STEPS b
on a.FAIL_STEP_ID=b.ROUTE_STEP_ID left join dbo.CT_WORK_CENTERS c on