老问题~~又是gridview数据无法取得新值的问题~急

大家好！！我是新手，可是我为了这个问题已经一个礼拜睡不好了。哪位仁兄能拔刀相助一下呢？？这个gridview在rowupdating事件里面就是取不到新值呢~~书上很多都是把控件一拉就得了。很少有介绍直接用代码来的，大家看一下我的程序吧直接能运行的******************
ASP.NET页面<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <fieldset>
                <legend>使用ObjectDataSource控件绑定数据访问层</legend>
                <table>
                   <tr>
                      <td>选择地区：<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" >
                                    </asp:DropDownList>
                      </td>
                   </tr>
                   <tr>
                      <td>
                          <asp:GridView ID="GridView1" runat="server" AllowPaging="True" PageSize="5"  OnPageIndexChanging="GridView1_PageIndexChanging" AutoGenerateEditButton="True" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" AutoGenerateColumns="False" >
                              <Columns>
                                  <asp:BoundField DataField="au_id" HeaderText="au_id" />
                                  <asp:BoundField DataField="au_lname" HeaderText="au_lname" />
                                  <asp:BoundField DataField="au_fname" HeaderText="au_fname" />
                                  <asp:BoundField DataField="state" HeaderText="state" />
                              </Columns>
                          </asp:GridView>
                      </td>
                   </tr>
                </table>
               
                
            </fieldset>
        </div>
    </form>
</body>
</html>***********************
页面后台Default5.aspx.cs
public partial class Default5 : System.Web.UI.Page
{
    ObjectDataSource objds2;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ObjectDataSource objds1 = new ObjectDataSource("Class1", "GetDropStates");;
            DropDownList1.DataSource = objds1;
            DropDownList1.DataTextField = "state";
            DropDownList1.DataBind();
            DropDownList1.SelectedIndex = 0;
            GridView1.DataBind();
           
        }
        objds2 = new ObjectDataSource("Class1", "GetAuthors");
        objds2.SelectParameters.Add("state", DropDownList1.SelectedItem.Text);
        objds2.UpdateMethod = "UpdateAuthors";
        GridView1.DataSource = objds2;
         GridView1.DataBind();
        
    }    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        GridView1.DataBind();    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    { 
  ////
  ////就是在这边都是取到原来的值
//////
        objds2.UpdateParameters.Add("au_id", ((TextBox)GridView1.Rows[e.RowIndex ].Cells[1].Controls[0]).Text);
        objds2.UpdateParameters.Add("au_lname", ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text);
        objds2.UpdateParameters.Add("au_fname", ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text);
        objds2.UpdateParameters.Add("state", ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text);
        objds2.Update();
        GridView1.EditIndex = -1;
        GridView1.DataBind();
    }
}*********************
数据访问层Class1.cs(也就是App_Code文件夹里的)
using System.Data.SqlClient;
public class Class1
{
public Class1()
{

}    public DataTable GetDropStates()
    {
        ConnectionStringSettings constr = ConfigurationManager.ConnectionStrings["pubConnectionString"];
        if (constr != null)
        {
            string selstr = "select distinct state from authors";
            SqlConnection sqlcon = new SqlConnection(constr.ConnectionString);
            SqlDataAdapter sqlad = new SqlDataAdapter(selstr, sqlcon);
            DataTable dt = new DataTable("state");
            sqlad.Fill(dt);
            return dt;
        }
        else
            return null;
    }    public DataTable GetAuthors(string state)
    {
        ConnectionStringSettings constr = ConfigurationManager.ConnectionStrings["pubConnectionString"];
        if (constr != null)
        {
            string selstr = "select au_id,au_lname,au_fname,state from authors where state=@state";
            SqlConnection sqlcon = new SqlConnection(constr.ConnectionString);
            SqlCommand sqlcom = new SqlCommand();
            sqlcom.Connection = sqlcon;
            sqlcom.CommandType = CommandType.Text;
            sqlcom.CommandText = selstr;
            sqlcom.Parameters.Add("@state", SqlDbType.Char).Value = state;
            SqlDataAdapter sqlad = new SqlDataAdapter(sqlcom);
            DataTable dt = new DataTable("authors");
            sqlad.Fill(dt);
            return dt;
        }
        else
            return null;
    }    public int UpdateAuthors(string au_id,string au_lname,string au_fname,string state)
    {
        ConnectionStringSettings constr = ConfigurationManager.ConnectionStrings["pubConnectionString"];
        if (constr != null)
        {
            string selstr = "update authors set au_lname=@au_lname,au_fname=@au_fname,state=@state where au_id=@au_id";
            SqlConnection sqlcon = new SqlConnection(constr.ConnectionString);
            SqlCommand sqlcom = new SqlCommand();
            sqlcom.Connection = sqlcon;
            sqlcom.CommandType = CommandType.Text;
            sqlcom.CommandText = selstr;
            sqlcom.Parameters.Add("@au_lname", SqlDbType.Char).Value = au_lname;
            sqlcom.Parameters.Add("@au_fname", SqlDbType.Char).Value = au_fname;
            sqlcom.Parameters.Add("@state", SqlDbType.Char).Value = state;
            sqlcom.Parameters.Add("@au_id", SqlDbType.Char).Value = au_id;
            sqlcon.Open();
            int rowaffect=sqlcom.ExecuteNonQuery();
            sqlcon.Close();
            return rowaffect;
        }
        else
            return -1;
    }
}******************
Web.config文件<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings>
 
    <add name="pubConnectionString" connectionString="data source=(local);database=pubs;integrated security=sspi"/>
 </connectionStrings>
 
