修改一行gridview中一行的数据后,数据不更新,还是原来的数据。
我是选取gridview中的一行,通过旁边的“更改”按钮进入修改这行数据的页面,修改后数据还是原来数据,但是提示“修改成功”了,程序编译没有提示错误,求解,谢谢...
代码如下:
public partial class Admin_fitEdit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
/*验证是否登陆了系统*/
if (Session["adminFlag"] == null)
{
Response.Write("<script>top.location.href='../Login.aspx';</script>");
return;
}
}
InitView();
}
protected void Btn_Update_Click(object sender, EventArgs e)
{
//建立维修数据模型
string houseId = Request.QueryString["HouseId"];
FitModel fitModel = new FitModel();
fitModel.HouseId = Request.QueryString["HouseId"];
fitModel.Inform = this.Inform.Text;
fitModel.Time = this.Time.Text;
fitModel.Result = this.Result.Text;
fitModel.Type = this.Type.Text;
fitModel.Fee = this.Fee.Text;
fitModel.Remarks = this.Remarks.Text;
//执行维修信息的更新
FitLogic fitLogic = new FitLogic();
if (fitLogic.UpdateFitInfo(fitModel))
{
Response.Write("<script>alert('维修信息更新成功!');location.href='fitEdit.aspx?HouseId=" + houseId + "';</script>");
}
else
{
Response.Write("<script>alert('" + fitLogic.ErrMessage + "');</script>");
}
}
private void InitView()
{
string houseId = Request.QueryString["HouseId"];
FitLogic fitLogic = new FitLogic();
FitModel fitModel = fitLogic.GetFitInfo(houseId);
this.HouseId.Text = fitModel.HouseId;
this.Inform.Text = fitModel.Inform;
this.Time.Text = fitModel.Time;
this.Result.Text = fitModel.Result;
this.Type.Text = fitModel.Type;
this.Fee.Text = fitModel.Fee;
this.Remarks.Text = fitModel.Remarks;
}
protected void Btn_Cancle_Click(object sender, EventArgs e)
{
Response.Write("<script>location.href='fitment.aspx';</script>");
}
}
=============
GetFitInfo和UpdateFitInfo在FitLogic类里面
public FitModel GetFitInfo(string houseId)
{
string sqlString = "select * from fitment where HouseId=" + houseId;
DataSet ds = DBoperator.GetDataSet(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null);
if (ds.Tables[0].Rows.Count == 0) return null;
DataRow dr = ds.Tables[0].Rows[0];
FitModel fitModel = new FitModel();
fitModel.HouseId = dr["HouseId"].ToString();
fitModel.Inform = dr["Inform"].ToString();
fitModel.Time = dr["Time"].ToString();
fitModel.Result = dr["Result"].ToString();
fitModel.Type = dr["Type"].ToString();
fitModel.Fee = dr["Fee"].ToString();
fitModel.Remarks = dr["Remarks"].ToString();
return fitModel;
}
//更新维修信息
public bool UpdateFitInfo(FitModel fitModel)
{
string sqlString = "update fitment set ";
sqlString = sqlString + "HouseId='" + fitModel.HouseId + "',";
sqlString = sqlString + "Inform='" + fitModel.Inform + "',";
sqlString = sqlString + "Time='" + fitModel.Time + "',";
sqlString = sqlString + "Result='" + fitModel.Result + "',";
sqlString = sqlString + "Type='" + fitModel.Type + "',";
sqlString = sqlString + "Fee='" + fitModel.Fee + "',";
sqlString = sqlString + "Remarks='" + fitModel.Remarks + "'";
sqlString += "where HouseId=" + fitModel.HouseId;
if (DBoperator.ExecuteNonQuery(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null) < 0)
{
this.errMessage = "更新维修信息时发生了错误";
return false;
}
return true;
}
代码如下:
public partial class Admin_fitEdit : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
/*验证是否登陆了系统*/
if (Session["adminFlag"] == null)
{
Response.Write("<script>top.location.href='../Login.aspx';</script>");
return;
}
}
InitView();
}
protected void Btn_Update_Click(object sender, EventArgs e)
{
//建立维修数据模型
string houseId = Request.QueryString["HouseId"];
FitModel fitModel = new FitModel();
fitModel.HouseId = Request.QueryString["HouseId"];
fitModel.Inform = this.Inform.Text;
fitModel.Time = this.Time.Text;
fitModel.Result = this.Result.Text;
fitModel.Type = this.Type.Text;
fitModel.Fee = this.Fee.Text;
fitModel.Remarks = this.Remarks.Text;
//执行维修信息的更新
FitLogic fitLogic = new FitLogic();
if (fitLogic.UpdateFitInfo(fitModel))
{
Response.Write("<script>alert('维修信息更新成功!');location.href='fitEdit.aspx?HouseId=" + houseId + "';</script>");
}
else
{
Response.Write("<script>alert('" + fitLogic.ErrMessage + "');</script>");
}
}
private void InitView()
{
string houseId = Request.QueryString["HouseId"];
FitLogic fitLogic = new FitLogic();
FitModel fitModel = fitLogic.GetFitInfo(houseId);
this.HouseId.Text = fitModel.HouseId;
this.Inform.Text = fitModel.Inform;
this.Time.Text = fitModel.Time;
this.Result.Text = fitModel.Result;
this.Type.Text = fitModel.Type;
this.Fee.Text = fitModel.Fee;
this.Remarks.Text = fitModel.Remarks;
}
protected void Btn_Cancle_Click(object sender, EventArgs e)
{
Response.Write("<script>location.href='fitment.aspx';</script>");
}
}
=============
GetFitInfo和UpdateFitInfo在FitLogic类里面
public FitModel GetFitInfo(string houseId)
{
string sqlString = "select * from fitment where HouseId=" + houseId;
DataSet ds = DBoperator.GetDataSet(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null);
if (ds.Tables[0].Rows.Count == 0) return null;
DataRow dr = ds.Tables[0].Rows[0];
FitModel fitModel = new FitModel();
fitModel.HouseId = dr["HouseId"].ToString();
fitModel.Inform = dr["Inform"].ToString();
fitModel.Time = dr["Time"].ToString();
fitModel.Result = dr["Result"].ToString();
fitModel.Type = dr["Type"].ToString();
fitModel.Fee = dr["Fee"].ToString();
fitModel.Remarks = dr["Remarks"].ToString();
return fitModel;
}
//更新维修信息
public bool UpdateFitInfo(FitModel fitModel)
{
string sqlString = "update fitment set ";
sqlString = sqlString + "HouseId='" + fitModel.HouseId + "',";
sqlString = sqlString + "Inform='" + fitModel.Inform + "',";
sqlString = sqlString + "Time='" + fitModel.Time + "',";
sqlString = sqlString + "Result='" + fitModel.Result + "',";
sqlString = sqlString + "Type='" + fitModel.Type + "',";
sqlString = sqlString + "Fee='" + fitModel.Fee + "',";
sqlString = sqlString + "Remarks='" + fitModel.Remarks + "'";
sqlString += "where HouseId=" + fitModel.HouseId;
if (DBoperator.ExecuteNonQuery(DBoperator.CONN_STRING_NON_DTC, CommandType.Text, sqlString, null) < 0)
{
this.errMessage = "更新维修信息时发生了错误";
return false;
}
return true;
}
...全文
相关推荐
asp.net中GridView控件遍历的小例子
在asp.net中要遍历像数据之类的内容我们一般会用到for,foreach,while这种了,下面我来介绍利用for遍历GridView控件
asp.net中GridView编辑,更新,合计用法示例
主要介绍了asp.net中GridView编辑,更新,合计用法,结合实例形式分析了asp.net中GridView常见的操作技巧,具有一定参考借鉴价值,需要的朋友可以参考下
asp.net_合并GridView中某列相同信息的行(单元格
asp.net_合并GridView中某列相同信息的行
ASP.NET Gridview与checkbox全选、全不选实现代码
ASP.NET Gridview checkbox全选与全不选实现代码,其实原理就是利用js来实现的,但需要简单的设置下回传。
gridview在aspx中的不分层的增删改查
关于gridview不分层的增删改成, 里面有数据库, 还有关于性别如果在数据库中大小为1,但要显示中文的方法 还有dropdownlist的使用


