using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace ASPNET.StarterKit.Portal 
{

	public  class Contacts2s : ASPNET.StarterKit.Portal.PortalModuleControl 
	{
		protected System.Web.UI.WebControls.DataGrid myDataGrid;
		//  protected System.Web.UI.WebControls.DataGrid myDataGrid;

		//*******************************************************
		//
		// The Page_Load event handler on this User Control is used to
		// obtain a DataReader of contact information from the Contacts
		// table, and then databind the results to a DataGrid
		// server control.  It uses the ASPNET.StarterKit.Portal.ContactsDB()
		// data component to encapsulate all data functionality.
		//
		//*******************************************************

		private void Page_Load(object sender, System.EventArgs e) 
		{

          
			SqlConnection connection = new SqlConnection("server=localhost;Trusted_Connection=true;database=Portal");
			SqlCommand command = new SqlCommand("SELECT u.UserID U, u.Name N, r.RoleName R, u.Email E  FROM Portal_Roles r, Portal_UserRoles ur, Portal_Users u WHERE r.RoleID = ur.RoleID AND ur.UserID = u.UserID ORDER BY u.UserID", connection);
			connection.Open();
			myDataGrid.DataSource = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
			myDataGrid.DataBind();
		}


		public Contacts2s() 
		{
			this.Init += new System.EventHandler(Page_Init);
		}

		private void Page_Init(object sender, EventArgs e) 
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
		}

		#region Web Form Designer generated code
		///		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
	}
}
