我正在使用文本框将广泛的文本行插入SQL中,该字段目前是nvarchar type nvarchar限制为3000。
文本框将显示我写的所有内容,一旦我按提交将其发送给db/cut版本。
文本框:
<asp:TextBox ID="SummaryTextBox" CssClass="SummaryTextBox" runat="server" EnableTheming="True" TextMode="MultiLine" MaxLength="3000"></asp:TextBox>
单击事件:
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Leo\Desktop\PAP\App_Data\AnimationFront.mdf;Integrated Security=True");
int id = Convert.ToInt32(Request.QueryString["animeid"]);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Anime_SP";
cmd.Parameters.AddWithValue("@acao", "UPDATES");
cmd.Parameters.AddWithValue("@Id_Anime", id);
cmd.Parameters.AddWithValue("@Summary", SummaryTextBox.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Redirect("AnimePage.aspx?animeid=" + id);
}
存储过程:
IF @acao = 'UPDATES'
BEGIN
UPDATE Anime
SET Summary = @Summary
WHERE Id_Anime = @Id_Anime
END
我忘了将参数从邮政程序从nvarchar(500(更改为nvarchar(3000((3000(。
@acao NVARCHAR(10)
,@Id_Anime INT = NULL
,@Title NVARCHAR(100) = NULL
,@Genre NVARCHAR(100) = NULL
,@Episodes INT = NULL
,@Studios NVARCHAR (100) = NULL
,@Prequels NVARCHAR (100) = NULL
,@Sequels NVARCHAR (100) = NULL
,@Cover NVARCHAR (100) = NULL
,@Summary NVARCHAR (500) = NULL