关于asp.net的添加图书信息的代码问题
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.Data.SqlClient;
using System.Configuration;
namespace BookShop
{
/// <summary>
/// AddBoo 的摘要说明。
/// </summary>
public partial class AddBoo : System.Web.UI.Page
{ SqlConnection myConnection;
SqlCommand myCommand;
protected System.Web.UI.WebControls.Button Button1;
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(Session["manageuser"].ToString()!=null)
{
myConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["dsn"]);
}
else
{
Response.Write("<script language=javascript>alert('非法用户,不得进入')</script>");
Response.Redirect("managelogin.aspx");
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
protected void btnApply_Click(object sender, System.EventArgs e)
{
try
{
string strname1=Convert.ToString(this.tbx_bookimage.Value);
string strname=strname1.Substring(strname1.LastIndexOf("\\")+1);
this.tbx_bookimage.PostedFile.SaveAs(Server.MapPath("BookImages")+"\\"+strname);
this.tbx_bookimage.PostedFile.SaveAs(Server.MapPath("BookImages")+"\\AllBooks\\"+strname);
this.Image1.ImageUrl=Server.MapPath("BookImages")+"\\"+strname;
Session["strname"]=strname;
}
catch
{
Response.Write("<script language=javascript>alert('您还没有选择图片')</script>");
}
}
protected void btnsubmit_Click(object sender, System.EventArgs e)
{
//myCommand.Parameters["@ddlCategoryID"].Value=Convert.ToInt32(this.ddl_Sort.SelectedItem.Value.ToString());
// string addstr="insert into Book values(@CategoryID,'@txtISBN','@txtBookName','@txtBookImage','@txtOriginal','@txtSale','@txtReserve','@txtDescription')";
try{
int categoryid=Convert.ToInt32(this.ddl_Sort.SelectedItem.Value.ToString());
string isbn=this.tbx_ISBN.Text;
string bookname=this.tbx_BookName.Text;
string bookimage=Session["strname"].ToString();
double original=Convert.ToDouble(this.tbx_Original.Text.ToString());
double sale=Convert.ToDouble(this.tbx_sale.Text.ToString());
string reserve=this.tbx_Reserve.Text;
string description=this.tbx_description.Text;
string addstr="insert into Book values(" + categoryid + "," + isbn + "," + bookname + "," + bookimage + "," + original + "," + sale + "," + reserve + "," + description + ")";
myCommand=new SqlCommand(addstr,myConnection);
//给命令添加参数
// myCommand.Parameters.Add("@CategoryID",SqlDbType.Int);
// myCommand.Parameters.Add("@txtISBN",SqlDbType.NVarChar);
// myCommand.Parameters.Add("@txtBookName",SqlDbType.NVarChar);
// myCommand.Parameters.Add("@txtBookImage",SqlDbType.NVarChar);
// myCommand.Parameters.Add("@txtOriginal",SqlDbType.Int);
// myCommand.Parameters.Add("@txtSale",SqlDbType.Int);
// myCommand.Parameters.Add("@txtReserve", SqlDbType.NVarChar);
// myCommand.Parameters.Add("@txtDescription",SqlDbType.NVarChar);
// //给参数赋值
// myCommand.Parameters["@CategoryID"].Value=Convert.ToInt32(this.ddl_Sort.SelectedItem.Value.ToString());
// myCommand.Parameters["@txtISBN"].Value=this.tbx_ISBN.Text;
// myCommand.Parameters["@txtBookName"].Value=this.tbx_BookName.Text;
// myCommand.Parameters["@txtBookImage"].Value=strname;
// myCommand.Parameters["@txtOriginal"].Value=Convert.ToDouble(this.tbx_Original.Text);
// myCommand.Parameters["@txtSale"].Value=Convert.ToDouble(this.tbx_sale.Text.ToString());
// myCommand.Parameters["@txtReserve"].Value=this.tbx_Reserve.Text;
// myCommand.Parameters["@txtDescription"].Value=this.tbx_description.Text;
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
Response.Write("<script language=javascript>alert('添加书成功!')</script>");
}
catch
{
Response.Write("<script language=javascript>alert('添加失败')</script>");
}
}
}
}
补充:可以帮我改一下吗?可以运行,,可是怎么添加都添加不进去,总是提示“添加失败”