c# - DB 中的 System.Web.UI.WebControls.TextBox

Question

SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)");
        string qry = "INSERT INTO temporary_markers (location) VALUES ('" + txtlocation + "')";
        SqlCommand cmd = new SqlCommand(qry, con);

上面的代码片段是我用来将值传递给数据库的。该值被传递但“System.Web.UI.WebControls.TextBox”是表中的内容

Answer 1

使用 txtlocation.Text而不是 txtlocation .

txtlocation.Text is the string you want.

txtlocation is your TextBox