liuyan.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
public partial class liuyan : System.Web.UI.Page
{
    private SqlConnection con = new SqlConnection( ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    public void BindInsert()
    {

        string Name = FunStr(this.txtName.Text.Trim());
        string Email = FunStr(this.txtEmail.Text.Trim());
        string http = FunStr(this.txthttp.Text.Trim());
        string qq = FunStr(this.txtqq.Text.Trim());
        string content = FunStr(this.txtbig.Text.Trim());

        //头像
        string face = "";
        //
        StringBuilder strSql = new StringBuilder();
        strSql.Append("insert into liuyan(");
        strSql.Append("name,email,younet,qq,content,touxiang,addTime)");
        strSql.Append(" values (");
        strSql.Append("@nName,@email,@http,@qq,@nContent,@touxiang,@nTime)");

        //带参数
        SqlParameter[] parameters = {
					new SqlParameter("@nName", SqlDbType.NVarChar,50),
                    new SqlParameter("@email", SqlDbType.NVarChar,50),
                    new SqlParameter("@http",SqlDbType.NVarChar,50),
                    new SqlParameter("@qq", SqlDbType.NVarChar,15),
					new SqlParameter("@nContent", SqlDbType.NVarChar,200),
                    new SqlParameter("@touxiang", SqlDbType.NVarChar,50),
					new SqlParameter("@nTime", SqlDbType.DateTime)};
        parameters[0].Value = Name;
        parameters[1].Value = Email;
        parameters[2].Value = http;
        parameters[3].Value = qq;
        parameters[4].Value = content;
  
        parameters[5].Value = face;
        parameters[6].Value = DateTime.Now;

        SqlCommand cmd = new SqlCommand(strSql.ToString(), con);
        cmd.Parameters.Add(parameters[0]);
        cmd.Parameters.Add(parameters[1]);
        cmd.Parameters.Add(parameters[2]);
        cmd.Parameters.Add(parameters[3]);