web/WebUserControl5.ascx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

public partial class web_WebUserControl5 : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
      
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //string sql = "select RcategoryId 类型号,Name 类型名称,Area 面积,BedNum 床位数,price 价格,Aircondition 空调数,TV 电视数 from RoomCategory";
        //// String sql1 = "select Cname 姓名,CustomersInfo.CidentityId 身份证,RoomId 房间号,BeginTime 开始时间,EndTime 结束时间 from Customersinfo,History where CustomersInfo.Cidentityid=History.Cidentityid  and History.BeginTime>='" + Calendar1.SelectedDate.ToString() + "' and History.BeginTime <='" + Calendar2.SelectedDate.ToString() + "' and CustomersInfo.Cname='" + TextBox3.Text.Trim() + "'";
        //string ConnStr1 = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ToString();
        //SqlConnection cn = new SqlConnection(ConnStr1);
        //cn.ConnectionString = ConnStr1;
        //// String sql1 = "select Cname 姓名,CustomersInfo.CidentityId 身份证,RoomId 房间号,BeginTime 开始时间,EndTime 结束时间 from History,CustomersInfo where History.CidentityId=CustomersInfo.CidentityId";
        //cn.Open();
        //SqlCommand cmd = new SqlCommand(sql, cn);
        //GridView1.DataSource = cmd.ExecuteReader();
        //GridView1.DataBind();
        //cn.Close();
        GridView1.DataSourceID = "sqlDataSource1";
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("AddRoomCategory.aspx");
    }
    protected void bhy(object sender, CommandEventArgs e)
    {
        string[] id = e.CommandArgument.ToString().Split('|');
        string roomcategory = id[0];
     
        
            Response.Redirect("RoomCategoryChange.aspx?Name=" + roomcategory);

    }
    protected void delete(object sender, GridViewDeleteEventArgs e)
    {

    }
}