获取repeater中控件的值并且进行数据更新

最新推荐文章于 2021-03-20 12:09:19 发布

兵_哥哥

最新推荐文章于 2021-03-20 12:09:19 发布

阅读量879

点赞数

分类专栏：学习当中文章标签： textbox login string website command session

学习当中专栏收录该内容

34 篇文章

订阅专栏

本文介绍如何使用ASP.NET中的Repeater控件获取各输入框的值，并通过SQL命令实现用户信息的批量更新。具体包括TextBox控件的查找及SQL连接字符串的配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

获取repeater中控件的值并且进行数据更新

2011-06-17 11:42

protected void UpdateInfo_Click(object sender, EventArgs e)
    {
        foreach (RepeaterItem item in Repeater1.Items)
        {
            TextBox txtNiName = (TextBox)item.FindControl("txtNiName");
            TextBox txtName = (TextBox)item.FindControl("txtName");
            TextBox txtSex = (TextBox)item.FindControl("txtSex");
            TextBox txtBirthday = (TextBox)item.FindControl("txtBirthday");
            TextBox txtID = (TextBox)item.FindControl("txtID");
            TextBox txtMobile = (TextBox)item.FindControl("txtMobile");
            TextBox txtTele = (TextBox)item.FindControl("txtTele");
            TextBox txtEmail = (TextBox)item.FindControl("txtEmail");
            TextBox txtCom = (TextBox)item.FindControl("txtCom");
            TextBox txtAddress = (TextBox)item.FindControl("txtAddress");
            TextBox txtWeb = (TextBox)item.FindControl("txtWeb");
            string Login = Session["Login"].ToString();
            string conn = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
            SqlConnection connection=new SqlConnection(conn);
            connection.Open();
            string sql = "Update UserInfo set NiName='" + txtNiName.Text + "', Name='" + txtName.Text + "',Sex='" +
                         txtSex.Text + "',Birthday='" + txtBirthday.Text + "',ID='" + txtID.Text +
                         "',Mobile='" + txtMobile.Text + "',Tele='" + txtTele.Text + "',Email='" +
                         txtEmail.Text + "',Com='" + txtCom.Text + "',Address='" + txtAddress.Text +
                         "',Website='" + txtWeb.Text + "' where Login='" + Login + "'";
            SqlCommand command=new SqlCommand(sql,connection);
            int i = command.ExecuteNonQuery();
            if(i>0)
            {
                Response.Write("<script language=javascript>alert('修改成功！')</script>");
            }
            else
            {
                Response.Write("<script language=javascript>alert('修改失败！')</script>");
            }
        }


    }