Products产品列表页面:<td><a href='proedit.aspx?ID=<%# Eval("id")%>'>编辑产品</a></td>编辑页面proedit.aspx.cs:protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Request.QueryString["id"] != null)
{
aid = Request.QueryString["id"].ToString();
}
string strSql = "SELECT * from products where products.id = '" + aid + "'";
dtTable = webService.ExcuteSelect(strSql);
if (dtTable.Rows.Count != 0)
{
this.pkh.Text = dtTable.Rows[0]["model"].ToString();
this.ppm.Text = dtTable.Rows[0]["pro"].ToString();
this.pclass.Text = dtTable.Rows[0]["classid"].ToString();
this.pstyle.Text = dtTable.Rows[0]["styleid"].ToString();
this.pml.Text = dtTable.Rows[0]["fabric"].ToString();
this.pll.Text = dtTable.Rows[0]["lining"].ToString();
this.pgy.Text = dtTable.Rows[0]["art"].ToString();
this.pfob.Text = dtTable.Rows[0]["fob"].ToString();
this.pqdl.Text = dtTable.Rows[0]["prgm"].ToString();
this.img.Text = dtTable.Rows[0]["pimg"].ToString();
this.pkh.Text = dtTable.Rows[0]["model"].ToString();
}
}
}protected void ProEdit_Click(object sender, EventArgs e) 点击编辑按钮触发事件
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["constr"]);
if (Page.IsValid)
{
string strpkh = this.pkh.Text.Trim(); //编号
string strppm = this.ppm.Text.Trim(); //品名
string strsclass = this.pclass.Text.ToString(); //类别
string strxh = this.xh.Checked.ToString(); //现货供应
string strtj = this.tj.Checked.ToString(); //推荐
string strsstyle = this.pstyle.Text.ToString(); //款式
string strpml = this.pml.Text.Trim(); //面料
string strpll = this.pll.Text.Trim(); //里料
string strpgy = this.pgy.Text.Trim(); //工艺
string strpfob = this.pfob.Text.Trim(); //FOB
string strpqdl = this.pqdl.Text.Trim(); //品牌
HttpPostedFile postFile = this.ad1.PostedFile;
DateTime now = DateTime.Now;
int intFileLength = postFile.FileName.Length;
string strImgName = postFile.FileName;
int i = strImgName.LastIndexOf(".") + 1;
string strExtension = strImgName.Substring(i);
string newname = now.DayOfYear.ToString() + postFile.ContentLength.ToString();
string strad1 = Server.MapPath("~\\UploadFile\\" + newname + strExtension);
postFile.SaveAs(strad1);
strad1 = @"~/UploadFile/" + newname + strExtension; //图片
conn.Open();
string strSQL2 = "Update products set model='" + strpkh + "',pro='" + strppm + "',xtid='" + strsclass + "',xh='" + strxh + "',tj='" + strtj + "',xsid='" + strsstyle + "',fabric='" + strpml + "',lining='" + strpll + "',art='" + strpgy + "',fob='" + strpfob + "',prgm='" + strpqdl + "',pimg='" + strad1 + "',addtime='" + DateTime.Now + "'";
webService.ExcuteSql(strSQL2);
Response.Write("<script> alert('修改成功!');location.href = 'products.aspx'</script>");
DataBind();
}
}
}初涉C#,求教高人!
{
if (!Page.IsPostBack)
{
if (Request.QueryString["id"] != null)
{
aid = Request.QueryString["id"].ToString();
}
string strSql = "SELECT * from products where products.id = '" + aid + "'";
dtTable = webService.ExcuteSelect(strSql);
if (dtTable.Rows.Count != 0)
{
this.pkh.Text = dtTable.Rows[0]["model"].ToString();
this.ppm.Text = dtTable.Rows[0]["pro"].ToString();
this.pclass.Text = dtTable.Rows[0]["classid"].ToString();
this.pstyle.Text = dtTable.Rows[0]["styleid"].ToString();
this.pml.Text = dtTable.Rows[0]["fabric"].ToString();
this.pll.Text = dtTable.Rows[0]["lining"].ToString();
this.pgy.Text = dtTable.Rows[0]["art"].ToString();
this.pfob.Text = dtTable.Rows[0]["fob"].ToString();
this.pqdl.Text = dtTable.Rows[0]["prgm"].ToString();
this.img.Text = dtTable.Rows[0]["pimg"].ToString();
this.pkh.Text = dtTable.Rows[0]["model"].ToString();
}
}
}protected void ProEdit_Click(object sender, EventArgs e) 点击编辑按钮触发事件
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["constr"]);
if (Page.IsValid)
{
string strpkh = this.pkh.Text.Trim(); //编号
string strppm = this.ppm.Text.Trim(); //品名
string strsclass = this.pclass.Text.ToString(); //类别
string strxh = this.xh.Checked.ToString(); //现货供应
string strtj = this.tj.Checked.ToString(); //推荐
string strsstyle = this.pstyle.Text.ToString(); //款式
string strpml = this.pml.Text.Trim(); //面料
string strpll = this.pll.Text.Trim(); //里料
string strpgy = this.pgy.Text.Trim(); //工艺
string strpfob = this.pfob.Text.Trim(); //FOB
string strpqdl = this.pqdl.Text.Trim(); //品牌
HttpPostedFile postFile = this.ad1.PostedFile;
DateTime now = DateTime.Now;
int intFileLength = postFile.FileName.Length;
string strImgName = postFile.FileName;
int i = strImgName.LastIndexOf(".") + 1;
string strExtension = strImgName.Substring(i);
string newname = now.DayOfYear.ToString() + postFile.ContentLength.ToString();
string strad1 = Server.MapPath("~\\UploadFile\\" + newname + strExtension);
postFile.SaveAs(strad1);
strad1 = @"~/UploadFile/" + newname + strExtension; //图片
conn.Open();
string strSQL2 = "Update products set model='" + strpkh + "',pro='" + strppm + "',xtid='" + strsclass + "',xh='" + strxh + "',tj='" + strtj + "',xsid='" + strsstyle + "',fabric='" + strpml + "',lining='" + strpll + "',art='" + strpgy + "',fob='" + strpfob + "',prgm='" + strpqdl + "',pimg='" + strad1 + "',addtime='" + DateTime.Now + "'";
webService.ExcuteSql(strSQL2);
Response.Write("<script> alert('修改成功!');location.href = 'products.aspx'</script>");
DataBind();
}
}
}初涉C#,求教高人!
解决方案 »
- 在一个udp端口上接收多组数据的问题
- C# 画直线带一个箭头 完成了大部分
- 求法算法
- 跟大佬们求个正则!
- StringBuilder 转换成 数组 的问题?
- 第一。 我想根据(大学,期刊,作者)DROPDOWNLIST来进行组合查询,请问这个功能怎么实现呀?在DROPDOWNLIST中可以添加300个数据吗?
- 关于POST问题
- [请教] 使用FileSystemWatcher检查到文件Create的事件中,是否不能使用Form.Show()?谢谢
- dotnet怎么实现不让程序重复运行?
- 紧急!!!c#注册tomcat
- 'FW20090604$' 不是一个有效名称。请确认它不包含无效的字符或标点,且名称不太长。
- ---------------------->旧题新问
sql语句没where条件
肯定都更新了不
{
get{return viewState["aid"].ToString();}
set{viewState["aid"]=value;}
}
aid = Request.QueryString["id"] != null?Request.QueryString["id"].ToString():"0";
where products.id = '" + aid + "'";