Liaotianshi.rar_ASP.NET 聊天 源码_asp.net_asp.net 聊天室_liaotianshi_qq

 //online = Session["online"].ToString(); //userName = Session["userName"].ToString(); //if (conn.State != ConnectionState.Open) //conn.Open(); //string sql1 = "update tb_user set online='" + online + "' where userName='" + userName + "'"; //SqlCommand cmd1 = new SqlCommand(sql1, conn); //cmd1.ExecuteNonQuery(); //conn.Close(); //cmd1.Dispose(); Label5.Text =Application["total"].ToString(); Label4.Text =Application["online"].ToString(); Label3.Text=Session["userName"].ToString(); string sql = "select * from tb_user"; //string sql2 = "select * from tb_user where online='"+online+"'"; SqlDataAdapter ada = new SqlDataAdapter(sql, conn); //SqlDataAdapter ada2 = new SqlDataAdapter(sql2, conn); DataSet ds = new DataSet(); //DataSet ds2 = new DataSet(); ada.Fill(ds, "tb_user"); //ada2.Fill(ds2,"tb_user"); DropDownList1.DataSource = ds.Tables["tb_user"]; DataList2.DataSource = ds2.Tables["tb_user"]; DropDownList1.DataTextField = "userName"; DropDownList1.DataValueField = "userID"; DropDownList1.DataBind(); DataList2.DataBind(); conn.Close(); ada.Dispose(); ada2.Dispose(); //SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["CR_conn"].ToString()); //con.Open(); //string YESonline = "Yes"; //string NOonline = "NO"; //string sql1 = "update tb_user set online='" + NOonline + "' where online='" + YESonline + "'"; //SqlCommand cmd1 = new SqlCommand(sql1, con); //cmd1.ExecuteNonQuery(); //con.Close(); //cmd1.Dispose();