<system.web>
    <httpRuntime maxRequestLength="6000" />
   
    
<compilation debug="true"/>
<authentication mode="Windows"/>

</system.web></configuration>

解决方案 »

  1.   

    objds2.UpdateParameters.Add("au_id", ……
    程序没看出什么问题，是不是参数有问题，对于SqlServer一般都为@au_id
      

  2.   

    这个objds2.UpdateParameters.Add("au_id", ……不是把参数直接添加到sql语句中的，而是添加到数据访问层的updateauthors方法中的参数中的，而updateauthors方法再把那些值赋给sql语句中的“@au_id”这边不会发生异常的就是你修改记录以后更新不了。
      

  3.   

    GridView用法
    public partial class _Default : System.Web.UI.Page 
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.BindToGridView();
            }
        }
        //定义绑定
        private void BindToGridView()
        {
            SqlConnection conn = DB.Createconn();
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = new SqlCommand("select * from newstype order by typeID", conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "newstype");
            this.GridView1.DataKeyNames = new string[] { "typeid" };
            this.GridView1.DataSource = ds.Tables["newstype"];
            this.GridView1.DataBind();
            conn.Close();
        }
        //添加记录
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            SqlConnection conn = DB.Createconn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("insert into newsType(typeName) values('"+this.txtTypeName.Text+"')",conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            this.txtTypeName.Text = "";
            this.BindToGridView();
        }
        //分页
        protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            this.GridView1.PageIndex = e.NewPageIndex;
            this.BindToGridView();
        }
        //编辑记录
        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
        {
            this.GridView1.EditIndex = e.NewEditIndex;
            this.BindToGridView();
        }
        //更新记录
        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            TextBox tb = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");
            string typeId = this.GridView1.DataKeys[e.RowIndex].Values[0].ToString();
            SqlConnection conn = DB.Createconn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("update newstype set typeName='"+tb.Text+"' where typeid=" + typeId, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            this.GridView1.EditIndex = -1;
            this.BindToGridView();
        }
        //删除记录
        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            string typeId = this.GridView1.DataKeys[e.RowIndex].Values[0].ToString();
            SqlConnection conn = DB.Createconn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("delete from newstype where typeid="+typeId, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
           
            this.BindToGridView();
        }
        //编辑时的取消
        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            this.GridView1.EditIndex = -1;
            this.BindToGridView();
        }
        //排序处理程序
        protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
        {
            string sortExpression = e.SortExpression;
            if (GridViewSortDirection == SortDirection.Ascending)
            {
                GridViewSortDirection = SortDirection.Descending;
                SortGridView(sortExpression, "DESC");
            }
            else
            {
                GridViewSortDirection = SortDirection.Ascending;
                SortGridView(sortExpression, "ASC");         }
        }
        //存储选定列当前排序状态     public SortDirection GridViewSortDirection
        {
            get
            {
                if (ViewState["sortDirection"] == null)
                    ViewState["sortDirection"] = SortDirection.Ascending;
                return (SortDirection)ViewState["sortDirection"];
            }
            set { ViewState["sortDirection"] = value; }
         }
         /// 排序并绑定     private void SortGridView(string sortExpression, string direction)
         {
             SqlConnection conn = DB.Createconn();
             conn.Open();
             SqlDataAdapter sda = new SqlDataAdapter();
             sda.SelectCommand = new SqlCommand("select * from newstype order by typeID", conn);
             DataSet ds = new DataSet();
             sda.Fill(ds, "newstype");
             DataTable dt = ds.Tables["newstype"];
            DataView dv = new DataView(dt);        dv.Sort = sortExpression + " " + direction;         GridView1.DataSource = dv;
             GridView1.DataBind();
             conn.Close();
        }    //删除加确认
        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                e.Row.Cells[3].Attributes.Add("onclick","Javascript:return confirm('确认删除\""+e.Row.Cells[1].Text+"\"吗？')");
            }
        }
    } 
      

  4.   

    好谢谢楼上的给了我点灵感~~也谢谢大家我是菜鸟。。忘记了ASP.NET页面是无状态的页面了。。真是的~~！！
        本来是已经解决了我之前是用session保存一个状态值当页面加载时检测到这个状态值时就不绑定数据。现在找到了比较好的方法谢谢了哦
        结贴~~