<script type="text/javascript">

var xmlhttpfunction loadXMLDoc(url)

{

// code for Mozilla, etc.

if (window.XMLHttpRequest)

  {

  xmlhttp=new XMLHttpRequest()

  xmlhttp.onreadystatechange=xmlhttpChange

  xmlhttp.open("GET",url,true)

  xmlhttp.send(null)

  }

// code for IE

else if (window.ActiveXObject)

  {

  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP")

    if (xmlhttp)

    {

    xmlhttp.onreadystatechange=xmlhttpChange

    xmlhttp.open("GET",url,true)

    xmlhttp.send()

    }

  }

}

 

function xmlhttpChange()

{

// if xmlhttp shows "loaded"

if (xmlhttp.readyState==4)

  {

  // if "OK"

  if (xmlhttp.status==200)

    {

    // ...some code here...

    }

  else

    {

    alert("Problem retrieving XML data")

    }

  }

}

</script>

Ajax.Utility.RegisterTypeForAjax(typeof(AjaxMethod)); if(!Page.IsPostBack) { this.DropDownList1.DataSource=AjaxMethod.GetPovinceList(); this.DropDownList1.DataTextField="province"; this.DropDownList1.DataValueField="provinceID"; this.DropDownList1.DataBind(); this.DropDownList1.Attributes.Add("onchange","cityResult();"); } 用下面的类来操作数据 using System; using System.Data; using System.Data.SqlClient; namespace AjaxTest { ///

/// Summary description for AjaxMethod. ///

public class AjaxMethod { #region GetPovinceList public static DataSet GetPovinceList() { string sql="select * from province"; return GetDataSet(sql); } #endregion #region GetCityList [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] public DataSet GetCityList(int povinceid) { string sql="select * from city where father="+povinceid; return GetDataSet(sql); } #endregion #region GetAreaList [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)] public DataSet GetAreaList(int cityid) { string sql="select * from area where father="+cityid; return GetDataSet(sql); } #endregion #region GetDataSet public static DataSet GetDataSet(string sql) { string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]; SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString); DataSet ds=new DataSet(); sda.Fill(ds); return ds; } #endregion } }

SqlTransaction st;
   SqlConnection con;
   SqlCommand cmdUpdateA;
   SqlCommand cmdUpdateB;
   con=new SqlConnection("Server=.;database=gggcorn;uid=sa;pwd=");
   cmdUpdateA=new SqlCommand("update data set Datas='"+this.TextBox3.Text+"'where ID=1 ",con);
   cmdUpdateB=new SqlCommand("update data set Datas='"+this.TextBox3.Text+"'where ID=2 ",con);
   con.Open();
   st=con.BeginTransaction();
   cmdUpdateA.Transaction=st;
   cmdUpdateB.Transaction=st;
   try
   {
    cmdUpdateA.ExecuteNonQuery();
    cmdUpdateB.ExecuteNonQuery();
    st.Commit();
    this.Response.Write("<script>alert('success');</script>");
   }
   catch(Exception ex)
   {
    st.Rollback();
    this.Response.Write("<script>alert('fail');</script>");
   }
   finally
   {
    con.Close();
   }