default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


namespace waDEIG
{
    public partial class _default : System.Web.UI.Page
    {
        string dash = "-";
       // string zero = "0";
        string comma = ", ";
        // enum day of week and remove it from db.

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack )
            {
                 ddlDOW.SelectedIndex = 1;
            }
        }

        protected void lbGet_Click(object sender, EventArgs e)
        {
            // Get the data from the selection and filter the data.
            //
            int dow = Int32.Parse(ddlDOW.SelectedValue);
            int time = Int32.Parse(ddlTime.SelectedValue);
            string town = ddlTown.SelectedValue;

            StringBuilder sbGet = new StringBuilder();
              // get day selection
            if (dow != 0)
            {
                sbGet.Append(string.Format(" DOW = {0}", dow));
            }
            else 
            {
                sbGet.Append(String.Format(" DOW > {0}", 0));
            }

            // Get time selection
            if (time != 0)
            {
                if (sbGet.Length > 0)
                {
                    sbGet.Append(String.Format(" AND TimeID = {0}", time));
                }
            }

            // Get Town selection
            if (town != dash)
            {
                if (sbGet.Length > 0)
                {
                    sbGet.Append(String.Format(" AND Town = '{0}'", town));
                }                
            }
            else
            {
                sbGet.Append(String.Format(" AND Town like '{0}'", "%"));
            }

            // Set the filter
            if (sbGet.Length > 0)
            {
                SqlDsList.FilterExpression = sbGet.ToString();
            }
            else
            {
                SqlDsList.FilterExpression = null;
            }
           // lblFilter.Text = "Filter: " + SqlDsList.FilterExpression.ToString();
        }

        protected void LnkExport_Click(object sender, EventArgs e)
        {
            int rc = -1;
            string cnStr = ConfigurationManager.ConnectionStrings["cnDEIG"].ConnectionString;
            SqlConnection cn = new SqlConnection(cnStr);
            SqlCommand cmd = new SqlCommand("GetMeetingList");
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter();

            // Get the connection into the SqlCommand object
            cmd.Connection = cn;

            da.SelectCommand = cmd;

            DataTable dt = new DataTable();

            try
            {
                rc = da.Fill(dt);
            }
            catch (InvalidCastException ex)
            {
                lblFilter.Text = ex.ToString();
            }

            // Read the table to create a file for export
            StringBuilder sb = new StringBuilder();

            foreach (DataColumn column in dt.Columns)
            {
                // Add the Header row for the text file
                sb.Append(column.ColumnName + comma);
            }
            // Add new line
            sb.AppendLine();

            // Get the data
            foreach (DataRow row in dt.Rows)
            {
                foreach (DataColumn column in dt.Columns)
                {
                    sb.Append(row[column.ColumnName].ToString() + comma);
                }

                // Add new line
                sb.AppendLine();
            }

            // Download the text file
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=MeetingList.csv");
            Response.Charset = "";
            Response.ContentType = "application/text";
            Response.Output.Write(sb.ToString());
            Response.Flush();
            Response.End();

        }
    }
}