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();
}
