当update后 如何自动刷新本页 显示刚刚update后的数据?
来源:百度知道 编辑:UC知道 时间:2024/09/20 09:29:59
if (Page.IsPostBack)
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("paiches.mdb");
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
string fff = Request.QueryString["f"].ToString();
if (fff == "")
return;
string nums = Request.QueryString["num"].ToString();
string userren = "";
if(fff=="go")
{
string sql;
sql = "update car set gotime=now(),backtime=null where num='" + nums + "'";
OleDbCommand MyComm = new OleDbCommand(sql, MyConn);
MyComm.ExecuteNonQuery();
MyConn.Close();
详细点呐。。。。。。
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("paiches.mdb");
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
string fff = Request.QueryString["f"].ToString();
if (fff == "")
return;
string nums = Request.QueryString["num"].ToString();
string userren = "";
if(fff=="go")
{
string sql;
sql = "update car set gotime=now(),backtime=null where num='" + nums + "'";
OleDbCommand MyComm = new OleDbCommand(sql, MyConn);
MyComm.ExecuteNonQuery();
MyConn.Close();
详细点呐。。。。。。
照着你的思路来的.修完在绑下数据
string sql;
sql = "update car set gotime=now(),backtime=null where num='" + nums + "'";
OleDbCommand MyComm = new OleDbCommand(sql, MyConn);
MyComm.ExecuteNonQuery();
MyComm.CommandText = "select * from car";
OleDbDataReader dr = MyComm.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
MyConn.Close();
----------------------------------------
在重新绑定一边数据
你修改完后,在从数据库里面把数据提出一边来.绑定到你要绑定的地方.