指定的参数已超出有效值的范围。

Skrr. 2019-05-07 12:33:42

请教下大佬帮忙看下，我这个改了很多次一直都是指定的参数已超出有效值的范围。。

点击编辑，更新列表出错。。



 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        ///方法一：需改进

    //    string sqlstr = "update Teacher set teacher_id='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',teacher_name='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',teacher_sex='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',DepartmentName='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',Position='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',Telephone='"

    //+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "' where teacher_id='"

    //+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

    //    mycom = new SqlCommand(sqlstr,myconn);

    //    mycom.ExecuteNonQuery();

    //    GridView1.EditIndex = -1;

    //    tech_show();

        ///方法二：

        //当前更新的行数

        int index = e.RowIndex;

        //(重点)获取格子里面，第index行，第0号单元格里面第0个控件（也就是TextBox）强转，获取值

        string newsteach_id = ((TextBox)this.GridView1.Rows[index].Cells[0].Controls[0]).Text.ToString();

        string newsteach_name = ((TextBox)this.GridView1.Rows[index].Cells[1].Controls[0]).Text.ToString();

        string newsteach_sex = ((TextBox)this.GridView1.Rows[index].Cells[2].Controls[0]).Text.ToString();

        string newsteach_xibu = ((TextBox)this.GridView1.Rows[index].Cells[3].Controls[0]).Text.ToString();

        string newsteach_zhicheng = ((TextBox)this.GridView1.Rows[index].Cells[4].Controls[0]).Text.ToString();

        string newsteach_tel = ((TextBox)this.GridView1.Rows[index].Cells[5].Controls[0]).Text.ToString();

        //这里的id是绑定上去的主键

        int id = Convert.ToInt32(this.GridView1.DataKeys[index].Value);

        ////////////////////////

        GridView1.EditIndex = -1;

        myconn.Open();

        string str = "select * from Teacher";

        mydata = new SqlDataAdapter(str, myconn);

        myset = new DataSet();

        mydata.Fill(myset, "teacher");

        DataTable dt = myset.Tables["teacher"];

        dt.PrimaryKey = new DataColumn[] { dt.Columns["teacher_id"] };

        DataRow dr = dt.Rows.Find(id);

        dr["teacher_id"] = newsteach_id;

        dr["teacher_name"] = newsteach_name;

        dr["teacher_sex"] = newsteach_sex;

        dr["DepartmentName"] = newsteach_xibu;

        dr["Position"] = newsteach_zhicheng;

        dr["Telephone"] = newsteach_tel;

        SqlCommandBuilder mycb = new SqlCommandBuilder(mydata);

        mydata.Update(myset.Tables["teacher"]);

        myconn.Close();

        tech_show();



    }