Question

使用gridview更新数据，不能显示更新后的数据

using System;
using System.Configuration;
using System.Data;
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.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
DataSet GetDataSet()
{
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = "Persist security info=false;User id=saa;pwd=saa;database=Northwind;server=(local)";
myCon.Open();

SqlCommand selectCMD = new SqlCommand("SELECT top 10 CustomerID,CompanyName,Address FROM Customers", myCon);

SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = selectCMD;

DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");

myCon.Close();
return custDS;
}
void LoadData()
{
DataSet ds = GetDataSet();
GridView1.DataSource = ds;
GridView1.DataBind();
}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
LoadData();
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = "Persist security info=true;User id=saa;pwd=saa;database=Northwind;server=(local)";
myCon.Open();
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
string sql=
"update Customers set CompanyName='"
+((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString()
+"',Address='"
+ ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString()
+"'where CustomerID='"
+ GridView1.Rows[e.RowIndex].Cells[0].Text.ToString()+ "'";
myCom.CommandText = sql;

myCom.ExecuteNonQuery();
myCon.Close();
GridView1.EditIndex = -1;
LoadData();

}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
LoadData();
}
protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
LoadData();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}

}

Answer 1

if (!IsPostBack)
{
LoadData();
}

if去掉

Answer 2

((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString()

看看是不是这个取值有问题？

Answer 3

你确认数据库中的数据已经被你更新掉了嘛？

追问

没有被更新，怎么回事？