sql server failed to find the stored procedure

德鲁伊

declare @CardNumber varchar(50)
DECLARE @sql NVARCHAR(2000)
set @CardNumber='1.2.3.4'
   set @CardNumber ='''' + replace(@CardNumber,'.',''',''') +''''
select @CardNumber
SET @sql ='select 1 where'''+'1'+''' in ('+ @CardNumber +')'
exec (@sql)

----->This can be found

zuoshou

How do you write the parameters in the previous program? Are there any errors?
CardData cards = new CardData();
this.ViewState["Card Number"] += this.CardNumberTextBox.Text +"," + ".";
string[] ary = this.ViewState["Card Number"].ToString().Split(',');
foreach(string s in ary)
{
if(s.Trim() != "")
{
using (CardAccess ca=new CardAccess())
{
cards = ca.GetCardByNumber(s);
}
}
}

zuoshou

The above is a bit unclear, look at this
CardData cards = new CardData();
this.ViewState["Card Number"] += this.CardNumberTextBox.Text +"," + ".";
string[] ary = this.ViewState["Card Number"].ToString().Split(',');
foreach(string s in ary)
{
if(s.Trim() != "")
{
using (CardAccess ca=new CardAccess())
{
cards = ca.GetCardByNumber(s);
}
}
}