下面的有错误,,该怎么改动:
cmdText=@"select sum(FenShu) as s from Topic where TopicName like '*'+@Name";
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbCmd.Parameters.Add("@Name",ID.Trim());
cmdText=@"select sum(FenShu) as s from Topic where TopicName like '*'+@Name";
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbCmd.Parameters.Add("@Name",ID.Trim());
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbCmd.Parameters.Add("@Name",ID.Trim());
不能用@ID吗···
我不想用字符传连接的办法!!
OleDbCommand dbCmd=new OleDbCommand(cmdText, dbConn);
dbCmd.Parameters.Add("@Name",OleDbType.VarChar);
dbCmd.Parameters["@Name"].Value = "*" + ID.Trim();
在 access中使用通陪护%好象有问题