gridview problem

Question

Hai all,
   this is my aspx code

<asp:GridView ID="gvCustomers" DataKeyNames = "CustomerId" runat="server" AutoGenerateColumns = "false" OnRowEditing = "EditCustomer" OnRowDataBound = "RowDataBound" OnRowUpdating = "UpdateCustomer" OnRowCancelingEdit = "CancelEdit">

<Columns>

    <asp:BoundField DataField = "ContactName" HeaderText = "Contact Name" />

    <asp:TemplateField HeaderText = "City">

    <ItemTemplate>

        <asp:Label ID="lblCity" runat="server" Text='<%# Eval("City")%>'></asp:Label>

    </ItemTemplate>

    <EditItemTemplate>

            <asp:Label ID="lblCity" runat="server" Text='<%# Eval("City")%>' Visible = "false"></asp:Label>

    <asp:DropDownList ID = "ddlCities" runat = "server">

    </asp:DropDownList>

    </EditItemTemplate>

    </asp:TemplateField>

    <asp:CommandField ShowEditButton="True" />

</Columns>

</asp:GridView>

and my .cs code is

protected void Page_Load(object sender, EventArgs e)

{

    if (!IsPostBack)

    {

        this.BindData();

    }

}

 

private void BindData()

{

    string query = "SELECT top 10 * FROM Customers";

    SqlCommand cmd = new SqlCommand(query);

    gvCustomers.DataSource = GetData(cmd);

    gvCustomers.DataBind();

}

 

private DataTable GetData(SqlCommand cmd)

{

    string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

    using (SqlConnection con = new SqlConnection(strConnString))

    {

        using (SqlDataAdapter sda = new SqlDataAdapter())

        {

            cmd.Connection = con;

            sda.SelectCommand = cmd;

            using (DataTable dt = new DataTable())

            {

                sda.Fill(dt);

                return dt;

            }

        }

    }

}

protected void EditCustomer(object sender, GridViewEditEventArgs e)

{

    gvCustomers.EditIndex = e.NewEditIndex;

    BindData();

}

 

protected void CancelEdit(object sender, GridViewCancelEditEventArgs e)

{

    gvCustomers.EditIndex = -1;

    BindData();

}

protected void RowDataBound(object sender, GridViewRowEventArgs e)

{

    if (e.Row.RowType == DataControlRowType.DataRow && gvCustomers.EditIndex == e.Row.RowIndex)

    {

        DropDownList ddlCities = (DropDownList)e.Row.FindControl("ddlCities");

        string query = "select distinct city from customers";

        SqlCommand cmd = new SqlCommand(query);

        ddlCities.DataSource = GetData(cmd);

        ddlCities.DataTextField = "city";

        ddlCities.DataValueField = "city";

        ddlCities.DataBind();

        ddlCities.Items.FindByValue((e.Row.FindControl("lblCity") as Label).Text).Selected = true;

    }

}

protected void UpdateCustomer(object sender, GridViewUpdateEventArgs e)

{

    string city = (gvCustomers.Rows[e.RowIndex].FindControl("ddlCities") as DropDownList).SelectedItem.Value;

    string customerId = gvCustomers.DataKeys[e.RowIndex].Value.ToString();

    string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

    using (SqlConnection con = new SqlConnection(strConnString))

    {

        string query = "update customers set city = @city where customerId = @customerId";

        using (SqlCommand cmd = new SqlCommand(query))

        {

            cmd.Connection = con;

            cmd.Parameters.AddWithValue("@city", city);

            cmd.Parameters.AddWithValue("@customerId", customerId);

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();

            Response.Redirect(Request.Url.AbsoluteUri);

        }

    }

}

and my error is  Expected class, delegate, enum, interface, or struct......at at first few lines i.e, protected void.....

can any one help me

Thanks and Regards