更新ASP.NET文本框中的文本

Question

我试图使用文本框更新SQL数据库中的文本。这是管理员要覆盖数据库中的数据。在声明其中一个变量时遇到困难。项目名称文本在当前上下文中不存在。

项目编辑页代码：

 <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="admin_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>elmtree - Admin</title>


    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>

<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css" />

<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="../styles/mylist.css" />

</head>
<body>
    <form id="form1" runat="server">

        <img src="images/ELleft.png" style="width:226px; height:52px; margin-top: 3px; margin-left: 17px; text-align: justify; float: none;"/></a></li>



<div class="container">
    <h1> Item Edit </h1> </div>

        <div class="container">

            <div class="form-group">

                <label class="col-sm-2 control-label">Item name: </label> 

                <div class="col-md-4">
                    <asp:TextBox ID="itemnameedit" runat="server" Text="" CssClass="form-control">

                    </asp:TextBox>
                </div>
                <div class="pull-right">
                    <asp:Button CssClass="btn btn-primary btn-lg" ID="updatebutton" role="button" runat="server" Text="save" OnClick="updatebutton_Click" />
                </div>
            </div>

        </div>

        </form>
    </body>
    </html>

itemediting.aspx.cs代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;

using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;



public partial class admin_itemediting : System.Web.UI.Page{

    protected void Page_Load(object sender, EventArgs e)
    {
        int row = 0;
        if (Request.QueryString["itemID"] != null){

            row = int.Parse(Request.QueryString["itemID"]);
        }
        else{
            Response.Redirect("itemedit.aspx");
        }




        string connectionString = WebConfigurationManager.ConnectionStrings
            ["ConnectionString"].ConnectionString;

        SqlConnection myConnection = new SqlConnection(connectionString);


        myConnection.Open();


        string query = "SELECT * FROM reports WHERE ID=@rowid";


        SqlCommand myCommand = new SqlCommand(query, myConnection);

        myCommand.Parameters.AddWithValue("@rowid", row);


        SqlDataReader rdr = myCommand.ExecuteReader();


        while (rdr.Read())
        {
            string myname = rdr["itemname"].ToString();

            itemnametext.Text = myname;
        }
    }
    protected void updatebutton_Click(object sender, EventArgs e){

        string connectionString = WebConfigurationManager.ConnectionStrings ["ConnectionString"].ConnectionString;

        SqlConnection myConnection = new SqlConnection(connectionString);

        myConnection.Open();

    string itemnametextupdate = itemnametext.Text;

    string query = "UPDATE reports SET itemname = @itemnewname";

    }













    }

}

Answer 1

只需将文本框的ID从itemnameedit更改为itemnametext即可

Update:更改这里的引用，以匹配codefile和codefile类。我认为您没有正确的引用，所以codefile类 admin_itemediting不知道您在aspx文件中的任何控件。

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="itemediting.aspx.cs" Inherits="admin_itemediting" %>

Answer 2

文本框名为itemname编辑，因此找不到itemnametext。

 <asp:TextBox ID="itemnametext" runat="server" Text="" CssClass="form-control"></asp:TextBox>

编辑：您的aspx页面是默认的，您正在发布itemediting.aspx.cs.Post的代码itemediting.aspx代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="admin_Default" %>