using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace model3
{

public partial class UpdateData : System.Web.UI.Page
{
//protected System.Web.UI.WebControls.TextBox TextBox1;
//protected System.Web.UI.WebControls.TextBox TextBox2;
//protected System.Web.UI.WebControls.Button Button1;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{ showDBData();}
}
private void showDBData()
{
string accessString = ConfigurationSettings.AppSettings["accessconnectionstring"].ToString() + Server.MapPath("MyFirstAccessDB.mdb");
OleDbConnection conn = new OleDbConnection(accessString);
string cmdText = "select * from MyDataTable";

OleDbCommand cmd = new OleDbCommand(cmdText,conn);

string dataString = "<br>MyID MyName MyType MyLength<br>";

try
{
conn.Open();
Response.Write("连接数据库成功");

OleDbDataReader reca = cmd.ExecuteReader();

while(reca.Read())
{
dataString += reca["MyID"].ToString() + " " + reca["MyName"].ToString() + " " + reca["MyType"].ToString() + " " + reca["MyLength"].ToString();
dataString+="<br>";
}
reca.Close();
Response.Write(dataString);
conn.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
private void Button1_Click(object sender,EventArgs e)
{
if (TextBox1.Text.Trim().Length > 0 && TextBox2.Text.Trim().Length > 0)
{
UpdataDBData(TextBox1.Text.Trim(), TextBox2.Text.Trim());
showDBData();
}
}
private void UpdataDBData(String myid,String myname)
{
string accessString = ConfigurationSettings.AppSettings["accessconnectionstring"].ToString() + Server.MapPath("MyFirstAccessDB.mdb");
string cmdText = "UPDATE MyDataTable SET MyName='"+myname+"'WHERE MyID="+myid;

OleDbConnection conn = new OleDbConnection(accessString);

OleDbCommand cmd = new OleDbCommand(cmdText,conn);

try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}

}
}


这是主页的代码, 数据库是access的很简单 相信你们高手大哥们会明白的
就是 单击按钮的时候更新不了 请高手赐教

我也是这样子的。不知道为什么。 也没有错误提示
---------------------------------
string id = lblid.Text.Trim();
string info = FreeTextBox1.Text;
int xu = Convert.ToInt32(txtxu.Text);
string Title = txtTitle.Text.Trim();
string class1 = txtclass1.Text.Trim();
string class2 = txtclass2.Text.Trim();
string class3 = txtclass3.Text.Trim();
DateTime dt =Convert.ToDateTime(txtdt.Text);

string DataPatch = ConfigurationManager.AppSettings["data"];
string ConnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;data source=" + HttpContext.Current.Server.MapPath(DataPatch);
Con = new OleDbConnection(ConnetionString);
cmd = new OleDbCommand("Update info set Title=@Title,xu=@xu,data=@dt,info=@info,class1=@class1,class2=@class2,class3=@class3 Where ID=@id", Con);
cmd.Parameters.Add(new OleDbParameter("@id", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@info", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@xu", OleDbType.Integer));
cmd.Parameters.Add(new OleDbParameter("@Title", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@class1", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@class2", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@class3", OleDbType.Char));
cmd.Parameters.Add(new OleDbParameter("@dt",OleDbType.Date));

cmd.Parameters["@id"].Value = id;
cmd.Parameters["@info"].Value = info;
cmd.Parameters["@xu"].Value = xu;
cmd.Parameters["@Title"].Value = Title;
cmd.Parameters["@class1"].Value = class1;
cmd.Parameters["@class2"].Value = class2;
cmd.Parameters["@class3"].Value = class3;
cmd.Parameters["@dt"].Value = dt;

Con.Open();
cmd.ExecuteNonQuery();
-------------------------------------------
这是我的代码

我找到答案了
你双击按钮后 在里面写代码 就好使了