using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Utilities;

using System.Data;

namespace GridViews

{

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

{

DBConnect objDB = new DBConnect();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

String strSQL = "SELECT * FROM Product";

// Bind the dataset data to the listbox list

// set the text displayed in the list to the Description field value

// and the value of a selected item to the ProductNumber field value

lstProducts.DataSource = objDB.GetDataSet(strSQL);

lstProducts.DataTextField = "Description";

lstProducts.DataValueField = "ProductNumber";

lstProducts.DataBind();

}

}

protected void btnDisplay_Click(object sender, EventArgs e)

{

String strSQL = "";

DataSet myDS = null, tempDS = null;

Boolean atleastOneItemFound = false;

for (int i = 0; i < lstProducts.Items.Count; i++)

{

if (lstProducts.Items[i].Selected)

{

String productNumber = lstProducts.Items[i].Value;

strSQL = "SELECT * FROM Product WHERE ProductNumber = '" + productNumber + "'";

tempDS = objDB.GetDataSet(strSQL);

// Merge the dataset data when more than one item is selected

if (atleastOneItemFound == false)

{

myDS = tempDS;

atleastOneItemFound = true;

}

else

{

// More than one item was found

// Merge datasets

myDS.Merge(tempDS);

}

}

}

gvProducts.DataSource = myDS;

gvProducts.DataBind();

}

}

}