Update ข้อมูลใหม่ ไม่ได้น่ะค่ะ ใช้ asp.net กับ C# ค่ะ database เป็น sql server ค่ะ ช่วยหน่อยนะคะ

if(!Page.IsPostBack())
{
// Bound Data
}

using System;
using System.Collections;
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;

public partial class Account_Account : System.Web.UI.Page
{
    public int intSAOID, intCompanyID, intAccountID;
    protected void Page_Load(object sender, EventArgs e)
    {
        if ((String)Session["Username"] == null)
        {
            Response.Redirect("http://192.168.1.20/CRM/Warning.aspx");
        }
        else
        {
            if (Request.QueryString["SAOID"] != null || Request.QueryString["CompanyID"] != null) // receive value from View_Computer.aspx page
            {
                intSAOID = Int32.Parse(Request.QueryString["SAOID"]);
                intCompanyID = Int32.Parse(Request.QueryString["CompanyID"]);

                txtbox.Text = intSAOID.ToString(); /// for pass value
                txtbox2.Text = intCompanyID.ToString(); /// for pass value
            }

            DataSetCRMTableAdapters.CompanyTableAdapter dsCompany = new DataSetCRMTableAdapters.CompanyTableAdapter();
            DataTable dtCompany = dsCompany.GetDataByCompanyID(intCompanyID);
            DataRow drCompany = dtCompany.Rows[0];
            lbCompanyName.Text = drCompany["CompanyName"].ToString();



            DataSetCRMTableAdapters.AccountTableAdapter dtAccount = new DataSetCRMTableAdapters.AccountTableAdapter();
            DataTable dsAccount = dtAccount.GetDataByCompanyID(intCompanyID);
            

            if (dsAccount.Rows.Count > 0)
            {
                DataRow drAccount = dsAccount.Rows[0];
                txtCreditLimit.Text = drAccount["CreditLimit"].ToString();
                txtCreditDay.Text = drAccount["CreditDay"].ToString();
                txtPutBillDate.Text = drAccount["PutBillDate"].ToString();
                txtPutBillPlace.Text = drAccount["PutBillPlace"].ToString();
                txtPutBillTime.Text = drAccount["PutBillTime"].ToString();
                txtReceiveCheckDate.Text = drAccount["ReceiveCheckDate"].ToString();
                txtReceiveCheckPlace.Text = drAccount["ReceiveCheckPlace"].ToString();
                txtReceiveCheckTime.Text = drAccount["ReceiveCheckTime"].ToString();
                txtOrderCycle.Text = drAccount["OrderCycle"].ToString();
            }

        }
    }
    protected void Button_Save_Click(object sender, EventArgs e)
    {

        DataSetCRMTableAdapters.AccountTableAdapter dsAccount = new DataSetCRMTableAdapters.AccountTableAdapter();
        DataTable dtAccount = dsAccount.GetDataByCompanyID(intCompanyID);
        if (dtAccount.Rows.Count > 0)
        {
            DataRow drViewAccount = dtAccount.Rows[0];
            intAccountID = int.Parse(drViewAccount["AccountID"].ToString());
            string CreditLimit = txtCreditLimit.Text.Trim();
            string CreditDay = txtCreditDay.Text.Trim();
            string PutBillDate = txtPutBillDate.Text.Trim();
            string PutBillTime = txtPutBillTime.Text.Trim();
            string PutBillPlace = txtPutBillPlace.Text.Trim();
            string ReceiveCheckDate = txtReceiveCheckDate.Text.Trim();
            string ReceiveCheckTime = txtReceiveCheckTime.Text.Trim();
            string ReceiveCheckPlace = txtReceiveCheckPlace.Text.Trim();
            string OrderCycle = txtOrderCycle.Text.Trim();

            dsAccount.UpdateQuery(CreditLimit, CreditDay, intCompanyID, PutBillDate, PutBillTime, PutBillPlace, ReceiveCheckDate, ReceiveCheckTime, ReceiveCheckPlace, OrderCycle, intAccountID);
            Response.Redirect("Account.aspx?SAOID=" + intSAOID + "&CompanyID=" + intCompanyID);
        }
        else
        {
            string CreditLimit = txtCreditLimit.Text.Trim();
            string CreditDay = txtCreditDay.Text.Trim();
            string PutBillDate = txtPutBillDate.Text.Trim();
            string PutBillTime = txtPutBillTime.Text.Trim();
            string PutBillPlace = txtPutBillPlace.Text.Trim();
            string ReceiveCheckDate = txtReceiveCheckDate.Text.Trim();
            string ReceiveCheckTime = txtReceiveCheckTime.Text.Trim();
            string ReceiveCheckPlace = txtReceiveCheckPlace.Text.Trim();
            string OrderCycle = txtOrderCycle.Text.Trim();

            dsAccount.Insert(CreditLimit, CreditDay, intCompanyID, PutBillDate, PutBillTime, PutBillPlace, ReceiveCheckDate, ReceiveCheckTime, ReceiveCheckPlace, OrderCycle);
        }

        

    }
    protected void Button_Back_Click(object sender, EventArgs e)
    {

    }

    protected void txtCreditLimit_TextChanged(object sender, EventArgs e)
    {

    }
}

    protected void Page_Load(object sender, EventArgs e)
    {
        if ((String)Session["Username"] == null)
        {
            Response.Redirect("http://192.168.1.20/CRM/Warning.aspx");
        }
        else
        {

            if (Request.QueryString["SAOID"] != null || Request.QueryString["CompanyID"] != null) // receive value from View_Computer.aspx page
            {
                intSAOID = Int32.Parse(Request.QueryString["SAOID"]);
                intCompanyID = Int32.Parse(Request.QueryString["CompanyID"]);

                txtbox.Text = intSAOID.ToString(); /// for pass value
                txtbox2.Text = intCompanyID.ToString(); /// for pass value
            }

		if(!Page.IsPostBack)
		{

				    DataSetCRMTableAdapters.CompanyTableAdapter dsCompany = new DataSetCRMTableAdapters.CompanyTableAdapter();
				    DataTable dtCompany = dsCompany.GetDataByCompanyID(intCompanyID);
				    DataRow drCompany = dtCompany.Rows[0];
				    lbCompanyName.Text = drCompany["CompanyName"].ToString();



				    DataSetCRMTableAdapters.AccountTableAdapter dtAccount = new DataSetCRMTableAdapters.AccountTableAdapter();
				    DataTable dsAccount = dtAccount.GetDataByCompanyID(intCompanyID);
				    

				    if (dsAccount.Rows.Count > 0)
				    {
					DataRow drAccount = dsAccount.Rows[0];
					txtCreditLimit.Text = drAccount["CreditLimit"].ToString();
					txtCreditDay.Text = drAccount["CreditDay"].ToString();
					txtPutBillDate.Text = drAccount["PutBillDate"].ToString();
					txtPutBillPlace.Text = drAccount["PutBillPlace"].ToString();
					txtPutBillTime.Text = drAccount["PutBillTime"].ToString();
					txtReceiveCheckDate.Text = drAccount["ReceiveCheckDate"].ToString();
					txtReceiveCheckPlace.Text = drAccount["ReceiveCheckPlace"].ToString();
					txtReceiveCheckTime.Text = drAccount["ReceiveCheckTime"].ToString();
					txtOrderCycle.Text = drAccount["OrderCycle"].ToString();
				    }
		}

        }
    }