Invalid column name 'Jan'.Same for All months

Question

I want to filter datagrid data according to Dropdownlist order by Months and Year(retrive from databse/listitem)showing same problem.   Invalid column name 'Jan'.Same for All months(its when i choosed jan in dropdownlist

 

 

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class Er_TimeSheetHistory : System.Web.UI.Page

{

public string strcon1 = "Data Source=LENOVO-EF645A82;AttachDbFilename=E:\\ERSYSTEMS_WEB_1\\DataSourse\\EmpDb1.mdf;Initial Catalog=Erdata;Integrated Security=True";

public string WelcomeName;

SqlDataReader dr;

SqlParameter mparam, yparam;

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

WelcomeName = Session["userid"].ToString();

//lbldate.Text = DateTime.Now.ToString ();

DateTime Date = DateTime.Now;

Label2.Text = Date.ToString("MMMM");

Label3.Text = Date.ToString("yyyy");

BtnSubmit.Enabled = false;

}

protected void BtnSubmit_Click1(object sender, EventArgs e)

{

HtmlForm frm=new HtmlForm() ;

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

//frm.Attributes.Add("runat", "server");

//GridView1.Attributes.Add("runat", "server");

//GridView1.RenderControl(htmlWrite);

DataGrid1.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

protected void Button1_Click(object sender, EventArgs e)

{

Bindgrid();

}

public void Bindgrid()

{

SqlConnection conn = new SqlConnection(strcon1);

SqlDataAdapter da = new SqlDataAdapter("select * from D_TimeSheet1 where EmpId=" + Session["usid"] + " AND Year=" +lstyear .SelectedValue + " AND Months="+DropDownList1 .SelectedValue.ToString () +" order By AttDate DESC", conn);

DataSet ds = new DataSet();

da.Fill(ds, "D_TimeSheet1");

// Filling a employee table

DataTable dt = ds.Tables["D_TimeSheet1"];

dt = RemoveDuplicateRows(dt, "EmpId");

DataGrid1.DataSource = ds.Tables["D_TimeSheet1"].DefaultView;

DataGrid1.DataBind();

}

public DataTable RemoveDuplicateRows(DataTable dTable, string AttDate)

{

Hashtable hTable = new Hashtable();

ArrayList duplicateList = new ArrayList();

//Add list of all the unique item value to hashtable, which stores combination of key, value pair.

//And add duplicate item value in arraylist.

foreach (DataRow drow in dTable.Rows)

{

if (hTable.Contains(drow[AttDate]))

duplicateList.Add(drow);

else

hTable.Add(drow[AttDate], string.Empty);

}

//Removing a list of duplicate items from datatable.

foreach (DataRow dRow in duplicateList)

dTable.Rows.Remove(dRow);

//Datatable which contains unique records will be return as output.

return dTable;

}

}