DataGrid Editing in C#

Thanks a lot, here is the working code for anyone else to reference


<asp:DataGrid id="gridBO" runat="server" OnEditCommand="gridBO_Edit" OnCancelCommand="gridBO_Cancel" OnUpdateCommand="gridBO_Update" DataKeyField="employeeDepRank" AutoGenerateColumns="False">
                <ItemStyle font-name="Arial" font-size="10pt" forecolor="#000000" />
                <HeaderStyle font-name="Arial" font-size="12pt" font-bold="true" backcolor="#658bbc" forecolor="#FFFFFF" />
                <AlternatingItemStyle font-name="Arial" font-size="10pt" backcolor="#e3efff" />
                <Columns>
                    <asp:TemplateColumn>
                        <HeaderTemplate>
                            Status
                        </HeaderTemplate>
                        <ItemTemplate>
                            <%# DataBinder.Eval(Container.DataItem, "employeeStatus") %>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:DropDownList id="ddlStatus" runat="server" SelectedIndex='<%# getStatusIndex(DataBinder.Eval(Container.DataItem, "employeeStatus").ToString()) %>' >
                                <asp:ListItem>IN</asp:ListItem>
                                <asp:ListItem>OUT</asp:ListItem>
                            </asp:DropDownList>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:BoundColumn DataField="employeeName" HeaderText="Name" ReadOnly="true" />
                    <asp:BoundColumn DataField="employeePhone" HeaderText="Phone" ReadOnly="true" />
                    <asp:BoundColumn DataField="employeeComments" HeaderText="Comments" />
                    <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" />
                </Columns>
            </asp:DataGrid>


******************************************************************************************

using System;
using System.Collections;
using System.IO;
using System.Configuration;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data.SqlClient;



public class InOut : Page
{

        public Label        lblStatus;
        public DropDownList  ddlStatus;
      public DataGrid     gridBO;
        public string sqlStatement1  = "Select * FROM Employee WHERE employeeDepartmentId = 1 ORDER BY employeeDepRank";



protected void page_load(Object s, EventArgs e)
{

    if(!IsPostBack)
    {

        BindData();

      }


}

public int getStatusIndex(string statusName)
{

    if(statusName == "IN")
    {
        return 1;
    } else {
        return 0;
    }

}

protected void BindData()
{
        OleDbConnection objConn = new OleDbConnection(ConfigurationSettings.AppSettings["wabash"]);
        OleDbCommand objCmd   = new OleDbCommand(sqlStatement1,  objConn);
        objConn.Open();
        OleDbDataReader objRdr = objCmd.ExecuteReader();
        gridBO.DataSource = objRdr;
        gridBO.DataBind();
        objRdr.Close();
        objConn.Close();
}


protected void gridBO_Edit(Object s, DataGridCommandEventArgs e)
{
    gridBO.EditItemIndex = e.Item.ItemIndex;
    BindData();

}

protected void gridBO_Cancel(Object s, DataGridCommandEventArgs e)
{
    gridBO.EditItemIndex = -1;
    BindData();

}

protected void gridBO_Update(Object s, DataGridCommandEventArgs e)
{
    int employeeDepRank = (int)gridBO.DataKeys[e.Item.ItemIndex];
    string strStatus = ((DropDownList)e.Item.FindControl("ddlStatus")).SelectedItem.ToString();
    string strComments = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
    string strCmd = "UPDATE Employee Set employeeStatus='" + strStatus + "', employeeComments='" + strComments + "' WHERE employeeDepRank=" + employeeDepRank;

    OleDbConnection objConn = new OleDbConnection(ConfigurationSettings.AppSettings["wabash"]);
    OleDbCommand objCmd = new OleDbCommand(strCmd, objConn);

    objConn.Open();
    objCmd.ExecuteNonQuery();
    objConn.Close();

    gridBO.EditItemIndex = -1;
    BindData();



}