using System;
using System.Data;
using System.Data.SqlClient;
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;namespace klcf
{
public partial class Article_Class_Add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArtUpClass_Bind();
}
}
public void ArtUpClass_Bind()
{
string mysql = null;
mysql = "Select ID,Name,Sid From klcf_ArtClass where sid=0";
SqlConnection conn = DataBase.ReturnConn();
SqlDataAdapter da = new SqlDataAdapter(mysql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
ArtUpClass.DataSource = dt;
ArtUpClass.DataTextField = "Name";
ArtUpClass.DataValueField = "ID";
ArtUpClass.DataBind();
ArtUpClass.Items.Insert(0,"添加一级分类");
}
protected void AddArtClass_Click(object sender, EventArgs e)
{
string ClassName = ArtClassName.Text;
Response.Write(ClassName);
if(ClassName=="")
{
Response.Write("<script language=javascript>alert('请输入分类名称!');history.go(1);</script>");
Response.End();
}
string ClassID = null;
if (ArtUpClass.SelectedValue == "添加一级分类")
{
ClassID = "0";
}
else
{
ClassID = ArtUpClass.SelectedValue;
}
string mysql = null;
mysql = "insert into klcf_ArtClass(Name,Sid) values('" + ClassName + "'," + ClassID + ")";
SqlConnection conn = DataBase.ReturnConn();
SqlCommand cmd = new SqlCommand(mysql, conn);
cmd.ExecuteNonQuery();
ArtUpClass_Bind();
ArtClassName.Text = null;
}
}
}上面的代码,我在两台机上进行测试,在用XP做的服务器上可以正常执行,但在2003做的服务器上面却无法执行AddArtClass_Click事件。
using System.Data;
using System.Data.SqlClient;
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;namespace klcf
{
public partial class Article_Class_Add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArtUpClass_Bind();
}
}
public void ArtUpClass_Bind()
{
string mysql = null;
mysql = "Select ID,Name,Sid From klcf_ArtClass where sid=0";
SqlConnection conn = DataBase.ReturnConn();
SqlDataAdapter da = new SqlDataAdapter(mysql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
ArtUpClass.DataSource = dt;
ArtUpClass.DataTextField = "Name";
ArtUpClass.DataValueField = "ID";
ArtUpClass.DataBind();
ArtUpClass.Items.Insert(0,"添加一级分类");
}
protected void AddArtClass_Click(object sender, EventArgs e)
{
string ClassName = ArtClassName.Text;
Response.Write(ClassName);
if(ClassName=="")
{
Response.Write("<script language=javascript>alert('请输入分类名称!');history.go(1);</script>");
Response.End();
}
string ClassID = null;
if (ArtUpClass.SelectedValue == "添加一级分类")
{
ClassID = "0";
}
else
{
ClassID = ArtUpClass.SelectedValue;
}
string mysql = null;
mysql = "insert into klcf_ArtClass(Name,Sid) values('" + ClassName + "'," + ClassID + ")";
SqlConnection conn = DataBase.ReturnConn();
SqlCommand cmd = new SqlCommand(mysql, conn);
cmd.ExecuteNonQuery();
ArtUpClass_Bind();
ArtClassName.Text = null;
}
}
}上面的代码,我在两台机上进行测试,在用XP做的服务器上可以正常执行,但在2003做的服务器上面却无法执行AddArtClass_Click事件。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货