Export into excel with multiple list boxes filter !!

protected void Button1_Click(object sender, EventArgs e)

{

string connectionString ="Data Source=csfsb-sql02;Initial Catalog=ACCENTURE_PROD;Integrated Security=True;";

SqlConnection connection = new SqlConnection(connectionString);

string ListValue1 = LL1.Text;

string ListValue2 = LL2.Text;

string ListValue3 = LL3.Text;

string ListValue4 = LL4.Text;

string ListValue5 = LL5.Text;

string ListValue6 = LL6.Text;

//// Using GetSelectedIndices

Label6.Text = "";

foreach (int i in LL1.GetSelectedIndices())

{

Label6.Text += "Selected Value: " + LL1.Items[i].Value + " Selected Text: " + LL1.Items[i].Text + "
";

}

//string dbQuery = "select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = '" + ListValue1 + "' OR [SUPPLIER NUM] = '" + ListValue2 + "'";

string dbQuery = "select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = '" + ListValue1 + "' OR [SUPPLIER NUM] = '" + ListValue2 + "' OR [PO NUMBER] = '" + ListValue3 + "' OR [OPERTAING_UNIT] = '" + ListValue4 + "' OR [SUPPLIER] = '" + ListValue5 + "' OR [INVOICE NUM] = '" + ListValue6 + "'";

// if (ListValue1 != "" )

//{

// dbQuery = dbQuery + "type = '"+ ListValue1 +"'";

//}

//if (ListValue2 != "" )

//{

// dbQuery = dbQuery + "[SUPPLIER NUM] = '" + ListValue2 + "'";

//}

try

{

SqlCommand sqlCmd = new SqlCommand(dbQuery, connection);

connection.Open();

SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);

DataSet dataset = new DataSet();

sda.Fill(dataset);

connection.Close();

Gridview1.DataSource = dataset;

Gridview1.DataBind();

ExportToExcel(dataset.Tables[0], "DailyBatch" + DateTime.Now.ToShortDateString());

//Response.Write(LL1.SelectedValue.ToString());

//ExportExcel(dataset);

}

catch

{

throw;

}

}