public void binddata(string che) { //创建数据库连接对象 Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); //打开数据库 if (con.State == System.Data.ConnectionState.Closed) { con.Open(); } string sqlstr = ""; if (che == "") { sqlstr = "select * from Topic"; } else { sqlstr = "select * from Topic where [check]='" + che + "'"; } //SQL查询语句 SqlDataAdapter da = new SqlDataAdapter(sqlstr, con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); Label1.Text = "当前页为 " + (GridView1.PageIndex + 1) + " / " + GridView1.PageCount + " 页"; con.Close(); }
//string sql = "server=UBVBIYXSV1LKLZB;database=Semester;trusted_connection=true;"; protected void Page_Load(object sender, EventArgs e) { //Response.Write(Session["user"].ToString()); string id = Request.Params["id"]; if (id == null) { //Response.Redirect("index5.aspx"); Data_con dc = new Data_con(); SqlConnection con1 = dc.SQL_con(); con1.Open(); SqlDataAdapter da1 = new SqlDataAdapter("select * from [user] where usename='" + Session["user"].ToString() + "'", con1); DataSet ds1 = new DataSet(); da1.Fill(ds1, "user"); con1.Close(); DataList1.DataSource = ds1; DataList1.DataBind(); Response.Write(id); } else { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from [user] where id='" + id + "'", con); DataSet ds = new DataSet(); da.Fill(ds, "user"); con.Close(); DataList1.DataSource = ds; DataList1.DataBind(); // Response.Write(id); } }
protected void Page_Load(object sender, EventArgs e) { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da1 = new SqlDataAdapter("SELECT top 13 * FROM [Down_2] where soft_type='软件更新' ", con); DataSet ds1 = new DataSet(); da1.Fill(ds1, "Down_2"); con.Close(); DataList1.DataSource = ds1; DataList1.DataBind(); SqlDataAdapter da2 = new SqlDataAdapter("SELECT top 13 * FROM [Down_2] where soft_type='手机软件' ", con); DataSet ds2 = new DataSet(); da2.Fill(ds2, "Down_2"); con.Close(); DataList2.DataSource = ds2; DataList2.DataBind(); SqlDataAdapter da3 = new SqlDataAdapter("SELECT top 13 * FROM [Down_2] where soft_type='单机游戏' ", con); DataSet ds3 = new DataSet(); da3.Fill(ds3, "Down_2"); con.Close(); DataList3.DataSource = ds3; DataList3.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { if (String.Compare(Request.Cookies["yzmcode"].Value, this.TextBox3.Text, true) != 0) { Response.Write("<script>alert('验证码错误!')</script>"); TextBox3.Text = ""; } else { string name = T_usename.Text; string pass = T_password.Text; Data_con dc = new Data_con(); SqlConnection conn = dc.SQL_con(); if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); } string str = "select * from [user] where usename='" + name + "' and password='******' "; SqlCommand comm = new SqlCommand(str, conn); SqlDataReader dr = comm.ExecuteReader(); if (name == "" | pass == "") { Response.Write("<script>alert('不能为空!')</script>"); } else if (dr.Read()) { Session["user"] = name; Response.Redirect("index5.aspx"); } else { Response.Write("<script>alert('登陆失败!烦死了')</script>"); } } }
protected void Page_Load(object sender, EventArgs e) { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da1 = new SqlDataAdapter("SELECT top 15 * FROM [Down_4] where soft_type='热门软件' ", con); DataSet ds1 = new DataSet(); da1.Fill(ds1, "Down_4"); con.Close(); DataList1.DataSource = ds1; DataList1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { //注册用户 if (TextBox1.Text == "") { Response.Write("<script> alert('昵称不能为空')</script>"); } else if (TextBox2.Text == "") { Response.Write("<script> alert('账号不能为空')</script>"); } else if (TextBox3.Text == "") { Response.Write("<script> alert('密码不能为空')</script>"); } else if (TextBox4.Text == "") { Response.Write("<script> alert('邮箱不能为空')</script>"); } else { Data_con dc = new Data_con(); SqlConnection conn = dc.SQL_con(); if (conn.State == System.Data.ConnectionState.Closed) { conn.Open(); } string str = "insert into [user] (name,topic,image,usename,password,email,weibo,geqian,jianjie) values('" + TextBox1.Text.Trim().ToString() + "','" + TextBox7.Text.Trim().ToString() + "','qq.png','" + TextBox2.Text.Trim().ToString() + "','" + TextBox3.Text.Trim().ToString() + "','" + TextBox4.Text.Trim().ToString() + "','" + TextBox5.Text.Trim().ToString() + "','" + TextBox6.Text.Trim().ToString() + "','" + TextBox8.Text.Trim().ToString() + "')"; SqlCommand comm = new SqlCommand(str, conn); if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0) { Response.Write("<script> alert('恭喜你,注册成功,立即跳转登陆!')</script>"); Response.Write("<script language='javascript' type='text/javascript'>tiaozhuan(); function tiaozhuan(){setTimeout(window.location.href='login.aspx',2); }</script>"); } else { Response.Write("<script> alert('注册失败请,检查输入信息!')</script>"); } if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } }
// string sql = "server=UBVBIYXSV1LKLZB;database=Semester;trusted_connection=true;"; protected void Page_Load(object sender, EventArgs e) { string id = Request.Params["id"]; if (id == null) { Response.Redirect("index5.aspx"); } Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from [Topic] where id='" + id + "'", con); DataSet ds = new DataSet(); da.Fill(ds, "Topic"); con.Close(); DataList1.DataSource = ds; DataList1.DataBind(); Response.Write(id); }
protected void Page_Load(object sender, EventArgs e) { string id = Request.Params["id"]; if (Session["ser"] == null) { Response.Redirect("index5.aspx"); } else { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [Topic] WHERE topic LIKE '%" + Session["ser"] + "%' or name LIKE '%" + Session["ser"] + "%' or message LIKE '%" + Session["ser"] + "%' ", con); DataSet ds = new DataSet(); da.Fill(ds, "Topic"); con.Close(); DataList1.DataSource = ds; DataList1.DataBind(); Response.Write(id); } }
//改变数据库的方法 public void changer(string _che, string id) { //创建数据库连接对象 Data_con dc = new Data_con(); SqlConnection cons = dc.SQL_con(); //SqlConnection cons = new SqlConnection(sqlcon); string sqlstr = "update Topic set [check]='" + _che + "' where id='" + id + "'"; SqlCommand comm = new SqlCommand(sqlstr, cons); cons.Open(); int recoder = Convert.ToInt32(comm.ExecuteNonQuery()); if (recoder > 0) { Response.Write("修改成功!哈哈哈"); } else { Response.Write("修改失败!烦死了!"); } RadioCheck(); }
protected void Page_Load(object sender, EventArgs e) { Data_con dc = new Data_con(); SqlConnection con = dc.SQL_con(); con.Open(); SqlDataAdapter da1 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题' ", con); DataSet ds1 = new DataSet(); da1.Fill(ds1, "Down_1"); con.Close(); DataList1.DataSource = ds1; DataList1.DataBind(); con.Open(); SqlDataAdapter da2 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds2 = new DataSet(); da2.Fill(ds2, "Down_1"); con.Close(); DataList2.DataSource = ds2; DataList2.DataBind(); con.Open(); SqlDataAdapter da3 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='软件专题' ", con); DataSet ds3 = new DataSet(); da3.Fill(ds3, "Down_1"); con.Close(); DataList3.DataSource = ds3; DataList3.DataBind(); con.Open(); SqlDataAdapter da4 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds4 = new DataSet(); da4.Fill(ds4, "Down_1"); con.Close(); DataList4.DataSource = ds4; DataList4.DataBind(); con.Open(); SqlDataAdapter da5 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='游戏专题' ", con); DataSet ds5 = new DataSet(); da5.Fill(ds5, "Down_1"); con.Close(); DataList5.DataSource = ds5; DataList5.DataBind(); con.Open(); SqlDataAdapter da6 = new SqlDataAdapter("SELECT top 7 * FROM [Down_1] where soft_type='热门专题1' ", con); DataSet ds6 = new DataSet(); da6.Fill(ds6, "Down_1"); con.Close(); DataList6.DataSource = ds6; DataList6.DataBind(); }