做的是三层架构后台代码:
 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',但未提供该参数