using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Text;
namespace bt
{
/// <summary>
/// add 的摘要说明。
/// </summary>
public class add : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList guojia;
protected System.Web.UI.WebControls.DropDownList zhonglei;
protected System.Web.UI.WebControls.TextBox neirong;
protected System.Web.UI.WebControls.TextBox zuti;
protected System.Web.UI.HtmlControls.HtmlInputFile url5;
protected System.Web.UI.HtmlControls.HtmlInputFile url4;
protected System.Web.UI.HtmlControls.HtmlInputFile url3;
protected System.Web.UI.HtmlControls.HtmlInputFile url2;
protected System.Web.UI.HtmlControls.HtmlInputFile url1;
protected System.Web.UI.WebControls.Button Button1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Button1_Click(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
SqlConnection Conn=new SqlConnection(ConfigurationSettings.AppSettings["sqlconn"]);
String InsertCmd="insert into body (zuti, guojia, zhonglei, neirong) values (@zuti, @guojia, @zhonglei, @neirong)";
SqlCommand addCmd=new SqlCommand(InsertCmd,Conn);
Conn.Open();
addCmd.Parameters.Add(new SqlParameter("@zuti", SqlDbType.VarChar, 200));
addCmd.Parameters["@zuti"].Value= zuti.Text;
addCmd.Parameters.Add(new SqlParameter("@guojia", SqlDbType.VarChar, 200));
addCmd.Parameters["@guojia"].Value= guojia.SelectedItem.Text;
addCmd.Parameters.Add(new SqlParameter("@zhonglei", SqlDbType.VarChar, 200));
addCmd.Parameters["@zhonglei"].Value= zhonglei.SelectedItem.Text;
addCmd.Parameters.Add(new SqlParameter("@neirong", SqlDbType.Text, 16));
addCmd.Parameters["@neirong"].Value= neirong.Text;
addCmd.ExecuteNonQuery();
Conn.Close();
}
}
}
}
看看我的问题好吗
