做的是三层架构后台代码:
private void ddlCityDB() //????
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCity();
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
} private void ddlProvinceDB() //??
{
ProvinceBusiness pb = new ProvinceBusiness();
ddlProvince.DataSource = pb.GetProvince();
ddlProvince.DataTextField = "pname";
ddlProvince.DataValueField = "pid";
ddlProvince.DataBind();
}
private void ddlCityDB(string _pid) //重载 ???
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCityByPid(_pid);
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
}
protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e)
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCityByPid(ddlProvince.SelectedValue);
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
LostBusiness lb = new LostBusiness();
Lost l = new Lost();
l.Lname = txtLostName.Text.Trim();
if (rbtnMale.Checked)
{
l.Gender = "男";
}
else if (rbtnFemale.Checked)
{
l.Gender = "女";
}
l.Birthday = Convert.ToDateTime(txtBirthday.Text.Trim());
l.HeightThen = txtHeightThen.Text.Trim();
l.Losttime = Convert.ToDateTime(txtLostTime.Text.Trim()); l.Jiguan = txtJiGuan.Text.Trim();
l.Cid = Convert.ToInt32(ddlCity.SelectedValue);
l.Lostplace = txtLostPlace.Text.Trim();
l.Otherexplain = txtOtherExplain.Text.Trim();
l.Backgroundandclue = txtBackGround.Text.Trim();
l.Relaname = txtRelaname.Text.Trim();
l.Relation = txtRelation.Text.Trim();
l.RelaTelephone = txtTelephone.Text.Trim();
l.RelaEmail = txtEmail.Text.Trim();
l.Address = txtAddressDetail.Text.Trim();
int i = lb.AddLostExceptPhoto(l);
if (i > 0)
{
Response.Write("<script>alert('添加成功!');window.location='Index.aspx';</script>");
}
存储过程:
alter proc p_AddLostExceptPhoto
@lname varchar(20),
@gender char(2),
@birthday datetime,
@heightThen varchar(10),
@losttime datetime,
@jiguan varchar(200),
@cid int,
@lostplace varchar(100),
@backgroundandclue varchar(500),
@otherexplain varchar(200),
@relaname varchar(20),
@relation varchar(20),
@relaTelephone char(11),
@relaEmail varchar(50),
@address varchar(200)
as
begin
insert into tb_lost(lname,gender,birthday,heightThen,losttime,jiguan,cid,lostplace,backgroundandclue,otherexplain,relaname,relation,relaTelephone,relaEmail,address) values(@lname,@gender,@birthday,@heightThen,@losttime,@jiguan,@cid,@lostplace,@backgroundandclue,@otherexplain,@relaname,@relation,@relaTelephone,@relaEmail,@address)
end运行时出现问题 过程或函数 'p_AddLostExceptPhoto' 需要参数 '@cid',但未提供该参数
private void ddlCityDB() //????
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCity();
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
} private void ddlProvinceDB() //??
{
ProvinceBusiness pb = new ProvinceBusiness();
ddlProvince.DataSource = pb.GetProvince();
ddlProvince.DataTextField = "pname";
ddlProvince.DataValueField = "pid";
ddlProvince.DataBind();
}
private void ddlCityDB(string _pid) //重载 ???
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCityByPid(_pid);
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
}
protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e)
{
CityBusiness cb = new CityBusiness();
ddlCity.DataSource = cb.GetCityByPid(ddlProvince.SelectedValue);
ddlCity.DataTextField = "cname";
ddlCity.DataValueField = "cid";
ddlCity.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
LostBusiness lb = new LostBusiness();
Lost l = new Lost();
l.Lname = txtLostName.Text.Trim();
if (rbtnMale.Checked)
{
l.Gender = "男";
}
else if (rbtnFemale.Checked)
{
l.Gender = "女";
}
l.Birthday = Convert.ToDateTime(txtBirthday.Text.Trim());
l.HeightThen = txtHeightThen.Text.Trim();
l.Losttime = Convert.ToDateTime(txtLostTime.Text.Trim()); l.Jiguan = txtJiGuan.Text.Trim();
l.Cid = Convert.ToInt32(ddlCity.SelectedValue);
l.Lostplace = txtLostPlace.Text.Trim();
l.Otherexplain = txtOtherExplain.Text.Trim();
l.Backgroundandclue = txtBackGround.Text.Trim();
l.Relaname = txtRelaname.Text.Trim();
l.Relation = txtRelation.Text.Trim();
l.RelaTelephone = txtTelephone.Text.Trim();
l.RelaEmail = txtEmail.Text.Trim();
l.Address = txtAddressDetail.Text.Trim();
int i = lb.AddLostExceptPhoto(l);
if (i > 0)
{
Response.Write("<script>alert('添加成功!');window.location='Index.aspx';</script>");
}
存储过程:
alter proc p_AddLostExceptPhoto
@lname varchar(20),
@gender char(2),
@birthday datetime,
@heightThen varchar(10),
@losttime datetime,
@jiguan varchar(200),
@cid int,
@lostplace varchar(100),
@backgroundandclue varchar(500),
@otherexplain varchar(200),
@relaname varchar(20),
@relation varchar(20),
@relaTelephone char(11),
@relaEmail varchar(50),
@address varchar(200)
as
begin
insert into tb_lost(lname,gender,birthday,heightThen,losttime,jiguan,cid,lostplace,backgroundandclue,otherexplain,relaname,relation,relaTelephone,relaEmail,address) values(@lname,@gender,@birthday,@heightThen,@losttime,@jiguan,@cid,@lostplace,@backgroundandclue,@otherexplain,@relaname,@relation,@relaTelephone,@relaEmail,@address)
end运行时出现问题 过程或函数 'p_AddLostExceptPhoto' 需要参数 '@cid',但未提供该参数
解决方案 »
- 求一本asp.net学习用书,我现在有一本asp.net 3.5揭秘了,想学学ajax,缓存,linq,自定义控件,sqlhelper等
- 没解决完的datalist 里imagebutton控件跳转问题
- 什么是datatable列的建议值?
- 奇怪。StringBuilder参数问题
- 怎么给子程序中调用的存储过程传递参数!有例子..但不知如何带入!
- 如何在客户段控制RegularExpressionValidator控件错误提示的显示与否?
- 在ASP.NET中在DataGrid分页的情况下如何实现全部内容打印?
- 在.aspx的文件中为什么不能加Oracle的引用
- 请教一个关于Li动态添加漂浮小图标的问题。
- 请问vs.net自带的日历控件怎么让它只显示日,一,二,而不是星期几?
- 如何将含有特殊字符和数字的字符串,转换为整数
- asp.net webform页面点击按钮动态添加其他控件,添加控件少于点击次数(页面刷新次数),
问题出在这个AddLostExceptPhoto方法,检查下代码在调用cmd.ExecuteNonQuery 方法前的传参。