更新访问数据库

本文关键字:数据库 访问 更新 | 更新日期: 2023-09-27 18:11:12

我有页面在Page_Load我填充一些文本框和下拉列表与数据我从数据库中获得,我得到的数据正确,但当我点击按钮保存新数据它采取旧数据,而不是更新的新数据。

我把我的代码:Page_load:

string id = Request.QueryString["id"];
        OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath("path to DB"));
        OleDbCommand comm = new OleDbCommand("select * from table where ID=" + id, conn);
        OleDbDataReader reader;
        conn.Open();
        reader = comm.ExecuteReader();
        reader.Read();

        ddlType.SelectedIndex = (Convert.ToInt32(reader["PersonType"]) - 1); // -1 to fix position, list is zero based. type 1(0) = PP type 2(1) = DC
        txtFirstName.Text = reader["FirstName"].ToString();
        txtLastName.Text = reader["LastName"].ToString();
        txtAddress.Text = reader["Address"].ToString();
        txtCountry.Text = reader["Country"].ToString();
        txtPhone.Text = reader["Phone"].ToString();
        txtFax.Text = reader["Fax"].ToString();
        txtClinic.Text = reader["Clinic"].ToString();
        txtReferredBy.Text = reader["ReferingFactor"].ToString();
        txtWebSite.Text = reader["WebSite"].ToString();
        txtReceiptNumber.Text = reader["Receipt"].ToString();
        txtDeviceType.Text = reader["DeviceType"].ToString();
        txtDeviceSerialNumber.Text = reader["DeviceSerialNumber"].ToString();
        txtPaymentType.Text = reader["PaymentType"].ToString();
        txtDevicePrice.Text = reader["DevicePrice"].ToString();
        txtClientUserName.Text = reader["PersonUserName"].ToString();
        txtClientPassword.Text = reader["PersonPassword"].ToString();
        txtComments.Text = reader["Comment"].ToString();

保存按钮:

string personType = ddlType.SelectedValue;
        string firstName = txtFirstName.Text;
        string lastName = txtLastName.Text;
        string address = txtAddress.Text;
        string country = txtCountry.Text;
        string phone = txtPhone.Text;
        string fax = txtFax.Text;
        string clinic = txtClinic.Text;
        string referredBy = txtReferredBy.Text;
        string website = txtWebSite.Text;
        string receiptNumber = txtReceiptNumber.Text;
        string deviceType = txtDeviceType.Text;
        string deviceSerialNumber = txtDeviceSerialNumber.Text;
        string paymentType = txtPaymentType.Text;
        string devicePrice = txtDevicePrice.Text;
        string clientUserName = txtClientUserName.Text;
        string clientPassword = txtClientPassword.Text;
        string comments = txtComments.Text;

        string id = Request.QueryString["id"];
        OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath("path to DB"));
        string str = "update table set PersonType = ?, FirstName = ?, LastName = ?, Address = ?, Country = ?, Phone = ?, Fax = ?, Clinic = ?, ReferingFactor = ?, WebSite = ?, Receipt = ?, DeviceType = ?, DeviceSerialNumber = ?, PaymentType = ?, DevicePrice = ?,PersonUserName = ?, PersonPassword = ?, Comment = ? where ID = ?";
        using (conn)
        {
            using (OleDbCommand cmd = new OleDbCommand(str, conn))
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("PersonType", personType);
                cmd.Parameters.AddWithValue("FirstName", firstName);
                cmd.Parameters.AddWithValue("LastName", lastName);
                cmd.Parameters.AddWithValue("Address", address);
                cmd.Parameters.AddWithValue("Country", country);
                cmd.Parameters.AddWithValue("Phone", phone);
                cmd.Parameters.AddWithValue("Fax", fax);
                cmd.Parameters.AddWithValue("Clinic", clinic);
                cmd.Parameters.AddWithValue("ReferingFactor", referredBy);
                cmd.Parameters.AddWithValue("WebSite", website);
                cmd.Parameters.AddWithValue("Receipt", receiptNumber);
                cmd.Parameters.AddWithValue("DeviceType", deviceType);
                cmd.Parameters.AddWithValue("DeviceSerialNumber", deviceSerialNumber);
                cmd.Parameters.AddWithValue("PaymentType", paymentType);
                cmd.Parameters.AddWithValue("DevicePrice", devicePrice);
                cmd.Parameters.AddWithValue("PersonUserName", clientUserName);
                cmd.Parameters.AddWithValue("PersonPassword", clientPassword);
                cmd.Parameters.AddWithValue("Comment", comments);
                cmd.Parameters.AddWithValue("PersonID", id);
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }

