为什么我修改不了,程序错在哪里?
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
DataGrid1.DataSource=BindData();
DataGrid1.DataBind();
}
// 在此处放置用户代码以初始化页面
}
public DataSet BindData()
{
string DSN;
DSN=ConfigurationSettings.AppSettings["dsn"];
SqlConnection conn=new SqlConnection(DSN);
conn.Open();
string str="select * from province";
SqlDataAdapter comm=new SqlDataAdapter(str,conn);
DataSet ds=new DataSet();
comm.Fill(ds,"a");
return ds;
} public void Edit(object sender,DataGridCommandEventArgs e){
DataGrid1.EditItemIndex=Convert.ToInt32(e.Item.ItemIndex);
DataGrid1.DataSource=BindData();
DataGrid1.DataBind();
}
public void Update(object sender,DataGridCommandEventArgs e)
{
DataSet ds=BindData();
int Row=Convert.ToInt32(e.Item.ItemIndex);
TextBox EditText1=null;
EditText1=(TextBox)e.Item.FindControl("txtprovince");
ds.Tables[0].Rows[Row]["provincename"]=EditText1.Text;
DataGrid1.DataSource=ds;
DataGrid1.DataBind(); }
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
DataGrid1.DataSource=BindData();
DataGrid1.DataBind();
}
// 在此处放置用户代码以初始化页面
}
public DataSet BindData()
{
string DSN;
DSN=ConfigurationSettings.AppSettings["dsn"];
SqlConnection conn=new SqlConnection(DSN);
conn.Open();
string str="select * from province";
SqlDataAdapter comm=new SqlDataAdapter(str,conn);
DataSet ds=new DataSet();
comm.Fill(ds,"a");
return ds;
} public void Edit(object sender,DataGridCommandEventArgs e){
DataGrid1.EditItemIndex=Convert.ToInt32(e.Item.ItemIndex);
DataGrid1.DataSource=BindData();
DataGrid1.DataBind();
}
public void Update(object sender,DataGridCommandEventArgs e)
{
DataSet ds=BindData();
int Row=Convert.ToInt32(e.Item.ItemIndex);
TextBox EditText1=null;
EditText1=(TextBox)e.Item.FindControl("txtprovince");
ds.Tables[0].Rows[Row]["provincename"]=EditText1.Text;
DataGrid1.DataSource=ds;
DataGrid1.DataBind(); }
{
if(!IsPostBack)
{
DataGrid1.DataSource=BindData().Tables[0].DefaultView;
DataGrid1.DataBind();
}
// 在此处放置用户代码以初始化页面
}
public DataSet BindData()
{
string DSN;
DSN=ConfigurationSettings.AppSettings["dsn"];
SqlConnection conn=new SqlConnection(DSN);
conn.Open();
string str="select * from province";
SqlDataAdapter comm=new SqlDataAdapter(str,conn);
DataSet ds=new DataSet();
comm.Fill(ds,"a");
return ds;
} public void Edit(object sender,DataGridCommandEventArgs e){
DataGrid1.EditItemIndex=Convert.ToInt32(e.Item.ItemIndex);
DataGrid1.DataSource=BindData().Tables[0].DefaultView;
DataGrid1.DataBind();
}
public void Update(object sender,DataGridCommandEventArgs e)
{
DataSet ds=BindData();
int Row=Convert.ToInt32(e.Item.ItemIndex);
TextBox EditText1=null;
EditText1=(TextBox)e.Item.FindControl("txtprovince");
ds.Tables[0].Rows[Row]["provincename"]=EditText1.Text;
DataGrid1.DataSource=ds.Tables[0].DefaultView;
DataGrid1.DataBind(); }
可以使用 DataGrid1.DataSource = BindData().Tables[0].DefaultView;
int Row=Convert.ToInt32(e.Item.ItemIndex);
TextBox EditText1=null;
EditText1=(TextBox)e.Item.FindControl("txtprovince");
ds.Tables[0].Rows[Row]["provincename"]=EditText1.Text;
____----------------
加上 da.update(ds);
___________________-----