Gridview prblom

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Drawing;

namespace ParleAgro

{

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

{

List dictionary = new List();

string a;

protected void Page_Load(object sender, EventArgs e)

{

DropDownList masterDropDown = (DropDownList)Master.FindControl("DropDownList1");

int selectedValue = masterDropDown.SelectedIndex;

string x = masterDropDown.SelectedValue;

DropDownList masterDropDown1 = (DropDownList)Master.FindControl("DropDownList2");

int selectedValue1 = masterDropDown1.SelectedIndex;

string y = masterDropDown1.SelectedValue;

DropDownList masterDropDown2 = (DropDownList)Master.FindControl("DropDownList3");

int selectedValue2 = masterDropDown2.SelectedIndex;

string z = masterDropDown2.SelectedValue;

Response.Write("hello:" + z);

//var cpcode = selectedValue2.Split(new[] { '-' }, StringSplitOptions.RemoveEmptyEntries);

//string[] words = z.Split('-');

//for (int i = 0; i < words.Length; i++)

//{

// a = words[0];

//}

dictionary.Add(new myDictionary() { columnNameDB = "RGM_HQ", columnNameDt = "RGM_HQ" });

dictionary.Add(new myDictionary() { columnNameDB = "AGM_HQ", columnNameDt = "AGM_HQ" });

dictionary.Add(new myDictionary() { columnNameDB = "GO_HQ", columnNameDt = "GO_HQ" });

dictionary.Add(new myDictionary() { columnNameDB = "SEC_TGT", columnNameDt = "SALES_TGT" });

dictionary.Add(new myDictionary() { columnNameDB = "SEC_ACH", columnNameDt = "SALES_ACH" });

dictionary.Add(new myDictionary() { columnNameDB = "Growth", columnNameDt = "GROWTH" });

dictionary.Add(new myDictionary() { columnNameDB = "CALLS_MADE", columnNameDt = "Calls_Made" });

dictionary.Add(new myDictionary() { columnNameDB = "PC", columnNameDt = "Productive_calls" });

dictionary.Add(new myDictionary() { columnNameDB = "LPSC_TGT", columnNameDt = "LPSC_TGT" });

dictionary.Add(new myDictionary() { columnNameDB = "LPSC_ACH", columnNameDt = "LPSC_ACH" });

dictionary.Add(new myDictionary() { columnNameDB = "TLSD_TGT", columnNameDt = "TLSD_TGT" });

dictionary.Add(new myDictionary() { columnNameDB = "TLSD_ACH", columnNameDt = "TLSD_ACH" });

dictionary.Add(new myDictionary() { columnNameDB = "DROP_SIZE", columnNameDt = "DROP_SIZE" });

dictionary.Add(new myDictionary() { columnNameDB = "DROP_SIZE_ACH", columnNameDt = "DROP_SIZE_ACH" });

DataTable records = new DataTable()

{

Columns = {

new DataColumn ("RGM_HQ", typeof(string)),

new DataColumn ("AGM_HQ", typeof(string)),

new DataColumn ("GO_HQ", typeof(string)),

new DataColumn ("SEC_TGT", typeof(string)),

new DataColumn ("SEC_ACH", typeof(string)),

new DataColumn ("Growth", typeof(double)),

new DataColumn ("CALLS_MADE", typeof(string)),

new DataColumn ("PC", typeof(string)),

new DataColumn ("LPSC_TGT", typeof(string)),

new DataColumn ("LPSC_ACH", typeof(string)),

new DataColumn ("TLSD_TGT", typeof(string)),

new DataColumn ("TLSD_ACH", typeof(string)),

new DataColumn ("DROP_SIZE", typeof(string)),

new DataColumn ("DROP_SIZE_ACH", typeof(string)),

}

};

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

using (SqlConnection con = new SqlConnection(constr))

{

SqlCommand cmd;

if (selectedValue > 0 && selectedValue1 > 0)

{

cmd = new SqlCommand("SELECT *FROM SIS where RGM_HQ='" + x + "' and AGM_HQ='" + y + "' ORDER BY RGM_HQ ASC,AGM_HQ ASC,GO_HQ ASC,DATE ASC ");

}

else if (selectedValue > 0)

{

cmd = new SqlCommand("SELECT *FROM SIS where RGM_HQ='" + x + "' ORDER BY RGM_HQ ASC,AGM_HQ ASC,GO_HQ ASC,DATE ASC");

}

else

{

cmd = new SqlCommand("SELECT *FROM SIS ORDER BY RGM_HQ ASC,AGM_HQ ASC,GO_HQ ASC,DATE ASC");

}

using (SqlDataAdapter sda = new SqlDataAdapter())

{

cmd.Connection = con;

sda.SelectCommand = cmd;

//string index = "";

DataRow dr1 = null;

using (DataTable dt = new DataTable())

{

sda.Fill(dt);

foreach (DataRow dr in dt.Rows)

{

if (dr1 != null)

{

records.Rows.Add(dr1);

dr1 = null;

}

dr1 = records.NewRow();

//index = dr["RGM_HQ"].ToString();

dr1["RGM_HQ"] = dr["RGM_HQ"];

dr1["AGM_HQ"] = dr["AGM_HQ"];

dr1["GO_HQ"] = dr["GO_HQ"];

dr1["SEC_TGT"] = dr["SALES_TGT"];

dr1["SEC_ACH"] = dr["SALES_ACH"];

dr1["Growth"] = dr["GROWTH"];

dr1["CALLS_MADE"] = dr["Calls_Made"];

dr1["PC"] = dr["Productive_calls"];

dr1["LPSC_TGT"] = dr["LPSC_TGT"];

dr1["LPSC_ACH"] = dr["LPSC_ACH"];

dr1["TLSD_TGT"] = dr["TLSD_TGT"];

dr1["TLSD_ACH"] = dr["TLSD_ACH"];

dr1["DROP_SIZE"] = dr["DROP_SIZE"];

dr1["DROP_SIZE_ACH"] = dr["DROP_SIZE_ACH"];

}

}

GridView1.DataSource = records;

GridView1.DataBind();

}

//}

}

}

public struct myDictionary

{

public string columnNameDB { get; set; }

public string columnNameDt { get; set; }

}