yjfc_xinxi/use_list.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
// 下载于www.51aspx.com
namespace yjfc_xinxi
{
    public partial class use_list : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                try
                {
                    if (Session["usertruename"].ToString().Trim() == "")
                    {
                        Response.Redirect("/login.aspx");
                    }
                    else
                    {
                        lb_username.Text = Session["usertruename"].ToString().Trim();
                        string sql = "select * from xinxi_organize where organizeid=" + Session["organizeid"].ToString() + "";
                        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
                        conn.Open();
                        SqlCommand cmd = new SqlCommand(sql, conn);
                        SqlDataReader dr = cmd.ExecuteReader();
                        if (dr.Read())
                        {
                            lb_organization.Text = dr["organizename"].ToString();
                        }
                        dr.Close();
                        dr.Dispose();
                        conn.Close();
                        bind();

                    }
                }
                catch (Exception ex)
                {
                    Response.Redirect("/login.aspx");
                }
            }
        }
        public void bind()
        {
            string sql = "select boardid,boardtitle,boardtime,click from xinxi_board order by boardid desc";
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString);
            SqlDataAdapter adp = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            conn.Open();
            adp.Fill(ds);
            //GridView1.DataSource = ds;