1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
|
namespace WebApplication2
{
/// <summary>
/// Summary description for UserConnected.
/// </summary>
public class UserConnected : System.Web.UI.Page
{
protected System.Web.UI.WebControls.ListBox connectedUser;
System.Timers.Timer instance = new System.Timers.Timer(1000);
private void Page_Load(object sender, System.EventArgs e)
{
instance.Elapsed += new System.Timers.ElapsedEventHandler(listconnected);
instance.Start();
}
public void listconnected(object sender,System.Timers.ElapsedEventArgs ev)
{
string SconnectionString="Server=127.0.0.1;Uid=root;Pwd=www.com;Database=padb";
MySql.Data.MySqlClient.MySqlConnection cnx=new MySql.Data.MySqlClient.MySqlConnection(SconnectionString);
MySqlCommand userconnectd=new MySqlCommand("select nom from user where connected='"+1+"'");
userconnectd.Connection=cnx;
MySqlDataReader DRConnectedUser;
try
{
cnx.Open();
DRConnectedUser=userconnectd.ExecuteReader();
while(DRConnectedUser.Read()==true)
{
connectedUser.Items.Add(DRConnectedUser[0].ToString());
}
}
catch(MySqlException ex)
{
Response.Write(ex.ToString());
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
} |
Partager