c# - Page_Load() 保存到数据库
问题描述
如何在 C# 中使用 Page_Load() 保存到数据库我一直在尝试保存到 MSSQL 数据库中,它只是让列非常空,并且这些列中没有保存任何内容,我在这里需要帮助,因为我有点新手使用 ASP.NET
我的代码如下所示:
protected void Page_Load(object sender, EventArgs e)
{
string firstname = Request.QueryString["firstname"];
string lastname = Request.QueryString["lastname"];
string email = Request.QueryString["email"];
//Put user code to initialize the page here
Topaz.SigPlusNET sigObj = new Topaz.SigPlusNET();
sigObj.AutoKeyStart();
//use the same data to decrypt signature
sigObj.SetAutoKeyData(Request.Form["username"]);
sigObj.AutoKeyFinish();
sigObj.SetSigCompressionMode(1);
sigObj.SetEncryptionMode(2);
//Now, get sigstring from client
//Sigstring can be stored in a database if
//a biometric signature is desired rather than an image
//sigObj.SetSigString(Request.Form["hidden"]);
if (sigObj.NumberOfTabletPoints() > 0)
{
sigObj.SetImageFileFormat(0);
sigObj.SetImageXSize(500);
sigObj.SetImageYSize(150);
sigObj.SetImagePenWidth(8);
sigObj.SetJustifyX(5);
sigObj.SetJustifyY(5);
sigObj.SetJustifyMode(5);
System.Drawing.Image img = sigObj.GetSigImage();
base64ImageString = ImageToBase64(img, System.Drawing.Imaging.ImageFormat.Jpeg);
if (base64ImageString.Length > 3000)
{
using (SqlConnection con = new SqlConnection(constring))
{
con.Open();
string sql = "insert into SakalPicturecontrol (firstname,lastname,email,base64ImageString) Values (@firstname,@lastname,@email,@base64ImageString)";
try
{
using (SqlCommand cmd = new SqlCommand(sql, con))
{
cmd.Parameters.AddWithValue("@firstname", firstname);
cmd.Parameters.AddWithValue("@lastname", lastname);
cmd.Parameters.AddWithValue("@email", email);
cmd.Parameters.AddWithValue("@base64ImageString", base64ImageString);
cmd.ExecuteNonQuery();
Response.Write("Information has been saved Correctly..");
con.Close();
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.ToString());
}
}
}
}
else
{
//signature has not been returned successfully!
}
}
解决方案
推荐阅读
- python - Python添加不同大小的数组 - 上限?
- excel - 使用 excel VBA 代码将 PDF 转换为 Word Doc
- azure-sql-database - Sqoop 导出到 SQL Server。更新和插入。Sqoop 导出更新 SQL Server 上相同的记录
- python - 如何从此文本文件中读取字典?
- python - Numpy where 沿轴 0 的条件语句
- android - 片段调用 onDestroyView 但对适配器的引用为空
- python - Numpy:订阅多维数组中的最外层维度
- swagger - 我想通过 Xcode 为我的项目生成文档。有什么建议吗?
- python - 在新数据框中对多行进行分组
- php - 测试和比较 MySQL 速度的脚本