62,046
社区成员
发帖
与我相关
我的任务
分享
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;
using DevExpress.Web.ASPxGridView;
using System.Data.SqlClient;
using cn.xzcj.utility.database;
public partial class sys_province_modifyProvince : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
//if (!Page.IsPostBack)
//{
//}
bindTitle();
}
//protected void Page_PreInit(object sender, EventArgs e)
//{
// bindTitle();
//}
protected void Button2_Click(object sender, EventArgs e)
{
GridViewEditFormTemplateContainer container = this.NamingContainer as GridViewEditFormTemplateContainer;
ASPxGridView tmpleteGrid = container.Grid;
tmpleteGrid.CancelEdit();
}
private void saveEdit()
{
string old_province_name = old_provinceName.Value.ToString();
int old_province_id = Convert.ToInt32(old_provinceId.Value.ToString());
string provinceName = province_name.Text.ToString();
Response.Write("--------11-----"+area_name.Text.ToString());
Response.Write("--------222-----" + area_name.TextField.ToString());
String strSql = "update province set province_name=@province_name ,kid = @kid ,area_id =@area_id,area_name =@area_name where province_id=@province_id ";
string sql_city = "update city set province_name ='" + provinceName + "' ,province_id =" + old_province_id + " where province_name ='" + old_province_name + "'";
String[] value = { province_name.Text, kid.Value,area_name.Value.ToString(),area_name.Text.ToString(), province_id.Value };
DoDataBase1 ddb = new DoDataBase1();
SqlParameter[] param = ddb.getSqlToParameter(strSql, value);
ddb.execNoResultSql(strSql, param);
ddb.ExecuteSQL(sql_city);
}
protected void Button1_Click(object sender, EventArgs e)
{
GridViewEditFormTemplateContainer container = this.NamingContainer as GridViewEditFormTemplateContainer;
ASPxGridView tmpleteGrid = container.Grid;
saveEdit();
// tmpleteGrid.DataBind();
tmpleteGrid.DataBind();
tmpleteGrid.CancelEdit();
}
private void bindTitle()
{//对一个下拉列表的数据绑定, textfield和valuefield属性
DoDataBase1 db = new DoDataBase1();
DataSet ds = new DataSet();
string sql = "select area_id,area_name from area";
ds = db.GetDataSet(sql);
this.area_name.DataSource = ds;
this.area_name.TextField = "area_name";
this.area_name.ValueField = "area_id";
this.area_name.DataBindItems();
}
}