这么写带参数的语句错了??
StringBuilder sql = new StringBuilder();
sql.Append("select * from(select top @ccts");
sql.Append(" * from(select top @endRecord");
sql.Append(" * from Info where gsid = @gsid");
sql.Append(" order by dateandtime desc)");
sql.Append("t1 order by dateandtime)");
sql.Append("t2 order by dateandtime desc");
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand(sql.ToString(), con);
SqlParameter pccts = new SqlParameter("@ccts", SqlDbType.Int);
pccts.Value = ccts;
SqlParameter pendRecord = new SqlParameter("@endRecord", SqlDbType.Int);
pendRecord.Value = endRecord;
SqlParameter pgsid = new SqlParameter("@gsid", SqlDbType.Int);
pgsid.Value = gsid;
sda.SelectCommand.Parameters.Add(pccts);
sda.SelectCommand.Parameters.Add(pendRecord);
sda.SelectCommand.Parameters.Add(pgsid);