c# - 如何修复“值”附近的错误语法

问题描述

我正在尝试制作反馈表，但我的 asp.net 代码在下面出现“值”错误附近的语法，“i”标签用于添加图标

<form id="form1" runat="server">
                            <p>
                                What do you think of this?
                            </p>
                            <p>
                                <asp:RadioButtonList CssClass="size" ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal">
                                    <asp:ListItem Text='<i class="material-icons yellow md-36">sentiment_very_dissatisfied</i>' Value="1"></asp:ListItem>
                                    <asp:ListItem Text='<i class="material-icons yellow md-36">sentiment_dissatisfied</i>' Value="2"></asp:ListItem>
                                    <asp:ListItem Text='<i class="material-icons yellow md-36">sentiment_satisfied</i>' Value="3"></asp:ListItem>
                                    <asp:ListItem Text='<i class="material-icons yellow md-36">sentiment_satisfied_alt</i>' Value="4"></asp:ListItem>
                                    <asp:ListItem Selected="True" Text='<i class="material-icons yellow md-36">sentiment_very_satisfied</i>' Value="5"></asp:ListItem>
                                </asp:RadioButtonList>
                            </p>
                            <p>
                                Your Feedback
                    <asp:RequiredFieldValidator ForeColor="#EB3E59" ID="RequiredFieldValidator2" runat="server" ErrorMessage=" *" ControlToValidate="feedTxt"></asp:RequiredFieldValidator>
                            </p>
                            <asp:TextBox CssClass="input" placeholder="enter your feedback" ID="feedTxt" runat="server" MinLength="10" MaxLength="100" TextMode="MultiLine" Height="50px"></asp:TextBox>
                            <p>
                                how likely are you to recommend us to your friends and colleagues?
                            </p>
                            <p>
                                <asp:RadioButtonList CssClass="size" ID="RadioButtonList2" runat="server" RepeatDirection="Horizontal">
                                    <asp:ListItem>1</asp:ListItem>
                                    <asp:ListItem>2</asp:ListItem>
                                    <asp:ListItem>3</asp:ListItem>
                                    <asp:ListItem>4</asp:ListItem>
                                    <asp:ListItem Selected="True">5</asp:ListItem>
                                    <asp:ListItem>6</asp:ListItem>
                                    <asp:ListItem>7</asp:ListItem>
                                    <asp:ListItem>8</asp:ListItem>
                                    <asp:ListItem>9</asp:ListItem>
                                    <asp:ListItem>10</asp:ListItem>
                                </asp:RadioButtonList>
                            </p>
                            <asp:Label ID="Label1" runat="server" Text=""></asp:Label>
                            <asp:TextBox CssClass="size input" ID="TextBox1" runat="server" placeholder="email ( optional )" TextMode="Email"></asp:TextBox>
                            <asp:Button CssClass="input loginbox_submit" ID="Submit" runat="server" Text="Submit" Height="42px" OnClick="Submit_Click" />
                        </form>

我想我得到了错误 cmd.parameters .........我的 c#

 protected void Submit_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);
            con.Open();
            string feed;
            if (string.IsNullOrEmpty(TextBox1.Text.Trim()) || Session["email"] == null) //textbox1 takes email which is optional
            {
                feed = "insert into feedback (feedback,stars,recommend) value(@feedback,@stars,@recommend)";
            }
            else
            {
                feed = "insert into feedback (email,feedback,stars,recommend) value(@email,@feedback,@stars,@recommend)";
            }

            SqlCommand cmd = new SqlCommand(feed, con);
            if (!(string.IsNullOrEmpty(TextBox1.Text.Trim()) || Session["email"] == null))
            {
                cmd.Parameters.AddWithValue("@email", TextBox1.Text);
            }
            cmd.Parameters.AddWithValue("@feedback", feedTxt.Text);
            cmd.Parameters.AddWithValue("@stars", RadioButtonList1.SelectedValue);
            cmd.Parameters.AddWithValue("@recommend", RadioButtonList2.SelectedValue);
            cmd.ExecuteNonQuery();
            passbox.Visible = false;
            passdone.Visible = true;
            con.Close();
        }

在这种情况下，我得到 System.Data.SqlClient.SqlException：''value' 附近的语法不正确。' 我不擅长c#
请尽快帮助
谢谢

标签： c#sqlasp.netsql-server

c# - 如何修复“值”附近的错误语法

问题描述

解决方案

推荐阅读