using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;



using DotNetNuke;

using DotNetNuke.Security;



using System.Data;

using System.Data.SqlClient;

using System.Configuration;





namespace DotNetNuke.Modules.styTest

{

    public partial class View : DotNetNuke.Entities.Modules.PortalModuleBase

    {





        protected void Page_Load(object sender, EventArgs e)

        {

            if (!this.IsPostBack)

            {

                this.BindGrid();

            }

        }



        private void BindGrid()

        {



            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

            string query = "SELECT ContactName, Country FROM Customers";



            string condition = string.Empty;

            foreach (ListItem item in chkCountries.Items)

            {

                condition += item.Selected ? string.Format("'{0}',", item.Value) : string.Empty;

            }



            if (!string.IsNullOrEmpty(condition))

            {

                condition = string.Format(" WHERE Country IN ({0})", condition.Substring(0, condition.Length - 1));

            }



            using (SqlConnection con = new SqlConnection(constr))

            {

                using (SqlCommand cmd = new SqlCommand(query + condition))

                {

                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))

                    {

                        cmd.Connection = con;

                        using (DataTable dt = new DataTable())

                        {

                            sda.Fill(dt);

                            GridView1.DataSource = dt;

                            GridView1.DataBind();

                        }

                    }

                }

            }

        }



        protected void OnPageIndexChanging(object sender, GridViewPageEventArgs e)

        {

            GridView1.PageIndex = e.NewPageIndex;

            this.BindGrid();

        }





        protected void Country_Selected(object sender, EventArgs e)

        {

            this.BindGrid();

        }

    }

}