注册 登录
编程论坛 ASP技术论坛

[菜鸟求助]如何在按钮中实现Gridview转页

hllf6031 发布于 2008-09-03 21:34, 450 次点击
我写的代码如下(有省略)
 public void updateUsers(DataSet ds)
        {
            SqlCommand cmd = new SqlCommand("insert into employe(userid,username,sex,mobile_phone_no,identity_no,marry)values(@员工编号,@姓名,@性别,@手机,@身份证号,@婚否)", cn);
            cmd.Parameters.Add("@员工编号", SqlDbType.Int,4, "userid");
            cmd.Parameters.Add("@姓名",SqlDbType.NVarChar,20,"username");
            cmd.Parameters.Add("@性别",SqlDbType.NVarChar,5,"sex");
            cmd.Parameters.Add("@手机",SqlDbType.Decimal,9,"mobile_phone_no");
            cmd.Parameters.Add("@身份证号", SqlDbType.NVarChar, 20, "identity_no");
            cmd.Parameters.Add("@婚否", SqlDbType.NVarChar,2, "marry");
            da = new SqlDataAdapter();
            da.InsertCommand = cmd;
            cn.Open();
            da.Update(ds,ClassLibrary2.Class1.Table_User);
            cn.Close();

        }
protected void Button1_Click(object sender, EventArgs e)
    {
        ClassLibrary1.Class1 dac = new ClassLibrary1.Class1();
        DataSet ds = dac.getemploye();
        DataRow dr = ds.Tables[0].NewRow();
        dr["userid"] = this.TextBox2.Text;
        dr["username"] = this.TextBox1.Text;
        dr["sex"] = this.DropDownList2.Text;
        dr["mobile_phone_no"] = this.TextBox11.Text;
        dr["identity_no"] = this.TextBox6.Text;
        dr["marry"] = this.DropDownList3.Text;
        ds.Tables[0].Rows.Add(dr);
        dac.updateUsers(ds);
        bindData();
    }
可以实现将TextBox里面的值写入数据库并在Gridview里显示出来,但是点击Button后因为Gridview是分页显示所以翻页后就不能看到数据了,要点击页码才能看到,可不可以在点击Button的同时也实现到页面随数据跳转
0 回复
1