ASP.NET房屋租赁管理系统(5)

来源:xiaoniu168.com 作者:本站原创 添加时间:2012-03-14 点击数:14990

计算机毕业设计介绍:

5.2.5  查询模块
当会员查看房源时,可以根据自己的需要来查询
实现方法:
如窗体中所示,上边为查询条件,下边的gridview显示结果,通过上边的的文本框的值是否为空来配置查询语句,然后简历数据集,gridview绑定到该数据集.

 protected void btnReset_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this.TextBox2.Text = "";
        this.TextBox3.Text = "";
        this.TextBox4.Text = "";
        this.TextBox5.Text = "";
        this.TextBox6.Text = "";
        this.TextBox7.Text = "";
        this.TextBox8.Text = "";
        this.TextBox9.Text = "";
        this.TextBox10.Text = "";
    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
       string  zhuangxiu = this.DropDownList2.SelectedItem.Text;
        string  yongtu = this.DropDownList1.SelectedItem.Text;
        string time = System.DateTime.Now.ToString("d");
        string checkboxlist = "";
        for (int i = 1; i < this.CheckBoxList1.Items.Count; i++)
        {
            if (this.CheckBoxList1.Items[i].Selected == true )
            {
                checkboxlist += this.CheckBoxList1.Items[i].Text.ToString();
            }
        }
        Sql sql = new Sql();
        switch (this.RadioButtonList1.SelectedValue)
        {
            case "1":
                {
                    string insertSQL = "insert into czxx(fangxing,cengshu,mianji,jianyu,zujin,sheshi,dizhi,lianxiren,dianhua,time,zhuangxiu,yongtu)values('";
                    insertSQL += this.TextBox1.Text + "室" + this.TextBox2.Text + "厅','";
                    insertSQL += "第" + this.TextBox4.Text + "层共" + this.TextBox5.Text + "层',";
                    insertSQL += this.TextBox3.Text + ",'";
                    insertSQL += this.TextBox6.Text + "年" + "',";
                    insertSQL += this.TextBox7.Text  + ",'";
                    insertSQL += checkboxlist + "','";
                    insertSQL += this.TextBox8.Text + "','";
                    insertSQL += this.TextBox9.Text + "','";
                    insertSQL += this.TextBox10.Text + "','";
                    insertSQL += time + "','";
                    insertSQL += zhuangxiu + "','";
                    insertSQL +=yongtu +"')";
                    sql.ExcuteSQL(insertSQL);

〖资料来源:计算机毕业论文 www.xiaoniu168.com

第6页为计算机毕业论文部分......

【联系方式】

【本站信誉】

用心做计算机毕业设计论文网