C#中，UPDATE问题

yee_yj 2010-02-09 05:14:19

问题如下：

我在用C#写新闻后台更新程序时，出现了个奇怪的问题：
首先我简单说明下我的思路：
我进入后台管理页面，是新闻的一个gridview，点击其中的修改，进入modify页面，该页面的各Textbox的值是从数据库中读取出来的，所以显示的时候是待修改的数据。但是修改完提交以后：
update语句中，不加where条件时，gridview中所有行都被重置为刚要修改的那一行，而且还是未修改前的数据；加了where条件后，更新就无效了

这个问题电脑没有提示任何错误消息，id传值正确，我测试过了

谢谢大侠么，拜谢

...全文

170 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

wangminqi 2010-02-10

打赏
举报

看看 Request.QueryString["id"] 的值是否为空

http://www.mybuffet.cn

yee_yj 2010-02-10

打赏
举报



page_load() 

{ 

  if(!ispostback) 

  { your code } 

}

yee_yj 2010-02-10

打赏
举报

[code=c#]
page_load()
{
if(!ispostback)
{ your code }
}
[/code]
顶

yee_yj 2010-02-10

打赏
举报

引用 4 楼 seesea125 的回复:

page_load()
{
if(!ispostback)
{
your code
}
}

正解，基础没过关，没办法，新手一个，呵呵

yee_yj 2010-02-09

打赏
举报

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.IO;

namespace zjutieyjs.admin
{
public partial class modi : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server='(local)';database='news';uid='sa';pwd='sa';");
conn.Open();
string str = "select * from news where id='" + Request.QueryString["id"] + "'";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
TextBox1.Text=rd["Title"].ToString();
TextBox2.Text=rd["Time"].ToString();
TextBox3.Text=rd["Author"].ToString();
DropDownList3.Text=rd["Weather"].ToString();
FCKeditor1.Value=rd["Content"].ToString();
DropDownList1.Text=rd["Level"].ToString();
DropDownList2.Text=rd["Classname"].ToString();
}
rd.Close();
conn.Close();

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection("server='(local)';database='news';uid='sa';pwd='sa';");
con.Open();
//string strsql = ame) values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + FCKeditor1.Value + "','" + DropDownList3.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "')";
//string strsql = "UPDATE News SET Title = '" + TextBox1.Text + "',Time = '" + TextBox2.Text + "', Author = '" + TextBox3.Text + "', Content ='" + FCKeditor1.Value + "', Weather = '" + DropDownList3.Text + "', Level = '" + DropDownList1.Text + "',Classname = '" + DropDownList2.Text + "'where ID='" + Request.QueryString["id"] + "'";
string strsql = "UPDATE News SET Title = '" + TextBox1.Text + "'where ID='" + Request.QueryString["id"] + "'";
SqlCommand cmdd = new SqlCommand(strsql, con);
cmdd.ExecuteNonQuery();

StreamReader aw = File.OpenText(Server.MapPath("template.htm"));
string template = aw.ReadToEnd();
aw.Close();

template = template.Replace("[新闻标题]", TextBox1.Text);
template = template.Replace("[发布时间]", TextBox2.Text);
template = template.Replace("[新闻作者]", TextBox3.Text);
template = template.Replace("[新闻天气]", DropDownList3.Text);
template = template.Replace("[新闻内容]", FCKeditor1.Value);

StreamWriter sw = File.CreateText(Server.MapPath("../html/" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Second.ToString() + ".htm"));
sw.Write(template);
sw.Close();

Response.Redirect("manage.aspx");

}
catch (Exception ee)
{
Response.Write(ee.ToString());
}
}
}
}

yee_yj 2010-02-09