我做错了什么,我如何使它正确?对不起,如果这个问题之前,但我没有找到答案。我觉得它有回发功能,对吗?

如果你需要更多的信息,请写信给我。谢谢(我编辑命令字符串上的一些单词)

更新访问数据库

您必须使用Page。IsPostback类似

的属性
protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
             // Put your code inside this.
             string id = Request.QueryString["id"];
             OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath("path to DB"));
    OleDbCommand comm = new OleDbCommand("select * from table where ID=" + id, conn);
    OleDbDataReader reader;
    conn.Open();
    reader = comm.ExecuteReader();
    reader.Read();
    ddlType.SelectedIndex = (Convert.ToInt32(reader["PersonType"]) - 1); // -1 to fix position, list is zero based. type 1(0) = PP type 2(1) = DC
    txtFirstName.Text = reader["FirstName"].ToString();
    txtLastName.Text = reader["LastName"].ToString();
    txtAddress.Text = reader["Address"].ToString();
    txtCountry.Text = reader["Country"].ToString();
    txtPhone.Text = reader["Phone"].ToString();
    txtFax.Text = reader["Fax"].ToString();
    txtClinic.Text = reader["Clinic"].ToString();
    txtReferredBy.Text = reader["ReferingFactor"].ToString();
    txtWebSite.Text = reader["WebSite"].ToString();
    txtReceiptNumber.Text = reader["Receipt"].ToString();
    txtDeviceType.Text = reader["DeviceType"].ToString();
    txtDeviceSerialNumber.Text = reader["DeviceSerialNumber"].ToString();
    txtPaymentType.Text = reader["PaymentType"].ToString();
    txtDevicePrice.Text = reader["DevicePrice"].ToString();
    txtClientUserName.Text = reader["PersonUserName"].ToString();
    txtClientPassword.Text = reader["PersonPassword"].ToString();
    txtComments.Text = reader["Comment"].ToString();
            }
        }

这是因为您正在将旧值传递给数据库。

在更新查询中传递文本框中的新值。

示例:

OleDbConnection conn = new OleDbConnection(@"Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + Server.MapPath("path to DB"));
        string str = "update table set PersonType = ?, FirstName = ?, LastName = ?, Address = ?, Country = ?, Phone = ?, Fax = ?, Clinic = ?, ReferingFactor = ?, WebSite = ?, Receipt = ?, DeviceType = ?, DeviceSerialNumber = ?, PaymentType = ?, DevicePrice = ?,PersonUserName = ?, PersonPassword = ?, Comment = ? where ID = ?";
        using (conn)
        {
            using (OleDbCommand cmd = new OleDbCommand(str, conn))
            {
                cmd.CommandType = CommandType.Text;
                cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);
                cmd.Parameters.AddWithValue("LastName", lastName);
                .
                .
                .
            }
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();

当页面第一次加载时,你应该加载数据到控件

if (!IsPostBack)
            {
txtFirstName.Text = reader["FirstName"].ToString();
        txtLastName.Text = reader["LastName"].ToString();
        txtAddress.Text = reader["Address"].ToString();
        txtCountry.Text = reader["Country"].ToString();
        txtPhone.Text = reader["Phone"].ToString();
        txtFax.Text = reader["Fax"].ToString();
        txtClinic.Text = reader["Clinic"].ToString();
        txtReferredBy.Text = reader["ReferingFactor"].ToString();
        txtWebSite.Text = reader["WebSite"].ToString();
        txtReceiptNumber.Text = reader["Receipt"].ToString();
        txtDeviceType.Text = reader["DeviceType"].ToString();
        txtDeviceSerialNumber.Text = reader["DeviceSerialNumber"].ToString();
        txtPaymentType.Text = reader["PaymentType"].ToString();
        txtDevicePrice.Text = reader["DevicePrice"].ToString();
        txtClientUserName.Text = reader["PersonUserName"].ToString();
        txtClientPassword.Text = reader["PersonPassword"].ToString();
        txtComments.Text = reader["Comment"].ToString();
    }