DATAGRID INDEX .There are some mistakes. Please help.Im having a heck of a time

Question

DataSet ds = GetValues(tbl_Users_StoreID); ddlStores.DataBind(); This I cannot do. Because GetValues if of type SqlDataReader and the ddlStores databind() also? Here is the new code. But nothing gets populated. Users Interface to Managing Adminitrators private DataSet ddlDataSet1 = new DataSet(); private DataSet ddlDataSet2 = new DataSet(); private DataSet ddlDataSet3 = new DataSet(); private SqlConnection myConnection = new SqlConnection(server=(local);database=MSPOS;uid=sa;pwd=); //**************************************************************** protected void Page_Load(object sender System.EventArgs e) { if (!Page.IsPostBack) { BindData(); } } //**************************************************************** //************************************************************ // Get Stores and populate dataset with STOREID and STORENAME private DataSet GetStores() { // Populate the ddlDataSet const string strSQLDDL = @SELECT StoreID Store FROM tbl_Users_StoreID ORDER BY Store; SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQLDDL myConnection); myDataAdapter.Fill(ddlDataSet1 ddlStores); return ddlDataSet1; } //************************************************************ //************************************************************ // Get Stores and populate dataset with ACCCESSLEVELID and ACCESSLEVEL private DataSet GetAccessLevels() { // Populate the ddlDataSet const string strSQLDDL = @SELECT t.AccessLevelID p.AccessLevel From tbl_Users t Inner JOIN tbl_Users_AccessLevelID p ON t.AccessLevelID = p.AccessLevelID ORDER BY UserName; SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQLDDL myConnection); myDataAdapter.Fill(ddlDataSet2 ddlAccessLevels); return ddlDataSet2; } //************************************************************ //************************************************************ // Get Stores and populate dataset with ReportToID and UserName private DataSet GetReportTos() { // Populate the ddlDataSet const string strSQLDDL = @SELECT ReportToID UserName From tbl_Users Where ReportToID = UserID; SqlDataAdapter myDataAdapter = new SqlDataAdapter(strSQLDDL myConnection); myDataAdapter.Fill(ddlDataSet3 ddlReportTos); return ddlDataSet3; } //************************************************************ //************************************************************ private void DataGridUserManagementID_SelectedIndexChanged(object sender System.EventArgs e) { // Response.Write (DataGridUserManagementID_SelectedIndexChanged); //DataGridUserManagementID.SelectedItem.BorderStyle = BorderStyle.Dashed; } //************************************************************ //************************************************************ protected void SelectedIndexChangedEventHandler(object sender System.EventArgs e) { DropDownList ddl=(DropDownList)sender; DataGridItem dgi=(DataGridItem)ddl.Parent.Parent; } //**************************************************************** //**************************************************************** // common routine for all database updates private void UpdateDB(string cmd) { myConnection.Open( ; // Create a SqlCommand object and assign the connection System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand( ; command.Connection = myConnection; command.CommandText = cmd; // execute the sproc command.ExecuteNonQuery( ; } //**************************************************************** //**************************************************************** private void BindData() { // Create the command object passing in the SQL string // connect to the Bugs database string connectionString = server=(local);uid=sa;pwd=;database=MSPOS; System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString); // Set the datagrid's datasource to the datareader and databind // get records from the table string commandString = SELECT t.UserID p.Store pe.AccessLevel t.UserName t.FullName t.ReportToID From tbl_Users t INNER JOIN tbl_Users_StoreID p ON t.StoreID = p.StoreID INNER JOIN tbl_Users_AccessLevelID pe ON t.AccessLevelID = pe.AccessLevelID ORDER BY UserName; System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(); command.CommandText = commandString; command.Connection = connection; connection.Open(); // Create the Reader and bind it to the datagrid SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); DataGridUserManagementID.DataSource=reader; DataGridUserManagementID.DataBind(); } //**************************************************************** //**************************************************************** private void DataGridUserManagementID_ItemDataBound(object sender System.Web.UI.WebControls.DataGridItemEventArgs e) { if(e.Item.ItemType == ListItemType.EditItem) { //GET THE DATAROW // System.Data.Common.DbDataRecord DataRow =(System.Data.Common.DbDataRecord)e.Item.DataItem; //POPULATE AND SET SELECTED INDEX FOR MANAGER DROPDOWN LIST } } //**************************************************************** //**************************************************************** private void DataGridUserManagementID_Edit(object source System.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGridUserManagementID.EditItemIndex = e.Item.ItemIndex; BindData(); DataGridUserManagementID.ShowFooter = false; } //**************************************************************** //**************************************************************** private void DataGridUserManagementID_Cancel(object sourceSystem.Web.UI.WebControls.DataGridCommandEventArgs e) { DataGridUserManagementID.EditItemIndex = -1; BindData(); DataGridUserManagementID.ShowFooter = true; } //**************************************************************** //**************************************************************** protected void GridDropDown_SelectedIndexChanged(object sender EventArgs e) { // DropDownList list = (DropDownList)sender; // Response.Write(list.SelectedValue); } //**************************************************************** //****************************************************************************** private void DataGridUserManagementID_ItemDataBound(object sourceSystem.Web.UI.WebControls.DataGridCommandEventArgs e) { Response.Write(The ItemDataBound Command has been fired); if(e.Item.ItemType == ListItemType.EditItem) { //((DropDownList)(e.Item.FindControl(ddlStores))).SelectedItem.Value // DropDownList ddlStoreID = (DropDownList) e.Item.FindControl(ddlStores); // ddlStoreID.SelectedItem.Text = Convert.ToString(DataBinder.Eval(e.Item.DataItemStore)); // ddlStoreId.SelectedValue = //Convert.ToString(DataBinder.Eval(e.Item.DataItemStoreId)); Using this //statement is a better option.. } } //*************************************************************** //*************************************************************** private int ExecuteQuery(string sqlCmd) { // connect to the database string connectionString = server=(local); uid=sa;pwd=;database=MSPOS; System.Data.SqlClient.SqlConnection connection =new System.Data.SqlClient.SqlConnection(connectionString); connection.Open( ; // call the update and rebind the datagrid System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand( ; command.CommandText = sqlCmd; command.Connection = connection; return command.ExecuteNonQuery( ; } //*************************************************************** private void DataGridUserManagementID_Update(object sourceSystem.Web.UI.WebControls.DataGridCommandEventArgs e) { // Determine what store was selected string strUserID; string strStoreID strStore; string strAccessLevelID strAccessLevel; string strReportToID strReportTo; // Declare Textboxes string strUserName strFullName; // Gets the value of the key field of the row being updated strUserID = ((Label)e.Item.FindControl(lblUserID)).Text; strStoreID = ((DropDownList)(e.Item.FindControl(ddlStores))).SelectedItem.Value; strStore = ((DropDownList)(e.Item.FindControl(ddlStores))).SelectedItem.Text; strAccessLevelID = ((DropDownList)(e.Item.FindControl(ddlAccessLevels))).SelectedItem.Value; strAccessLevel = ((DropDownList)(e.Item.FindControl(ddlAccessLevels))).SelectedItem.Text; strReportToID = ((DropDownList)(e.Item.FindControl(ddlReportTos))).SelectedItem.Value; strReportTo = ((DropDownList)(e.Item.FindControl(ddlReportTos))).SelectedItem.Text; strUserName = ((TextBox)e.Item.FindControl(editUserName)).Text; strFullName = ((TextBox)e.Item.FindControl(editFullName)).Text; Response.Write (strUserName + strReportTo); if ((strUserName.Equals(strReportTo))) { strReportToID = strUserID; Response.Write (Strings are Equal); } // form the update statement // connect to the database string cmd=Update tbl_Users Set UserName='+ strUserName +' StoreID='+ strStoreID +' FullName='+ strFullName +' AccessLevelID='+ strAccessLevelID +' ReportToID='+ strReportToID +' Where UserID = + strUserID +; ExecuteQuery(cmd); DataGridUserManagementID.EditItemIndex = -1; BindData( ; } //************************************************************************ //************************************************************************ public void DataGridUserManagementID_Delete(object source System.Web.UI.WebControls.DataGridCommandEventArgs e) { string cmd = Delete from tbl_Users where UserID =  + DataGridUserManagementID.DataKeys[e.Item.ItemIndex]; int rowsDeleted = ExecuteQuery(cmd); DataGridUserManagementID.EditItemIndex = -1; BindData( ; } //************************************************************************ //************************************************************************ protected void lstItems_SelectedIndexChanged(object sender System.EventArgs e) { System.Web.UI.WebControls.DropDownList lst = (System.Web.UI.WebControls.DropDownList)sender; DataGridItem dgi = lst.Parent.Parent as DataGridItem; if(dgi != null) { Response.Write( ItemIndex:  + dgi.ItemIndex ); Response.Write( Cells Count:  + dgi.Cells.Count); } } //************************************************************************ //************************************************************************ protected int GetSelectedIndex(string StoreID) { int iLoop; DataTable dt = ddlDataSet1.Tables[ddlStores]; for (iLoop=0; iLoop  CancelText=  EditText= > ' BackColor=lightblue Font-Bold=true Runat=server ID=lblUserID> ' DataValueField=AccessLevelID DataTextField=AccessLevel> ' Runat=server ID=lblUserName> ' Width=150> ' Runat=server ID=Label2> ' Width=150> '>


	<%# Convert.ToString(DataBinder.Eval(Container.DataItem, "Store")) %> <%# Convert.ToString(DataBinder.Eval(Container.DataItem, "AccessLevel")) %> <%# Convert.ToString(DataBinder.Eval(Container.DataItem, "UserName")) %>