好急啊,谢谢大家,想问问.net里面要写防止用SQL语句注册,自定验证控件里面应该怎么写代码啊 好急啊,谢谢大家,想问问.net里面要写防止用SQL语句注册,自定验证控件里面应该怎么写代码啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 带参数的:string cmdString = "select ID from table where ID=@ID"; SqlCommand selCommand = new SqlCommand(cmdString,dbConnection); SqlParameter GetID=new SqlParameter("@ID",SqlDbType.VarChar,11); GetID.Value=Request.QueryString["id"].Trim(); selCommand.Parameters.Add(GetID); SqlDataReader read = selCommand.ExecuteReader(); if(read.Read() != true) { Response.Write("<script language='javascript'>alert('没有数据!');window.close();</script>"); read.Close(); dbConnection.Close(); Response.End(); }{.......} 存储过程:CREATE PROCEDURE deleteTable @ID int As delete Table where ID=@IDGO CS:dbConn.Open(); SqlCommand dbCommand = new SqlCommand("deleteTable",dbConn); dbCommand.CommandType = CommandType.StoredProcedure; SqlParameter selid=dbCommand.Parameters.Add("@ID",SqlDbType.Int); selid.Value = Request.QueryString["id"].Trim(); dbCommand.ExecuteNonQuery(); dbConn.Close(); http://www.yesky.com/110/1912610.shtml 急! .xpi文件如何下载完自动安装 ASP.NET 实现 在线 word 阅读器 ConnectionString 属性尚未初始化---新建文件夹子目录出现的错误 @@gridview里模板列fileupload的典型问题:如何上传文件,并将路径保存到数据库中? 求一完整的datalist导出excel类 求助高难度C#算法,实现月份排列! 本来正常的程序某一天就出现这样的错误,那应该怎么解决呢? 用.net能实现登陆到一个网站,并提取里面的网页数据吗!? 对datalist,datagrid,repeater.的一些看法。还有问题 MSMQ的问题 求分辨率问题 关于写日志
SqlCommand selCommand = new SqlCommand(cmdString,dbConnection); SqlParameter GetID=new SqlParameter("@ID",SqlDbType.VarChar,11);
GetID.Value=Request.QueryString["id"].Trim();
selCommand.Parameters.Add(GetID);
SqlDataReader read = selCommand.ExecuteReader();
if(read.Read() != true)
{
Response.Write("<script language='javascript'>alert('没有数据!');window.close();</script>");
read.Close();
dbConnection.Close();
Response.End();
}
{
.......
}
CREATE PROCEDURE deleteTable
@ID int
As
delete Table where ID=@ID
GO
CS:dbConn.Open();
SqlCommand dbCommand = new SqlCommand("deleteTable",dbConn);
dbCommand.CommandType = CommandType.StoredProcedure;
SqlParameter selid=dbCommand.Parameters.Add("@ID",SqlDbType.Int);
selid.Value = Request.QueryString["id"].Trim(); dbCommand.ExecuteNonQuery();
dbConn.Close();