Multiple Column Dropdownlist for the ASP.NET DataGrid

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
namespace CSharpSample
{
	/// <summary>
	/// Summary description for WebForm6.
	/// </summary>
	public class WebForm6 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Message;
		protected System.Web.UI.WebControls.DataGrid jskDataGrid;
		SqlDataAdapter sqlDa;
		SqlConnection SqlCon = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);	
		DataSet ds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
			if (! IsPostBack)
			{

				BindDataGrid();

			}

		}
		protected void BindDataGrid()
		{
			
			string sqlStr = "SELECT S.CompanyName,S.SupplierID,P.ProductName,P.ProductID " +
									"from Suppliers S inner join Products P " +
									"on S.SupplierID = P.SupplierID ";
			sqlDa = new SqlDataAdapter(sqlStr, SqlCon);
			ds = new DataSet();
			sqlDa.Fill(ds, "Suppliers");
			jskDataGrid.DataSource = ds.Tables["Suppliers"];
			jskDataGrid.DataBind();

		}

		protected void jskDataGrid_Edit(object sender, DataGridCommandEventArgs e) 
		{

			jskDataGrid.EditItemIndex = e.Item.ItemIndex;
			BindDataGrid();
		}

		protected void jskDataGrid_Cancel(object sender, DataGridCommandEventArgs e) 
		{

			jskDataGrid.EditItemIndex = -1;
			BindDataGrid();

		}
		protected void jskDataGrid_Update(object sender, DataGridCommandEventArgs e) 
		{
			try
			{
				string itemValue;
				string itemText;
				
				((ddList.mcDDList)e.Item.FindControl("McDDList1")).ReturnsValue = true;
				itemValue = ((ddList.mcDDList)e.Item.FindControl("McDDList1")).Text.ToString();

				((ddList.mcDDList)e.Item.FindControl("McDDList1")).ReturnsValue = false;
				itemText = ((ddList.mcDDList)e.Item.FindControl("McDDList1")).Text.ToString();

				//write your update query
				//update table set col1 = itemtext where col2 = itemvalue
				jskDataGrid.EditItemIndex = -1;
				BindDataGrid();

			}
			catch(Exception ex)
			{
				Response.Write(ex.Message);

			}
			finally{
				/*Close your connection */
			}
		}
		public DataSet PopulateDDList()
		{
			string sqlString = " select ProductID,ProductName,CategoryName as Name,UnitPrice as Price " +
										"from Products p inner join Categories c " +
										"on p.categoryid = c.categoryid ";
			SqlDataAdapter ad = new SqlDataAdapter(sqlString,SqlCon);
			DataSet ds = new DataSet();
			ad.Fill(ds,"Categories");
			return ds;
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}