friendlink.aspx.cs

asp.net 的某物流管理系统 MIS 系统

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.OleDb;

public partial class include_Friendlink : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtName.Text.ToString().Trim().Length > 1 && txtUrl.Text.ToString().Trim().Length > 1)
        {
            
            Addlink(txtName.Text.ToString().Trim(), txtUrl.Text.ToString().Trim(), txtEmail.Text.ToString().Trim());
            txtWarning.Text = "提交成功，请在三日内做好本站链接，审核后生效！";
            txtName.Text = "";
            txtUrl.Text = "Http://";
            txtEmail.Text = "";
        }
        else
        {
            txtWarning.Text = "提交失败，请按要求添写！";
        }

    }
    private void Addlink(string sName, string sUrl, string sEmail)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "INSERT INTO Friendlink(Name,Linkurl,Linkemail,Createdate)VALUES('" +
            sName + "','" +
            sUrl + "','" +
            sEmail + "'," +
            "Now)";
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
    }
}