在做一个系统,有添加商品模块。利用存储过程如下
ALTER PROCEDURE [dbo].[AddCommodity]
@TypeName nvarchar(50), //商品类型
@CommName nvarchar(250), //商品名称
@CommPrice decimal(18,2), //价格
@CommCover nvarchar(100), //图片路径
@Description nvarchar(500), //描述
@OfferUser nvarchar(50), //提供人
@RecordTime datetime, //发布时间
@SaleDays int, //持续销售时间
@Deadline datetime, //截止日期
AS INSERT Commodity(TypeName,CommName,CommPrice,CommCover,Description,OfferUser,RecordTime,SaleDays,Deadline) values(@CommID,@TypeID,@CommName,@CommPrice,@CommCover,@Description,@OfferUser,@RecordTime,@SaleDays,@Deadline) 代码如下:
string OfferUserName = Convert.ToString(Session["UserName"]);
fileName = Server.MapPath("\\基于ASP.NET的网上拍卖系统\\photo").ToString().Trim() + "\\" + FileUpload1.PostedFile.FileName.ToString();
SqlCommand cmd = new SqlCommand("AddCommodity", con);
cmd.CommandType = CommandType.StoredProcedure;
Response.Write("<script language=javascript>alert('添加成功0!');</script>");
try
{
cmd.Parameters.Add(new SqlParameter("@typename",SqlDbType.NVarChar,50 ));
cmd.Parameters["@typename"].Value = dropType.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@commname",SqlDbType.NVarChar,250));
cmd.Parameters["@commname"].Value=txtCommName.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@commprice",SqlDbType.Decimal,18));
cmd.Parameters["@commprice"].Value = decimal.Parse(txtCommPrice.Text.ToString().Trim());
cmd.Parameters.Add(new SqlParameter("@commcover",SqlDbType.NVarChar,100));
cmd.Parameters["@commcover"].Value = fileName;
cmd.Parameters.Add(new SqlParameter("@description", SqlDbType.NVarChar,500));
cmd.Parameters["@description"].Value = txtDescription.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@offeruser", SqlDbType.NVarChar,50));
cmd.Parameters["@description"].Value = OfferUserName;
cmd.Parameters.Add(new SqlParameter("@recordtime", SqlDbType.DateTime));
cmd.Parameters["@record"].Value = DateTime.Now.AddDays(0).ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@saledays", SqlDbType.Int));
cmd.Parameters["@saledays"].Value = txtSaleDays.Text.Trim();
int d = int.Parse(txtSaleDays.Text.ToString().Trim());
cmd.Parameters.Add(new SqlParameter("@deadline", SqlDbType.DateTime));
cmd.Parameters["@commcover"].Value =DateTime.Now.AddDays(d);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('添加成功!');</script>");
}
catch(Exception ex)
{
ErrMessage.Text = ex.Message;
}
cmd.Connection.Close(); //此处出现错误:未将对象引用设置到对象的实例。
ALTER PROCEDURE [dbo].[AddCommodity]
@TypeName nvarchar(50), //商品类型
@CommName nvarchar(250), //商品名称
@CommPrice decimal(18,2), //价格
@CommCover nvarchar(100), //图片路径
@Description nvarchar(500), //描述
@OfferUser nvarchar(50), //提供人
@RecordTime datetime, //发布时间
@SaleDays int, //持续销售时间
@Deadline datetime, //截止日期
AS INSERT Commodity(TypeName,CommName,CommPrice,CommCover,Description,OfferUser,RecordTime,SaleDays,Deadline) values(@CommID,@TypeID,@CommName,@CommPrice,@CommCover,@Description,@OfferUser,@RecordTime,@SaleDays,@Deadline) 代码如下:
string OfferUserName = Convert.ToString(Session["UserName"]);
fileName = Server.MapPath("\\基于ASP.NET的网上拍卖系统\\photo").ToString().Trim() + "\\" + FileUpload1.PostedFile.FileName.ToString();
SqlCommand cmd = new SqlCommand("AddCommodity", con);
cmd.CommandType = CommandType.StoredProcedure;
Response.Write("<script language=javascript>alert('添加成功0!');</script>");
try
{
cmd.Parameters.Add(new SqlParameter("@typename",SqlDbType.NVarChar,50 ));
cmd.Parameters["@typename"].Value = dropType.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@commname",SqlDbType.NVarChar,250));
cmd.Parameters["@commname"].Value=txtCommName.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@commprice",SqlDbType.Decimal,18));
cmd.Parameters["@commprice"].Value = decimal.Parse(txtCommPrice.Text.ToString().Trim());
cmd.Parameters.Add(new SqlParameter("@commcover",SqlDbType.NVarChar,100));
cmd.Parameters["@commcover"].Value = fileName;
cmd.Parameters.Add(new SqlParameter("@description", SqlDbType.NVarChar,500));
cmd.Parameters["@description"].Value = txtDescription.Text.ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@offeruser", SqlDbType.NVarChar,50));
cmd.Parameters["@description"].Value = OfferUserName;
cmd.Parameters.Add(new SqlParameter("@recordtime", SqlDbType.DateTime));
cmd.Parameters["@record"].Value = DateTime.Now.AddDays(0).ToString().Trim();
cmd.Parameters.Add(new SqlParameter("@saledays", SqlDbType.Int));
cmd.Parameters["@saledays"].Value = txtSaleDays.Text.Trim();
int d = int.Parse(txtSaleDays.Text.ToString().Trim());
cmd.Parameters.Add(new SqlParameter("@deadline", SqlDbType.DateTime));
cmd.Parameters["@commcover"].Value =DateTime.Now.AddDays(d);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('添加成功!');</script>");
}
catch(Exception ex)
{
ErrMessage.Text = ex.Message;
}
cmd.Connection.Close(); //此处出现错误:未将对象引用设置到对象的实例。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货